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 |
|
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 |
|
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:
|
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:
|
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:
|
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:
|
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:
|
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 |
|
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:
|
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:
|
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:
|
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:
|
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:
|
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:
|
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:
|
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:
|
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:
|
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:
|
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:
|
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:
|
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:
|
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:
|
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 |
|
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:
|
CONFLICT_OBJECTS | Name of the corresponding objects |
CONFLICT_INFO | Additional information about the conflict |