beautypg.com

HP Neoview Release 2.5 Software User Manual

Page 206

background image

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