Neoview Repository User Guide (R2.4 SP2)

Table 3-1 QUERY_STATS_VW1 Field Definitions (continued)
DescriptionData TypeField Name
Cumulative number of times record (row)
locks were escalated to file (table) locks
during query execution.
LARGEINT DEFAULT
NULL
LOCK_ESCALATIONS
Number of times the statement waited for a
lock request (concurrency cost). Access to
the table is delayed due to conflicting locks.
Ideally, this number is zero or very small.
LARGEINT DEFAULT
NULL
LOCK_WAITS
Size, in bytes, of the total number of
messages sent to the Encapsulated SQL
Access Manager (ESAM).
LARGEINT DEFAULT
NULL
MESSAGE_BYTES_TO_DISK
Number of messages sent to ESAM. That is,
the number of messages exchanged between
the file system and the disk process.
LARGEINT DEFAULT
NULL
MESSAGES_TO_DISK
Cumulative number of rows accessed in each
table to evaluate the statement. This includes
records examined by the disk process, the
file system, and the SQL Executor.
LARGEINT DEFAULT
NULL
ROWS_ACCESSED
Cumulative number of rows retrieved and/or
actually used. Number of rows that were
returned by Executor in Disk (EID) process.
LARGEINT DEFAULT
NULL
ROWS_RETRIEVED
Number of rows actually inserted, updated,
deleted in the base tables, by a query.
LARGEINT DEFAULT
NULL
NUM_ROWS_IUD
The number of OPEN partition calls
performed by the SQL Executor on behalf of
this query.
LARGEINT DEFAULT
NULL
NUM_OPENS
Time in microseconds this process spent
doing file OPENs.
LARGEINT DEFAULT
NULL
OPEN_BUSY_TIME
Time in seconds this process spent doing file
OPENs.
FLOAT(54) DEFAULT
NULL
OPEN_BUSY_TIME_SEC
Number of new processes created by the
Executor on behalf of this process.
INTEGER UNSIGNED
DEFAULT NULL
PROCESSES_CREATED
Time in microseconds the Executor spent
creating new processes.
LARGEINT NO
DEFAULT
PROCESS_CREATE_BUSY_TIME
Time in seconds the Executor spent creating
new processes.
FLOAT(54) DEFAULT
NULL
PROCESS_CREATE_BUSY_TIME_SEC
The first 254 characters of query SQL text. If
query text is longer than 254 characters, the
entire query text is available in “VIEW
NEO.HP_METRICS.SQL_TEXT_VW1”
(page 32).
CHAR(254) DEFAULT
NULL
SQL_TEXT
Indicates the status of the SQL_TEXT field:
• zero (0)– all SQL Text for the query is in
this field.
• 1 – only a preview (the first 254
characters) of the text is in the SQL_TEXT
field and the entire query text is stored in
“VIEW
NEO.HP_METRICS.SQL_TEXT_VW1”
(page 32)
SMALLINT UNSIGNED
DEFAULT NULL
SQL_TEXT_OVERFLOW_INDICATOR
Query Statistics 31