beautypg.com

HP Neoview Release 2.5 Software User Manual

Page 84

background image

Description

Field

Indicates estimated total number of rows that will be used. This
is the compiler estimate of the number of rows that the Executor
returns in the disk process (EID) after applying the predicates.

Rows Usage Estimate

Indicates estimated total amount of memory.

Total Memory Estimate

Indicates estimated total resource usage.

Resource Usage Estimate

Internal error code returned to the stats collector from the
run-time statistics (RMS) infrastructure.

Stats Error Code

Number of disk reads for accessing the tables referenced in this
statement.

Disk Ios

Number of SQL processes (excluding ESAM processes) involved
in executing the query.

Num Sql Processes

Total space allocation by Neoview SQL.

Sql Space Alloc

Total space used by Neoview SQL.

Sql Space Used

Total heap allocation by Neoview SQL.

Sql Heap Alloc

Total heap used by Neoview SQL.

Sql Heap Used

Total space allocation by the Executor in the disk process.

Eid Space Alloc

Total space used by the Executor in the disk process.

Eid Space Used

Total heap allocation by the Executor in the disk process.

Eid Heap Alloc

Total heap used by the Executor in the disk process.

Eid Heap Used

Total memory allocated for the query.

Total Memory Alloc

Maximum memory used by the query.

Max Memory Usage

Count of messages that are initiated from the Master Executor
process to ESPs or ESP to ESP. This count includes both control
and data messages.

Num Sql Request Msgs

Number of message bytes sent as part of Num Sql Request Msgs.

Num Sql Request Msg Bytes

Count of reply messages from ESPs.

Num Sql Reply Msgs

Number of bytes sent as part of the replies from ESPs.

Num Sql Reply Msg Bytes

Number of rows fetched.

Num Rows Fetched

Number of disk reads performed by the Data Access Manager
to access all the tables associated with this query.

Disk Reads

Number of times row locks escalated to file lock on any tables
associated with this query during the execution of the query.

Lock Escalations

Number of times access to tables associated with this query was
delayed due to conflicting lock mode.

Lock Waits

Number of bytes exchanged between the file system and the Data
Access Manager in accessing all tables associated with this query.

Message Bytes to Disk

Number of messages sent to the Data Access Manager to access
the table.

Messages to Disk

Number of rows accessed by the query.

Rows Accessed

Number of rows retrieved.

Rows Retrieved

Total number of rows inserted, updated, or deleted in all tables
accessed by the query.

Num Rows Iud

Number of open files.

Num Open Files

84

Use the Triage Space Pane