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 |
---|---|---|
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. It is useful for understanding the number and attributes of the aggregators for a given cluster. | 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. Each row displays information about a given column on a given database partition. | N/A | |
This view stores information about each | N/A | |
This view stores information about each column. | N/A | |
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. Each row displays information about a given index on a given database partition. | 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 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) | |
This view shows all databases in a cluster and their current states. | N/A | |
This view contains statistics collected with PROFILE. The table shows only the | N/A | |
This view provides the replication status of every replication link on a single node. This view can be accessed from any node in the cluster. | 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_HISTORY command is executed | |
This view provides the aggregated replication status of each database in the cluster. | 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 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_merger processes for columnstore tables. | 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 describes all SingleStoreDB nodes in the cluster. | N/A | |
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 SingleStoreDB. | 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. It holds a row per query. | 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 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 | |
This view is primarily for internal use, we recommend using MV_COLLECTED_ROW_CHANGE_COUNTS instead. | N/A | |
This view describes the total CPU usage breakdown of SingleStoreDB and other processes per node. | N/A | |
This view describes the total CPU usage breakdown of SingleStoreDB and other processes per core. | N/A | |
This view describes the total disk usage breakdown of SingleStoreDB and other processes. | N/A | |
This view describes the total memory usage breakdown of SingleStoreDB 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_TRANSACTION_TABLE belongs. The row is deleted when all the nodes that participated in that distributed transaction are aware of that distributed transaction's outcome. | |
This view contains information about the workload per aggregator. The statistics available in the | 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. Each row represents a single pipeline. | 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. It contains one row per batch. | N/A | |
This view contains information about a pipeline’s offset ranges. Each row represents a single data source partition. | N/A | |
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 | |
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 | |
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 is deprecated and no longer used. This table previously contained information about legacy histograms that have been collected using | N/A | |
This view contains information about resource pools. | 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 SingleStoreDB. | N/A | |
This view contains statistics about table indexes. It displays one row per column per index. | 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. It contains one row per table, per partition. | N/A | |
This view contains information about the tables visible to the current node. | 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. See more about how to define these in 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 |