System Views
Reference of the built-in SQL system views in the GridGain 9 SYSTEM schema, with the columns and data types of each view.
GridGain provides a number of built-in SQL views that provide information on the cluster's state and provide real-time insight into the status of its components. These views are available in the SYSTEM schema.
Getting Data
You access system views in GridGain by using SQL and selecting data from the system view like you would from any other table. For example, you can get a list of all available system views in the following way:
SELECT * FROM system.system_views;You can also use joins to combine data from multiple views. The example below returns all columns of a view that was found in the SYSTEM_VIEWS view:
SELECT svc.*
FROM system.system_view_columns svc
JOIN system.system_views sv ON svc.view_id = sv.id
WHERE sv.name = 'SYSTEM_VIEWS';Available Views
COMPUTE_TASKS
COORDINATOR_NODE_ID
STRING
The task's coordinator node ID.
COMPUTE_TASK_ID
STRING
The compute task ID.
COMPUTE_TASK_STATUS
STRING
The task status.
COMPUTE_TASK_CREATE_TIME
TIMESTAMP WITH LOCAL TIME ZONE
The task creation timestamp.
COMPUTE_TASK_START_TIME
TIMESTAMP WITH LOCAL TIME ZONE
The task start timestamp.
COMPUTE_TASK_FINISH_TIME
TIMESTAMP WITH LOCAL TIME ZONE
The task finish timestamp.
ID
STRING
Deprecated. The compute task ID.
STATUS
STRING
Deprecated.The task status.
CREATE_TIME
TIMESTAMP WITH LOCAL TIME ZONE
Deprecated.The task creation timestamp.
START_TIME
TIMESTAMP WITH LOCAL TIME ZONE
Deprecated.The task start timestamp.
FINISH_TIME
TIMESTAMP WITH LOCAL TIME ZONE
Deprecated.The task finish timestamp.
GLOBAL_ZONE_PARTITION_STATES
ZONE_NAME
STRING
Name of the zone.
ZONE_ID
INT32
Internal identifier of the zone.
PARTITION_ID
INT32
Identifier of the partition.
PARTITION_STATE
STRING
Current state of the partition. Possible values:
• AVAILABLE – All replicas are healthy.
• DEGRADED – There are healthy replicas, and they form a majority.
• READ_ONLY – There are healthy replicas, but they don’t form a majority.
• UNAVAILABLE – There are no healthy replicas.
INDEXES
INDEX_ID
INT32
Unique index identifier.
INDEX_NAME
STRING
The name of the index.
TABLE_ID
INT32
Unique table identifier.
TABLE_NAME
STRING
The name of the table.
SCHEMA_ID
INT32
Unique schema identifier.
SCHEMA_NAME
STRING
The name of the schema.
INDEX_TYPE
STRING
The type of the index. Possible values: HASH, SORTED.
IS_UNIQUE_INDEX
BOOLEAN
If the index is unique.
INDEX_COLUMNS
STRING
The list of indexed columns.
INDEX_STATE
STRING
Current status of the index. Possible values:
• REGISTERED - Index has been registered and is awaiting the start of building,
• BUILDING - Index is being built,
• AVAILABLE - Index is built and is ready to use,
• STOPPING - DROP INDEX command has been executed, index is waiting for running transactions to finish.
TYPE
STRING
Deprecated. The type of the index. Possible values: HASH, SORTED.
IS_UNIQUE
BOOLEAN
Deprecated. If the index is unique.
COLUMNS
STRING
Deprecated. The list of indexed columns.
STATUS
STRING
Deprecated. Current status of the index. Possible values:
• REGISTERED - Index has been registered and is awaiting the start of building,
• BUILDING - Index is being built,
• AVAILABLE - Index is built and is ready to use,
• STOPPING - DROP INDEX command has been executed, index is waiting for running transactions to finish.
CATALOG_VERSION
INT32
The version of the current catalog that contains this index.
INDEX_COLUMNS
SCHEMA_ID
INT32
Unique schema identifier.
SCHEMA_NAME
STRING
The name of the schema.
TABLE_ID
INT32
Unique table identifier.
TABLE_NAME
STRING
The name of the table.
INDEX_ID
INT32
Unique index identifier.
INDEX_NAME
STRING
The name of the index.
COLUMN_NAME
STRING
Column name.
COLUMN_ORDINAL
INT32
The ordinal number of the column in the index definition.
COLUMN_COLLATION
STRING
Collation rules for the column.
CATALOG_VERSION
INT32
The version of the current catalog that contains this index column.
LICENSES
LICENSE_ID
STRING
The license ID.
LICENSE_EDITION
STRING
License edition.
LICENSE_COMMON_INFO
STRING
A list of key-value pairs providing information about the license requester/owner.
LICENSE_LIMITS
STRING
A list of key-value pairs providing information about the license validity period, cores and heap size limits, etc.
LICENSE_FEATURES
STRING
A list of GridGain features the license grants to the user.
ID
STRING
Deprecated. The license ID.
EDITION
STRING
Deprecated. License edition.
INFOS
STRING
Deprecated. A list of key-value pairs providing information about the license requester/owner.
LIMITS
STRING
Deprecated. A list of key-value pairs providing information about the license validity period, cores and heap size limits, etc.
FEATURES
STRING
Deprecated. A list of GridGain features the license grants to the user.
LOCAL_ZONE_PARTITION_STATES
NODE_NAME
STRING
Name of the node reporting the partition state.
ZONE_NAME
STRING
Name of the zone.
ZONE_ID
INT32
Internal identifier of the zone.
ESTIMATED_ROWS
INT64
Approximate number of rows stored in this partition on the local node.
PARTITION_ID
INT32
Identifier of the partition.
PARTITION_STATE
STRING
Current state of the local partition. Possible values:
• UNAVAILABLE – This state might be used when partition is not yet started, or it's already stopping, for example.
• HEALTHY – Alive partition with a healthy state machine.
• INITIALIZING – Partition is starting right now.
• INSTALLING_SNAPSHOT – Partition is installing a Raft snapshot from the leader.
• CATCHING_UP – Partition is catching up, meaning that it's not replicated part of the log yet.
• BROKEN – Partition is in broken state, usually it means that its state machine thrown an exception.
LOCKS
A node system view that lists the currently active locks.
OWNING_NODE_ID
STRING
The ID of the node that owns the lock.
TRANSACTION_ID
STRING
The ID of the transaction that created the lock.
OBJECT_ID
STRING
The ID of the locked object.
LOCK_MODE
STRING
The lock mode. Possible values are: • IS - intention shared lock • S- shared lock • IX - intention exclusive lock • SIX - shared intention exclusive lock • X - exclusive lock
TX_ID
STRING
Deprecated. The ID of the transaction that created the lock.
MODE
STRING
Deprecated. The lock mode. Possible values are: • IS - intention shared lock • S- shared lock • IX - intention exclusive lock • SIX - shared intention exclusive lock • X - exclusive lock
POLICIES
SCHEMA_NAME
STRING
The name of the schema.
SCHEMA_ID
INT32
Unique schema identifier.
TABLE_NAME
STRING
The name of the table.
TABLE_ID
INT32
Unique table identifier.
POLICY_NAME
STRING
The name of the policy.
POLICY_ID
INT32
Unique policy identifier.
ROLES
STRING
The comma-separated list of roles the policy applies to.
CONDITION
STRING
A boolean SQL expression over the columns of the target table.
CATALOG_VERSION
INT32
The version of the current catalog that contains this policy.
SCHEMAS
SCHEMA_ID
INT32
Unique schema identifier.
SCHEMA_NAME
STRING
The name of the schema.
CATALOG_VERSION
INT32
The version of the current catalog that contains this schema.
SEQUENCES
SEQUENCE_ID
INT32
The ID of the sequence.
SEQUENCE_NAME
STRING
The name of the sequence.
SEQUENCE_DATA_TYPE
STRING
The sequence data type.
SEQUENCE_INCREMENT
INT64
How much the sequence is incremented by each time.
SEQUENCE_MINIMUM_VALUE
INT64
Minimum sequence value.
SEQUENCE_MAXIMUM_VALUE
INT64
Maximum sequence value.
SEQUENCE_START_VALUE
INT64
The starting value of the sequence.
SEQUENCE_CACHE_VALUE
INT64
The amount of sequence numbers that are pre-allocated and stored in memory.
ID
INT32
Deprecated. The ID of the sequence.
NAME
STRING
Deprecated. The name of the sequence.
SCHEMA_ID
INT32
The id of the schema used by the sequence.
SCHEMA_NAME
STRING
The name of the schema used by the sequence.
DATA_TYPE
STRING
Deprecated. The sequence data type.
INCREMENT
INT64
Deprecated. How much the sequence is incremented by each time.
MINIMUM_VALUE
INT64
Deprecated. Minimum sequence value.
MAXIMUM_VALUE
INT64
Deprecated. Maximum sequence value.
START_VALUE
INT64
Deprecated. The starting value of the sequence.
CACHE_VALUE
INT64
Deprecated. The amount of sequence numbers that are pre-allocated and stored in memory.
CATALOG_VERSION
INT32
The version of the current catalog that contains this sequence.
SQL_QUERIES
INITIATOR_NODE
STRING
The name of the node that initiated the query.
QUERY_ID
STRING
The query ID.
USERNAME
STRING
The name of the user who started the query.
QUERY_PHASE
STRING
The query phase: • INITIALIZATION - query registration and parsing • OPTIMIZATION - query validation and plan optimization • EXECUTION - query plan execution
QUERY_TYPE
STRING
The query type: DDL, DML, QUERY, or SCRIPT.
QUERY_DEFAULT_SCHEMA
STRING
The name of the default schema that was used to execute the query.
SQL
STRING
The SQL query's expression. Password literals in CREATE USER and ALTER USER statements are replaced with '******', including statements inside a multi-statement script.
QUERY_START_TIME
TIMESTAMP
The date/time the query started.
TRANSACTION_ID
STRING
The ID of the transaction in which the query was executed.
PARENT_QUERY_ID
STRING
ID of the script that initiated the query (NULL if the query was not initiated by a script).
QUERY_STATEMENT_ORDINAL
INT32
The ordinal number of the query.
ID
STRING
Deprecated. The query ID.
PHASE
STRING
Deprecated. The query phase: • INITIALIZATION - query registration and parsing • OPTIMIZATION - query validation and plan optimization • EXECUTION - query plan execution
TYPE
STRING
Deprecated. The query type: DDL, DML, QUERY, or SCRIPT.
SCHEMA
STRING
Deprecated. The name of the default schema that was used to execute the query.
START_TIME
TIMESTAMP
Deprecated. The date/time the query started.
PARENT_ID
STRING
Deprecated. ID of the script that initiated the query (NULL if the query was not initiated by a script).
STATEMENT_NUM
INT32
Deprecated. The ordinal number of the query.
QUERY_RETRY_COUNT
INT32
The number of times the query was retried. 0 if the query was not retried.
QUERY_RETRY_REASON
STRING
The error message that triggered the most recent retry. NULL if the query was not retried.
SQL_CACHED_QUERY_PLANS
NODE_ID
STRING
ID of the node where the plan is cached.
PLAN_ID
STRING
Internal identifier of the prepared plan.
CATALOG_VERSION
INT32
Catalog version used when the query was prepared.
QUERY_DEFAULT_SCHEMA
STRING
Default schema applied during query preparation.
SQL
STRING
Normalized SQL text of the query.
QUERY_TYPE
STRING
Query type.
QUERY_PLAN
STRING
Serialized or explain representation of the chosen query plan.
QUERY_PREPARE_TIME
TIMESTAMP WITH LOCAL TIME ZONE
Time the plan was prepared on the node.
SYSTEM_VIEWS
Describes available system views.
VIEW_ID
INT32
System view ID.
SCHEMA_NAME
STRING
Name of the schema used. Default is SYSTEM.
VIEW_NAME
STRING
System view name.
VIEW_TYPE
STRING
System view type. Possible values: • NODE - The view provides node-specific information. Data will be collected from all nodes, and represented in the view. • CLUSTER - The view provides cluster-wide information. Data will be collected from one node, chosen to represent the cluster.
ID
INT32
Deprecated. System view ID.
SCHEMA
STRING
Deprecated. Name of the schema used. Default is SYSTEM.
NAME
STRING
Deprecated. System view name.
TYPE
STRING
Deprecated. System view type. Possible values: • NODE - The view provides node-specific information. Data will be collected from all nodes, and represented in the view. • CLUSTER - The view provides cluster-wide information. Data will be collected from one node, chosen to represent the cluster.
CATALOG_VERSION
INT32
The version of the current catalog that contains this system view.
SYSTEM_VIEW_COLUMNS
Describes available system view columns.
VIEW_ID
INT32
System view ID.
VIEW_NAME
STRING
System view name.
COLUMN_NAME
STRING
Column name.
IS_NULLABLE_COLUMN
BOOLEAN
Defines if the column can be empty.
COLUMN_PRECISION
INT32
Maximum number of digits.
COLUMN_SCALE
INT32
Maximum number of decimal places.
COLUMN_LENGTH
INT32
Maximum length of the value. Symbols for string values or bytes for binary values.
NAME
STRING
Deprecated. Column name.
NULLABLE
BOOLEAN
Deprecated. Defines if the column can be empty.
PRECISION
INT32
Deprecated. Maximum number of digits.
SCALE
INT32
Deprecated. Maximum number of decimal places.
LENGTH
INT32
Deprecated. Maximum length of the value. Symbols for string values or bytes for binary values.
CATALOG_VERSION
INT32
The version of the current catalog that contains this system view column.
TABLES
SCHEMA_NAME
STRING
The schema used by the table.
TABLE_NAME
STRING
Table name.
TABLE_ID
INT32
Unique table identifier.
TABLE_PK_INDEX_ID
INT32
The identifier of the primary key index.
ZONE_NAME
STRING
The distribution zone the table belongs to.
STORAGE_PROFILE
STRING
The storage profile the table uses.
TABLE_COLOCATION_COLUMNS
STRING
The name of the column that is used to colocate data.
SCHEMA_ID
STRING
The identifier of the schema used by the table.
ZONE_ID
STRING
The identifier of the zone the table belongs to.
SECONDARY_ZONE_ID
INT32
The identifier of the distribution zone used for secondary storage. Returns NULL if the table does not have secondary storage configured.
SECONDARY_ZONE_NAME
STRING
The name of the distribution zone used for secondary storage. Returns NULL if the table does not have secondary storage configured.
SECONDARY_STORAGE_PROFILE
STRING
The name of the storage profile used for secondary storage. Returns NULL if the table does not have secondary storage configured.
SECONDARY_STORAGE_STATE
STRING
The current synchronization state of secondary storage. Possible values:
• NOT_AVAILABLE - The table does not have secondary storage configured.
• SYNCING - Secondary storage is being synchronized with primary storage.
• AVAILABLE - Secondary storage is synchronized and available for queries.
SCHEMA
STRING
Deprecated. The schema used by the table.
NAME
STRING
Deprecated. Table name.
ID
INT32
Deprecated. Unique table identifier.
PK_INDEX_ID
INT32
Deprecated. The identifier of the primary key index.
COLOCATION_KEY_INDEX
STRING
Deprecated. The name of the column that is used to colocate data.
ZONE
STRING
Deprecated. The distribution zone the table belongs to.
CATALOG_VERSION
INT32
The version of the current catalog that contains this table.
EXPIRE_COLUMN_ID
INT32
The identifier of the column used for row expiration. Returns NULL if the table has no expiration column.
EXPIRE_COLUMN_NAME
STRING
The name of the column used for row expiration. Returns NULL if the table has no expiration column.
ARCHIVE_COLUMN_ID
INT32
The identifier of the column used for archiving. Returns NULL if the table has no archive column.
ARCHIVE_COLUMN_NAME
STRING
The name of the column used for archiving. Returns NULL if the table has no archive column.
PROPERTIES
STRING
The table options set with the WITH (...) clause, in the form MIN STALE ROWS <n>, STALE ROWS FRACTION <f>. Tables created without these options show the defaults: MIN STALE ROWS 500, STALE ROWS FRACTION 0.2.
TABLE_SCHEMA_VERSION
INT32
The latest schema version of the table. The version increases every time the table's schema changes, for example when a column is added or dropped.
TABLE_COLUMNS
SCHEMA_NAME
STRING
The schema used by the table.
TABLE_NAME
STRING
Table name.
TABLE_ID
INT32
Unique table identifier.
COLUMN_NAME
STRING
Column name.
COLUMN_TYPE
STRING
Column data type.
IS_NULLABLE_COLUMN
BOOLEAN
If the column can be NULL.
COLUMN_PRECISION
INT32
Value precision. 0 if not applicable to data type.
COLUMN_SCALE
INT32
Value scale. 0 if not applicable to data type.
COLUMN_LENGTH
INT32
Value length, in bytes.
COLUMN_ORDINAL
INT32
The ordinal number of the column.
SCHEMA_ID
INT32
The id of the schema used by the sequence.
PK_COLUMN_ORDINAL
INT32
Zero-based position of the column in the primary key. NULL if the column is not part of the primary key.
COLOCATION_COLUMN_ORDINAL
INT32
Zero-based position of the column in the colocation key. NULL if the column is not part of the primary key.
SCHEMA
STRING
Deprecated. The schema used by the table.
TYPE
STRING
Deprecated. Column data type.
NULLABLE
BOOLEAN
Deprecated. If the column can be NULL.
PREC
INT32
Deprecated. Value precision. 0 if not applicable to data type.
SCALE
INT32
Deprecated. Value scale. 0 if not applicable to data type.
LENGTH
INT32
Deprecated. Value length, in bytes.
CATALOG_VERSION
INT32
The version of the current catalog that contains this table column.
DEFAULT_VALUE
STRING
The SQL representation of the column's default value, or NULL if default is NULL or is not set. Literals are shown in SQL form (for example, 'hello', 42, DATE '2020-01-01', x'AABBCCDDEEFF'). Function-based defaults are shown as their call form (for example, RAND_UUID, NEXTVAL('SEQ_NAME'), CURRENT_TIMESTAMP + INTERVAL '7' DAYS).
TRANSACTIONS
COORDINATOR_NODE_ID
STRING
The name of the transaction's coordinator node.
TRANSACTION_STATE
STRING
The transaction state. For read-only transactions, the value is always null (empty). For read-write transactions, the possible values are PENDING - the transaction is in progress - and FINISHING - the transaction is in the process of being finished.
TRANSACTION_ID
STRING
The transaction ID.
TRANSACTION_START_TIME
TIMESTAMP
The transaction's start time.
TRANSACTION_TYPE
STRING
The transaction type: READ_ONLY or READ_WRITE.
TRANSACTION_PRIORITY
STRING
The transaction priority, which is used to resolve conflicts between transactions. This value cannot be explicitly set by the user. Possible values are LOW and NORMAL (default).
TRANSACTION_LABEL
STRING
The label of the transaction, if any. Labels are assigned to transaction creation, and persist for the lifetime. Labels are only available for read-write transactions.
STATE
STRING
Deprecated. The transaction state. For read-only transactions, the value is always null (empty). For read-write transactions, the possible values are PENDING - the transaction is in progress - and FINISHING - the transaction is in the process of being finished.
ID
STRING
Deprecated. The transaction ID.
START_TIME
TIMESTAMP
Deprecated. The transaction's start time.
TYPE
STRING
Deprecated. The transaction type: READ_ONLY or READ_WRITE.
PRIORITY
STRING
Deprecated. The transaction priority, which is used to resolve conflicts between transactions. This value cannot be explicitly set by the user. Possible values are LOW and NORMAL (default).
ZONES
ZONE_NAME
STRING
The name of the distribution zone.
ZONE_PARTITIONS
INT32
The number of partitions in the distribution zone.
ZONE_REPLICAS
STRING
The number of copies of each partition in the distribution zone.
DATA_NODES_AUTO_ADJUST_SCALE_UP
INT32
The delay in seconds between the new node joining and the start of data zone adjustment.
DATA_NODES_AUTO_ADJUST_SCALE_DOWN
INT32
The delay in seconds between the node leaving the cluster and the start of data zone adjustment.
DATA_NODES_FILTER
STRING
The filter that specifies what nodes will be used by the distribution zone.
IS_DEFAULT_ZONE
BOOLEAN
If the data zone is used by default.
ZONE_CONSISTENCY_MODE
STRING
The zone's consistency mode. Possible values: STRONG_CONSISTENCY, HIGH_AVAILABILITY.
ZONE_ID
INT32
Unique zone identifier.
NAME
STRING
Deprecated. The name of the distribution zone.
PARTITIONS
INT32
Deprecated. The number of partitions in the distribution zone.
REPLICAS
STRING
Deprecated. The number of copies of each partition in the distribution zone.
CONSISTENCY_MODE
STRING
Deprecated. The zone's consistency mode. Possible values: STRONG_CONSISTENCY, HIGH_AVAILABILITY.
CATALOG_VERSION
INT32
The version of the current catalog that contains this distribution zone.
ZONE_STORAGE_PROFILES
ZONE_NAME
STRING
The name of the distribution zone.
STORAGE_PROFILE
STRING
The name of the storage profile used by the distribution zone.
IS_DEFAULT_PROFILE
BOOLEAN
If the storage profile is used by default.
ZONE_ID
INT32
Unique zone identifier.
This page is: Copyright © 2026 MariaDB. All rights reserved.
Last updated
Was this helpful?

