Metadata System Tables

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

System Table Name Description
EXA_ALL_COLUMNS Contains information on all the table columns to which the current user has access.
EXA_ALL_CONNECTIONS Lists all connections of the database.
EXA_ALL_CONSTRAINTS Contains information about constraints of tables to which the current user has access.
EXA_ALL_CONSTRAINT_COLUMNS Contains information about referenced table columns of all constraints to which the current user has access.
EXA_ALL_DEPENDENCIES Lists all direct dependencies between schema objects to which the current user has access.
EXA_ALL_FUNCTIONS Describes all functions of the database to which the current user has access. All users have access.
EXA_ALL_INDICES Describes all indices on tables to which the current user has access.
EXA_ALL_OBJ_PRIVS Contains all of the object privileges granted for objects in the database to which the current user has access.
EXA_ALL_OBJ_PRIVS_MADE Lists all object privileges that are self-assigned by the user or those on objects that belong to the user.
EXA_ALL_OBJ_PRIVS_RECD Lists all object privileges granted to the user directly or through PUBLIC.
EXA_ALL_OBJECTS Describes all of the database objects to which the current user has access.
EXA_ALL_OBJECT_SIZES Contains the sizes of all of the database objects to which the current user has access.
EXA_ALL_ROLES A list of all roles known to the system.
EXA_ALL_SCHEMAS Lists all the schemas to which the current user has access.
EXA_ALL_SCHEMA_OBJECTS Lists all objects in the current schema to which the current user has access.
EXA_ALL_SCRIPTS Describes all scripts of the database to which the current user has access.
EXA_ALL_SESSIONS Contains restricted information on open sessions of any database user.
EXA_ALL_TABLES Describes all of the tables in the database to which the current user has access.
EXA_ALL_USERS Provides restricted information on all of the users known to the system.
EXA_ALL_VIEWS Lists all of the views accessible to the current user.
EXA_ALL_VIRTUAL_COLUMNS Lists all columns of virtual tables to which the current user has access. It contains the information which are specific to virtual columns.
EXA_ALL_VIRTUAL_SCHEMAS Lists all virtual schemas to which the current user has access and shows the properties which are specific to virtual schemas.
EXA_ALL_VIRTUAL_SCHEMA_PROPERTIES Contains information on the properties of all virtual schemas to which the current user has access.
EXA_ALL_VIRTUAL_TABLES Lists all virtual tables to which the current user has access. It contains the information which are specific to virtual tables.
EXA_CONSUMER_GROUPS Lists all the consumer groups known to the system.
EXA_DBA_COLUMNS Contains information on all table columns.
EXA_DBA_COLUMN_SIZES Lists all columns in all (non-system-)tables in all schemas with their memory and raw sizes
EXA_DBA_CONNECTIONS Lists all connections of the database.
EXA_DBA_CONNECTION_PRIVS Lists all connections which were granted to the user or one of their roles.
EXA_DBA_IMPERSONATION_PRIVS Lists the specific privileges who can impersonate whom.
EXA_DBA_RESTRICTED_OBJ_PRIVS Lists all connection objects to which certain, restricted scripts were granted access to.
EXA_DBA_CONSTRAINT_COLUMNS Contains information about referenced table columns of all constraints of the database.
EXA_DBA_DEPENDENCIES Lists all the direct dependencies between schema objects.
EXA_DBA_DEPENDENCIES_RECURSIVE Lists all the direct and indirect dependencies between schema objects (thus recursive).
EXA_DBA_FUNCTIONS Describes all function of the database.
EXA_DBA_INDICES Describes all indices on tables.
EXA_DBA_OBJ_PRIVS Contains all of the object privileges granted for objects in the database.
EXA_DBA_OBJECTS Describes all of the database objects.
EXA_DBA_OBJECT_SIZES Contains the sizes of all database objects. The values are calculated recursively, that is, the size of a schema includes the total of all of the sizes of the schema objects contained within.
EXA_DBA_ROLES A list of all roles known to the system.
EXA_DBA_ROLE_PRIVS List of all roles granted to a user or a role.
EXA_DBA_SCHEMAS Lists all schemas.
EXA_DBA_SCHEMA_OBJECTS Lists all objects in the current schema.
EXA_DBA_SCRIPTS Describes all scripts of the database.
EXA_DBA_SESSIONS Contains complete information on open sessions of any database user.
EXA_DBA_SESSION_RESOURCES Shows all sessions and associated resources limits known to the system.
EXA_DBA_SYS_PRIVS Shows the system privileges granted to all users and roles.
EXA_DBA_TABLES Describes all tables in the database.
EXA_DBA_USERS Provides complete information on all of the users known to the system.
EXA_DBA_VIEWS Lists all views in the database.
EXA_DBA_VIRTUAL_COLUMNS Lists all columns of virtual tables. It contains the information which are specific to virtual columns.
EXA_DBA_VIRTUAL_SCHEMAS Lists all virtual schemas and shows the properties which are specific to virtual schemas.
EXA_DBA_VIRTUAL_SCHEMA_PROPERTIES Lists the properties of all virtual schemas in the database.
EXA_DBA_VIRTUAL_TABLES Lists all virtual tables and contains the information which are specific to virtual tables.
EXA_LOADAVG Contains information on the current CPU load in each of the Exasol nodes.
EXA_METADATA Contains information that describes the properties of the database.
EXA_PARAMETERS Provides the database parameters - both system-wide and session-based information is displayed.
EXA_ROLE_CONNECTION_PRIVS Lists any connection that the current user possesses indirectly via other roles.
EXA_ROLE_RESTRICTED_OBJ_PRIVS Lists all connection objects to which certain, restricted scripts were granted access to, either granted directly to the current user or indirectly via other roles.
EXA_ROLE_OBJ_PRIVS Lists all object privileges that have been granted to roles of the user.
EXA_ROLE_ROLE_PRIVS Lists any role that the current user possesses indirectly via other roles.
EXA_ROLE_SYS_PRIVS Lists any system privilege that the current user possesses through roles.
EXA_SCHEMAS

Lists all the schemas of the database.

EXA_SCHEMA_OBJECTS Lists all objects that exist in the current schema.
EXA_SESSION_CONNECTIONS List of all connections the user can access.
EXA_SESSION_PRIVS Lists all of the system privileges the user currently disposes of.
EXA_SESSION_ROLES Lists all roles held by the current user.
EXA_SPATIAL_REF_SYS List of supported spatial reference systems.
EXA_SQL_KEYWORDS Contains all SQL keywords in Exasol.
EXA_SQL_TYPES Describes the SQL data types of Exasol.
EXA_STATISTICS_OBJECT_SIZES This system table contains the sizes of all statistical system tables aggregated by the type of the statistical info.
EXA_SYS_SCRIPTS This system table describes all system scripts of the database.
EXA_TIME_ZONES Lists all named timezones supported by the database.
EXA_USER_COLUMNS Contains information on the table columns to those tables owned by the current user.
EXA_USER_CONNECTION_PRIVS Lists all connections which were granted directly to the user.
EXA_USER_IMPERSONATION_PRIVS Lists the specific impersonation privileges granted to current user.
EXA_USER_RESTRICTED_OBJ_PRIVS Lists all connection objects to which certain, restricted scripts were granted access to, granted directly to the current user.
EXA_USER_CONSTRAINTS Contains information about constraints of tables owned by the current user.
EXA_USER_CONSTRAINT_COLUMNS Contains information about referenced table columns of all constraints owned by the current user.
EXA_USER_DEPENDENCIES Lists all direct dependencies between schema objects owned by the current user.
EXA_USER_FUNCTIONS Describes all functions in the database owned by the current user.
EXA_USER_INDICES Describes all indices on tables owned by the current user.
EXA_USER_OBJ_PRIVS Contains all of the object privileges granted for objects in the database to which the current user has access (except via the PUBLIC role).
EXA_USER_OBJ_PRIVS_MADE Lists all of the object privileges related to objects owned by the current user.
EXA_USER_OBJ_PRIVS_RECD Lists all object privileges granted directly to the user.
EXA_USER_OBJECTS Lists all of the objects owned by the current user.
EXA_USER_OBJECT_SIZES Contains the size of all database objects owned by the current user.
EXA_USER_ROLE_PRIVS Lists all of the roles directly granted to the current user (not via other roles).
EXA_USER_SCHEMAS Lists all the schemas that are owned by the current user.
EXA_USER_SCHEMA_OBJECTS Lists all objects in the current schema that are owned by the current user.
EXA_USER_SCRIPTS Describes all of the scripts in the database owned by the current user.
EXA_USER_SESSIONS Contains complete information on open sessions of the current user.
EXA_USER_SESSION_RESOURCES Shows all sessions that are owned by the current user and associated resource limits.
EXA_USER_SYS_PRIVS Lists all system privileges that have been directly granted to the user.
EXA_USER_TABLES Describes all of the tables in the database owned by the current user.
EXA_USER_USERS Provides detailed information about the user currently logged in.
EXA_USER_VIEWS Lists all views owned by the current user.
EXA_USER_VIRTUAL_SCHEMAS Lists all virtual schemas that are owned by the current user and shows the properties which are specific to virtual schemas.
EXA_USER_VIRTUAL_COLUMNS Lists all columns of virtual tables owned by the current user.
EXA_USER_VIRTUAL_SCHEMA_PROPERTIES Contains information on the properties of all virtual schemas belonging to the current user.
EXA_USER_VIRTUAL_TABLES Lists all virtual tables owned by the current user.
EXA_VIRTUAL_SCHEMAS Lists all virtual schemas and shows the properties which are specific to virtual schemas.
EXA_VOLUME_USAGE Shows details of the database usage of the storage volumes.
EXA_OBJECTSTORAGE_USAGE Shows details of the database usage of the cloud storage volumes.

