Neoview Workload Management Services Guide (R2.4)

Table A-13 Query Runtime Statistics (continued)
DescriptionData TypeColumn Name
OTHER
UNKNOWN
SELECT_UNIQUE
SELECT_NON_UNIQUE
INSERT_UNIQUE
INSERT_NON_UNIQUE
UPDATE_UNIQUE
UPDATE_NON_UNIQUE
DELETE_UNIQUE
DELETE_NON_UNIQUE
CONTROL
SET_TRANSACTION
SET_CATALOG
SET_SCHEMA
CALL_NO_RESULT_SETS
CALL_WITH_RESULT_SETS
SP_RESULT_SET
VARCHAR(21)STATEMENT_TYPE
Compilation start timeLARGEINTCOMP_START_TIME
Compilation end timeLARGEINTCOMP_END_TIME
Execution start timeLARGEINTEXEC_START_TIME
Execution end timeLARGEINTEXEC_END_TIME
INITIAL
OPEN
EOF
CLOSE
DEALLOCATED
FETCH
CLOSE_TABLES
PREPARE
PROCESS_ENDED
UNKNOWN
VARCHAR(21)EXEC_STATE
Elapsed time of query execution, in microseconds.LARGEINTELAPSED_TIME
Number of rows accessed from the tables referenced by the
query. This number includes the records examined by the disk
process, the file system, and the executor.
LARGEINTACCESSED_ROWS
Number of rows actually used by the query.LARGEINTUSED_ROWS
Number of messages sent to execute operations on the tables
referenced by the query, including messages sent by the file
system to the disk process and messages sent by the executor
to the compiler for recompilation. For example, a FETCH
operation through a secondary index generally sends two
messages.
LARGEINTMESSAGE_COUNT
Number of bytes to send and receive messages for this queryLARGEINTMESSAGE_BYTES
Number of bytes to send statistics messages for this queryLARGEINTSTATS_BYTES
Number of disk reads caused by accessing the tables referenced
by the query
LARGEINTDISK_IOS
Number of times the query waited for a lock requestLARGEINTLOCK_WAITS
Number of times a row lock was escalated to a file lock for the
query
LARGEINTLOCK_ESCALATIONS
The actual CPU time in microseconds spent by all DP2s involved
in executing the query
LARGEINTPROCESS_BUSYTIME
STATUS QUERIES Command 133