HP Neoview Release 2.5 Software User Manual
Page 206
Description
Field
Group Box
Timestamp when the first row was returned from the root operator of
the master executor process. A value of -1 means that the first row has
not yet been returned.
First Row Returned
Processor (CPU) utilization, in seconds, by Neoview SQL for the query
SQL CPU (sec)
Processor (CPU) utilization, in seconds, by the disk process
Process Busy Time (sec)
Amount of time, in seconds, spent on opens
Open (sec)
Amount of time, in seconds, to create Executor Server Processes (ESPs)
Process Create (sec)
The compiler's estimated number of rows accessed
Est Accessed Rows
Usage
Actual number of rows accessed
Accessed Rows
The compiler's estimated number of rows returned after applying
predicates
Est Used Rows
Actual number of rows returned after the predicates were applied. In
a pushed down plan, all the used rows might not be returned.
Used Rows
Number of messages
Message Count
Number of message bytes sent while accessing the tables referenced by
the query
Message Bytes
Number of bytes returned for the statistics counters
Stats Bytes
Number of disk reads for accessing the tables referenced in the query
Disk I/Os
Number of rows returned from the root operator of the master executor
process
Rows Returned
Number of messages initiated from the master to ESPs or from an ESP
to ESPs
Req Message Count
Number of message bytes that are sent from the master to ESPs or from
an ESP to ESPs as part of the request messages
Req Message Bytes
Number of reply messages from the ESPs for the message requests
Reply Message Count
Number of bytes sent as part of the reply messages
Reply Message Bytes
Total space allocation by Neoview SQL for the query
SQL Space Alloc
Memory (KB)
Total space used by Neoview SQL for the query
SQL Space Used
Total heap allocation by Neoview SQL for the query
SQL Heap Alloc
Total heap used by Neoview SQL for the query
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, which is the sum of the SQL Space
Used and SQL Heap Used
Total Mem Alloc
Maximum memory used by the query, which is the sum of the SQL
Space Alloc, SQL Heap Alloc, EID Space Alloc, and EID Heap Alloc
Max Mem Used
Total amount of processor (CPU) time used by the query, which is the
sum of the SQL CPU time, Process Busy Time, Open time, and Process
Create time. The display is in seconds.
Total CPU (sec)
Derived Time
Total amount of processor (CPU) time used by the query. The display
format is hh:mm:ss.sss for hours, minutes, and seconds.
Total Processor
206
Find Offending Processes and Queries