HP Neoview Release 2.5 Software - Manual (Page 94)

Table E-1 QUERY_STATS_VW1 Field Definitions (continued)
Description Data Type Field Name
Estimated total cost (time in seconds) of the
SQL operations for this query in the Master
Executor. The estimate occurs at the time the
query is prepared.
Example: 1.74125E-6 DOUBLE PRECISION
DEFAULT NULL EST_COST
Estimated number of rows that will be
returned. The estimate occurs at the time the
query is prepared.
Example: 10.0 DOUBLE PRECISION
NO DEFAULT EST_CARDINALITY
Estimated number of rows to be accessed by
SELECT statements from Disk Process at
runtime by EID (Executor in Disk Process).
For Insert/Update/Delete statements, the
value is reported as 0.0. DOUBLE PRECISION
DEFAULT NULL EST_ACCESSED_ROWS
Estimated number of rows to be returned by
EID (Executor in Disk Process) after applying
selection predicates based on SELECT
statements. For Insert/Update/Delete
statements, the value is reported as 0.0. DOUBLE PRECISION
DEFAULT NULL EST_USED_ROWS
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.
Example: 0.0 DOUBLE PRECISION
DEFAULT NULL 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.
Example: 0.0 DOUBLE PRECISION
DEFAULT NULL EST_MSG_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.
Example: 0.0 DOUBLE PRECISION
DEFAULT NULL EST_IDLE_TIME
Estimate of the number of seconds of
processor time it might take to execute
instructions for this operator. The estimate
occurs at the time the query is prepared.
Example: 1.74125E-6 DOUBLE PRECISION
DEFAULT NULL EST_NODE_TIME
Estimated time in seconds for the SQL
operations for this query. This estimate
includes estimates of I/O time, Message time,
and Node time, and does not include Idle
time. The estimate occurs at the time the
query is prepared.
Example: 1.74125E-6
DOUBLE PRECISION
DEFAULT NULL EST_TOTAL_TIME
Estimate, in kilobytes, of the memory that
the query plan will use. The value is
computed based on operators that could
potentially consume large amounts of
memory: Hash Join, Hash Groupby, Sort,
Merge Join and Sequence.
Example: 0.0 DOUBLE PRECISION
DEFAULT NULL EST_TOTAL_MEM
94 Pre-R2.5 Query Statistics Views