EXA_ALL_COLUMNS

This system table contains information on all the table columns to which the current user has access. Additionally, all users have access.

Column Meaning
COLUMN_SCHEMA Associated schema
COLUMN_TABLE Associated table
COLUMN_OBJECT_TYPE Associated object type
COLUMN_NAME Name of column
COLUMN_TYPE Data type of column
COLUMN_TYPE_ID ID of data type
COLUMN_MAXSIZE Maximum number of characters for strings
COLUMN_NUM_PREC Precision for numeric values
COLUMN_NUM_SCALE Scale for numeric values
COLUMN_ORDINAL_POSITION Position of the column in the table beginning at 1
COLUMN_IS_VIRTUAL States whether the column is part of a virtual table
COLUMN_IS_NULLABLE States whether NULL values are allowed (TRUE or FALSE). In case of views this value is always NULL
COLUMN_IS_DISTRIBUTION_KEY States whether the column is part of the distribution key (TRUE or FALSE)
COLUMN_PARTITION_KEY_ORDINAL_POSITION Position of the column in table's composite partition key beginning at 1 or NULL for columns which are not part of it
COLUMN_DEFAULT Default value of the column
COLUMN_IDENTITY Current value of the identity number generator, if this column has the identity attribute
COLUMN_OWNER Owner of the associated object
COLUMN_OBJECT_ID ID of the column
STATUS Status of the object
COLUMN_COMMENT Comment on the column

EXA_ALL_CONNECTIONS

Lists all connections of the database.

All users have access.

Column Meaning
CONNECTION_NAME Name of the connection
CREATED Time of the creation date of the connection
CONNECTION_COMMENT Comment on the connection

EXA_ALL_CONSTRAINTS

This system table contains information about constraints of tables to which the current user has access.

All users have access.

Column Meaning
CONSTRAINT_SCHEMA Associated schema
CONSTRAINT_TABLE Associated table
CONSTRAINT_TYPE Constraint type (PRIMARY KEY, FOREIGN KEY or NOT NULL)
CONSTRAINT_NAME Name of the constraints
CONSTRAINT_ENABLED Displays whether the constraint is checked or not
CONSTRAINT_OWNER Owner of the constraint (which is the owner of the table)

EXA_ALL_CONSTRAINT_COLUMNS

This system table contains information about referenced table columns of all constraints to which the current user has access.

All users have access.

Column Meaning
CONSTRAINT_SCHEMA Associated schema
CONSTRAINT_TABLE Associated table
CONSTRAINT_TYPE Constraint type (PRIMARY KEY, FOREIGN KEY or NOT NULL)
CONSTRAINT_NAME Name of the constraints
CONSTRAINT_OWNER Owner of the constraint (which is the owner of the table)
ORDINAL_POSITION Position of the column in the table beginning at 1
COLUMN_NAME Name of the column
REFERENCED_SCHEMA Referenced schema (only for foreign keys)
REFERENCED_TABLE Referenced table (only for foreign keys)
REFERENCED_COLUMN Name of the column in the referenced table (only for foreign keys)

EXA_ALL_DEPENDENCIES

Lists all direct dependencies between schema objects to which the current user has access.

Dependencies between scripts cannot be determined. In case of a view, entries with REFERENCE_TYPE=NULL values can be shown, if the underlying objects have been changed and the view has not been accessed yet.

All users have access.

Column Meaning
OBJECT_SCHEMA Schema of object
OBJECT_NAME Name of object
OBJECT_TYPE Type of object
OBJECT_OWNER Owner of the object
OBJECT_ID ID of the object
REFERENCE_TYPE Reference type (VIEW, CONSTRAINT)
REFERENCED_OBJECT_SCHEMA Schema of the referenced object
REFERENCED_OBJECT_NAME Name of the referenced object
REFERENCED_OBJECT_TYPE Type of the referenced object
REFERENCED_OBJECT_OWNER Owner of the referenced object
REFERENCED_OBJECT_ID ID of the referenced object

EXA_ALL_FUNCTIONS

This system table describes all functions of the database to which the current user has access.

All users have access.

Column Meaning
FUNCTION_SCHEMA Schema of the function
FUNCTION_NAME Name of the function
FUNCTION_OWNER Owner of the function
FUNCTION_OBJECT_ID ID of the function
FUNCTION_TEXT Generation text of the function
FUNCTION_COMMENT Comment on the function

EXA_ALL_INDICES

This system table describes all indices on tables to which the current user has access.

Indices are created and managed automatically by the system. Hence, the purpose of this table is mainly for transparency

All users have access.

Column Meaning
INDEX_SCHEMA Schema of the index
INDEX_TABLE Table of the index
INDEX_OWNER Owner of the index
INDEX_OBJECT_ID ID of the index
INDEX_TYPE Index type
IS_GEOMETRY States whether this is a geospatial index
MEM_OBJECT_SIZE Index size in bytes (at last COMMIT)
CREATED Timestamp of when the index was created
LAST_COMMIT Last time the object was changed in the DB
REMARKS Additional information about the index

EXA_ALL_OBJ_PRIVS

This table contains all of the object privileges granted for objects in the database to which the current user has access.

All users have access.

Column Meaning
OBJECT_SCHEMA Schema in which the target object is located
OBJECT_NAME Name of the object
OBJECT_TYPE Object type
PRIVILEGE The granted right
GRANTEE Recipient of the right
GRANTOR Name of the user who granted the right
OWNER Owner of the target object

EXA_ALL_OBJ_PRIVS_MADE

Lists all object privileges that are self-assigned by the user or those on objects that belong to the user.

All users have access.

Column Meaning
OBJECT_SCHEMA Schema in which the target object is located
OBJECT_NAME Name of the object
OBJECT_TYPE Object type
PRIVILEGE The granted right
GRANTEE Recipient of the right
GRANTOR Name of the user who granted the right
OWNER Owner of the target object

EXA_ALL_OBJ_PRIVS_RECD

Lists all object privileges granted to the user directly or through PUBLIC.

All users have access.

Column Meaning
OBJECT_SCHEMA Schema in which the target object is located
OBJECT_NAME Name of the object
OBJECT_TYPE Object type
PRIVILEGE The granted right
GRANTEE Recipient of the right
GRANTOR Name of the user who granted the right
OWNER Owner of the target object

EXA_ALL_OBJECTS

This system table describes all of the database objects to which the current user has access.

All users have access.

Column Meaning
OBJECT_NAME Name of the object
OBJECT_TYPE Object type
CREATED Timestamp of when the object was created
LAST_COMMIT Last time the object was changed in the DB
OWNER Owner of the object
OBJECT_ID ID of the object
ROOT_NAME Name of the containing object
ROOT_TYPE Type of the containing object
ROOT_ID ID of the containing object
OBJECT_IS_VIRTUAL States whether this is a virtual object
OBJECT_COMMENT Comment on the object

EXA_ALL_OBJECT_SIZES

This system table contains the sizes of all of the database objects to which the current user has access. The values are calculated recursively, that is, the size of a schema includes the total of all of the sizes of the schema objects contained therein.

All users have access.

Column Meaning
OBJECT_NAME Name of the object
OBJECT_TYPE Type of the object
RAW_OBJECT_SIZE Uncompressed volume of data in the object in bytes (at last COMMIT)
MEM_OBJECT_SIZE Compressed volume of data in the object in bytes (at last COMMIT)
RAW_OBJECT_SIZE_LIMIT Upper limit for the uncompressed volume of data in the object in bytes
CREATED Timestamp of when the object was created
LAST_COMMIT Last time the object was changed in the DB
OWNER Owner of the object
OBJECT_ID ID of the object
OBJECT_IS_VIRTUAL States whether this is a virtual object
ROOT_NAME Name of the containing object
ROOT_TYPE Type of the containing object
ROOT_ID ID of the containing object

EXA_ALL_ROLES

A list of all roles known to the system.

All users have access.

Column Meaning
ROLE_NAME Name of the role
CREATED Timestamp of when the role was created
ROLE_PRIORITY Priority of the role
ROLE_COMMENT Comment on the role

EXA_ALL_SCHEMAS

This system table lists all the schemas to which the current user has access.

All users have access.

Column Meaning
SCHEMA_NAME Name of the schema object
SCHEMA_OWNER Owner of the object
SCHEMA_OBJECT_ID ID of the schema object
SCHEMA_IS_VIRTUAL States whether this is a virtual schema
SCHEMA_COMMENT Comment on the object

EXA_ALL_SCHEMA_OBJECTS

Lists all objects in the current schema to which the current user has access.

All users have access.

Column Meaning
OBJECT_NAME Name of the object
OBJECT_TYPE Type of the object

EXA_ALL_SCRIPTS

This system table describes all scripts of the database to which the current user has access.

