Statistical System Tables

The following system tables contain historical data about the usage and the status of the DBMS. They are placed in a system schema EXA_STATISTICS that is automatically integrated in the namespace. These system tables can also be retrieved in the EXA_SYSCAT system table. Timestamps of historical statistics are stored in the current database time zone (DBTIMEZONE).

Statistics are updated periodically, for an explicit update, you can use the command FLUSH STATISTICS.

Most statistical system tables can be accessed by all users as read-only and are subject to the transactional concept explained in Transaction Management. Therefore, you may have to open a new transaction to see the updated data.

System tables with DBA in its name require the SELECT ANY DICTIONARY privilege to access them.

Within a transaction, you should access exclusively either statistical system tables or normal database objects to minimize transactional conflicts for the user and the DBMS.

The following table provides you with a list of all the statistical system tables in Exasol. Click the table name to view its details.

Statistical System Table Name	Description
EXA_DBA_AUDIT_IMPERSONATION	This system table contains all impersonations.
EXA_DBA_AUDIT_SESSIONS	This system table contains all sessions if auditing is switched on in EXAoperation.
EXA_DBA_AUDIT_SQL	This system table contains all executed SQL statements if the auditing is switched on in EXAoperation.
EXA_DBA_IMPERSONATION_LAST_DAY	This system table contains all impersonation of last day.
EXA_DBA_PROFILE_LAST_DAY	This system table contains all profiling information of sessions with activated profiling.
EXA_DBA_PROFILE_RUNNING	This system table contains all profiling information of running queries.
EXA_DBA_SESSIONS_LAST_DAY	This system table contains all sessions of the last day.
EXA_DBA_TRANSACTION_CONFLICTS	This system table contains all transaction conflicts.
EXA_DB_SIZE_LAST_DAY	This system table contains cluster-level database size of the last 24 hours. For each cluster the information is aggregated across all nodes.
EXA_DB_SIZE_HOURLY	This system table contains information about hourly aggregated database sizes at cluster level, sorted by the interval start.
EXA_DB_SIZE_DAILY	This system table contains information about daily aggregated database sizes at cluster level, sorted by the interval start.
EXA_DB_SIZE_MONTHLY	This system table contains information about monthly aggregated database sizes at cluster level, sorted by the interval start.
EXA_MONITOR_LAST_DAY	This system table contains monitoring information (the maximum values in the cluster).
EXA_MONITOR_HOURLY	This system table contains the hourly aggregated monitoring information (of values from EXA_MONITOR_LAST_DAY) for a cluster sorted by the interval start and cluster name.
EXA_MONITOR_DAILY	This system table contains the daily aggregated monitoring information (of values from EXA_MONITOR_LAST_DAY) for a cluster sorted by the interval start and cluster name.
EXA_MONITOR_MONTHLY	This system table contains the monthly aggregated monitoring information (of values from EXA_MONITOR_LAST_DAY) for a cluster sorted by the interval start and cluster name.
EXA_SQL_LAST_DAY	This system table contains all executed SQL statements without any reference to the executing user or detail SQL texts.
EXA_SQL_HOURLY	This system table contains the hourly aggregated number of executed SQL statements per cluster sorted by the interval start.
EXA_SQL_DAILY	This system table contains the daily aggregated number of executed SQL statements per cluster sorted by the interval start.
EXA_SQL_MONTHLY	This system table contains the monthly aggregated number of executed SQL statements per cluster sorted by the interval start.
EXA_SYSTEM_EVENTS	This system table contains system events like startup or shutdown of the DBMS.
EXA_USAGE_LAST_DAY	This system table contains information about the DBMS usage of the last 24 hours.
EXA_USAGE_HOURLY	This system table contains the cluster level hourly aggregated usage information of the DBMS, sorted by the interval start.
EXA_USAGE_DAILY	This system table contains the cluster level daily aggregated usage information of the DBMS, sorted by the interval start.
EXA_USAGE_MONTHLY	This system table contains the cluster level monthly aggregated usage information of the DBMS, sorted by the interval start.
EXA_USER_IMPERSONATION_LAST_DAY	This system table contains all impersonations involving the current user.
EXA_USER_PROFILE_LAST_DAY	This system table contains all profiling information of own sessions with activated profiling.
EXA_USER_PROFILE_RUNNING	This system table contains all profiling information of running queries for the current user.
EXA_USER_SESSIONS_LAST_DAY	This system table contains all `own` sessions of the last day. All users have access to the table.
EXA_USER_TRANSACTION_CONFLICTS_LAST_DAY	This system table describes all transaction conflicts linked to the current user's sessions.

EXA_DBA_AUDIT_IMPERSONATION

This system table contains all impersonations. For details about impersonation, see IMPERSONATE.

Only users with the SELECT ANY DICTIONARY system privilege have access to the table.

Column	Meaning
`IMPERSONATOR`	User impersonating
`IMPERSONATE`	User being impersonated
`SESSION_ID`	Session ID of impersonation
`STMT_ID`	First statement of the new effective user

EXA_DBA_AUDIT_SESSIONS

This system table contains all sessions if auditing is switched on in EXAoperation.

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	Meaning
`SESSION_ID`	ID of the session
`LOGIN_TIME`	Login time
`LOGOUT_TIME`	Logout time
`USER_NAME`	User name
`CLIENT`	Client application used by the user
`DRIVER`	Used driver
`ENCRYPTED`	Flag whether the connection is encrypted
`HOST`	Computer name or IP address from where the user has logged-in
`OS_USER`	User name used by the user to log into the operating system of the computer from where the login came
`OS_NAME`	Operating system of the client server
`SUCCESS`	`TRUE`: Login was successfully `FALSE`: Login failed (for example, because of a wrong password)
`ERROR_CODE`	Error code if the login failed
`ERROR_TEXT`	Error text if the login failed
`CLUSTER_NAME`	Name of the cluster

EXA_DBA_AUDIT_SQL

This system table contains all executed SQL statements if the auditing is switched on in EXAoperation.

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	Meaning
`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 utilization in percentage
`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)
`LOCAL_WRITE_DURATION`	Time spent writing data to local (non-cache) storage in seconds (maximum over all nodes)
`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)s
`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 time spent in writing data 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 where the user was located
`CONSUMER_GROUP`	Consumer group at query start
`NICE`	`NICE` attribute
`RESOURCES`	Allocated resources in percentage
`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
`SQL_TEXT`	SQL text limited to 2,000,000 characters

EXA_DBA_IMPERSONATION_LAST_DAY

This system table contains all impersonation of last day. For details about impersonation, see IMPERSONATE.

Only users with the SELECT ANY DICTIONARY system privilege have access to the table.

Column	Meaning
`IMPERSONATOR`	User impersonating
`IMPERSONATEE`	User being impersonated
`SESSION_ID`	Session id of impersonation
`STMT_ID`	First statement of the new effective user

EXA_DBA_PROFILE_LAST_DAY

This system table contains all profiling information of sessions with activated profiling. For more details, see Profiling.

Only users with the SELECT ANY DICTIONARY system privilege have access to the table.

Column	Meaning
`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`)
`PART_ID`	Serially numbered ID of the execution part within the statement
`PART_NAME`	Name of the execution part
`PART_INFO`	Extended information of the execution part. For example: `GLOBAL`: Global action (for example, global join) `EXPRESSION INDEX`: Non-persistent join index which is built on an expression `NL JOIN`: Nested loop join (cross product) `REPLICATED`: Replicated object (for example, small tables) `TEMPORARY`: Temporary object (for intermediate results)
`OBJECT_SCHEMA`	Schema of the processed object
`OBJECT_NAME`	Name of the processed object
`OBJECT_ROWS`	Number of rows of the processed object
`OUT_ROWS`	Number of result rows of the execution part
`DURATION`	Duration of the execution part in seconds
`CPU`	CPU utilization in percentage of the execution part (averaged over the duration)
`TEMP_DB_RAM_PEAK`	Usage of temporary DB memory of the execution part in MiB (overall nodes, maximum over the duration)
`PERSISTENT_DB_RAM_PEAK`	Usage of modified, persistent DB memory of the execution part in MiB (overall nodes, maximum over the duration)
`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 time spent writing data 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 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 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 time spent writing data 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)
`REMARKS`	Any additional information such as, index type and columns, or index used for a join. Some examples for the `REMARKS` column: Join descriptions Column which is read for a filter
`SQL_TEXT`	Corresponding SQL text

