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.

Parent topic: System Views

Thank you very much for your feedback. We will continue working to improve the documentation.

The system is busy. Please try again later.