HP Neoview Release 2.4 Software - Manual (Page 33)

Table 3-4 QUERY_RUNTIME_STATS_V1 Field Definitions (continued)
Description Data Type
Field Name (* means available only in
this view)
Usually the warning number that is
returned to the stats collector while
obtaining statistics from RMS. A
warning of 8922 means that one or
more nodes did not report the statistics
for the given query. INTEGER SIGNED NO DEFAULT STATS_ERROR_CODE*
Number of physical disk I/O
operations performed for this
statement. LARGEINT SIGNED NO DEFAULT DISK_IOS*
Cumulative number of times record
locks were escalated to file locks. LARGEINT SIGNED NO DEFAULT LOCK_ESCALATIONS
Number of times the statement waited
for a lock request (concurrency cost). LARGEINT SIGNED NO DEFAULT LOCK_WAITS
Number of bytes written to disk. LARGEINT SIGNED NO DEFAULT MESSAGE_BYTES_TO_DISK
Number of messages sent to disk. LARGEINT SIGNED NO DEFAULT MESSAGES_TO_DISK
Number of records accessed by the
disk process or the file system to
evaluate the statement. LARGEINT SIGNED NO DEFAULT ROWS_ACCESSED
Cumulative number of rows retrieved. LARGEINT SIGNED NO DEFAULT ROWS_RETRIEVED
Number of rows
updated/inserted/deleted. This value
is NULL for queries in process or for
which the Repository did not receive
end statistics. It is 0 for SELECT
queries for which the Repository
received end statistics and >0 for UID
queries for which the Repository
received end statistics. LARGEINT SIGNED NO DEFAULT NUM_ROWS_UID
Time, in microseconds, that the query
spent in the Workload Management
queue before it started executing. INTERVAL SECOND(12,6) NO
DEFAULT QUE_TIME*
Number of OPEN calls performed by
the Executor on behalf of this query. LARGEINT SIGNED NO DEFAULT OPENS*
An approximation of the total node
time spend in master and ESPs
involved in the query. The node time
is expressed in microseconds. INTERVAL SECOND(12,6) NO
DEFAULT SQL_PROCESS_BUSY_TIME*
Number of new processes created by
the Executor on behalf of this process. INTEGER SIGNED NO DEFAULT NUM_PROCESSES_CREATED*
Estimated number of rows to be
accessed from Disk Process at runtime
by EID (Executor in Disk Process). This
value is meaningful for SELECT, not
for Insert/Update/Delete. For
Insert/Update/Delete, the value is
reported as 0.0. DOUBLE PRECISION NO DEFAULT EST_ACCESSED_ROWS*
Estimated number of rows to be
returned by EID after applying
selection predicates DOUBLE PRECISION NO DEFAULT EST_USED_ROWS*
Query Statistics 33