HP Neoview Release 2.4 Software - Manual (Page 108)

Table C-7 QUERY_RUNTIME_STATS_V1 Field Definitions (continued)
Description Data Type
Field Name (* means available only in
this view)
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
Repository internal. Identification
number of the Query Runtime
Statistics metric class (measurement)
in the Metric Class Registry. INTEGER UNSIGNED NO
DEFAULT METRIC_CLASS_ID
Repository internal. Internal version
number of the Query Runtime
Statistics metric (measurement) in the
Metric Class Registry. INTEGER UNSIGNED NO
DEFAULT METRIC_CLASS_VERSION
Repository internal. CHAR(10) NO DEFAULT METRIC_CTRL
108 Pre-R2.4 SP2 Query Statistics Views