beautypg.com

HP Neoview Release 2.4 Software User Manual

Page 115

background image

Table C-7 QUERY_RUNTIME_STATS_V1 Field Definitions (continued)

Description

Data Type

Field Name (* means available only in
this view)

ANSI Timestamp, in Local Civil Time,
indicating when query execution
began. If the query has not yet begun
execution, the value is NULL.

TIMESTAMP(6) NO DEFAULT

EXEC_START_TS

ANSI Timestamp indicating when
query execution ended, converted to
LCT from UTC. If the query has not
yet begun execution, the value is
NULL.

TIMESTAMP(6) NO DEFAULT

EXEC_END_TS

1

Total memory used by a query in the sum: “SQL Space Used” + “SQL Heap Used” + “EID Space Used” + “EID Heap
Used”. This value changes during the lifetime of a query.

VIEW NEO.HP_METRICS.QUERY_RUNTIME_STATS_V1

115