HP Neoview Release 2.5 Software - Manual (Page 109)

Table E-5 QUERY_RUNTIME_STATS_V1_2400 Field Definitions (continued)
Description Data Type
Field Name (* means available only in
this view)
Starting priority of the Master Executor
process. SMALLINT UNSIGNED NO
DEFAULT START_PRIORITY
Cumulative node utilization
percentage for the Master Executor
process during the elapsed time of this
query. SMALLINT UNSIGNED NO
DEFAULT MASTER_BUSY*
Cumulative node utilization
percentage for the busiest Executor
Server Process in the query. SMALLINT UNSIGNED NO
DEFAULT NODE_BUSY_FOR_BUSIEST_ESP*
Percentage of available processing
node resources (for the whole Neoview
platform) used by the Master Executor
process and all its child processes for
this query. SMALLINT UNSIGNED NO
DEFAULT PCT_BUSY_ALL_PROCESSES*
Node of the busiest Executor Server
Process involved in the query. SMALLINT UNSIGNED NO
DEFAULT BUSIEST_ESP_NODE*
Process identification number of the
busiest Executor Server Process
involved in the query. SMALLINT UNSIGNED NO
DEFAULT BUSIEST_ESP_PIN*
Segment of the busiest Executor Server
Process involved in the query. SMALLINT UNSIGNED NO
DEFAULT BUSY_ESP_SEGMENT*
Level of utilization that causes a
process to be identified as busy. SMALLINT UNSIGNED NO
DEFAULT BUSY_THRESHOLD*
Cumulative node utilization
percentage for all the Executor Server
Processes. SMALLINT UNSIGNED NO
DEFAULT PCT_NODE_BUSY_ALL_ESPS*
Node utilization percentage for all
query processes for the last statistics
collection interval. SMALLINT UNSIGNED NO
DEFAULT PCT_TOT_BUSY_FOR_INTERVAL*
Node utilization percentage for all
Executor Server processes for the last
interval. SMALLINT UNSIGNED NO
DEFAULT ESP_BUSY_FOR_INTERVAL*
Node utilization for the Master
Executor for the last interval. SMALLINT UNSIGNED NO
DEFAULT MASTER_BUSY_FOR_INTERVAL*
Minimum priority this Master
Executor has had while executing. SMALLINT UNSIGNED NO
DEFAULT MIN_PRIORITY_ESP*
Estimated parallelism of the query,
computed as
BusyExecutorServerProcesses
/Number
of processors * 100.
SMALLINT UNSIGNED NO
DEFAULT EST_PARALLELISM*
Difference in minutes between the time
when WMS last refreshed statistics
from RMS. (REFRESH_TS value) and
the time when the Repository last
wrote this row (LAST_UPDATE_TS).
Indicates lag time, if any, between
WMS statistics and Repository
statistics. INTERVAL MINUTE(6) NO
DEFAULT LAG_ELAPSED_TIME*
Offset in minutes between Local Civil
Time and UTC when this record was
written. INTERVAL MINUTE(3) NO
DEFAULT UTC_BIAS
Query Statistics for Pre-R2.4 SP1 109