EXA_DBA_AUDIT_SQL

This system table contains all executed SQL statements if auditing is enabled. This system table can be cleared by the statement TRUNCATE AUDIT LOGS. Only users with the SELECT ANY DICTIONARY system privilege have access to the table.

Column Name Description
SESSION_ID ID of the session
STMT_ID Serially numbered ID of statement within a session
COMMAND_NAME Name of the statement (for example, SELECT, COMMIT, or MERGE)
COMMAND_CLASS Class of statement (for example, DQL, TRANSACTION, or DML)
DURATION Duration of the statement in seconds
START_TIME Timestamp at the start of the statement
STOP_TIME Timestamp at the stop of the statement
CPU CPU usage as percentage of total system CPU resources available
TEMP_DB_RAM_PEAK Maximum usage of temporary DB memory of the query in MiB (overall nodes)
PERSISTENT_DB_RAM_PEAK Maximum usage of modified, persistent DB memory of the query in MiB (overall nodes)
HDD_READ Hard disk maximum read ratio in MiB per second (per node, averaged over the duration)

If this value is larger than 0, then data had to be loaded into the main memory.

HDD_WRITE Hard disk maximum write ratio in MiB per second (per node, averaged over the duration)

This column reflects only the data written during a COMMIT. For other statements its value is NULL.

LOCAL_READ_SIZE Total size of data read from local (non-cache) storage in MiB (sum over all nodes)
LOCAL_READ_DURATION Time spent reading data from local (non-cache) storage in seconds (maximum over all nodes)
LOCAL_WRITE_SIZE

Total size of data written to local (non-cache) storage in MiB (sum over all nodes)

This column reflects only the data written during a COMMIT. For other statements its value is NULL.

LOCAL_WRITE_DURATION

Time spent writing data to local (non-cache) storage in seconds (maximum over all nodes)

This column reflects only the data written during a COMMIT. For other statements its value is NULL.

CACHE_READ_SIZE Total size of data read from cache in MiB (sum over all nodes)
CACHE_READ_DURATION Time spent reading data from cache in seconds (maximum over all nodes)
CACHE_WRITE_SIZE Total size of data written to cache in MiB (sum over all nodes)
CACHE_WRITE_DURATION Time spent in writing data to cache in seconds (maximum over all nodes)
REMOTE_READ_SIZE Total size of data read from remote storage in MiB (sum over all nodes)
REMOTE_READ_DURATION Time spent in reading data from remote storage in seconds (maximum over all nodes)
REMOTE_WRITE_SIZE

Total size of data written to remote storage in MiB (sum over all nodes).

This column reflects only the data written during a COMMIT. For other statements its value is NULL.

REMOTE_WRITE_DURATION

Time spent writing data to remote storage in seconds (maximum over all nodes).

This column reflects only the data written during a COMMIT. For other statements its value is NULL.

NET Network traffic ratio in MiB per second (sum of send/receive, per node, averaged over the duration)
SUCCESS
  • TRUE: Statement was executed successfully
  • FALSE: Statement failed (for example, with a data exception)
ERROR_CODE Error code if the statement failed
ERROR_TEXT Error text if the statement failed
SCOPE_SCHEMA Schema that was explicitly opened by means of a connection parameter or OPEN SCHEMA command before statement execution
CONSUMER_GROUP Consumer group at query start
NICE NICE attribute
RESOURCES Share of the CPU allocated to this query, expressed in percentage. This depends on factors such as number of queries running in parallel and consumer groups
ROW_COUNT Number of result rows for queries, or number of affected rows for DML and DDL statements
EXECUTION_MODE

The following execution modes are supported:

  • EXECUTE: Normal execution of statements
  • PREPARE: Prepared phase for prepared statements
  • CACHED: Cached query results
  • PREPROCESS: Execution of the Preprocessor script
  • CRASHED: Marks the crashed queries (coredumps, segfaults, and so on)
CLUSTER_NAME Name of the cluster where the SQL was executed
SQL_TEXT SQL text limited to 2,000,000 characters
SNAPSHOT_MODE

The snapshot execution mode for this query:

  • OFF: No snapshot mode
  • ON: Snapshot mode for all objects
  • SYSTEM TABLES: Only system tables operate in snapshot mode