All users have access.

Column Meaning
SCRIPT_SCHEMA Name of the schema of the script
SCRIPT_NAME Name of the script
SCRIPT_OWNER Owner of the script
SCRIPT_OBJECT_ID ID of the script object
SCRIPT_TYPE Type of the script (PROCEDURE, ADAPTER or UDF)
SCRIPT_LANGUAGE Script language
SCRIPT_INPUT_TYPE Script input type (NULL, SCALAR or SET)
SCRIPT_RESULT_TYPE Return type of the script (ROWCOUNT, TABLE, RETURNS or EMITS)
SCRIPT_TEXT Complete creation text for a script
SCRIPT_COMMENT Comment on the script

EXA_ALL_SESSIONS

This system table contains restricted information on open sessions of any database user. Among other things, the most recent SQL statement is shown. With regard to security issues, only the command name is displayed. The complete SQL text can be found in EXA_USER_SESSIONS and EXA_DBA_SESSIONS.

All users have access.

Column Meaning
SESSION_ID Id of the session
USER_NAME Logged-in user
STATUS

Current status of the session. The most important of these are:

  • IDLE: Client is connected but not taking any action.
  • EXECUTE SQL: Execution of one single SQL statement.
  • EXECUTE BATCH: Execution of a series of SQL statements.
  • PREPARE SQL: Entry of a prepared statement.
  • EXECUTE PREPARED: Execution of a prepared statement.
  • FETCH DATA: Client reads results.
  • QUEUED: Client is queued because too many parallel queries are executed.
  • COMMIT STMT TIMEOUT: Commit aborted due to query timeout.
  • STMT TIMEOUT: Statement aborted due to query timeout.
COMMAND_NAME Name of the statement (for example. SELECT, COMMIT, MERGE etc.)
STMT_ID Serially numbered id of statement within a session
DURATION Duration of the statement
QUERY_TIMEOUT Session-specific value of QUERY_TIMEOUT, see also ALTER SESSION and ALTER SYSTEM
ACTIVITY Current activity of the SQL
TEMP_DB_RAM Current temporary database memory usage in MiBClosedMebibyte = 1.048.576 Bytes (cluster wide)
PERSISTENT_DB_RAM Current modified, persistent database memory usage in MiBClosedMebibyte = 1.048.576 Bytes (cluster wide)
LOGIN_TIME Time of login
CLIENT Client application used by the user
DRIVER Used driver
ENCRYPTED Flag whether the connection is encrypted
PRIORITY Current priority group
NICE NICE attribute
RESOURCES Allocated resources in percent

EXA_ALL_TABLES

This system table describes all of the tables in the database to which the current user has access.

All users have access.

Column Meaning
TABLE_SCHEMA Name of the schema of the table
TABLE_NAME Name of the table
TABLE_OWNER Owner of the table
TABLE_OBJECT_ID ID of the table
TABLE_IS_VIRTUAL States whether this is a virtual table
TABLE_HAS_DISTRIBUTION_KEY States whether the table is explicitly distributed
TABLE_HAS_PARTITION_KEY States whether the table is partitioned
TABLE_ROW_COUNT Number of rows in the table
DELETE_PERCENTAGE Fraction of the rows which are just marked as deleted, but not yet physically deleted (in percent)
TABLE_COMMENT Comment on the table

EXA_ALL_USERS

This table provides restricted information on all of the users known to the system.

All users have access.

Column Meaning
USER_NAME Name of the user
CREATED Timestamp of when the user was created
USER_CONSUMER_GROUP Consumer Group of the user
USER_COMMENT Comment on the user

EXA_ALL_VIEWS

Lists all of the views accessible to the current user.

All users have access.

Column Meaning
VIEW_SCHEMA Name of the schema in which the view was created
VIEW_NAME Name of the view
SCOPE_SCHEMA Schema from which the view was created
VIEW_OWNER Owner of the view
VIEW_OBJECT_ID Internal ID of the view
VIEW_TEXT Text of the view, with which it was created
VIEW_COMMENT Comment on the view

EXA_ALL_VIRTUAL_COLUMNS

Lists all columns of virtual tables to which the current user has access. It contains the information which are specific to virtual columns. Virtual columns are also listed in the table EXA_ALL_COLUMNS

All users have access.

Column Meaning
COLUMN_SCHEMA Associated virtual schema
COLUMN_TABLE Associated virtual table
COLUMN_NAME Name of the virtual column
COLUMN_OBJECT_ID ID of the virtual columns object
ADAPTER_NOTES The adapter can store additional information about the virtual column in this field

EXA_ALL_VIRTUAL_SCHEMAS

Lists all virtual schemas to which the current user has access and shows the properties which are specific to virtual schemas. Virtual schemas are also listed in the table EXA_SCHEMAS.

All users have access.

Column Meaning
SCHEMA_NAME Name of the virtual schema
SCHEMA_OWNER Owner of the virtual schema
SCHEMA_OBJECT_ID ID of the virtual schema object
ADAPTER_SCRIPT Name of the adapter script used for this virtual schema
LAST_REFRESH Timestamp of the last metadata refresh
LAST_REFRESH_BY Name of the user that performed the last metadata refresh
ADAPTER_NOTES The adapter can store additional information about the schema in this filed

EXA_ALL_VIRTUAL_SCHEMA_PROPERTIES

This system table contains information on the properties of all virtual schemas to which the current user has access.

All users have access.

Column Meaning
SCHEMA_NAME Name of the virtual schema
SCHEMA_OBJECT_ID ID of the virtual schema object
PROPERTY_NAME Name of the property of the virtual schema
PROPERTY_VALUE Value of the property of the virtual schema

EXA_ALL_VIRTUAL_TABLES

Lists all virtual tables to which the current user has access. It contains the information which are specific to virtual tables. Virtual tables are also listed in the table EXA_ALL_TABLES.

All users have access.

Column Meaning
TABLE_SCHEMA Name of the virtual schema containing the virtual table
TABLE_NAME Name of the virtual table
TABLE_OBJECT_ID ID of the virtual table
LAST_REFRESH Timestamp of the last metadata refresh (when metadata was committed)
LAST_REFRESH_BY Name of the user that performed the last metadata refresh
ADAPTER_NOTES The adapter can store additional information about the table in this field

EXA_CONSUMER_GROUPS

This system table lists all the consumer groups known to the system.

Column Meaning
CONSUMER_GROUP_NAME Name of the consumer group
CONSUMER_GROUP_ID ID of the consumer group
CPU_WEIGHT CPU Weight of the consumer group
PRECEDENCE Precedence attribute of a consumer group used for tie-breaking
GROUP_TEMP_DB_RAM_LIMIT Limit for Temp DB RAM usage by all sessions in the consumer group in MB
USER_TEMP_DB_RAM_LIMIT Limit for Temp DB RAM usage by all sessions of a user in the consumer group in MB
SESSION_TEMP_DB_RAM_LIMIT Limit for Temp DB RAM usage by each session in MB
CREATED Timestamp when the consumer group was created
CONSUMER_GROUP_COMMENT Comment on the consumer group

EXA_DBA_COLUMNS

This system table contains information on all table columns.

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

Column Meaning
COLUMN_SCHEMA Associated schema
COLUMN_TABLE Associated table
COLUMN_OBJECT_TYPE Associated object type
COLUMN_NAME Name of column
COLUMN_TYPE Data type of column
COLUMN_TYPE_ID ID of data type
COLUMN_MAXSIZE Maximum number of characters for strings
COLUMN_NUM_PREC Precision for numeric values
COLUMN_NUM_SCALE Scale for numeric values
COLUMN_ORDINAL_POSITION Position of the column in the table beginning at 1
COLUMN_IS_VIRTUAL States whether the column is part of a virtual table
COLUMN_IS_NULLABLE States whether NULL values are allowed (TRUE or FALSE). In case of views this value is always NULL.
COLUMN_IS_DISTRIBUTION_KEY States whether the column is part of the distribution key (TRUE or FALSE)
COLUMN_PARTITION_KEY_ORDINAL_POSITION Position of the column in table's composite partition key beginning at 1 or NULL for columns which are not part of it
COLUMN_DEFAULT Default value of the column
COLUMN_IDENTITY Current value of the identity number generator, if this column has the identity attribute.
COLUMN_OWNER Owner of the associated object
COLUMN_OBJECT_ID ID of the column
STATUS Status of the object
COLUMN_COMMENT Comment on the column

EXA_DBA_COLUMN_SIZES

This system table lists all columns in all (non-system-)tables in all schemas with their memory and raw sizes.

Column Meaning
COLUMN_SCHEMA Associated schema
COLUMN_TABLE Associated table
COLUMN_NAME Name of column
COLUMN_TYPE Name of column
COLUMN_OWNER Owner of the associated object
COLUMN_OBJECT_ID ID of the column
COLUMN_ORDINAL_POSITION Ordinal position of the column starting with 1
COLUMN_IS_VIRTUAL Flag indicating whether the associated table is virtual
RAW_OBJECT_SIZE Uncompressed volume of data in the column in bytes (at last COMMIT)
MEM_OBJECT_SIZE Compressed volume of data in the column in bytes (at last COMMIT)

EXA_DBA_CONNECTIONS

Lists all connections of the database.

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

