Skip to main content

Information Schema View List

Here is an alphabetical list of all the information_schema views that SingleStoreDB supports. Data retention value listed as "N/A" means the view returns applicable data in the current state of the cluster.

Table Name

Table Description

Data Retention

ADVANCED_HISTOGRAMS

This view contains information about histograms that have been collected by automatic statistics or using ANALYZE.

N/A

AGGREGATE_FUNCTIONS

This view contains information about user defined aggregate functions (UDAF).

N/A

AGGREGATORS

This view contains information about aggregators. It is useful for understanding the number and attributes of the aggregators for a given workspace.

N/A

AVAILABILITY_GROUPS

This view contains information about availability groups.

N/A

CHARACTER_SETS

This view stores information about available character sets.

N/A

COLLATION_CHARACTER_SET_APPLICABILITY

This view stores information about the available collations for each character set.

N/A

COLLATIONS

This view stores information about collations for each character set.

N/A

COLUMN_STATISTICS

This view contains information about each column in a given workspace. Each row displays information about a given column on a given database partition.

N/A

COLUMNAR_SEGMENTS

This view stores information about each columnar_segment (column segment).

N/A

COLUMNS

This view stores information about each column.

N/A

CURRENT_USER_GROUPS

This view contains information about the group(s) the current user belongs to.

N/A

CURRENT_USER_ROLES

This view contains information about the role(s) of the current user.

N/A

DISTRIBUTED_DATABASES

This view contains information about databases.

N/A

DISTRIBUTED_DATABASES_ON_SITES

This view contains information about how databases are distributed across workspaces.

N/A

DISTRIBUTED_PARTITIONS

This view contains information about partitions.

N/A

GROUP_PRIVILEGES

This view contains information about privileges as they relate to the roles and groups they are associated with.

N/A

GROUPS_ROLES

This view contains information about groups and the roles that are part of them.

N/A

IND_CS_PARTITION_ROW_SEGMENT_GROUPS

This view store information about groups of row segments that are sorted together.

N/A

INDEX_STATISTICS

This view contains statistics about indexes. Each row displays information about a given index on a given database partition.

N/A

KEY_COLUMN_USAGE

This view contains information about columns that are part of unique keys (constraints) and displays one row per column in a unique constraint.

N/A

LEAVES

This view contains information about leaves.

N/A

LMV_JOIN_OPTIMIZATION_RESULTS

This view contains information about the results of join optimization operations. This table displays rows for each query plan and each table joined in the query plan.

Tied to in-memory plancache expiration (default setting is 720 minutes)

LMV_PROFILE_STATS

This view contains statistics collected with PROFILE. The table shows only the PROFILE from the last query instance of a given activity.

N/A

LMV_REPLICATION_STATUS

This view provides the replication status of every replication link on a single node. This view can be accessed from any node in the workspace.

N/A

MV_ACTIVITIES

This view provides a high-level summary profile of all tasks which ran recently on any node in the workspace.

N/A

MV_ACTIVITIES_CUMULATIVE

This view provides a high-level summary profile of completed and currently running tasks on all nodes of the workspace.

Tied to in-memory plancache expiration (default setting is 720 minutes)

MV_ACTIVITIES_EXTENDED

This view provides a detailed profile of all tasks which ran recently on any node in the workspace.

N/A

MV_ACTIVITIES_EXTENDED_CUMULATIVE

This view provides a detailed profile of completed and currently running tasks on all nodes of the workspace.

Tied to in-memory plancache expiration (default setting is 720 minutes)

MV_AGGREGATED_COLUMN_USAGE

This view provides a summary of mv_query_column_usage, aggregating over the columns over all queries run.

Tied to in-memory plancache expiration (default setting is 720 minutes)

MV_AGGREGATED_REPLICATION_STATUS

This view provides the aggregated replication status of each database in the workspace.

N/A

MV_BACKUP_HISTORY

This view stores information about backups that have been made.

N/A

MV_BACKUP_STATUS

This view stores information about the status of ongoing backups.

Stores entries until CLEAR BACKUP_HISTORY command is executed

MV_BLOB_CACHE_EVENTSMV_BLOB_CACHE_EVENTS

This view stores information about events pertaining to cached blobs.

Stores the 115,122 most recent events on each node since the last restart

MV_BLOCKED_QUERIES

