Information Schema View List
Warning
SingleStore 9.0 gives you the opportunity to preview, evaluate, and provide feedback on new and upcoming features prior to their general availability. In the interim, SingleStore 8.9 is recommended for production workloads, which can later be upgraded to SingleStore 9.0.
On this page
Here is an alphabetical list of all the information_
views that SingleStore supports.
There are some additional, unused tables that are included purely for backward compatibility with MySQL, listed here.
Table Name |
Table Description |
Data Retention |
---|---|---|
This view contains information about histograms that have been collected by automatic statistics or using |
N/A |
|
This view contains information about user defined aggregate functions (UDAF). |
N/A |
|
This view contains information about aggregators. |
N/A |
|
This view contains information about availability groups. |
N/A |
|
This view stores information about available character sets. |
N/A |
|
This view stores information about the available collations for each character set. |
N/A |
|
This view stores information about collations for each character set. |
N/A |
|
This view contains information about each column in a given cluster. |
N/A |
|
This view stores information about each |
N/A |
|
This view stores information about each column. |
N/A |
|
This view contains information about correlated columns. |
The column correlation data is based on metadata rows that are persisted within the user database. |
|
This view contains information about the group(s) the current user belongs to. |
N/A |
|
This view contains information about the role(s) of the current user. |
N/A |
|
This view contains information about databases. |
N/A |
|
This view contains information about how databases are distributed across clusters. |
N/A |
|
This view contains information about partitions. |
N/A |
|
This view contains information about privileges as they relate to the roles and groups they are associated with. |
N/A |
|
This view contains information about groups and the roles that are part of them. |
N/A |
|
This view store information about groups of row segments that are sorted together. |
N/A |
|
This view contains statistics about indexes. |
N/A |
|
This view contains information about the schema inferred for JSON columns in columnstore tables. |
N/A |
|
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 |
|
This view contains information about leaves. |
N/A |
|
This view shows the queries being compiled. |
N/A |
|
This view shows connection attributes (key value pairs) for the node. |
Set when the connection is established and remain until the connection is closed. |
|
This view contains information about the results of join optimization operations. |
Tied to in-memory plancache expiration (default setting is 720 minutes) |
|
This view shows all databases in a cluster and their current states. |
N/A |
|
This view contains statistics collected with PROFILE. |
N/A |
|
This view provides the replication status of every replication link on a single node. |
N/A |
|
This table is where the errors are logged when the |
N/A |
|
This view shows internal information on distributed transactions that are currently active in the system. |
N/A |
|
This view provides a high-level summary profile of all tasks which ran recently on any node in the cluster. |
N/A |
|
This view provides a high-level summary profile of completed and currently running tasks on all nodes of the cluster. |
For query activity, it is tied to in-memory plancache expiration (default setting is 720 minutes). However, this is reset on node restart. |
|
This view provides a detailed profile of all tasks which ran recently on any node in the cluster. |
N/A |
|
This view provides a detailed profile of completed and currently running tasks on all nodes of the cluster. |
For query activity, it is tied to in-memory plancache expiration (default setting is 720 minutes). However, this is reset on node restart. |
|
This view provides a summary of |
Tied to in-memory plancache expiration (default setting is 720 minutes) |
|
This view provides the aggregated replication status of each database in the cluster. |
N/A |
|
This view stores information about backups that have been made. |
N/A |
|
This view stores information about the status of ongoing backups. |
Stores entries until CLEAR BACKUP_ |
|
This view stores information about events pertaining to cached blobs. |
Stores the 115,122 most recent events on each node since the last restart |
|
This view shows which queries are waiting, and what they are waiting for. |
N/A |
|
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 |
|
This view provides basic information about all the databases on an unlimited storage cluster. |
N/A |
|
This view gives a breakdown of the remote storage information for each unlimited storage database, both reference and partition. |
N/A |
|
This view gives an overview of all the unlimited storage databases in a cluster, includes the reference databases and the partition databases. |
N/A |
|
This view provides more diagnostic information compared to |
N/A |
|
This view is an at-a-glance rollup table the shows what is happening at the moment with the unlimited storage cluster. |
N/A |
|
This view shows backtrace information for all all nodes in the cluster. |
N/A |
|
This view stores information about currently cached blobs. |
N/A |
|
This view stores information about partitions within a cluster. |
N/A |
|
This view displays the best-effort counter for the number of changes that have been observed for the table partitions over time, and are persisted to disk. |
N/A |
|
This view stores information about indexes used to sort columnstore segments. |
N/A |
|
This view stores information about columnstore files. |
N/A |
|
This view stores information about the status of background_ |
N/A |
|
This view shows connection attributes (key value pairs) for all nodes in the cluster. |
Set when the connection is established and remain until the connection is closed. |
|
Displays the breakdown of disk usage by database. |
N/A |
|
Displays the breakdown of disk usage by SingleStore. |
N/A |
|
This view contains information about the status of databases. |
N/A |
|
This view contains information about events and is useful for monitoring events across clusters over time. |
Stores the 1,028 most recent events |
|
This view provides a detailed profile of completed tasks on all nodes of the cluster. |
Tied to in-memory plancache expiration (default setting is 720 minutes) |
|
This view contains information on the global server status variables that are set on the cluster’s nodes. |
N/A |
|
This view contains information about the global variables that are set on the cluster’s nodes. |
N/A |
|
This view contains information about hosts. |
N/A |
|
This view displays the list of milestones that have been created in the engine. |
N/A |
|
This view describes all SingleStore nodes in the cluster. |
N/A |
|
This view shows plancache information for all nodes in the cluster. |
Tied to in-memory plancache expiration (default setting is 720 minutes) |
|
This view contains information about currently running threads on a cluster for all nodes. |
N/A |
|
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) |
|
This view describes queries seen by SingleStore. |
Tied to in-memory plancache expiration (default setting is 720 minutes) |
|
This view provides a high-level summary profile of all the queries that ran recently in the cluster. |
N/A |
|
This view provides a detailed profile of completed and currently running queries on all nodes of the cluster. |
Tied to in-memory plancache expiration (default setting is 720 minutes) and reset on node restart. |
|
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) |
|
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) |
|
This view contains information about the status of |
N/A |
|
This view includes information about the status of the current recovery process. |
N/A |
|
This view shows the state of orphan partitions (orphans are partition databases that exist on a node but are either detached or not referenced in metadata). |
N/A |
|
This view shows the state of partition instances relevant to the node, which are listed in cluster metadata. |
N/A |
|
This view shows the state of the reference database replica on the node. |
N/A |
|
This view shows the aggregated state of replication management. |
N/A |
|
This view provides the replication status of each replication link in all nodes of the cluster. |
N/A |
|
This view contains information about the status of resource pools. |
N/A |
|
As this view is primarily for internal use, SingleStore recommends using MV_ |
N/A |
|
This view describes the total CPU usage breakdown of SingleStore and other processes per node. |
N/A |
|
This view describes the total CPU usage breakdown of SingleStore and other processes per core. |
N/A |
|
This view describes the total disk usage breakdown of SingleStore and other processes. |
N/A |
|
This view describes the total memory usage breakdown of SingleStore and other processes. |
N/A |
|
This view describes the total network usage by interface. |
N/A |
|
This view provides a detailed profile of all currently running tasks on all nodes of the cluster. |
N/A |
|
Contains distributed transaction metadata. |
A row is created when a distributed transaction prepares on the node to which LMV_ |
|
MV_ |
This view shows an aggregate view of every upgrade the cluster has gone through. |
This information is historical and remains unless intentionally deleted. |
This view contains information about the workload per aggregator. |
N/A |
|
This view contains column statistics calculated on columns when a table is processed by autostats or the |
N/A |
|
This view contains information about parameters. |
N/A |
|
This view stores high-level information about any pipelines that have been created in the cluster. |
N/A |
|
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 |
|
This view contains high-level information about individual batches as they are loaded into the database. |
N/A |
|
This view contains information about a pipeline’s offset ranges. |
N/A |
|
This view contains detailed information about errors that occurred during extraction, transformation, or loading. |
Stores the value set by the engine variable |
|
This view stores information about files that have been extracted from a file system-like data source, such as Amazon S3. |
N/A |
|
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) |
|
This view contains information about projections. |
N/A |
|
This view is deprecated and no longer used. |
N/A |
|
This view contains information about resource pools. |
N/A |
|
This view contains information about resource pool grants and privileges. |
N/A |
|
This view contains information about roles as they relate to privileges in a cluster. |
N/A |
|
This view contains information about routines in a cluster. |
N/A |
|
This view contains information about the privileges in a given cluster. |
N/A |
|
This view contains information about schemas (databases). |
N/A |
|
This view contains information about sites, and is available with SingleStore. |
N/A |
|
This view contains statistics about table indexes. |
N/A |
|
This view contains information about table constraints. |
N/A |
|
This view contains information about tables and their related privileges in a given cluster. |
N/A |
|
This view contains information about table statistics. |
N/A |
|
This view contains information about the tables visible to the current node. |
N/A |
|
This view contains information about the usage telemetry data feature. |
N/A |
|
This view contains information about the users and their related privileges in a given cluster. |
N/A |
|
This view contains information about user defined variables. |
N/A |
|
This view contains information about users for a given cluster. |
N/A |
|
This view contains information about how groups and users are related for a given cluster. |
N/A |
|
This view contains information about the in-memory and on-disk sizes of vector indexes. |
N/a |
|
This view contains information about the views in a cluster. |
N/A |
Unused Tables
Unlisted and unused tables included only for backward compatibility.
Table Name |
---|
COLUMN_ |
EVENTS |
FILES |
PLUGINS |
PROFILING |
REFERENTIAL_ |
TABLESPACES |
TRIGGERS |
Last modified: June 2, 2025