HP Neoview Release 2.3 Software - Manual (Page 31)

Table 3-4 QUERY_RUNTIME_STATS_V1 Field Definitions (continued)
Description Data Type
Field Name (* means available only in
this view)
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*
Estimated cost (time in seconds) of the
SQL operations in the Master Executor.
The estimate occurs at the time the
query is prepared. DOUBLE PRECISION NO DEFAULT EST_COST*
Estimate of the number of seconds of
I/O time (seeks plus data transfer) to
perform the I/O for this query. The
estimate occurs at the time the query
is prepared. DOUBLE PRECISION NO DEFAULT EST_IO_TIME*
Estimate of the number of seconds
required for the messaging for this
query, including local and remote
messages, and the amount of data sent.
The estimate occurs at the time the
query is prepared. DOUBLE PRECISION NO DEFAULT EST_MESSAGE_TIME*
Query Statistics 31