EXA_DBA_PROFILE_RUNNING

This system table contains all profiling information of running queries. For more details, see Profiling.

Only users with the SELECT ANY DICTIONARY system privilege have access to the table.

Column	Meaning
`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`)
`PART_ID`	Serially numbered id of the execution part within the statement
`PART_NAME`	Name of the execution part (see also Section 3.9, “Profiling”)
`PART_INFO`	Extended information of the execution part. For example: `GLOBAL`: Global action (for example, global join) `EXPRESSION INDEX`: Non-persistent join index which is built on an expression `NL JOIN`: Nested loop join (cross product) `REPLICATED`: Replicated object (for example, small tables) `TEMPORARY`: Temporary object (for intermediate results)
`PART_FINISHED`	Defines whether the execution part has already been finished
`OBJECT_SCHEMA`	Schema of the processed object
`OBJECT_NAME`	Name of the processed object
`OBJECT_ROWS`	Number of rows of the processed object
`OUT_ROWS`	Number of result rows of the execution part
`DURATION`	Duration of the execution part in seconds
`CPU`	CPU utilization in percentage of the execution part (averaged over the duration)
`TEMP_DB_RAM_PEAK`	Usage of temporary DB memory of the execution part in MiB (overall nodes, maximum over the duration)
`PERSISTENT_DB_RAM_PEAK`	Usage of modified, persistent DB memory of the execution part in MiB (overall nodes, maximum over the duration)
`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 time spent writing data 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 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 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 time spent writing data 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)
`REMARKS`	Any additional information such as, index type and columns, or index used for a join. Some examples for the `REMARKS` column: Join descriptions Column which is read for a filter
`SQL_TEXT`	Corresponding SQL text

EXA_DBA_SESSIONS_LAST_DAY

This system table contains all sessions of the last day.

Only users with the SELECT ANY DICTIONARY system privilege have access to the table.

Column	Meaning
`SESSION_ID`	ID of the session
`LOGIN_TIME`	Time of login
`LOGOUT_TIME`	Time of logout
`USER_NAME`	User name
`CLIENT`	Client application used by the user
`DRIVER`	Used driver
`ENCRYPTED`	Flag whether the connection is encrypted
`HOST`	Computer name or IP address from which the user has logged-in
`OS_USER`	User name used by the user to log in to the operating system of the computer from where the login came
`OS_NAME`	Operating system of the client server
`SUCCESS`	`TRUE`: Statement was executed successfully `FALSE`: Statement failed (for example, with a data exception)
`ERROR_CODE`	Error code if the login failed
`ERROR_TEXT`	Error text if the login failed
`CLUSTER_NAME`	Name of the cluster

EXA_DBA_TRANSACTION_CONFLICTS

This system table contains all transaction conflicts.

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	Meaning
`SESSION_ID`	ID of the session
`CONFLICT_SESSION_ID`	Session which produces the conflict
`START_TIME`	Start time of the conflict
`STOP_TIME`	End time of the conflict or `NULL` if the conflict is still open
`CONFLICT_TYPE`	Type of the conflict: `WAIT FOR COMMIT`: One session has to wait until the other one is committed `TRANSACTION ROLLBACK`: One session has to be rolled back due to a conflict
`CONFLICT_OBJECTS`	Name of the corresponding objects
`CONFLICT_INFO`	Additional information about the conflict

EXA_DB_SIZE_LAST_DAY

This system table contains cluster-level database sizes of the last 24 hours. For each cluster the information is aggregated across all nodes.

All users have access to the tables.

Column	Meaning
`CLUSTER_NAME`	Name of the cluster
`MEASURE_TIME`	Point of the measurement
`RAW_OBJECT_SIZE`	Uncompressed data volume in GiB
`MEM_OBJECT_SIZE`	Compressed data volume in GiB
`AUXILIARY_SIZE`	Size in GiB of auxiliary structures like indices
`STATISTICS_SIZE`	Size in GiB of statistical system tables
`RECOMMENDED_DB_RAM_SIZE`	Recommended DB RAM size in GiB to achieve the maximum system performance
`STORAGE_SIZE`	Size of the persistent volume in GiB
`USE`	Ratio of effectively used space of the persistent volume size in percentage
`TEMP_SIZE`	Size of the temporary volume in GiB
`OBJECT_COUNT`	Number of schema objects in the database.

EXA_DB_SIZE_HOURLY

This system table contains information about hourly aggregated database sizes at cluster level, sorted by the interval start.

All users have access to the table.

Column	Meaning
`CLUSTER_NAME`	Name of the cluster
`INTERVAL_START`	Start point of the aggregation interval
`RAW_OBJECT_SIZE_AVG`	Average uncompressed data volume in GiB
`RAW_OBJECT_SIZE_MAX`	Maximum uncompressed data volume in GiB
`MEM_OBJECT_SIZE_AVG`	Average compressed data volume in GiB
`MEM_OBJECT_SIZE_MAX`	Maximum compressed data volume in GiB
`AUXILIARY_SIZE_AVG`	Average size in GiB of auxiliary structures like indices
`AUXILIARY_SIZE_MAX`	Maximum size in GiB of auxiliary structures like indices
`STATISTICS_SIZE_AVG`	Average size in GiB of statistical system tables
`STATISTICS_SIZE_MAX`	Maximum size in GiB of statistical system tables
`RECOMMENDED_DB_RAM_SIZE_AVG`	Average recommended DB RAM size in GiB to achieve the optimal system performance
`RECOMMENDED_DB_RAM_SIZE_MAX`	Maximum recommended DB RAM size in GiB to achieve the optimal system performance
`STORAGE_SIZE_AVG`	Average size of the persistent volume in GiB
`STORAGE_SIZE_MAX`	Maximum size of the persistent volume in GiB
`USE_AVG`	Average ratio of effectively used space of the persistent volume size in percentage
`USE_MAX`	Maximum ratio of effectively used space of the persistent volume size in percentage
`TEMP_VOLUME_SIZE_AVG`	Average size in GiB of the temporary volume
`TEMP_VOLUME_SIZE_MAX`	Maximum size in GiB of the temporary volume
`OBJECT_COUNT_AVG`	Average number of schema objects in the database.
`OBJECT_COUNT_MAX`	Maximum number of schema objects in the database.

EXA_DB_SIZE_DAILY

This system table contains information about daily aggregated database sizes at cluster level, sorted by the interval start.

All users have access to the table.

Column	Meaning
`CLUSTER_NAME`	Name of the cluster
`INTERVAL_START`	Start point of the aggregation interval
`RAW_OBJECT_SIZE_AVG`	Average uncompressed data volume in GiB
`RAW_OBJECT_SIZE_MAX`	Maximum uncompressed data volume in GiB
`MEM_OBJECT_SIZE_AVG`	Average compressed data volume in GiB
`MEM_OBJECT_SIZE_MAX`	Maximum compressed data volume in GiB
`AUXILIARY_SIZE_AVG`	Average size in GiB of auxiliary structures like indices
`AUXILIARY_SIZE_MAX`	Maximum size in GiB of auxiliary structures like indices
`STATISTICS_SIZE_AVG`	Average size in GiB of statistical system tables
`STATISTICS_SIZE_MAX`	Maximum size in GiB of statistical system tables
`RECOMMENDED_DB_RAM_SIZE_AVG`	Average recommended DB RAM size in GiB to achieve the optimal system performance
`RECOMMENDED_DB_RAM_SIZE_MAX`	Maximum recommended DB RAM size in GiB to achieve the optimal system performance
`STORAGE_SIZE_AVG`	Average size of the persistent volume in GiB
`STORAGE_SIZE_MAX`	Maximum size of the persistent volume in GiB
`USE_AVG`	Average ratio of effectively used space of the persistent volume size in percentage
`USE_MAX`	Maximum ratio of effectively used space of the persistent volume size in percentage
`TEMP_VOLUME_SIZE_AVG`	Average size in GiB of the temporary volume
`TEMP_VOLUME_SIZE_MAX`	Maximum size in GiB of the temporary volume
`OBJECT_COUNT_AVG`	Average number of schema objects in the database.
`OBJECT_COUNT_MAX`	Maximum number of schema objects in the database.

EXA_DB_SIZE_MONTHLY

This system table contains information about monthly aggregated database sizes at cluster level, sorted by the interval start.

All users have access to the table.

Column	Meaning
`CLUSTER_NAME`	Name of the cluster
`INTERVAL_START`	Start point of the aggregation interval
`RAW_OBJECT_SIZE_AVG`	Average uncompressed data volume in GiB
`RAW_OBJECT_SIZE_MAX`	Maximum uncompressed data volume in GiB
`MEM_OBJECT_SIZE_AVG`	Average compressed data volume in GiB
`MEM_OBJECT_SIZE_MAX`	Maximum compressed data volume in GiB
`AUXILIARY_SIZE_AVG`	Average size in GiB of auxiliary structures like indices
`AUXILIARY_SIZE_MAX`	Maximum size in GiB of auxiliary structures like indices
`STATISTICS_SIZE_AVG`	Average size in GiB of statistical system tables
`STATISTICS_SIZE_MAX`	Maximum size in GiB of statistical system tables
`RECOMMENDED_DB_RAM_SIZE_AVG`	Average recommended DB RAM size in GiB to achieve the optimal system performance
`RECOMMENDED_DB_RAM_SIZE_MAX`	Maximum recommended DB RAM size in GiB to achieve the optimal system performance
`STORAGE_SIZE_AVG`	Average size of the persistent volume in GiB
`STORAGE_SIZE_MAX`	Maximum size of the persistent volume in GiB
`USE_AVG`	Average ratio of effectively used space of the persistent volume size in percentage
`USE_MAX`	Maximum ratio of effectively used space of the persistent volume size in percentage
`TEMP_VOLUME_SIZE_AVG`	Average size in GiB of the temporary volume
`TEMP_VOLUME_SIZE_MAX`	Maximum size in GiB of the temporary volume
`OBJECT_COUNT_AVG`	Average number of schema objects in the database.
`OBJECT_COUNT_MAX`	Maximum number of schema objects in the database.

EXA_MONITOR_LAST_DAY

This system table describes monitoring information (the maximum values in the cluster).

The data ratios don't indicate the hardware performance. They are introduced to improve the comparability in case of variations of the measure intervals. If you multiply the ratio with the last interval duration, you get the real data volumes.

All users have access to the table.

Column	Meaning
`CLUSTER_NAME`	Name of the cluster
`MEASURE_TIME`	Timestamp of the measurement
`LOAD`	System load (equals the load value of program up time)
`CPU`	CPU utilization in percentage (of the database instance, averaged over the last measure interval)
`TEMP_DB_RAM`	Usage of temporary DB memory in MiB (of the database instance, maximum over the last measure interval)
`PERSISTENT_DB_RAM`	Usage of modified, persistent DB memory in MiB (of the database instance, maximum over the last measure interval)
`HDD_READ`	Hard disk read ratio in MiB per second (per node, averaged over the last measure interval)
`HDD_WRITE`	Hard disk write ratio in MiB per second (per node, averaged over the last measure interval)
`LOCAL_READ_SIZE`	Data size read from local (non-cache) storage in MiB, (of the database instance, maximum over the last measure interval)
`LOCAL_READ_DURATION`	Time in seconds spent reading data from local (non-cache) storage, (of the database instance, maximum over the last measure interval)
`LOCAL_WRITE_SIZE`	Data size written to local (non-cache) storage in MiB, (of the database instance, maximum over the last measure interval)
`LOCAL_WRITE_DURATION`	Time in seconds spent writing data to local (non-cache) storage, (of the database instance, maximum over the last measure interval)
`CACHE_READ_SIZE`	Data size read from cache in MiB, (of the database instance, maximum over the last measure interval)
`CACHE_READ_DURATION`	Time in seconds spent reading data from cache, (of the database instance, maximum over the last measure interval)
`CACHE_WRITE_SIZE`	Data size written to cache in MiB, (of the database instance, maximum over the last measure interval)
`CACHE_WRITE_DURATION`	Time in seconds spent writing data to cache, (of the database instance, maximum over the last measure interval)
`REMOTE_READ_SIZE`	Data size read from remote storage in MiB, (of the database instance, maximum over the last measure interval)
`REMOTE_READ_DURATION`	Time in seconds spent reading data from remote storage, (of the database instance, maximum over the last measure interval)
`REMOTE_WRITE_SIZE`	Data size written to remote storage in MiB, (of the database instance, maximum over the last measure interval)
`REMOTE_WRITE_DURATION`	Time in seconds spent reading data from remote storage in MiB, (of the database instance, maximum over the last measure interval)
`NET`	Network traffic ratio in MiB per second (sum of send/receive, per node, averaged over the last measure interval)
`SWAP`	Swap ratio in MiB per second (averaged over the last measure interval). If this value is higher than 0, a system configuration problem may exist.

EXA_MONITOR_HOURLY

This system table contains the hourly aggregated monitoring information (of values from EXA_MONITOR_LAST_DAY) for a cluster, sorted by the interval start and cluster name.

All users have access to the tale.

Column	Meaning
`CLUSTER_NAME`	Name of the cluster
`INTERVAL_START`	Timestamp at the start of the aggregation interval
`LOAD_AVG`	Average system load (equals the 1-minute load value of program up time)
`LOAD_MAX`	Maximum system load (equals the 1-minute load value of program up time)
`CPU_AVG`	Average CPU utilization in percentage (of the database instance)
`CPU_MAX`	Maximum CPU utilization in percentage (of the database instance)
`TEMP_DB_RAM_AVG`	Average usage of temporary DB memory in MiB (of the database instance)
`TEMP_DB_RAM_MAX`	Maximum usage of temporary DB memory in MiB (of the database instance)
`PERSISTENT_DB_RAM_AVG`	Average usage of modified, persistent DB memory in MiB (of the database instance)
`PERSISTENT_DB_RAM_MAX`	Maximum usage of modified, persistent DB memory in MiB (of the database instance)
`HDD_READ_AVG`	Average hard disk read ratio in MiB per second
`HDD_READ_MAX`	Maximum hard disk read ratio in MiB per second
`HDD_WRITE_AVG`	Average hard disk write ratio in MiB per second
`HDD_WRITE_MAX`	Maximum hard disk write ratio in MiB per second
`LOCAL_READ_SIZE_AVG`	Average data size read from local (non-cache) storage in MiB
`LOCAL_READ_SIZE_MAX`	Maximum data size read from local (non-cache) storage in MiB
`LOCAL_READ_DURATION_AVG`	Average duration spent reading data from local (non-cache) storage in seconds
`LOCAL_READ_DURATION_MAX`	Maximum duration spent reading data from local (non-cache) storage in seconds
`LOCAL_WRITE_SIZE_AVG`	Average data size written to local (non-cache) storage in MiB
`LOCAL_WRITE_SIZE_MAX`	Maximum data size written to local (non-cache) storage in MiB
`LOCAL_WRITE_DURATION_AVG`	Average duration spent writing data to local (non-cache) storage in seconds
`LOCAL_WRITE_DURATION_MAX`	Maximum duration spent writing data to local (non-cache) storage in seconds
`CACHE_READ_SIZE_AVG`	Average data size read from cache in MiB
`CACHE_READ_SIZE_MAX`	Maximal data size read from cache in MiB
`CACHE_READ_DURATION_AVG`	Average duration spent reading data from cache in seconds
`CACHE_READ_DURATION_MAX`	Maximum duration spent reading data from cache in seconds
`CACHE_WRITE_SIZE_AVG`	Average data size written to cache in MiB
`CACHE_WRITE_SIZE_MAX`	Maximum data size written to cache in MiB
`CACHE_WRITE_DURATION_AVG`	Average duration spent writing data to cache in seconds
`CACHE_WRITE_DURATION_MAX`	Maximum duration spent writing data to cache in seconds
`REMOTE_READ_SIZE_AVG`	Average data size read from remote storage in MiB
`REMOTE_READ_SIZE_MAX`	Maximum data size read from remote storage in MiB
`REMOTE_READ_DURATION_AVG`	Average duration spent reading data from remote storage in seconds
`REMOTE_READ_DURATION_MAX`	Maximum duration spent reading data from remote storage in seconds
`REMOTE_WRITE_SIZE_AVG`	Average data size written to remote storage in MiB
`REMOTE_WRITE_SIZE_MAX`	Maximum data size written to remote storage in MiB
`REMOTE_WRITE_DURATION_AVG`	Average duration spent writing data to remote storage in seconds
`REMOTE_WRITE_DURATION_MAX`	Maximum duration spent writing data to remote storage in seconds
`NET_AVG`	Average network traffic ratio in MiB per second
`NET_MAX`	Maximum network traffic ratio in MiB per second
`SWAP_AVG`	Average swap ratio in MiB per second. If this value is higher than 0, a system configuration problem may exist.
`SWAP_MAX`	Maximum swap ratio in MiB per second. If this value is higher than 0, a system configuration problem may exist.

EXA_MONITOR_DAILY

This system table contains the daily aggregated monitoring information (of values from EXA_MONITOR_LAST_DAY) for a cluster, sorted by the interval start and cluster name.

All users have access to the table.

Column	Meaning
`CLUSTER_NAME`	Name of the cluster
`INTERVAL_START`	Timestamp at the start of the aggregation interval
`LOAD_AVG`	Average system load (equals the 1-minute load value of program up time)
`LOAD_MAX`	Maximum system load (equals the 1-minute load value of program up time)
`CPU_AVG`	Average CPU utilization in percentage (of the database instance)
`CPU_MAX`	Maximum CPU utilization in percentage (of the database instance)
`TEMP_DB_RAM_AVG`	Average usage of temporary DB memory in MiB (of the database instance)
`TEMP_DB_RAM_MAX`	Maximum usage of temporary DB memory in MiB (of the database instance)
`PERSISTENT_DB_RAM_AVG`	Average usage of modified, persistent DB memory in MiB (of the database instance)
`PERSISTENT_DB_RAM_MAX`	Maximum usage of modified, persistent DB memory in MiB (of the database instance)
`HDD_READ_AVG`	Average hard disk read ratio in MiB per second
`HDD_READ_MAX`	Maximum hard disk read ratio in MiB per second
`HDD_WRITE_AVG`	Average hard disk write ratio in MiB per second
`HDD_WRITE_MAX`	Maximum hard disk write ratio in MiB per second
`LOCAL_READ_SIZE_AVG`	Average data size read from local (non-cache) storage in MiB
`LOCAL_READ_SIZE_MAX`	Maximum data size read from local (non-cache) storage in MiB
`LOCAL_READ_DURATION_AVG`	Average duration spent reading data from local (non-cache) storage in seconds
`LOCAL_READ_DURATION_MAX`	Maximum duration spent reading data from local (non-cache) storage in seconds
`LOCAL_WRITE_SIZE_AVG`	Average data size written to local (non-cache) storage in MiB
`LOCAL_WRITE_SIZE_MAX`	Maximum data size written to local (non-cache) storage in MiB
`LOCAL_WRITE_DURATION_AVG`	Average duration spent writing data to local (non-cache) storage in seconds
`LOCAL_WRITE_DURATION_MAX`	Maximum duration spent writing data to local (non-cache) storage in seconds
`CACHE_READ_SIZE_AVG`	Average data size read from cache in MiB
`CACHE_READ_SIZE_MAX`	Maximal data size read from cache in MiB
`CACHE_READ_DURATION_AVG`	Average duration spent reading data from cache in seconds
`CACHE_READ_DURATION_MAX`	Maximum duration spent reading data from cache in seconds
`CACHE_WRITE_SIZE_AVG`	Average data size written to cache in MiB
`CACHE_WRITE_SIZE_MAX`	Maximum data size written to cache in MiB
`CACHE_WRITE_DURATION_AVG`	Average duration spent writing data to cache in seconds
`CACHE_WRITE_DURATION_MAX`	Maximum duration spent writing data to cache in seconds
`REMOTE_READ_SIZE_AVG`	Average data size read from remote storage in MiB
`REMOTE_READ_SIZE_MAX`	Maximum data size read from remote storage in MiB
`REMOTE_READ_DURATION_AVG`	Average duration spent reading data from remote storage in seconds
`REMOTE_READ_DURATION_MAX`	Maximum duration spent reading data from remote storage in seconds
`REMOTE_WRITE_SIZE_AVG`	Average data size written to remote storage in MiB
`REMOTE_WRITE_SIZE_MAX`	Maximum data size written to remote storage in MiB
`REMOTE_WRITE_DURATION_AVG`	Average duration spent writing data to remote storage in seconds
`REMOTE_WRITE_DURATION_MAX`	Maximum duration spent writing data to remote storage in seconds
`NET_AVG`	Average network traffic ratio in MiB per second
`NET_MAX`	Maximum network traffic ratio in MiB per second
`SWAP_AVG`	Average swap ratio in MiB per second. If this value is higher than 0, a system configuration problem may exist.
`SWAP_MAX`	Maximum swap ratio in MiB per second. If this value is higher than 0, a system configuration problem may exist.

EXA_MONITOR_MONTHLY

This system table contains the monthly aggregated monitoring information (of values from EXA_MONITOR_LAST_DAY) for a cluster, sorted by the interval start and cluster name.

All users have access to the table.

Column	Meaning
`CLUSTER_NAME`	Name of the cluster
`INTERVAL_START`	Timestamp at the start of the aggregation interval
`LOAD_AVG`	Average system load (equals the 1-minute load value of program up time)
`LOAD_MAX`	Maximum system load (equals the 1-minute load value of program up time)
`CPU_AVG`	Average CPU utilization in percentage (of the database instance)
`CPU_MAX`	Maximum CPU utilization in percentage (of the database instance)
`TEMP_DB_RAM_AVG`	Average usage of temporary DB memory in MiB (of the database instance)
`TEMP_DB_RAM_MAX`	Maximum usage of temporary DB memory in MiB (of the database instance)
`PERSISTENT_DB_RAM_AVG`	Average usage of modified, persistent DB memory in MiB (of the database instance)
`PERSISTENT_DB_RAM_MAX`	Maximum usage of modified, persistent DB memory in MiB (of the database instance)
`HDD_READ_AVG`	Average hard disk read ratio in MiB per second
`HDD_READ_MAX`	Maximum hard disk read ratio in MiB per second
`HDD_WRITE_AVG`	Average hard disk write ratio in MiB per second
`HDD_WRITE_MAX`	Maximum hard disk write ratio in MiB per second
`LOCAL_READ_SIZE_AVG`	Average data size read from local (non-cache) storage in MiB
`LOCAL_READ_SIZE_MAX`	Maximum data size read from local (non-cache) storage in MiB
`LOCAL_READ_DURATION_AVG`	Average duration spent reading data from local (non-cache) storage in seconds
`LOCAL_READ_DURATION_MAX`	Maximum duration spent reading data from local (non-cache) storage in seconds
`LOCAL_WRITE_SIZE_AVG`	Average data size written to local (non-cache) storage in MiB
`LOCAL_WRITE_SIZE_MAX`	Maximum data size written to local (non-cache) storage in MiB
`LOCAL_WRITE_DURATION_AVG`	Average duration spent writing data to local (non-cache) storage in seconds
`LOCAL_WRITE_DURATION_MAX`	Maximum duration spent writing data to local (non-cache) storage in seconds
`CACHE_READ_SIZE_AVG`	Average data size read from cache in MiB
`CACHE_READ_SIZE_MAX`	Maximal data size read from cache in MiB
`CACHE_READ_DURATION_AVG`	Average duration spent reading data from cache in seconds
`CACHE_READ_DURATION_MAX`	Maximum duration spent reading data from cache in seconds
`CACHE_WRITE_SIZE_AVG`	Average data size written to cache in MiB
`CACHE_WRITE_SIZE_MAX`	Maximum data size written to cache in MiB
`CACHE_WRITE_DURATION_AVG`	Average duration spent writing data to cache in seconds
`CACHE_WRITE_DURATION_MAX`	Maximum duration spent writing data to cache in seconds
`REMOTE_READ_SIZE_AVG`	Average data size read from remote storage in MiB
`REMOTE_READ_SIZE_MAX`	Maximum data size read from remote storage in MiB
`REMOTE_READ_DURATION_AVG`	Average duration spent reading data from remote storage in seconds
`REMOTE_READ_DURATION_MAX`	Maximum duration spent reading data from remote storage in seconds
`REMOTE_WRITE_SIZE_AVG`	Average data size written to remote storage in MiB
`REMOTE_WRITE_SIZE_MAX`	Maximum data size written to remote storage in MiB
`REMOTE_WRITE_DURATION_AVG`	Average duration spent writing data to remote storage in seconds
`REMOTE_WRITE_DURATION_MAX`	Maximum duration spent writing data to remote storage in seconds
`NET_AVG`	Average network traffic ratio in MiB per second
`NET_MAX`	Maximum network traffic ratio in MiB per second
`SWAP_AVG`	Average swap ratio in MiB per second. If this value is higher than 0, a system configuration problem may exist.
`SWAP_MAX`	Maximum swap ratio in MiB per second. If this value is higher than 0, a system configuration problem may exist.

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	Meaning
`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 utilization in percentage
`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`	Maximum read ratio for data not in DB memory in MiB per second (over all nodes, averaged over the last measure interval). If this value is larger than 0, then data had to be loaded into the main memory.
`HDD_WRITE`	Maximumwrite ratio to external storage in MiB per second (over all nodes, averaged over the last measure interval). 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) 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 `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`	Maximum network traffic ratio in MiB per second (sum of send/receive, per node, averaged over the last measure interval)
`SUCCESS`	Result of the statement: `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
`CONSUMER_GROUP`	Consumer group at query start
`NICE`	`NICE` attribute
`RESOURCES`	Allocated resources in percentage
`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

