Information Schema View List
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 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. |
Tied to in-memory plancache expiration (default setting is 720 minutes) |
|
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. |
Tied to in-memory plancache expiration (default setting is 720 minutes) |
|
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) |
|
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 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: July 30, 2024