Updated on 2025-07-15 GMT+08:00

ADM_HIST_SQLSTAT

ADM_HIST_SQLSTAT displays information about statements executed on the current node.

Table 1 ADM_HIST_SQLSTAT columns

Name

Type

Description

instance_number

integer

Instance ID of a snapshot.

sql_id

bigint

Query ID.

plan_hash_value

bigint

ID of the normalized SQL statement.

module

text

Name of the module that is executing when the SQL statement is first parsed.

elapsed_time_delta

bigint

Valid DB time, which is accumulated if multiple threads are involved (unit: μs).

cpu_time_delta

bigint

CPU time (unit: μs).

executions_delta

integer

Increment in the number of executions that have occurred on this object since it was brought into the cache.

iowait_delta

bigint

I/O time (unit: μs).

apwait_delta

integer

Delta value of the application wait time.

rows_processed_delta

bigint

Number of rows in the result set returned by the SELECT statement.

snap_id

integer

Unique snapshot ID.