EXA_SQL_HOURLY

This system table contains the hourly aggregated number of executed SQL statements per cluster, sorted by the interval start. For each (interval, cluster) pair several entries for each command type (for example, SELECT) is created.

All users have access to the table.

Column	Meaning
`CLUSTER_NAME`	Name of the cluster
`INTERVAL_START`	Timestamp at the start of the aggregation interval
`COMMAND_NAME`	Name of the statement (for example, `SELECT`, `COMMIT`, or `MERGE`)
`COMMAND_CLASS`	Class of statement (for example, `DQL`, `TRANSACTION`, or `DML`)
`SUCCESS`	Result of the statement: `TRUE`: Statement was executed successfully `FALSE`: Statement failed (for example, with a data exception)
`COUNT`	Number of executions
`DURATION_AVG`	Average execution time of statements
`DURATION_MAX`	Maximum execution time of statements
`CPU_AVG`	Average CPU utilization in percentage
`CPU_MAX`	Maximum CPU utilization in percentage
`TEMP_DB_RAM_PEAK_AVG`	Average usage of temporary DB memory of queries in MiB (overall nodes)
`TEMP_DB_RAM_PEAK_MAX`	Maximum usage of temporary DB memory of queries in MiB (overall nodes)
`PERSISTENT_DB_RAM_PEAK_AVG`	Average usage of modified, persistent DB memory of queries in MiB (overall nodes)
`PERSISTENT_DB_RAM_PEAK_MAX`	Maximum usage of modified, persistent DB memory of queries in MiB (overall nodes)
`HDD_READ_AVG`	Average hard disk read ratio in MiB per second (per node)
`HDD_READ_MAX`	Maximum hard disk read ratio in MiB per second (per node)
`HDD_WRITE_AVG`	Average hard disk write ratio in MiB per second (per node, `COMMIT` only)
`HDD_WRITE_MAX`	Maximum hard disk write ratio in MiB per second (per node, `COMMIT` only)
`LOCAL_READ_SIZE_AVG`	Average data size read from local (non-cache) storage in MiB
`LOCAL_READ_SIZE_MAX`	Maximum data size read from local (non-cache) storage in MiB
`LOCAL_READ_DURATION_AVG`	Average duration spent reading data from local (non-cache) storage in seconds
`LOCAL_READ_DURATION_MAX`	Maximum duration spent reading data from local (non-cache) storage in seconds
`LOCAL_WRITE_SIZE_AVG`	Average data size written to local (non-cache) storage in MiB
`LOCAL_WRITE_SIZE_MAX`	Maximum data size written to local (non-cache) storage in MiB
`LOCAL_WRITE_DURATION_AVG`	Average duration spent writing data to local (non-cache) storage in seconds
`LOCAL_WRITE_DURATION_MAX`	Maximum duration spent writing data to local (non-cache) storage in seconds
`CACHE_READ_SIZE_AVG`	Average data size read from cache in MiB
`CACHE_READ_SIZE_MAX`	Maximum data size read from cache in MiB
`CACHE_READ_DURATION_AVG`	Average duration spent reading data from cache in seconds
`CACHE_READ_DURATION_MAX`	Maximum duration spent reading data from cache in seconds
`CACHE_WRITE_SIZE_AVG`	Average data size written to cache in MiB
`CACHE_WRITE_SIZE_MAX`	Maximum data size written to cache in MiB
`CACHE_WRITE_DURATION_AVG`	Average duration spent writing data to cache in seconds
`CACHE_WRITE_DURATION_MAX`	Maximum duration spent writing data to cache in seconds
`REMOTE_READ_SIZE_AVG`	Average data size read from remote storage in MiB
`REMOTE_READ_SIZE_MAX`	Maximum data size read from remote storage in MiB
`REMOTE_READ_DURATION_AVG`	Average duration spent reading data from remote storage in seconds
`REMOTE_READ_DURATION_MAX`	Maximum duration spent reading data from remote storage in seconds
`REMOTE_WRITE_SIZE_AVG`	Average data size written to remote storage in MiB
`REMOTE_WRITE_SIZE_MAX`	Maximum data size written to remote storage in MiB
`REMOTE_WRITE_DURATION_AVG`	Average duration spent writing data to remote storage in seconds
`REMOTE_WRITE_DURATION_MAX`	Maximum duration spent writing data to remote storage in seconds
`NET_AVG`	Average network traffic ratio in MiB per second (per node)
`NET_MAX`	Maximum network traffic ratio in MiB per second (per node)
`ROW_COUNT_AVG`	Average number of result rows for queries, or number of affected rows for DML and DDL statements
`ROW_COUNT_MAX`	Maximum 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)

