EXA_SQL_LAST_DAY
This system table contains all executed SQL statements without any reference to the executing user or detail SQL texts. Only those statements are considered which could be successfully compiled. All users 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 point of the statement |
STOP_TIME
|
Timestamp at the stop point 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 (over all nodes) |
PERSISTENT_DB_RAM_PEAK
|
Maximum usage of modified, persistent DB memory of the query in MiB (over all nodes) |
HDD_READ
|
Maximum read ratio for data not in DB memory in MiB per second (over all nodes). If this value is larger than 0, then data had to be loaded into the main memory. |
HDD_WRITE
|
Maximum write ratio to external storage in MiB per second (over all nodes). This column reflects only the data written during a |
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) If this value is larger than 0, then data had to be loaded into the main memory. |
LOCAL_WRITE_DURATION
|
Time spent writing data to local (non-cache) storage in seconds (maximum over all nodes) If this value is larger than 0, then data had to be loaded into the main memory. |
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 |
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 |
NET
|
Maximum network traffic ratio in MiB per second (sum of send/receive, per node) |
SUCCESS
|
Result of the statement:
|
ERROR_CODE
|
Error code if the statement failed |
ERROR_TEXT
|
Error text if the statement failed |
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:
|
CLUSTER_NAME
|
Name of the cluster where the SQL was executed |
SNAPSHOT_MODE
|
The snapshot execution mode for this query:
|