Column Meaning
CONNECTION_NAME Name of the connection
CONNECTION_STRING Defines the target of the connection
USER_NAME User name which is used when a connection is used
CREATED Time of the creation date
CONNECTION_COMMENT Comment on the connection

EXA_DBA_CONNECTION_PRIVS

Lists all connections which were granted to the user or one of their roles.

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

Column Meaning
GRANTEE Name of the user or role who/which has been granted the right, to adopt GRANTED_ROLE
GRANTED_CONNECTION Name of the connection
ADMIN_OPTION Specifies whether GRANTEE is allowed to grant the right to the connection to other users or roles

EXA_DBA_IMPERSONATION_PRIVS

Lists the specific privileges who can impersonate whom. For more information on impersonation, refer to the IMPERSONATE statement in the Other Statements section.

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

Column Meaning
GRANTEE Name of the user or role who/which has been granted the privilege
IMPERSONATION_ON Name of user or role on whom/which the impersonation privilege has been granted
GRANTOR Name of user who granted the impersonation privilege

EXA_DBA_RESTRICTED_OBJ_PRIVS

Lists all connection objects to which certain, restricted scripts were granted access to.

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

Column Meaning
OBJECT_SCHEMA Schema of the object for which the restricted privilege has been granted
OBJECT_NAME Name of the object for which the restricted privilege has been granted
OBJECT_TYPE Type of the object for which the restricted privilege has been granted
FOR_OBJECT_SCHEMA Schema of the object that the privilege is restricted to
FOR_OBJECT_NAME Name of the object that the privilege is restricted to
FOR_OBJECT_TYPE Type of the object that the privilege is restricted to
PRIVILEGE The restricted privilege that is granted
GRANTEE Name of the user/role who/which has been granted the restricted privilege
GRANTOR Name of the user/role who/which has granted the restricted privilege
OWNER Name of the owner of the object for which the restricted privilege is granted

EXA_DBA_CONSTRAINTS

This system table contains information about all constraints of the database.

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

Column Meaning
CONSTRAINT_SCHEMA Associated schema
CONSTRAINT_TABLE Associated table
CONSTRAINT_TYPE Constraint type (PRIMARY KEY, FOREIGN KEY or NOT NULL)
CONSTRAINT_NAME Name of the constraints
CONSTRAINT_ENABLED Displays whether the constraint is checked or not
CONSTRAINT_OWNER Owner of the constraint (which is the owner of the table)

EXA_DBA_CONSTRAINT_COLUMNS

This system table contains information about referenced table columns of all constraints of the database.

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

Column Meaning
CONSTRAINT_SCHEMA Associated schema
CONSTRAINT_TABLE Associated table
CONSTRAINT_TYPE Constraint type (PRIMARY KEY, FOREIGN KEY or NOT NULL)
CONSTRAINT_NAME Name of the constraints
CONSTRAINT_OWNER Owner of the constraint (which is the owner of the table)
ORDINAL_POSITION Position of the column in the table beginning at 1
COLUMN_NAME Name of the column
REFERENCED_SCHEMA Referenced schema (only for foreign keys)
REFERENCED_TABLE Referenced table (only for foreign keys)
REFERENCED_COLUMN Name of the column in the referenced table (only for foreign keys)

EXA_DBA_DEPENDENCIES

Lists all the direct dependencies between schema objects.

Dependencies between scripts cannot be determined. In case of a view, entries with REFERENCE_TYPE=NULL values can be shown if underlying objects have been changed, and the view has not been accessed yet.

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

Column Meaning
OBJECT_SCHEMA Schema of object
OBJECT_NAME Name of object
OBJECT_TYPE Type of object
OBJECT_OWNER Owner of the object
OBJECT_ID ID of the object
REFERENCE_TYPE Reference type (VIEW, CONSTRAINT)
REFERENCED_OBJECT_SCHEMA Schema of the referenced object
REFERENCED_OBJECT_NAME Name of the referenced object
REFERENCED_OBJECT_TYPE Type of the referenced object
REFERENCED_OBJECT_OWNER Owner of the referenced object
REFERENCED_OBJECT_ID ID of the referenced object

EXA_DBA_DEPENDENCIES_RECURSIVE

This table lists all the direct and indirect dependencies between schema objects (thus recursive).

- Dependencies between scripts cannot be determined. Views are not shown if underlying objects have been changed, and the view has not been accessed yet.
- All database objects are read when accessing this system table.

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

Column Meaning
OBJECT_SCHEMA Schema of object
OBJECT_NAME Name of object
OBJECT_TYPE Type of object
OBJECT_OWNER Owner of the object
OBJECT_ID ID of the object
REFERENCE_TYPE Reference type (VIEW, CONSTRAINT)
REFERENCED_OBJECT_SCHEMA Schema of the referenced object
REFERENCED_OBJECT_NAME Name of the referenced object
REFERENCED_OBJECT_TYPE Type of the referenced object
REFERENCED_OBJECT_OWNER Owner of the referenced object
REFERENCED_OBJECT_ID ID of the referenced object
DEPENDENCY_LEVEL Hierarchy level in the dependency graph

EXA_DBA_FUNCTIONS

This system table describes all function of the database.

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

Column Meaning
FUNCTION_SCHEMA Schema of the function
FUNCTION_NAME Name of the function
FUNCTION_OWNER Owner of the function
FUNCTION_OBJECT_ID ID of the function
FUNCTION_TEXT Generation text of the function
FUNCTION_COMMENT Comment on the function

EXA_DBA_INDICES

This system table describes all indices on tables.

The indices are created and managed automatically by the system. Hence, the purpose of this table is mainly for transparency.

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

Column Meaning
INDEX_SCHEMA Schema of the index
INDEX_TABLE Table of the index
INDEX_OWNER Owner of the index
INDEX_OBJECT_ID ID of the index
INDEX_TYPE Index type
IS_GEOMETRY States whether this is a geospatial index
MEM_OBJECT_SIZE Index size in bytes (at last COMMIT)
CREATED Timestamp of when the index was created
LAST_COMMIT Last time the object was changed in the DB
REMARKS Additional information about the index

EXA_DBA_OBJ_PRIVS

This table contains all of the object privileges granted for objects in the database.

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

Column Meaning
OBJECT_SCHEMA Schema in which the target object is located
OBJECT_NAME Name of the object
OBJECT_TYPE Object type
PRIVILEGE The granted right
GRANTEE Recipient of the right
GRANTOR Name of the user who granted the right
OWNER Owner of the target object

EXA_DBA_OBJECTS

This system table describes all of the database objects.

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

Column Meaning
OBJECT_NAME Name of the object
OBJECT_TYPE Object type
CREATED Timestamp of when the object was created
LAST_COMMIT Last time the object was changed in the DB
OWNER Owner of the object
OBJECT_ID Unique ID of the object
ROOT_NAME Name of the containing object
ROOT_TYPE Type of the containing object
ROOT_ID ID of the containing object
OBJECT_IS_VIRTUAL States whether this is a virtual object
OBJECT_COMMENT Comment on the object

EXA_DBA_OBJECT_SIZES

This system table contains the sizes of all database objects. The values are calculated recursively, that is, the size of a schema includes the total of all of the sizes of the schema objects contained within.

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

Column Meaning
OBJECT_NAME Name of the object
OBJECT_TYPE Object type
RAW_OBJECT_SIZE Uncompressed volume of data in the object in bytes (at last COMMIT)
MEM_OBJECT_SIZE Compressed volume of data in the object in bytes (at last COMMIT)
RAW_OBJECT_SIZE_LIMIT Upper limit for the uncompressed volume of data in the object in bytes
CREATED Timestamp of when the object was created
LAST_COMMIT Last time the object was changed in the DB
OWNER Owner of the object
OBJECT_ID Unique ID of the object
OBJECT_IS_VIRTUAL States whether this is a virtual object
ROOT_NAME Name of the containing object
ROOT_TYPE Type of the containing object
ROOT_ID ID of the containing object

EXA_DBA_ROLES

A list of all roles known to the system.

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

Column Meaning
ROLE_NAME Name of role
CREATED Timestamp of when the role was created
ROLE_PRIORITY Priority of the role
ROLE_COMMENT Comment on the role

EXA_DBA_ROLE_PRIVS

List of all roles granted to a user or a role.

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

Column Meaning
GRANTEE Name of user or role who/which has been granted the right, to adopt GRANTED_ROLE
GRANTED_ROLE Name of role that was granted
ADMIN_OPTION Specifies whether GRANTEE is allowed to grant the right to the role to other users or roles

EXA_DBA_SCHEMAS

Lists all schemas.

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

Column Meaning
SCHEMA_NAME Name of the schema object
SCHEMA_OWNER Owner of the schema object
SCHEMA_OBJECT_ID ID of the schema object
SCHEMA_IS_VIRTUAL States whether this is a virtual schema
SCHEMA_COMMENT Comment on the object

EXA_DBA_SCHEMA_OBJECTS

Lists all objects in the current schema.

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

Column Meaning
OBJECT_NAME Name of the object
OBJECT_TYPE Type of the object

EXA_DBA_SCRIPTS

This system table describes all scripts of the database.

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