EXA_SQL_DAILY

This system table contains the daily aggregated number of executed SQL statements per cluster, sorted by the interval start. For each (interval, cluster) pair several entries for each command type (for example, SELECT) is created.

All users have access to the table.

Column	Meaning
`CLUSTER_NAME`	Name of the cluster
`INTERVAL_START`	Timestamp at the start of the aggregation interval
`COMMAND_NAME`	Name of the statement (for example, `SELECT`, `COMMIT`, or `MERGE`)
`COMMAND_CLASS`	Class of statement (for example, `DQL`, `TRANSACTION`, or `DML`)
`SUCCESS`	Result of the statement: `TRUE`: Statement was executed successfully `FALSE`: Statement failed (for example, with a data exception)
`COUNT`	Number of executions
`DURATION_AVG`	Average execution time of statements
`DURATION_MAX`	Maximum execution time of statements
`CPU_AVG`	Average CPU utilization in percentage
`CPU_MAX`	Maximum CPU utilization in percentage
`TEMP_DB_RAM_PEAK_AVG`	Average usage of temporary DB memory of queries in MiB (overall nodes)
`TEMP_DB_RAM_PEAK_MAX`	Maximum usage of temporary DB memory of queries in MiB (overall nodes)
`PERSISTENT_DB_RAM_PEAK_AVG`	Average usage of modified, persistent DB memory of queries in MiB (overall nodes)
`PERSISTENT_DB_RAM_PEAK_MAX`	Maximum usage of modified, persistent DB memory of queries in MiB (overall nodes)
`HDD_READ_AVG`	Average hard disk read ratio in MiB per second (per node)
`HDD_READ_MAX`	Maximum hard disk read ratio in MiB per second (per node)
`HDD_WRITE_AVG`	Average hard disk write ratio in MiB per second (per node, `COMMIT` only)
`HDD_WRITE_MAX`	Maximum hard disk write ratio in MiB per second (per node, `COMMIT` only)
`LOCAL_READ_SIZE_AVG`	Average data size read from local (non-cache) storage in MiB
`LOCAL_READ_SIZE_MAX`	Maximum data size read from local (non-cache) storage in MiB
`LOCAL_READ_DURATION_AVG`	Average duration spent reading data from local (non-cache) storage in seconds
`LOCAL_READ_DURATION_MAX`	Maximum duration spent reading data from local (non-cache) storage in seconds
`LOCAL_WRITE_SIZE_AVG`	Average data size written to local (non-cache) storage in MiB
`LOCAL_WRITE_SIZE_MAX`	Maximum data size written to local (non-cache) storage in MiB
`LOCAL_WRITE_DURATION_AVG`	Average duration spent writing data to local (non-cache) storage in seconds
`LOCAL_WRITE_DURATION_MAX`	Maximum duration spent writing data to local (non-cache) storage in seconds
`CACHE_READ_SIZE_AVG`	Average data size read from cache in MiB
`CACHE_READ_SIZE_MAX`	Maximum data size read from cache in MiB
`CACHE_READ_DURATION_AVG`	Average duration spent reading data from cache in seconds
`CACHE_READ_DURATION_MAX`	Maximum duration spent reading data from cache in seconds
`CACHE_WRITE_SIZE_AVG`	Average data size written to cache in MiB
`CACHE_WRITE_SIZE_MAX`	Maximum data size written to cache in MiB
`CACHE_WRITE_DURATION_AVG`	Average duration spent writing data to cache in seconds
`CACHE_WRITE_DURATION_MAX`	Maximum duration spent writing data to cache in seconds
`REMOTE_READ_SIZE_AVG`	Average data size read from remote storage in MiB
`REMOTE_READ_SIZE_MAX`	Maximum data size read from remote storage in MiB
`REMOTE_READ_DURATION_AVG`	Average duration spent reading data from remote storage in seconds
`REMOTE_READ_DURATION_MAX`	Maximum duration spent reading data from remote storage in seconds
`REMOTE_WRITE_SIZE_AVG`	Average data size written to remote storage in MiB
`REMOTE_WRITE_SIZE_MAX`	Maximum data size written to remote storage in MiB
`REMOTE_WRITE_DURATION_AVG`	Average duration spent writing data to remote storage in seconds
`REMOTE_WRITE_DURATION_MAX`	Maximum duration spent writing data to remote storage in seconds
`NET_AVG`	Average network traffic ratio in MiB per second (per node)
`NET_MAX`	Maximum network traffic ratio in MiB per second (per node)
`ROW_COUNT_AVG`	Average number of result rows for queries, or number of affected rows for DML and DDL statements
`ROW_COUNT_MAX`	Maximum 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)

