Neoview Repository User Guide (R2.4 SP2)

Table 3-1 QUERY_STATS_VW1 Field Definitions (continued)
DescriptionData TypeField Name
ANSI Timestamp, in Local Civil Time,
indicating when query compilation began.
That is, when a Prepare statement was issued
for this query.
Example: 2009-08-17 07:47:28.791758
TIMESTAMP(6) NO
DEFAULT
COMPILE_START_LCT_TS
ANSI Timestamp, in Coordinated Universal
Time, indicating when query compilation
began. That is, when a Prepare statement
was issued for this query.
Example: 2009-08-17 15:47:28.791758
TIMESTAMP(6)
DEFAULT NULL
COMPILE_START_UTC_TS
ANSI Timestamp, in Local Civil Time,
indicating when query compilation ended.
That is, when the Prepare statement
completed for this query.
Example: 2009-08-17 07:47:28.795259
TIMESTAMP(6)
DEFAULT NULL
COMPILE_END_LCT_TS
ANSI Timestamp, in Coordinated Universal
Time, indicating when query compilation
ended. That is, when the Prepare statement
completed for this query.
Example: 2009-08-17 15:47:28.795259
TIMESTAMP(6)
DEFAULT NULL
COMPILE_END_UTC_TS
Calculated compile time in microseconds,
computed as compilation end time minus
compilation start time. This is the amount of
time needed to prepare the query.
This value is obtained from the compiler.
Example: 3501
LARGEINT DEFAULT
NULL
COMPILE_ELAPSED_TIME
Compile time in seconds, computed as
compilation end time minus compilation
start time. This is the amount of time needed
to prepare the query.
This value is obtained from the compiler.
Example: 0.0035009999999999998
FLOAT(54) DEFAULT
NULL
COMPILE_ELAPSED_TIME_SEC
Specifies the choice of CPU Subsets to be
used for placement of ESPs.. The value used
by the compiler for ESP placement for this
query.
Example: 697115338
LARGEINT DEFAULT
NULL
COMPILE_AFFINITY_NUM
Degree of parallelism used by the query. The
number of ESP operators that are reused to
parallelize a single fragment of the query
plan. If different fragments in the same plan
are parallelized to different extents, then this
counter reports the degree of parallelization
of the fragment that is parallelized the most.
Example: 0
INTEGER UNSIGNED
DEFAULT NULL
COMPILE_DEGREE_OF_PARALLELISM
Query Statistics 23