Column Meaning
SCRIPT_SCHEMA Name of the schema of the script
SCRIPT_NAME Name of the script
SCRIPT_OWNER Owner of the script
SCRIPT_OBJECT_ID ID of the script object
SCRIPT_TYPE Type of the script (PROCEDURE, ADAPTER or UDF)
SCRIPT_LANGUAGE Script language
SCRIPT_INPUT_TYPE Script input type (NULL, SCALAR or SET)
SCRIPT_RESULT_TYPE Return type of the script (ROWCOUNT, TABLE, RETURNS or EMITS)
SCRIPT_TEXT Complete creation text for a script
SCRIPT_COMMENT Comment on the script

EXA_DBA_SESSIONS

This system table contains complete information on open sessions of any database user. Among other things the most recent SQL statement is shown.

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

Column Meaning
SESSION_ID Id of the session
USER_NAME Name of the logged-in user
EFFECTIVE_USER Effective user of the session (changeable via IMPERSONATE)
STATUS

Current status of the session. The most important of these are:

  • IDLE: Client is connected but not taking any action.
  • EXECUTE SQL: Execution of one single SQL statement.
  • EXECUTE BATCH: Execution of a series of SQL statements.
  • PREPARE SQL: Entry of a prepared statement.
  • EXECUTE PREPARED: Execution of a prepared statement.
  • FETCH DATA: Client reads results.
  • QUEUED: Client is queued because too many parallel queries are executed.
  • COMMIT STMT TIMEOUT: Commit aborted due to query timeout.
  • STMT TIMEOUT: Statement aborted due to query timeout.
COMMAND_NAME Name of the statement (for example, SELECT, COMMIT, MERGE)
STMT_ID Serially numbered id of statement within a session
DURATION Duration of the statement
QUERY_TIMEOUT Session-specific value of QUERY_TIMEOUT, see also ALTER SESSION and ALTER SYSTEM
ACTIVITY Current activity of the SQL
TEMP_DB_RAM Current temporary database memory usage in MiBClosedMebibyte = 1.048.576 Bytes (cluster wide)
PERSISTENT_DB_RAM Current modified, persistent database memory usage in MiBClosedMebibyte = 1.048.576 Bytes (cluster wide)
LOGIN_TIME Time of login
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 under which the user logged into the operating system of the computer from which the login came
OS_NAME Operating system of the client server
SCOPE_SCHEMA Name of the schema in which the user is located
PRIORITY Current priority group
NICE NICE attribute
RESOURCES Allocated resources in percent
SQL_TEXT SQL text of the statement

EXA_DBA_SESSION_RESOURCES

This table shows all sessions and associated resource limits known to the system.

Column Meaning
SESSION_ID Id of the session
RESOURCE_TYPE Name of the resource
LIMIT_SCOPE Scope of the limit
LIMIT_TYPE Name of the limit
USAGE Current usage
LIMIT_VALUE Value of the limit

EXA_DBA_SYS_PRIVS

This table shows the system privileges granted to all users and roles.

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

Column Meaning
GRANTEE Name of user or role who/which has been granted the privilege.
PRIVILEGE System privilege that was granted.
ADMIN_OPTION Specifies whether GRANTEE is allowed to grant the right

EXA_DBA_TABLES

This system table describes all tables in the database.

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

Column Meaning
TABLE_SCHEMA Name of the schema of the table
TABLE_NAME Name of the table
TABLE_OWNER Owner of the table
TABLE_OBJECT_ID ID of the table
TABLE_IS_VIRTUAL States whether this is a virtual table
TABLE_HAS_DISTRIBUTION_KEY States whether the table is explicitly distributed
TABLE_HAS_PARTITION_KEY States whether the table is partitioned
TABLE_ROW_COUNT Number of rows in the table
DELETE_PERCENTAGE Fraction of the rows which are just marked as deleted, but not yet physically deleted (in percent)
TABLE_COMMENT Comment on the table

EXA_DBA_USERS

The DBA_USERS table provides complete information on all of the users known to the system.

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

Column Meaning
USER_NAME Name of the user
CREATED Time when the user was created
DISTINGUISHED_NAME For the authorization against a LDAPClosedLightweight Directory Access Protocol (authentication service) server
KERBEROS_PRINCIPAL Kerberos principal
PASSWORD Encoded hash value of the password
USER_CONSUMER_GROUP Consumer Group of the user
PASSWORD_STATE State of the password (VALID, EXPIRED(GRACE) or EXPIRED)
PASSWORD_STATE_CHANGED Timestamp when the password state has changed, either by password change or by password expiry
PASSWORD_EXPIRY Timestamp when the password will expire or has been expired (if NULL, the password will never expire)
PASSWORD_EXPIRY_DAYS Number of days after which the user password expires after the last password change (if NULL, the password will never expire)
PASSWORD_GRACE_DAYS Number of days within the user has to change the password after it has expired (if NULL, there is no grace period and the user will directly be blocked from login after the expiry)
PASSWORD_EXPIRY_POLICY User-specific expiry policy as specified via ALTER USER command, overwriting the corresponding global system parameter
FAILED_LOGIN_ATTEMPTS Number of failed login attempts by the user since last successful login
USER_COMMENT Comment on the user

EXA_DBA_VIEWS

This system table lists all views in the database.

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

Column Meaning
VIEW_SCHEMA Name of the schema in which the view was created
VIEW_NAME Name of the view
SCOPE_SCHEMA Schema from which the view was created
VIEW_OWNER Owner of the view
VIEW_OBJECT_ID Internal ID of the view
VIEW_TEXT Text of the view, with which it was created
VIEW_COMMENT Comment on the view

EXA_DBA_VIRTUAL_COLUMNS

This system table lists all columns of virtual tables. It contains the information which are specific to virtual columns. Virtual columns are also listed in the table EXA_DBA_COLUMNS.

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

Column Meaning
COLUMN_SCHEMA Associated virtual schema
COLUMN_TABLE Associated virtual table
COLUMN_NAME Name of the virtual column
COLUMN_OBJECT_ID ID of the virtual column object
ADAPTER_NOTES The adapter can store

EXA_DBA_VIRTUAL_SCHEMAS

Lists all virtual schemas and shows the properties which are specific to virtual schemas. Virtual schemas are also listed in the table EXA_DBA_SCHEMAS.

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

Column Meaning
SCHEMA_NAME Name of the virtual schema
SCHEMA_OWNER Owner of the virtual schema
SCHEMA_OBJECT_ID ID of the virtual schema object
ADAPTER_SCRIPT Name of the adapter script used for this virtual schema
LAST_REFRESH Timestamp of the last metadata refresh
LAST_REFRESH_BY Name of the user that performed the last metadata refresh
ADAPTER_NOTES The adapter can store additional information about the schema in this filed

EXA_DBA_VIRTUAL_SCHEMA_PROPERTIES

This system table lists the properties of all virtual schemas in the database.

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

Column Meaning
SCHEMA_NAME Name of the virtual schema
SCHEMA_OBJECT_ID ID of the virtual schema object
PROPERTY_NAME Name of the property of the virtual schema
PROPERTY_VALUE Value of the property of the virtual schema

EXA_DBA_VIRTUAL_TABLES

This system table lists all virtual tables and contains the information which are specific to virtual tables. Virtual tables are also listed in the table EXA_DBA_TABLES.

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

Column Meaning
TABLE_SCHEMA Name of the schema of the virtual table
TABLE_NAME Name of the virtual table
TABLE_OBJECT_ID ID of the virtual table
LAST_REFRESH Timestamp of the last metadata refresh (when metadata was committed)
LAST_REFRESH_BY Name of the user that performed the last metadata refresh
ADAPTER_NOTES The adapter can store additional information about the table in this field

EXA_LOADAVG

This system table contains information on the current CPU load in each of the Exasol nodes.

All users have access.

Column Meaning
IPROC Number of the node
LAST_1MIN Average load in the last minute
LAST_5MIN Average load in the last 5 minutes
LAST_15MIN Average load in the last 15 minutes
RUNNING Contains two numbers separated with "/". The first indicates the number of active processes or threads at the time of evaluation. The second indicates the overall number of processes and threads on the node.

EXA_METADATA

This system table contains information that describes the properties of the database.

All users have access.

Column Meaning
PARAM_NAME Name of the property
PARAM_VALUE Value of the property
IS_STATIC

TRUE - The value of this property remains constant

FALSE - The value of this property can change at any time

EXA_PARAMETERS

This system table provides the database parameters - both system-wide and session-based information is displayed.

To know the list of parameters and how to change them for the system or the current session, refer to the ALTER SESSION statement.

All users have access.

Column Meaning
PARAMETER_NAME Name of the parameter
SESSION_VALUE Value of the session parameter
SYSTEM_VALUE Value of the system parameter

EXA_ROLE_CONNECTION_PRIVS

Lists any connection that the current user possesses indirectly via other roles.

All users have access.

Column Meaning
GRANTEE Name of the role which received the right
GRANTED_CONNECTION Name of the connection which was granted
ADMIN_OPTION Information on whether the connection can be passed on to other users/roles

EXA_ROLE_RESTRICTED_OBJ_PRIVS

This system table lists all connection objects to which certain, restricted scripts were granted access to, either granted directly to the current user or indirectly via other roles.

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