EXA_SQL_MONTHLY

This system table contains the monthly aggregated number of executed SQL statements per cluster, sorted by the interval start. For each (interval, cluster) pair several entries for each command type (for example, SELECT) is created.

All users have access to the table.

Column	Meaning
`CLUSTER_NAME`	Name of the cluster
`INTERVAL_START`	Timestamp at the start of the aggregation interval
`COMMAND_NAME`	Name of the statement (for example, `SELECT`, `COMMIT`, or `MERGE`)
`COMMAND_CLASS`	Class of statement (for example, `DQL`, `TRANSACTION`, or `DML`)
`SUCCESS`	Result of the statement: `TRUE`: Statement was executed successfully `FALSE`: Statement failed (for example, with a data exception)
`COUNT`	Number of executions
`DURATION_AVG`	Average execution time of statements
`DURATION_MAX`	Maximum execution time of statements
`CPU_AVG`	Average CPU utilization in percentage
`CPU_MAX`	Maximum CPU utilization in percentage
`TEMP_DB_RAM_PEAK_AVG`	Average usage of temporary DB memory of queries in MiB (overall nodes)
`TEMP_DB_RAM_PEAK_MAX`	Maximum usage of temporary DB memory of queries in MiB (overall nodes)
`PERSISTENT_DB_RAM_PEAK_AVG`	Average usage of modified, persistent DB memory of queries in MiB (overall nodes)
`PERSISTENT_DB_RAM_PEAK_MAX`	Maximum usage of modified, persistent DB memory of queries in MiB (overall nodes)
`HDD_READ_AVG`	Average hard disk read ratio in MiB per second (per node)
`HDD_READ_MAX`	Maximum hard disk read ratio in MiB per second (per node)
`HDD_WRITE_AVG`	Average hard disk write ratio in MiB per second (per node, `COMMIT` only)
`HDD_WRITE_MAX`	Maximum hard disk write ratio in MiB per second (per node, `COMMIT` only)
`LOCAL_READ_SIZE_AVG`	Average data size read from local (non-cache) storage in MiB
`LOCAL_READ_SIZE_MAX`	Maximum data size read from local (non-cache) storage in MiB
`LOCAL_READ_DURATION_AVG`	Average duration spent reading data from local (non-cache) storage in seconds
`LOCAL_READ_DURATION_MAX`	Maximum duration spent reading data from local (non-cache) storage in seconds
`LOCAL_WRITE_SIZE_AVG`	Average data size written to local (non-cache) storage in MiB
`LOCAL_WRITE_SIZE_MAX`	Maximum data size written to local (non-cache) storage in MiB
`LOCAL_WRITE_DURATION_AVG`	Average duration spent writing data to local (non-cache) storage in seconds
`LOCAL_WRITE_DURATION_MAX`	Maximum duration spent writing data to local (non-cache) storage in seconds
`CACHE_READ_SIZE_AVG`	Average data size read from cache in MiB
`CACHE_READ_SIZE_MAX`	Maximum data size read from cache in MiB
`CACHE_READ_DURATION_AVG`	Average duration spent reading data from cache in seconds
`CACHE_READ_DURATION_MAX`	Maximum duration spent reading data from cache in seconds
`CACHE_WRITE_SIZE_AVG`	Average data size written to cache in MiB
`CACHE_WRITE_SIZE_MAX`	Maximum data size written to cache in MiB
`CACHE_WRITE_DURATION_AVG`	Average duration spent writing data to cache in seconds
`CACHE_WRITE_DURATION_MAX`	Maximum duration spent writing data to cache in seconds
`REMOTE_READ_SIZE_AVG`	Average data size read from remote storage in MiB
`REMOTE_READ_SIZE_MAX`	Maximum data size read from remote storage in MiB
`REMOTE_READ_DURATION_AVG`	Average duration spent reading data from remote storage in seconds
`REMOTE_READ_DURATION_MAX`	Maximum duration spent reading data from remote storage in seconds
`REMOTE_WRITE_SIZE_AVG`	Average data size written to remote storage in MiB
`REMOTE_WRITE_SIZE_MAX`	Maximum data size written to remote storage in MiB
`REMOTE_WRITE_DURATION_AVG`	Average duration spent writing data to remote storage in seconds
`REMOTE_WRITE_DURATION_MAX`	Maximum duration spent writing data to remote storage in seconds
`NET_AVG`	Average network traffic ratio in MiB per second (per node)
`NET_MAX`	Maximum network traffic ratio in MiB per second (per node)
`ROW_COUNT_AVG`	Average number of result rows for queries, or number of affected rows for DML and DDL statements
`ROW_COUNT_MAX`	Maximum 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)

