HP Neoview Release 2.4 Software - Manual (Page 34)

Table 3-4 QUERY_RUNTIME_STATS_V1 Field Definitions (continued)
Description Data Type
Field Name (* means available only in
this view)
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*
Estimate of the number of seconds to
wait for an operation to complete, (e.g.,
opening a table or starting a process).
The estimate occurs at the time the
query is prepared. DOUBLE PRECISION NO DEFAULT EST_IDLE_TIME*
Estimate of the number of seconds of
processor time it might take to execute
the query. The estimate occurs at the
time the query is prepared. DOUBLE PRECISION NO DEFAULT EST_NODE_TIME*
Estimated total cost of the query, in
seconds. The cost for this operator plus
all operators below this operator in the
tree. For the Master, this is all other
operators in the tree. Sum of
EST_IDLE_TIME, EST_IO_TIME,
EST_MSG_TIME, and
EST_NODE_TIME. The estimate
occurs at the time the query is
prepared. DOUBLE PRECISION NO DEFAULT EST_TOTAL_TIME*
Estimated number of rows that will be
returned. The estimate occurs at the
time the query is prepared. DOUBLE PRECISION NO DEFAULT EST_CARDINALITY*
Number of bytes returned for statistics
counts. LARGEINT SIGNED NO DEFAULT STATS_BYTES*
Calculated number of elapsed
microseconds that the master executor
spent on behalf of the query since the
query began execution, computed as
query execution end time minus query
execution start time. If query execution
start time (EXEC_START_TS), end time
(EXEC_END_TS), or both are NULL,
this value is also NULL. INTERVAL SECOND(12,6) NO
DEFAULT MASTER_EXECUTOR_BUSY_TIME*
34 Repository Views