Column Meaning
OBJECT_SCHEMA Schema of the object for which the restricted privilege has been granted
OBJECT_NAME Name of the object for which the restricted privilege has been granted
OBJECT_TYPE Type of the object for which the restricted privilege has been granted
FOR_OBJECT_SCHEMA Schema of the object that the privilege is restricted to
FOR_OBJECT_NAME Name of the object that the privilege is restricted to
FOR_OBJECT_TYPE Type of the object that the privilege is restricted to
PRIVILEGE The restricted privilege that is granted
GRANTEE Name of the user/role who/which has been granted the restricted privilege
GRANTOR Name of the user/role who/which has granted the restricted privilege
OWNER Name of the owner of the object for which the restricted privilege is granted

EXA_ROLE_OBJ_PRIVS

Lists all object privileges that have been granted to roles of the user.

All users have access.

Column Meaning
OBJECT_SCHEMA Schema in which the target object is located
OBJECT_NAME Name of the object
OBJECT_TYPE Object type
PRIVILEGE The granted right
GRANTEE Name of the role
GRANTOR Name of the user who granted the right
OWNER Owner of the target object

EXA_ROLE_ROLE_PRIVS

Lists any role that the current user possesses indirectly via other roles.

All users have access.

Column Meaning
GRANTEE Name of the role through which the user possesses the role indirectly
GRANTED_ROLE Name of the role possessed by the user indirectly
ADMIN_OPTION Information on whether the role can be passed on to other users/roles

EXA_ROLE_SYS_PRIVS

Lists any system privilege that the current user possesses through roles.

All users have access.

Column Meaning
GRANTEE Name of the role
PRIVILEGE Name of the system privilege
ADMIN_OPTION Shows whether it is permissible for the privilege to be passed on to other users/roles

EXA_SCHEMAS

This system table lists all the schemas of the database to which the current user has access. Identical to EXA_ALL_SCHEMAS.

All users have access.

Column Meaning
SCHEMA_NAME Name of the schema object
SCHEMA_OWNER Owner of the object
SCHEMA_OBJECT_ID ID of the schema object
SCHEMA_IS_VIRTUAL States whether this is a virtual schema
SCHEMA_COMMENT Comment on the object

EXA_SCHEMA_OBJECTS

This system table lists all objects in the current schema to which the current user has access. Identical to EXA_ALL_SCHEMA_OBJECTS.

All users have access.

Column Meaning
OBJECT_NAME Name of the object
OBJECT_TYPE Type of the object

EXA_SESSION_CONNECTIONS

List of all connections the user can access. The entries for columns CONNECTION_STRING and USER_NAME are only displayed if the user can edit the connection (see also ALTER CONNECTION).

All users have access.

Column Meaning
CONNECTION_NAME Name of the connection
CONNECTION_STRING Defines the target of the connection
USER_NAME User name which is used when a connection is used
CREATED Time of the creation date
CONNECTION_COMMENT Comment on the connection

EXA_SESSION_PRIVS

Lists all of the system privileges the user currently disposes of.

All users have access.

Column Meaning
PRIVILEGE Name of the system privilege

EXA_SESSION_ROLES

Lists all roles held by the current user.

All users have access.

Column Meaning
ROLE_NAME Name of the role
ROLE_PRIORITY Priority of the role
ROLE_COMMENT Comment on the role

EXA_SPATIAL_REF_SYS

List of supported spatial reference systems.

All users have access.

Column Meaning
SRID Spatial reference system identifier
AUTH_NAME Spatial reference system authority name
AUTH_SRID Authority specific spatial reference system identifier
SRTEXT WKTClosedWell Known Text (text representation of geospatial data) description of the spatial reference system
PROJ4TEXT Parameters for Proj4 projections

EXA_SQL_KEYWORDS

This system table contains all SQL keywords in Exasol.

All users have access.

Column Meaning
KEYWORD Keyword
RESERVED

Defines whether the keyword is reserved. Reserved keywords cannot be used as SQL identifier.

For more information, refer to SQL Identifier section

EXA_SQL_TYPES

This system table describes the SQL data types of Exasol.

All users have access.

Column Meaning
TYPE_NAME Name according to SQL standard
TYPE_ID ID of the data type
PRECISION The precision in relation to numeric values, the (maximum) length in bytes in relation to strings and other types
LITERAL_PREFIX Prefix, with which a literal of this type must be initiated
LITERAL_SUFFIX Suffix, with which a literal of this type must be terminated
CREATE_PARAMS Information on which information is necessary in order to create a column of this type
IS_NULLABLE States whether NULL values are allowed (TRUE or FALSE).
CASE_SENSITIVE States whether case sensitivity is relevant to the type
SEARCHABLE

States how the type can be used in a WHERE clause:

0 - Cannot be searched
1 - Can only be searched with WHERE .. LIKE
2 - Cannot be searched with WHERE .. LIKE
3 - Can be searched with any WHERE clause

UNSIGNED_ATTRIBUTE States whether the type is unsigned
FIXED_PREC_SCALE States whether the type has fixed representation
AUTO_INCREMENT States whether it is an automatically incremented type
LOCAL_TYPE_NAME Local type name
MINIMUM_SCALE Minimum number of digits after the decimal point
MAXIMUM_SCALE Maximum number of digits after the decimal point
SQL_DATA_TYPE Reserved
SQL_DATETIME_SUB Reserved
NUM_PREC_RADIX Number base for details of the precision
INTERVAL_PRECISION Reserved

EXA_STATISTICS_OBJECT_SIZES

This system table contains the sizes of all statistical system tables aggregated by the type of the statistical info. For more information, refer to Statistical System Tables section.

All users have access.

Column Meaning
STATISTICS_TYPE

Type of statistics

AUDIT Auditing information
DB_SIZE Statistics about the size of database objects
MONITOR All monitoring statistics
OTHER Miscellaneous statistics, for example,. for internal optimizations
PROFILE Profiling information
SQL Statistics about SQL statements
SYSTEM_EVENTS Statistics about system events
TRANSACTION_CONFLICTS Statistics about transaction conflicts
USAGE Statistics about the usage of the system
RAW_OBJECT_SIZE Uncompressed data volume in bytes
MEM_OBJECT_SIZE Compressed data volume in bytes
AUXILIARY_SIZE Auxiliary structures like indices in bytes

EXA_SYS_SCRIPTS

This system table describes all system scripts of the database.

Column Meaning
SCRIPT_SCHEMA Name of the schema of the script
SCRIPT_NAME Name of the script
SCRIPT_OWNER Owner of the script
SCRIPT_OBJECT_ID ID of the script object
SCRIPT_TYPE Type of the script (PROCEDURE, ADAPTER or UDF)
SCRIPT_LANGUAGE Script language
SCRIPT_INPUT_TYPE Script input type (NULL, SCALAR or SET)
SCRIPT_RESULT_TYPE Return type of the script (ROWCOUNT, TABLE, RETURNS or EMITS)
SCRIPT_TEXT Complete creation text for a script
SCRIPT_COMMENT Comment on the script

EXA_TIME_ZONES

This system table lists all named timezones supported by the database.

All users have access.

Column Meaning
TIME_ZONE_NAME Time zone name

EXA_USER_COLUMNS

This system table contains information on the table columns to those tables owned by the current user.

All users have access.

Column Meaning
COLUMN_SCHEMA Associated schema
COLUMN_TABLE Associated table
COLUMN_OBJECT_TYPE Associated object type
COLUMN_NAME Name of column
COLUMN_TYPE Data type of column
COLUMN_TYPE_ID ID of data type
COLUMN_MAXSIZE Maximum number of characters for strings
COLUMN_NUM_PREC Precision for numeric values
COLUMN_NUM_SCALE Scale for numeric values
COLUMN_ORDINAL_POSITION Position of the column in the table beginning at 1
COLUMN_IS_VIRTUAL States whether the column is part of a virtual table
COLUMN_IS_NULLABLE States whether NULL values are allowed (TRUE or FALSE). In case of views this value is always NULL
COLUMN_IS_DISTRIBUTION_KEY States whether the column is part of the distribution key (TRUE or FALSE)
COLUMN_PARTITION_KEY_ORDINAL_POSITION Position of the column in table's composite partition key beginning at 1 or NULL for columns which are not part of it
COLUMN_DEFAULT Default value of the column
COLUMN_IDENTITY Current value of the identity number generator, if this column has the identity attribute.
COLUMN_OWNER Owner of the associated object
STATUS Status of the object
COLUMN_COMMENT Comment on the column

EXA_USER_CONNECTION_PRIVS

Lists all connections which were granted directly to the user.

All users have access.

Column Meaning
GRANTEE Name of the user who received the right
GRANTED_CONNECTION Name of the connection which was granted
ADMIN_OPTION Information on whether the connection can be passed on to other users/roles

EXA_USER_IMPERSONATION_PRIVS

Lists the specific impersonation privileges granted to current user. For more information on impersonation, refer to the IMPERSONATE statement in the Other Statements section.

All users have access.

Column Meaning
GRANTEE Name of user or role who/which has been granted the privilege
IMPERSONATION_ON Name of user or role on whom/which the impersonation privilege has been granted
GRANTOR Name of user who granted the impersonation privilege

EXA_USER_RESTRICTED_OBJ_PRIVS

Lists all connection objects to which certain, restricted scripts were granted access to, granted directly to the current user.