This view provides a summary of activities that are currently unable to complete (blocked queries) because they are blocked by another activity (blocking queries).

N/A

MV_BOTTOMLESS_API_EVENTSMV_BOTTOMLESS_API_EVENTS

This view gives details on every remote API call that is made from the engine.

Stores the 115,122 most recent events on each node since the last restart

MV_BOTTOMLESS_REMOTE_STATSMV_BOTTOMLESS_REMOTE_STATS

This view gives a breakdown of the remote storage information for each unlimited storage database, both reference and partition.

N/A

MV_BOTTOMLESS_STATUSMV_BOTTOMLESS_STATUS

This view gives an overview of all the unlimited storage databases in a workspace, includes the reference databases and the partition databases.

N/A

MV_BOTTOMLESS_STATUS_EXTENDEDMV_BOTTOMLESS_STATUS_EXTENDED

This view provides more diagnostic information compared to MV_BOTTOMLESS_STATUS, such as more detailed LSN, upload statistics, API statistics, and logchunk/snapshot information.

N/A

MV_BOTTOMLESS_SUMMARYMV_BOTTOMLESS_SUMMARY

This view is an at-a-glance rollup table the shows what is happening at the moment with the unlimited storage workspace.

N/A

MV_BT

This view shows backtrace information for all all nodes in the workspace. This is primarily used by SingleStore Customer Support.

N/A

MV_CACHED_BLOBSMV_CACHED_BLOBS

This view stores information about currently cached blobs.

N/A

MV_CLUSTER_STATUS

This view stores information about partitions within a workspace.

N/A

MV_COLLECTED_ROW_CHANGE_COUNTS

This view displays the best-effort counter for the number of changes that have been observed for the table partitions over time, and persisted to disk.

N/A

MV_COLUMNAR_SEGMENT_INDEX

This view stores information about indexes used to sort columnstore segments.

N/A

MV_COLUMNSTORE_FILES

This view stores information about columnstore files.

N/A

MV_COLUMNSTORE_MERGE_STATUS

This view stores information about the status of background_merger processes for columnstore tables.

N/A

MV_DISTRIBUTED_DATABASES_STATUS

This view contains information about the status of databases.

N/A

MV_EVENTS

This view contains information about events and is useful for monitoring events across workspaces over time.

Stores the 1,028 most recent events

MV_FINISHED_TASKS

This view provides a detailed profile of completed tasks on all nodes of the workspace.

Tied to in-memory plancache expiration (default setting is 720 minutes)

MV_GLOBAL_STATUS

This view contains information on the global server status variables that are set on the workspace’s nodes.

N/A

MV_GLOBAL_VARIABLES

This view contains information about the global variables that are set on the workspace’s nodes.

N/A

MV_HOSTS_INFORMATION

This view contains information about hosts.

N/A

MV_MILESTONESMV_MILESTONES

This view displays the list of milestones that have been created in the engine. This is the list of points that can be used to perform PITR.

N/A

MV_NODES

This view describes all SingleStoreDB Cloud nodes in the workspace.

N/A

MV_PLANCACHE

This view shows plancache information for all nodes in the workspace.

Tied to in-memory plancache expiration (default setting is 720 minutes)

MV_PROCESSLIST

This view contains information about currently running threads on a workspace for all nodes.

N/A

MV_PROSPECTIVE_HISTOGRAMS

This view contains information about columns which were used in queries where a histogram could have been utilized, but did not have histograms.

Tied to in-memory plancache expiration (default setting is 720 minutes)

MV_QUERIES

This view describes queries seen by SingleStoreDB Cloud.

Tied to in-memory plancache expiration (default setting is 720 minutes)

MV_QUERY_ACTIVITIES

This view provides a high-level summary profile of all the queries that ran recently in the workspace.

N/A

MV_QUERY_ACTIVITIES_EXTENDED_CUMULATIVE

This view provides a detailed profile of completed and currently running queries on all nodes of the workspace. It holds a row per query.

Tied to in-memory plancache expiration (default setting is 720 minutes)

MV_QUERY_COLUMN_USAGE

This view provides information about the usage of columns by queries in the workload.

Tied to in-memory plancache expiration (default setting is 720 minutes)

MV_QUERY_PROSPECTIVE_HISTOGRAMS

This view contains information about columns which were used in queries where a histogram could have been utilized, but did not have histograms.

Tied to in-memory plancache expiration (default setting is 720 minutes)

