HP Neoview Release 2.5 Software - Manual (Page 97)

Table E-1 QUERY_STATS_VW1 Field Definitions (continued)
Description Data Type Field Name
An approximation, in microseconds, of the
total node time spent in the Master Executor
process and all ESPs involved in the query.
This is a cumulative value, across all ESPs
across all segments.
Example: 31.169480999999998 LARGEINT DEFAULT
NULL SQL_PROCESS_BUSY_TIME
An approximation, in seconds, of the total
node time spent in the Master Executor
process and all ESPs involved in the query.
This value is cumulative across all ESPs
across all segments.
Example: 39593 FLOAT(54) DEFAULT
NULL SQL_PROCESS_BUSY_TIME_SEC
Cumulative node busy time in microseconds
for all disk processes involved in executing
the query.
Example: 0.039592999999999996
LARGEINT DEFAULT
NULL DISK_PROCESS_BUSY_TIME
Cumulative node busy time, in seconds, for
all disk processes involved in executing the
query.
Example: : 0.000000039592999999999996 FLOAT(54) DEFAULT
NULL DISK_PROCESS_BUSY_TIME_SEC
Number of physical disk I/O operations
(reads or writes) caused by accessing this
table. LARGEINT DEFAULT
NULL DISK_IOS
The number of SQL processes involved in
execution of this query. INTEGER NUM_SQL_PROCESSES
Amount of “space” type (static) memory, in
kilobytes, allocated (reserved) for query
processes (master executor and ESPs) at the
beginning of query execution. This value
stays constant for the duration of query
execution. INTEGER DEFAULT
NULL SQL_MEMORY_SPACE_ALLOCATED
Amount of “space” type (static) memory, in
kilobytes, allocated (reserved) for query
processes (master executor and ESPs) at the
beginning of query execution.
This value stays constant for the duration of
query execution. It should be less than or
equal to the SQL_MEMORY_SPACE_
ALLOCATED value. This is the value at the
end of query execution. INTEGER DEFAULT
NULL SQL_MEMORY_SPACE_USED
Amount of “heap” type (dynamic) memory,
in kilobytes, allocated (reserved) for query
processes (master executor and ESPs) at the
beginning of query execution. The processes
that execute the query request this memory
during execution, thus the amount can
change as the query runs. This is the value
at the end of query execution. INTEGER SIGNED
DEFAULT NULL SQL_MEMORY_HEAP_ALLOCATED
Amount of “heap” type (dynamic) memory,
in kilobytes, actually used for query
processes (master executor and ESPs) during
query execution. This is the value at the end
of query execution. INTEGER SIGNED
DEFAULT NULL SQL_MEMORY_HEAP_USED
Query Statistics for R2.4 SP2 97