All users have access.

Column Meaning
OBJECT_SCHEMA Schema of the object for which the restricted privilege has been granted
OBJECT_NAME Name of the object for which the restricted privilege has been granted
OBJECT_TYPE Type of the object for which the restricted privilege has been granted
FOR_OBJECT_SCHEMA Schema of the object that the privilege is restricted to
FOR_OBJECT_NAME Name of the object that the privilege is restricted to
FOR_OBJECT_TYPE Type of the object that the privilege is restricted to
PRIVILEGE The restricted privilege that is granted
GRANTEE Name of the user/role who/which has been granted the restricted privilege
GRANTOR Name of the user/role who/which has granted the restricted privilege
OWNER Name of the owner of the object for which the restricted privilege is granted

EXA_USER_CONSTRAINTS

This system table contains information about constraints of tables owned by the current user.

All users have access.

Column Meaning
CONSTRAINT_SCHEMA Associated schema
CONSTRAINT_TABLE Associated table
CONSTRAINT_TYPE Constraint type (PRIMARY KEY, FOREIGN KEY or NOT NULL)
CONSTRAINT_NAME Name of the constraints
CONSTRAINT_ENABLED Displays whether the constraint is checked or not
CONSTRAINT_OWNER Owner of the constraint (which is the owner of the table)

EXA_USER_CONSTRAINT_COLUMNS

This system table contains information about referenced table columns of all constraints owned by the current user.

All users have access.

Column Meaning
CONSTRAINT_SCHEMA Associated schema
CONSTRAINT_TABLE Associated table
CONSTRAINT_TYPE Constraint type (PRIMARY KEY, FOREIGN KEY or NOT NULL)
CONSTRAINT_NAME Name of the constraints
CONSTRAINT_OWNER Owner of the constraint (which is the owner of the table)
ORDINAL_POSITION Position of the column in the table beginning at 1
COLUMN_NAME Name of the column
REFERENCED_SCHEMA Referenced schema (only for foreign keys)
REFERENCED_TABLE Referenced table (only for foreign keys)
REFERENCED_COLUMN Name of the column in the referenced table (only for foreign keys)

EXA_USER_DEPENDENCIES

Lists all direct dependencies between schema objects owned by the current user.

Dependencies between scripts cannot be determined. In case of a view, entries with REFERENCE_TYPE=NULL values can be shown if underlying objects have been changed and the view has not been accessed again yet.

All users have access.

Column Meaning
OBJECT_SCHEMA Schema of object
OBJECT_NAME Name of object
OBJECT_TYPE Type of object
OBJECT_OWNER Owner of the object
OBJECT_ID ID of the object
REFERENCE_TYPE Reference type (VIEW, CONSTRAINT)
REFERENCED_OBJECT_SCHEMA Schema of the referenced object
REFERENCED_OBJECT_NAME Name of the referenced object
REFERENCED_OBJECT_TYPE Type of the referenced object
REFERENCED_OBJECT_OWNER Owner of the referenced object
REFERENCED_OBJECT_ID ID of the referenced object

EXA_USER_FUNCTIONS

This system table describes all functions in the database owned by the current user.

All users have access.

Column Meaning
FUNCTION_SCHEMA Schema of the function
FUNCTION_NAME Name of the function
FUNCTION_OWNER Owner of the function
FUNCTION_OBJECT_ID ID of the function
FUNCTION_TEXT Generation text of the function
FUNCTION_COMMENT Comment on the function

EXA_USER_INDICES

This system table describes all indices on tables owned by the current user.

Indices are created and managed automatically by the system. Hence, the purpose of this table is mainly for transparency.

All users have access.

Column Meaning
INDEX_SCHEMA Schema of the index
INDEX_TABLE Table of the index
INDEX_OWNER Owner of the index
INDEX_OBJECT_ID ID of the index
INDEX_TYPE Index type
IS_GEOMETRY States whether this is a geospatial index
MEM_OBJECT_SIZE Index size in bytes (at last COMMIT)
CREATED Timestamp of when the index was created
LAST_COMMIT Last time the object was changed in the DB
REMARKS Additional information about the index

EXA_USER_OBJ_PRIVS

This table contains all of the object privileges granted for objects in the database to which the current user has access (except via the PUBLIC role).

All users have access.

Column Meaning
OBJECT_SCHEMA Schema in which the target object is located
OBJECT_NAME Name of the object
OBJECT_TYPE Object type
PRIVILEGE The granted right
GRANTEE Recipient of the right
GRANTOR Name of the user who granted the right
OWNER Owner of the target object

EXA_USER_OBJ_PRIVS_MADE

Lists all of the object privileges related to objects owned by the current user.

All users have access.

Column Meaning
OBJECT_SCHEMA Schema in which the target object is located
OBJECT_NAME Name of the object
OBJECT_TYPE Object type
PRIVILEGE The granted right
GRANTEE Recipient of the right
GRANTOR Name of the user who granted the right
OWNER Owner of the target object

EXA_USER_OBJ_PRIVS_RECD

Lists all object privileges granted directly to the user.

All users have access.

Column Meaning
OBJECT_SCHEMA Schema in which the target object is located
OBJECT_NAME Name of the object
OBJECT_TYPE Object type
PRIVILEGE The granted right
GRANTEE Recipient of the right
GRANTOR Name of the user who granted the right
OWNER Owner of the target object

EXA_USER_OBJECTS

This system table lists all of the objects owned by the current user.

All users have access.

Column Meaning
OBJECT_NAME Name of the object
OBJECT_TYPE Object type
CREATED Timestamp of when the object was created
LAST_COMMIT Last time the object was changed in the DB
OWNER Owner of the object
OBJECT_ID ID of the object
ROOT_NAME Name of the containing object
ROOT_TYPE Type of the containing object
ROOT_ID ID of the containing object
OBJECT_IS_VIRTUAL States whether this is a virtual object
OBJECT_COMMENT Comment on the object

EXA_USER_OBJECT_SIZES

Contains the size of all database objects owned by the current user. The values are calculated recursively, that is, the size of a schema includes the total of all of the sizes of the schema objects contained therein.

All users have access.

Column Meaning
OBJECT_NAME Name of the object
OBJECT_TYPE Object type
RAW_OBJECT_SIZE Uncompressed volume of data in the object in bytes (at last COMMIT)
MEM_OBJECT_SIZE Compressed volume of data in the object in bytes (at last COMMIT)
RAW_OBJECT_SIZE_LIMIT Upper limit for the uncompressed volume of data in the object in bytes
CREATED Timestamp of when the object was created
LAST_COMMIT Last time the object was changed in the DB
OWNER Owner of the object
OBJECT_ID ID of the object
OBJECT_IS_VIRTUAL States whether this is a virtual object
ROOT_NAME Name of the containing object
ROOT_TYPE Type of the containing object
ROOT_ID ID of the containing object

EXA_USER_ROLE_PRIVS

This table lists all of the roles directly granted to the current user (not via other roles).

All users have access.

Column Meaning
GRANTEE Name of user
GRANTED_ROLE Name of the role possessed by the user
ADMIN_OPTION Information on whether the role can be passed on to other users/roles

EXA_USER_SCHEMAS

This system table lists all the schemas that are owned by the current user.

All users have access.

Column Meaning
SCHEMA_NAME Name of the schema object
SCHEMA_OWNER Owner of the object
SCHEMA_OBJECT_ID ID of the schema object
SCHEMA_IS_VIRTUAL States whether this is a virtual schema
SCHEMA_COMMENT Comment on the object

EXA_USER_SCHEMA_OBJECTS

Lists all objects in the current schema that are owned by the current user.

All users have access.

Column Meaning
OBJECT_NAME Name of the object
OBJECT_TYPE Type of the object

EXA_USER_SCRIPTS

This system table describes all of the scripts in the database owned by the current user.

All users have access.

Column Meaning
SCRIPT_SCHEMA Name of the schema of the script
SCRIPT_NAME Name of the script
SCRIPT_OWNER Owner of the script
SCRIPT_OBJECT_ID ID of the script object
SCRIPT_TYPE Type of the script (PROCEDURE, ADAPTER or UDF)
SCRIPT_LANGUAGE Script language
SCRIPT_INPUT_TYPE Script input type (NULL, SCALAR or SET)
SCRIPT_RESULT_TYPE Return type of the script (ROWCOUNT, TABLE, RETURNS or EMITS)
SCRIPT_TEXT Complete creation text for a script
SCRIPT_COMMENT Comment on the script

EXA_USER_SESSIONS

This system table contains complete information on open sessions of the current user. Among other things the most recent SQL statement is shown.

All users have access.

Column Meaning
SESSION_ID Id of the session
USER_NAME Name of the logged-in user
EFFECTIVE_USER Effective user of the session (changeable via IMPERSONATE)
STATUS

Current status of the session. The most important of these are:

  • IDLE: Client is connected but not taking any action.
  • EXECUTE SQL: Execution of one single SQL statement.
  • EXECUTE BATCH: Execution of a series of SQL statements.
  • PREPARE SQL: Entry of a prepared statement.
  • EXECUTE PREPARED: Execution of a prepared statement.
  • FETCH DATA: Client reads results.
  • QUEUED: Client is queued because too many parallel queries are executed.
  • COMMIT STMT TIMEOUT: Commit aborted due to query timeout.
  • STMT TIMEOUT: Statement aborted due to query timeout.
