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.

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 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.

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
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.

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
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