EXA_SYSTEM_EVENTS

This system table contains system events like startup or shutdown of the DBMS.

All users have access to the table.

Column	Meaning
`CLUSTER_NAME`	Name of the cluster
`MEASURE_TIME`	Time of the event
`EVENT_TYPE`	Type of the event: `STARTUP`: DBMS was started and logins are now possible `SHUTDOWN`: DBMS was stopped `BACKUP_START`: Start of a backup job `BACKUP_END`: End of a backup job `RESTORE_START`: Start of a restore job `RESTORE_END`: End of a restore job `FAILSAFETY`: Node failure with possible automatic DBMS restart using a stand by node `RECOVERY_START`: Start of the data restore process `RECOVERY_END`: End of the data restore process (at this point the full redundancy level of the cluster is re-established) `RESTART`: Restart of the DBMS due to a failure `LICENSE_EXCEEDED`: License limit exceeded (databases reject inserting statements) `LICENSE_OK`: License limit O.K. (databases allow inserting statements) `SIZE_LIMIT_EXCEEDED`: Size limit exceeded (database rejects inserting statements) `SIZE_LIMIT_OK`: Size limit O.K. (database allows inserting statements) `FULL_DISK_PREVENTION`: Prevention of full data volume by terminating the session with the highest DB memory allocation
`DBMS_VERSION`	Version of DBMS
`NODES`	Number of cluster nodes
`DB_RAM_SIZE`	Used DB RAM license in GiB
`PARAMETERS`	Parameters for the DBMS