COMMAND_NAME Name of the statement (for example, SELECT, COMMIT, MERGE)
STMT_ID Serially numbered id of statement within a session
DURATION Duration of the statement
QUERY_TIMEOUT Session-specific value of QUERY_TIMEOUT, see also ALTER SESSION and ALTER SYSTEM
ACTIVITY Current activity of the SQL
TEMP_DB_RAM Current temporary database memory usage in MiBClosedMebibyte = 1.048.576 Bytes (cluster wide)
PERSISTENT_DB_RAM Current modified, persistent database memory usage in MiBClosedMebibyte = 1.048.576 Bytes (cluster wide)
LOGIN_TIME Time of login
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 under which the user logged into the operating system of the computer from which the login came
OS_NAME Operating system of the client server
SCOPE_SCHEMA Name of the schema in which the user is located
PRIORITY Current priority group
NICE NICE attribute
RESOURCES Allocated resources in percent
SQL_TEXT SQL text of the statement

EXA_USER_SESSION_RESOURCES

This table shows all sessions that are owned by the current user and associated resource limits.

Column Meaning
SESSION_ID Id of the session
RESOURCE_TYPE Name of the resource
LIMIT_SCOPE Scope of the limit
LIMIT_TYPE Name of the limit
USAGE Current usage
LIMIT_VALUE Value of the limit

EXA_USER_SYS_PRIVS

Lists all system privileges that have been directly granted to the user.

All users have access.

Column Meaning
GRANTEE Name of user
PRIVILEGE Name of the system privilege
ADMIN_OPTION States whether it is permissible for the system privilege to be passed on to other users/roles

EXA_USER_TABLES

This system table describes all of the tables in the database owned by the current user.

All users have access.

Column Meaning
TABLE_SCHEMA Name of the schema of the table
TABLE_NAME Name of the table
TABLE_OWNER Owner of the table
TABLE_OBJECT_ID ID of the table
TABLE_IS_VIRTUAL States whether this is a virtual table
TABLE_HAS_DISTRIBUTION_KEY States whether the table is explicitly distributed
TABLE_HAS_PARTITION_KEY States whether the table is partitioned
TABLE_ROW_COUNT Number of rows in the table
DELETE_PERCENTAGE Fraction of the rows which are just marked as deleted, but not yet physically deleted (in percent)
TABLE_COMMENT Comment on the table

EXA_USER_USERS

This table provides detailed information about the user currently logged in.

All users have access.

Column Meaning
USER_NAME Name of the user
CREATED Time when the user was created
USER_CONSUMER_GROUP Consumer Group of the user
PASSWORD_STATE State of the password (VALID, EXPIRED(GRACE) or EXPIRED)
PASSWORD_STATE_CHANGED Timestamp when the password state has changed, either by password change or by password expiry
PASSWORD_EXPIRY Timestamp when the password will expire or has been expired (if NULL, the password will never expire)
PASSWORD_EXPIRY_DAYS Number of days after which the user password expires after the last password change (if NULL, the password will never expire)
PASSWORD_GRACE_DAYS Number of days within the user has to change the password after it has expired (if NULL, there is no grace period and the user will directly be blocked from login after the expiry)
PASSWORD_EXPIRY_POLICY User-specific expiry policy as specified via ALTER USER command, overwriting the corresponding global system parameter
FAILED_LOGIN_ATTEMPTS Number of failed login attempts by the user since last successful login
USER_COMMENT Comment on the user

EXA_USER_VIEWS

Lists all views owned by the current user.

All users have access.

Column Meaning
VIEW_SCHEMA Name of the schema in which the view was created
VIEW_NAME Name of the view
SCOPE_SCHEMA Schema from which the view was created
VIEW_OWNER Owner of the view
VIEW_OBJECT_ID Internal ID of the view
VIEW_TEXT Text of the view, with which it was created
VIEW_COMMENT Comment on the view

EXA_USER_VIRTUAL_SCHEMAS

Lists all virtual schemas that are owned by the current user and shows the properties which are specific to virtual schemas. Virtual schemas are also listed in the table EXA_SCHEMAS.

All users have access.

Column Meaning
SCHEMA_NAME Name of the virtual schema
SCHEMA_OWNER Owner of the virtual schema
SCHEMA_OBJECT_ID ID of the virtual schema object
ADAPTER_SCRIPT Name of the adapter script used for this virtual schema
LAST_REFRESH Timestamp of the last metadata refresh
LAST_REFRESH_BY Name of the user that performed the last metadata refresh
ADAPTER_NOTES The adapter can store additional information about the schema in this filed

EXA_USER_VIRTUAL_COLUMNS

Lists all columns of virtual tables owned by the current user. It contains the information which are specific to virtual columns. Virtual columns are also listed in the table EXA_USER_COLUMNS.

All users have access.

Column Meaning
COLUMN_SCHEMA Associated virtual schema
COLUMN_TABLE Associated virtual table
COLUMN_NAME Name of the virtual column
COLUMN_OBJECT_ID ID of the virtual columns object
ADAPTER_NOTES The adapter can store additional information about the virtual column in this field

EXA_USER_VIRTUAL_SCHEMA_PROPERTIES

This system table contains information on the properties of all virtual schemas belonging to the current user.

All users have access.

Column Meaning
SCHEMA_NAME Name of the virtual schema
SCHEMA_OBJECT_ID ID of the virtual schema object
PROPERTY_NAME Name of the property of the virtual schema
PROPERTY_VALUE Value of the property of the virtual schema

EXA_USER_VIRTUAL_TABLES

Lists all virtual tables owned by the current user. It contains the information which are specific to virtual tables. Virtual tables are also listed in the table EXA_USER_TABLES.

All users have access.

Column Meaning
TABLE_SCHEMA Name of the virtual schema containing the virtual table
TABLE_NAME Name of the virtual table
TABLE_OBJECT_ID ID of the virtual table
LAST_REFRESH Timestamp of the last metadata refresh (when metadata was committed)
LAST_REFRESH_BY Name of the user that performed the last metadata refresh
ADAPTER_NOTES The adapter can store additional information about the table in this field

EXA_VIRTUAL_SCHEMAS

Lists all virtual schemas to which the current user has access and shows the properties which are specific to virtual schemas. Identical to EXA_ALL_VIRTUAL_SCHEMAS. Virtual schemas are also listed in the table EXA_SCHEMAS.

All users have access.

Column Meaning
SCHEMA_NAME Name of the virtual schema
SCHEMA_OWNER Owner of the virtual schema
SCHEMA_OBJECT_ID ID of the virtual schema object
ADAPTER_SCRIPT Name of the adapter script used for this virtual schema
LAST_REFRESH Timestamp of the last metadata refresh
LAST_REFRESH_BY Name of the user that performed the last metadata refresh
ADAPTER_NOTES The adapter can store additional information about the schema in this field

EXA_VOLUME_USAGE

Shows details of the database usage of the storage volumes.

All users have access.

Column Meaning
CLUSTER_ID The identifier of the cluster.
TABLESPACE The tablespace of the volume
VOLUME_ID The identifier of the volume
IPROC Number of the node
LOCALITY Describes the locality of the master segment. If the value is FALSE, then a performance degradation of I/O operations is probable.
REDUNDANCY Redundancy level of the volume
HDD_TYPE Type of HDDs of the volume
HDD_COUNT Number of HDDs of the volume
HDD_FREE Physical free space on the node in GiB of all disks of the volume
VOLUME_SIZE Size of the volume on the node in GiB
USE Usage of the volume on the node in percent, i.e. 100% - (UNUSED_ DATA/VOLUME_SIZE)
COMMIT_DATA Committed data on the node in GiB
SWAP_DATA Swapped data on the node in GiB
UNUSED_DATA Unused data on the node in GiB. Be aware that volume fragmentation might prevent complete use of all unused data.
DELETE_DATA Deleted data on the node in GiB. This includes all data which cannot be deleted immediately, e.g. because of an active backup or shrink operation.
MULTICOPY_DATA Multicopy data on the node in GiB. Multicopy data occurs in case of transactions where one transaction read
SNAPSHOT_BACKUP_DATA Snapshot backup data on the node in GiB. This includes all data which is not used by the database any more but cannot be deleted because it is referenced by at least one snapshot backup.

EXA_OBJECTSTORAGE_USAGE

Shows details of the database usage of the cloud storage volumes.

All users have access.

Column Meaning
CLUSTER_ID The identifier of the cluster.
TABLESPACE The tablespace of the volume
IPROC Number of the node
COMMIT_DATA Committed data on the node in GiB
SWAP_DATA Swapped data on the node in GiB
UNUSED_DATA Unused data on the node in GiB. Be aware that volume fragmentation might prevent complete use of all unused data.
DELETE_DATA Deleted data on the node in GiB. This includes all data which cannot be deleted immediately, e.g. because of an active backup or shrink operation.
MULTICOPY_DATA Multicopy data on the node in GiB. Multicopy data occurs in case of transactions where one transaction read
SNAPSHOT_BACKUP_DATA Snapshot backup data on the node in GiB. This includes all data which is not used by the database any more but cannot be deleted because it is referenced by at least one snapshot backup.