MV_REBALANCE_STATUS

This view contains information about the status of REBALANCE operations.

N/A

MV_REPLICATION_STATUS

This view provides the replication status of each replication link in all nodes of the workspace.

N/A

MV_RESOURCE_POOL_STATUS

This view contains information about the status of resource pools.

N/A

MV_ROW_CHANGE_COUNTS

This view is primarily for internal use, we recommend using MV_COLLECTED_ROW_CHANGE_COUNTS instead.

N/A

MV_SYSINFO_CPU

This view describes the total CPU usage breakdown of SingleStoreDB Cloud and other processes per node.

N/A

MV_SYSINFO_CPULIST

This view describes the total CPU usage breakdown of SingleStoreDB Cloud and other processes per core.

N/A

MV_SYSINFO_DISK

This view describes the total disk usage breakdown of SingleStoreDB Cloud and other processes.

N/A

MV_SYSINFO_MEM

This view describes the total memory usage breakdown of SingleStoreDB Cloud and other processes.

N/A

MV_SYSINFO_NET

This view describes the total network usage by interface.

N/A

MV_TASKS

This view provides a detailed profile of all currently running tasks on all nodes of the workspace.

N/A

MV_WORKLOAD_MANAGEMENT_STATUS

This view contains information about the workload per aggregator. The statistics available in the STAT and VALUE columns are those displayed by SHOW WORKLOAD MANAGEMENT STATUS.

N/A

OPTIMIZER_STATISTICS

This view contains column statistics calculated on columns when a table is processed by autostats or the ANALYZE command.

N/A

PARAMETERS

This view contains information about parameters.

N/A

PIPELINES

This view stores high-level information about any pipelines that have been created in the workspace. Each row represents a single pipeline.

N/A

PIPELINES_BATCHES

This view contains detailed, low-level information about individual batches as they’re loaded into the database.

Stores the value set by the engine variable pipelines_batches_metadata_to_keep (default setting is 1000 batches)

PIPELINES_BATCHES_SUMMARY

This view contains high-level information about individual batches as they are loaded into the database. It contains one row per batch.

N/A

PIPELINES_CURSORS

This view contains information about a pipeline’s offset ranges. Each row represents a single data source partition.

N/A

PIPELINES_ERRORS

This view contains detailed information about errors that occurred during extraction, transformation, or loading. Each row represents a single error event.

Stores the value set by the engine variable pipelines_errors_retention_minutes (default setting is 1440 minutes)

PIPELINES_FILES

This view stores information about files that have been extracted from a file system-like data source, such as Amazon S3. Each row represents a single file.

N/A

PLANCACHE

This view contains information about all query statements that SingleStore has compiled and executed, as well as cumulative query execution statistics associated with each plan.

Tied to in-memory plancache expiration (default setting is 720 minutes)

RANGE_STATISTICS

This view is deprecated and no longer used. This table previously contained information about legacy histograms that have been collected using ANALYZE. Current histograms are shown in the ADVANCED_HISTOGRAMS table instead.

N/A

RESOURCE_POOLS

This view contains information about resource pools.

N/A

ROLE_PRIVILEGES

This view contains information about roles as they relate to privileges in a workspace.

N/A

ROUTINES

This view contains information about routines in a workspace.

N/A

SCHEMA_PRIVILEGES

This view contains information about the privileges in a given workspace.

N/A

SCHEMATA

This view contains information about schemas (databases).

N/A

SITES

This view contains information about sites, and is available with SingleStoreDB Cloud.

N/A

STATISTICS

This view contains statistics about table indexes. It displays one row per column per index.

N/A

TABLE_CONSTRAINTS

This view contains information about table constraints.

N/A

TABLE_PRIVILEGES

This view contains information about tables and their related privileges in a given workspace.

N/A

TABLE_STATISTICS

This view contains information about table statistics. It contains one row per table, per partition.

N/A

TABLES

This view contains information about the tables visible to the current node.

N/A

USER_PRIVILEGES

This view contains information about the users and their related privileges in a given workspace.

N/A

USER_VARIABLES

This view contains information about user defined variables. See more about how to define these in User-Defined Variables.

N/A

USERS

This view contains information about users for a given workspace.

N/A

USERS_GROUPS

This view contains information about how groups and users are related for a given workspace.

N/A

VIEWS

This view contains information about the views in a workspace.

N/A