HP Neoview Release 2.5 Software - Manual (Page 98)

Table E-1 QUERY_STATS_VW1 Field Definitions (continued)
Description Data Type Field Name
Amount of “space” type (static) memory, in
kilobytes, allocated (reserved) for the
Executor in Disk (EID) disk processes
involved in query execution. This process is
separate from master and ESPs, and all the
EID memory values are in addition to the
SQL memory values. This is the value at the
end of query execution. INTEGER DEFAULT
NULL EXECUTOR_IN_DISK_MEMORY_
SPACE_ALLOCATED
Amount of “space” type (static) memory, in
kilobytes, actually used by the Executor in
Disk (EID) disk processes involved in query
execution. This is the value at the end of
query execution. INTEGER DEFAULT
NULL EXECUTOR_IN_DISK_MEMORY_
SPACE_USED
Amount of “heap” type (dynamic) memory,
in kilobytes, allocated for the Executor in
Disk (EID) disk processes involved in query
execution. This is the value at the end of
query execution. INTEGER DEFAULT
NULL EXECUTOR_IN_DISK_MEMORY_
HEAP_ALLOCATED
Amount of “heap” type (dynamic) memory,
in kilobytes, actually used for the Executor
in Disk (EID) processes involved in query
execution. This is the value at the end of
query execution INTEGER DEFAULT
NULL EXECUTOR_IN-DISK_MEMORY_
HEAP_USED
Total memory allocated to the query. The
sum of SQL_MEMORY_SPACE_USED and
SQL_MEMORY_HEAP_USED. LARGEINT DEFAULT
NULL TOTAL_MEMORY_ALLOCATED
Maximum memory, in kilobytes, ever used
during the lifetime of the query. LARGEINT DEFAULT
NULL MAX_MEMORY_EVER_USED
Transaction identifier, in internal format, of
the transaction involved in executing the
query. CHAR(25) DEFAULT
NULL TRANSACTION_ID
Count of messages that are initiated from
the Master Executor process to ESPs or ESP
to ESP. This count includes both control and
data messages. LARGEINT DEFAULT
NULL NUM_REQUEST_MSGS
Number of message bytes sent as part of
NUM_REQUEST_MSGS. LARGEINT DEFAULT
NULL NUM_REQUEST_MSG_BYTES
Count of reply messages from ESPs. LARGEINT DEFAULT
NULL NUM_REPLY_MSGS
Number of bytes sent as part of the replies
from ESPs. LARGEINT DEFAULT
NULL NUM_REPLY_MSG_BYTES
RMS timestamp in Local Civil Time when
SQL sends the first result row to the Master
Executor process. TIMESTAMP(6)
DEFAULT NULL FIRST_RESULT_RETURN_LCT_TS
RMS timestamp in Coordinated Universal
Time when SQL sends the first result row to
the Master Executor process. TIMESTAMP(6)
DEFAULT NULL FIRST_RESULT_RETURN_UTC_TS
Number of rows returned from the root
operator to the Master Executor process and
to the application in both the regular fetch
and rowset fetch. LARGEINT DEFAULT
NULL ROWS_RETURNED_TO MASTER
98 Pre-R2.5 Query Statistics Views