HP Neoview Release 2.3 Software User Manual

Page 32

Table 3-4 QUERY_RUNTIME_STATS_V1 Field Definitions (continued)

Description

Data Type

Field Name (* means available only in
this view)

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.