EXA_USAGE_LAST_DAY

This system table contains information about the DBMS usage of the last 24 hours.

All users have access to the table.

Column	Meaning
`CLUSTER_NAME`	Name of the cluster
`MEASURE_TIME`	Timestamp of the measurement
`USERS`	Number of users connected to the DBMS
`QUERIES`	Number of concurrent queries

EXA_USAGE_HOURLY

This system table contains the hourly aggregated usage information of the DBMS for a cluster, sorted by the interval start.

All users have access to the table.

Column	Meaning
`CLUSTER_NAME`	Name of the cluster
`INTERVAL_START`	Timetamp at the start of the aggregation interval
`USERS_AVG`	Average number of users connected to the DBMS
`USERS_MAX`	Maximum number of users connected to the DBMS
`QUERIES_AVG`	Average number of concurrent queries
`QUERIES_MAX`	Maximum number of concurrent queries
`IDLE`	Percentage of last period where no query is running at all

EXA_USAGE_DAILY

This system table contains the daily aggregated usage information of the DBMS for a cluster, sorted by the interval start.

All users have access to the table.

Column	Meaning
`CLUSTER_NAME`	Name of the cluster
`INTERVAL_START`	Timetamp at the start of the aggregation interval
`USERS_AVG`	Average number of users connected to the DBMS
`USERS_MAX`	Maximum number of users connected to the DBMS
`QUERIES_AVG`	Average number of concurrent queries
`QUERIES_MAX`	Maximum number of concurrent queries
`IDLE`	Percentage of last period where no query is running at all

EXA_USAGE_MONTHLY

This system table contains the monthly aggregated usage information of the DBMS for a cluster, sorted by the interval start.

All users have access to the table.

Column	Meaning
`CLUSTER_NAME`	Name of the cluster
`INTERVAL_START`	Timetamp at the start of the aggregation interval
`USERS_AVG`	Average number of users connected to the DBMS
`USERS_MAX`	Maximum number of users connected to the DBMS
`QUERIES_AVG`	Average number of concurrent queries
`QUERIES_MAX`	Maximum number of concurrent queries
`IDLE`	Percentage of last period where no query is running at all

EXA_USER_IMPERSONATION_LAST_DAY

This system table contains all impersonations involving the current user. For more details, see IMPERSONATE.

All users have access to the table.

Column	Meaning
`IMPERSONATOR`	User impersonating
`IMPERSONATEE`	User being impersonated
`SESSION_ID`	Session id of impersonation
`STMT_ID`	First statement of the new effective user

EXA_USER_PROFILE_LAST_DAY

This system table contains all profiling information of own sessions with activated profiling. For more information on profiling, see Profiling.

All users have access to the table.

Column	Meaning
`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`)
`PART_ID`	Serially numbered id of the execution part within the statement
`PART_NAME`	Name of the execution part (see also Section 3.9, “Profiling”)
`PART_INFO`	Extended information of the execution part. For example: `GLOBAL`: Global action (for example, global join) `EXPRESSION INDEX`: Non-persistent join index which is built on an expression `NL JOIN`: Nested loop join (cross product) `REPLICATED`: Replicated object (for example, small tables) `TEMPORARY`: Temporary object (for intermediate results)
`PART_FINISHED`	Defines whether the execution part has already been finished
`OBJECT_SCHEMA`	Schema of the processed object
`OBJECT_NAME`	Name of the processed object
`OBJECT_ROWS`	Number of rows of the processed object
`OUT_ROWS`	Number of result rows of the execution part
`DURATION`	Duration of the execution part in seconds
`CPU`	CPU utilization in percentage of the execution part (averaged over the duration)
`TEMP_DB_RAM_PEAK`	Usage of temporary DB memory of the execution part in MiB (overall nodes, maximum over the duration)
`PERSISTENT_DB_RAM_PEAK`	Usage of modified, persistent DB memory of the execution part in MiB (overall nodes, maximum over the duration)
`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 time spent writing data 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 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 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 time spent writing data 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)
`REMARKS`	Any additional information such as, index type and columns, or index used for a join. Some examples for the `REMARKS` column: Join descriptions Column which is read for a filter
`SQL_TEXT`	Corresponding SQL text

EXA_USER_PROFILE_RUNNING

This system table contains all profiling information of the running queries of current user. For more information on profiling, see Profiling.

All users have access to the table.

Column	Meaning
`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`)
`PART_ID`	Serially numbered id of the execution part within the statement
`PART_NAME`	Name of the execution part (see also Section 3.9, “Profiling”)
`PART_INFO`	Extended information of the execution part. For example: `GLOBAL`: Global action (for example, global join) `EXPRESSION INDEX`: Non-persistent join index which is built on an expression `NL JOIN`: Nested loop join (cross product) `REPLICATED`: Replicated object (for example, small tables) `TEMPORARY`: Temporary object (for intermediate results)
`PART_FINISHED`	Defines whether the execution part has already been finished
`OBJECT_SCHEMA`	Schema of the processed object
`OBJECT_NAME`	Name of the processed object
`OBJECT_ROWS`	Number of rows of the processed object
`OUT_ROWS`	Number of result rows of the execution part
`DURATION`	Duration of the execution part in seconds
`CPU`	CPU utilization in percentage of the execution part (averaged over the duration)
`TEMP_DB_RAM_PEAK`	Usage of temporary DB memory of the execution part in MiB (overall nodes, maximum over the duration)
`PERSISTENT_DB_RAM_PEAK`	Usage of modified, persistent DB memory of the execution part in MiB (overall nodes, maximum over the duration)
`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 time spent writing data 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 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 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 time spent writing data 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)
`REMARKS`	Any additional information such as, index type and columns, or index used for a join. Some examples for the `REMARKS` column: Join descriptions Column which is read for a filter
`SQL_TEXT`	Corresponding SQL text

EXA_USER_SESSIONS_LAST_DAY

This system table contains all own sessions of the last day. All users have access to the table.

Column	Meaning
`SESSION_ID`	ID of the session
`LOGIN_TIME`	Time of login
`LOGOUT_TIME`	Time of logout
`USER_NAME`	User name
`CLIENT`	Client application used by the user
`DRIVER`	Used driver
`ENCRYPTED`	Flag whether the connection is encrypted
`HOST`	Computer name or IP address from which the user has logged-in
`OS_USER`	User name used by the user to log in to the operating system of the computer from where the login came
`OS_NAME`	Operating system of the client server
`SUCCESS`	`TRUE`: Statement was executed successfully `FALSE`: Statement failed (for example, with a data exception)
`ERROR_CODE`	Error code if the login failed
`ERROR_TEXT`	Error text if the login failed
`CLUSTER_NAME`	Name of the cluster

EXA_USER_TRANSACTION_CONFLICTS_LAST_DAY

This system table contains all transaction conflicts linked to the current user's sessions.

This system table can be cleared by the statement TRUNCATE AUDIT LOGS. All users have access to the table.

Column	Meaning
`SESSION_ID`	ID of the session
`CONFLICT_SESSION_ID`	Session which produces the conflict
`START_TIME`	Start time of the conflict
`STOP_TIME`	End time of the conflict or `NULL` if the conflict is still open
`CONFLICT_TYPE`	Type of the conflict: `WAIT FOR COMMIT`: One session has to wait until the other one is committed `TRANSACTION ROLLBACK`: One session has to be rolled back due to a conflict
`CONFLICT_OBJECTS`	Name of the corresponding objects
`CONFLICT_INFO`	Additional information about the conflict