# Information Schema View List Here is an alphabetical list of all the `information_schema` views that SingleStore supports. Data retention value listed as "N/A" means the view returns applicable data in the current state of the cluster. There are some additional, unused tables that are included purely for backward compatibility with MySQL, listed [here](https://docs.singlestore.com/#section-idm4576386560755233723333816108.md). | Table Name | Table Description | Data Retention | | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | [ADVANCED\_HISTOGRAMS](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/query-performance-workload-management-and-statistics/advanced-histograms.md) | This view contains information about histograms that have been collected by automatic statistics or using`ANALYZE`. | N/A | | [AGGREGATE\_FUNCTIONS](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/query-performance-workload-management-and-statistics/aggregate-functions.md) | This view contains information about user defined aggregate functions (UDAF). | N/A | | [AGGREGATORS](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/cluster-component/aggregators.md) | This view contains information about aggregators. It is useful for understanding the number and attributes of the aggregators for a givencluster. | N/A | | [AVAILABILITY\_GROUPS](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/resource-and-user-management/availability-groups.md) | This view contains information about[availability groups](https://docs.singlestore.com/db/v9.1/introduction/distributed-architecture/high-availability.md). | N/A | | [CHARACTER\_SETS](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/cluster-component/character-sets.md) | This view stores information about available character sets. | N/A | | [COLLATION\_CHARACTER\_SET\_APPLICABILITY](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/cluster-component/collation-character-set-applicability.md) | This view stores information about the available collations for each character set. | N/A | | [COLLATIONS](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/cluster-component/collations.md) | This view stores information about collations for each character set. | N/A | | [COLUMN\_STATISTICS](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/query-performance-workload-management-and-statistics/column-statistics.md) | This view contains information about each column in a givencluster. Each row displays information about a given column on a given database partition. | N/A | | [COLUMNAR\_SEGMENTS](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/segment-column-and-merge-status/columnar-segments.md) | This view stores information about each`columnar_segment`([column segment](https://docs.singlestore.com/db/v9.1/create-a-database/columnstore.md)). | N/A | | [COLUMNS](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/cluster-component/columns.md) | This view stores information about each column. | N/A | | [CORRELATED\_COLUMN\_STATISTICS](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/query-performance-workload-management-and-statistics/correlated-column-statistics.md) | This view contains information about correlated columns. | The column correlation data is based on metadata rows that are persisted within the user database. The lifetime of these rows is tied to the referenced user objects -- when those objects are dropped or deleted, the rows referencing those objects are dropped from the correlation view. | | [CROSS\_QUERY\_STATS\_CACHE](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/query-performance-workload-management-and-statistics/cross-query-stats-cache.md) | This view contains metadata about cross query stats cache entries for the connected aggregator. | Tied to the`cross_query_stats_expiration_minutes`engine variable (default setting is 720 minutes). | | [CURRENT\_USER\_GROUPS](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/resource-and-user-management/current-user-groups.md) | This view contains information about the group(s) the current user belongs to. | N/A | | [CURRENT\_USER\_ROLES](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/resource-and-user-management/current-user-roles.md) | This view contains information about the role(s) of the current user. | N/A | | [DISTRIBUTED\_DATABASES](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/cluster-component/distributed-databases.md) | This view contains information about databases. | N/A | | [DISTRIBUTED\_DATABASES\_ON\_SITES](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/cluster-component/distributed-databases-on-sites.md) | This view contains information about how databases are distributed acrossclusters. | N/A | | [DISTRIBUTED\_PARTITIONS](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/cluster-component/distributed-partitions.md) | This view contains information about partitions. | N/A | | [GROUPS](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/resource-and-user-management/groups.md) | This view contains information about user groups in the database. | N/A | | [GROUP\_PRIVILEGES](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/resource-and-user-management/group-privileges.md) | This view contains information about privileges as they relate to the roles and groups they are associated with. | N/A | | [GROUPS\_ROLES](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/resource-and-user-management/groups-roles.md) | This view contains information about groups and the roles that are part of them. | N/A | | [IND\_CS\_PARTITION\_ROW\_SEGMENT\_GROUPS](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/segment-column-and-merge-status/ind-cs-partition-row-segment-groups.md) | This view store information about groups of row segments that are sorted together. | N/A | | [INDEX\_STATISTICS](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/query-performance-workload-management-and-statistics/index-statistics.md) | This view contains statistics about indexes. Each row displays information about a given index on a given database partition. | N/A | | [JSON\_COLUMN\_SCHEMA](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/segment-column-and-merge-status/json-column-schema.md) | This view contains information about the schema inferred for JSON columns in columnstore tables. | N/A | | [KEY\_COLUMN\_USAGE](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/segment-column-and-merge-status/key-column-usage.md) | 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](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/cluster-component/leaves.md) | This view contains information about leaves. | N/A | | [LINKS](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/resource-and-user-management/links.md) | This view contains information about connection links. | N/A | | [LMV\_COLUMNSTORE\_ACTIVE\_MERGE\_PLANS](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/segment-column-and-merge-status/lmv-columnstore-active-merge-plans.md) | This view contains information about merge plans that are running on the current node. | N/A | | [LMV\_ASYNC\_COMPILES](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/query-performance-workload-management-and-statistics/lmv-async-compiles.md) | This view shows the queries being compiled. | N/A | | [LMV\_CONNECTION\_ATTRIBUTES](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/query-performance-workload-management-and-statistics/lmv-connection-attributes.md) | This view shows connection attributes (key value pairs) for the node. | Set when the connection is established and remain until the connection is closed. | | [LMV\_GLOBAL\_COUNTERS](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/management/lmv-global-counters.md) | This view shows cumulative global metrics for the current node.For example, one metric provides information about the amount of work performed by the merger on the current node. | N/A | | [LMV\_JOIN\_OPTIMIZATION\_RESULTS](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/query-performance-workload-management-and-statistics/lmv-join-optimization-results.md) | 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\_LOCAL\_DATABASES](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/query-performance-workload-management-and-statistics/lmv-local-databases.md) | This view shows all databases in a cluster and their current states. | N/A | | [LMV\_PROFILE\_STATS](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/query-performance-workload-management-and-statistics/lmv-profile-stats.md) | This view contains statistics collected with[PROFILE](https://docs.singlestore.com/db/v9.1/reference/sql-reference/data-manipulation-language-dml/profile.md). The table shows only the`PROFILE`from the last query instance of a given activity. | N/A | | [LMV\_REPLICATION\_STATUS](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/replication-management/lmv-replication-status.md) | This view provides the replication status of every replication link on a single node. This view can be accessed from any node in thecluster. | N/A | | [LMV\_TABLE\_COUNTERS](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/management/lmv-table-counters.md) | This view shows cumulative per-table metrics for the current node.For example, one metric provides information about the amount of work performed by the merger on a specific table on the current node. | N/A | | [LOAD\_DATA\_ERRORS](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/data-ingest/load-data-errors.md) | This table is where the errors are logged when the`LOAD DATA`command is used with the`ERRORS HANDLE`clause. | N/A | | [MV\_ACTIVE\_DISTRIBUTED\_TRANSACTIONS](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/query-performance-workload-management-and-statistics/mv-active-distributed-transactions.md) | This view shows internal information on distributed transactions that are currently active in the system. | N/A | | [MV\_ACTIVITIES](https://docs.singlestore.com/db/v9.1/query-data/query-tuning/workload-profiling/mv-activities.md) | This view provides a high-level summary profile of all tasks which ran*recently*on any node in thecluster. | N/A | | [MV\_ACTIVITIES\_CUMULATIVE](https://docs.singlestore.com/db/v9.1/query-data/query-tuning/workload-profiling/mv-activities-cumulative.md) | This view provides a high-level summary profile of completed and currently running tasks on all nodes of thecluster. | For query activity, it is tied to in-memory plancache expiration (default setting is 720 minutes). For database activity, it is tied to the lifetime of the database.However, this is reset on node restart. | | [MV\_ACTIVITIES\_EXTENDED](https://docs.singlestore.com/db/v9.1/query-data/query-tuning/workload-profiling/mv-activities-extended.md) | This view provides a detailed profile of all tasks which ran recently on any node in thecluster. | N/A | | [MV\_ACTIVITIES\_EXTENDED\_CUMULATIVE](https://docs.singlestore.com/db/v9.1/query-data/query-tuning/workload-profiling/mv-activities-extended-cumulative.md) | This view provides a detailed profile of completed and currently running tasks on all nodes of thecluster. | For query activity, it is tied to in-memory plancache expiration (default setting is 720 minutes). For database activity, it is tied to the lifetime of the database.However, this is reset on node restart. | | [MV\_AGGREGATED\_COLUMN\_USAGE](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/management/mv-aggregated-column-usage.md) | 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](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/management/mv-aggregated-replication-status.md) | This view provides the aggregated replication status of each database in thecluster. | N/A | | [MV\_BACKUP\_HISTORY](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/query-performance-workload-management-and-statistics/mv-backup-history.md) | This view stores information about backups that have been made. | N/A | | [MV\_BACKUP\_STATUS](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/query-performance-workload-management-and-statistics/mv-backup-status.md) | This view stores information about the status of ongoing backups. | Stores entries until[CLEAR BACKUP\_HISTORY](https://docs.singlestore.com/db/v9.1/manage-data/back-up-and-restore-data/types-of-backups/clearing-backup-history.md)command is executed | | [MV\_BLOB\_CACHE\_EVENTS](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/cluster-component/mv-blob-cache-events.md) | 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](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/management/mv-blocked-queries.md) | This view shows which queries are waiting, and what they are waiting for. It can be used to help debug unexpected waiting issues. | N/A | | [MV\_BOTTOMLESS\_API\_EVENTS](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/unlimited-storage/mv-bottomless-api-events.md) | 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\_DATABASES](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/unlimited-storage/mv-bottomless-databases.md) | This view provides basic information about all the databases on an unlimited storage cluster. It includes databases currently attached on the cluster. | N/A | | [MV\_BOTTOMLESS\_REMOTE\_STATS](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/unlimited-storage/mv-bottomless-remote-stats.md) | This view gives a breakdown of the remote storage information for each unlimited storage database, both reference and partition. | N/A | | [MV\_BOTTOMLESS\_STATUS](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/unlimited-storage/mv-bottomless-status.md) | This view gives an overview of all the unlimited storage databases in acluster, includes the reference databases and the partition databases. | N/A | | [MV\_BOTTOMLESS\_STATUS\_EXTENDED](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/unlimited-storage/mv-bottomless-status-extended.md) | 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\_SUMMARY](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/unlimited-storage/mv-bottomless-summary.md) | This view is an at-a-glance rollup table the shows what is happening at the moment with the unlimited storagecluster. | N/A | | [MV\_BT](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/query-performance-workload-management-and-statistics/mv-bt.md) | This view shows backtrace information for all all nodes in thecluster. This is primarily used by SingleStore Customer Support. | N/A | | [MV\_CACHED\_BLOBS](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/cluster-component/mv-cached-blobs.md) | This view stores information about currently cached blobs. | N/A | | [MV\_CLUSTER\_STATUS](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/cluster-component/mv-cluster-status.md) | This view stores information about partitions within acluster. | N/A | | [MV\_COLLECTED\_ROW\_CHANGE\_COUNTS](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/management/mv-collected-row-change-counts.md) | 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 | | [MV\_COLUMNAR\_SEGMENT\_INDEX](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/segment-column-and-merge-status/mv-columnar-segment-index.md) | This view stores information about indexes used to sort columnstore segments. | N/A | | [MV\_COLUMNSTORE\_ACTIVE\_MERGE\_PLANS](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/segment-column-and-merge-status/mv-columnstore-active-merge-plans.md) | This view contains information about merge plans that are running. | N/A | | [MV\_COLUMNSTORE\_FILES](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/segment-column-and-merge-status/mv-columnstore-files.md) | This view stores information about columnstore files. | N/A | | [MV\_COLUMNSTORE\_MERGE\_STATUS](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/segment-column-and-merge-status/mv-columnstore-merge-status.md) | This view stores information about the status of[background\_merger](https://docs.singlestore.com/db/v9.1/create-a-database/columnstore.md)processes for columnstore tables. | N/A | | [MV\_CONNECTION\_ATTRIBUTES](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/query-performance-workload-management-and-statistics/mv-connection-attributes.md) | This view shows connection attributes (key value pairs) for all nodes in thecluster. | Set when the connection is established and remain until the connection is closed. | | [MV\_CROSS\_QUERY\_STATS\_CACHE](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/query-performance-workload-management-and-statistics/mv-cross-query-stats-cache.md) | This view is a managed view that aggregates cross-query stats cache entries across all aggregators in the cluster. Use this view to get a cluster‑wide picture of cache utilization and distribution. | Tied to the`cross_query_stats_expiration_minutes`engine variable (default setting is 720 minutes). | | [MV\_DATA\_DISK\_USAGE](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/management/mv-data-disk-usage.md) | Displays the breakdown of disk usage by database. | N/A | | [MV\_DISK\_USAGE](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/management/mv-disk-usage.md) | Displays the breakdown of disk usage bySingleStore. | N/A | | [MV\_DISTRIBUTED\_DATABASES\_STATUS](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/cluster-component/mv-distributed-databases-status.md) | This view contains information about the status of databases. | N/A | | [MV\_EVENTS](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/cluster-component/mv-events.md) | This view contains information about events and is useful for monitoring events acrossclusters over time. | Stores the 1,028 most recent events | | [MV\_FINISHED\_TASKS](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/management/mv-finished-tasks.md) | This view provides a detailed profile of completed tasks on all nodes of thecluster. | Tied to in-memory plancache expiration (default setting is 720 minutes) | | [MV\_FULLTEXT\_INDEXES](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/query-performance-workload-management-and-statistics/mv-fulltext-indexes.md) | This view contains segment-level information about full-text indexes for all tables and all databases in thecluster. | N/A | | [MV\_FULLTEXT\_INDEX\_STATUS](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/query-performance-workload-management-and-statistics/mv-fulltext-index-status.md) | This view contains partition-level information about the status of full-text indexes for all tables and all databases in thecluster. | N/A | | [MV\_GLOBAL\_COUNTERS](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/management/mv-global-counters.md) | This view shows cumulative global per-node metrics.For example, one metric provides information about the amount of work performed by the merger on a specific node. | N/A | | [MV\_GLOBAL\_STATUS](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/management/mv-global-status.md) | This view contains information on the global server status variables that are set on thecluster’s nodes. | N/A | | [MV\_GLOBAL\_VARIABLES](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/management/mv-global-variables.md) | This view contains information about the global variables that are set on thecluster’s nodes. | N/A | | [MV\_HOSTS\_INFORMATION](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/cluster-component/mv-hosts-information.md) | This view contains information about hosts. | N/A | | [MV\_MEMORY\_USAGE](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/query-performance-workload-management-and-statistics/mv-memory-usage.md) | This view contains memory usage information that can be used to query specific memory usage types and identify the most significant memory consumers (processes, queries, or rowstore tables). | N/A | | [MV\_MILESTONES](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/unlimited-storage/mv-milestones.md) | 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](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/management/mv-nodes.md) | This view describes allSingleStorenodes in thecluster. | N/A | | [MV\_PLANCACHE](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/query-performance-workload-management-and-statistics/mv-plancache.md) | This view shows plancache information for all nodes in thecluster. | Tied to in-memory plancache expiration (default setting is 720 minutes) | | [MV\_PROCESSLIST](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/query-performance-workload-management-and-statistics/mv-processlist.md) | This view contains information about currently running threads on aclusterfor all nodes. | N/A | | [MV\_PROSPECTIVE\_HISTOGRAMS](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/query-performance-workload-management-and-statistics/mv-prospective-histograms.md) | 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](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/management/mv-queries.md) | This view describes queries seen bySingleStore. | Tied to in-memory plancache expiration (default setting is 720 minutes) | | [MV\_QUERY\_ACTIVITIES](https://docs.singlestore.com/db/v9.1/query-data/query-tuning/workload-profiling/mv-query-activities.md) | This view provides a high-level summary profile of all the queries that ran recently in thecluster. | N/A | | [MV\_QUERY\_ACTIVITIES\_EXTENDED\_CUMULATIVE](https://docs.singlestore.com/db/v9.1/query-data/query-tuning/workload-profiling/mv-query-activities-extended-cumulative.md) | This view provides a detailed profile of completed and currently running queries on all nodes of thecluster. It holds a row per query. | Tied to in-memory plancache expiration (default setting is 720 minutes) and reset on node restart. | | [MV\_QUERY\_COLUMN\_USAGE](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/management/mv-query-column-usage.md) | 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](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/query-performance-workload-management-and-statistics/mv-query-prospective-histograms.md) | 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](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/segment-column-and-merge-status/mv-rebalance-status.md) | This view contains information about the status of`REBALANCE`commands such as[REBALANCE ALL DATABASES](https://docs.singlestore.com/db/v9.1/reference/sql-reference/cluster-management-commands/rebalance-all-databases.md)and[REBALANCE PARTITIONS](https://docs.singlestore.com/db/v9.1/reference/sql-reference/cluster-management-commands/rebalance-partitions.md). | N/A | | [MV\_RECOVERY\_STATUS](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/backup-and-restore/mv-recovery-status.md) | This view includes information about the status of the current recovery process. | N/A | | [MV\_­REPLICATION\_­MANAGEMENT\_­ORPHANS\_­STATE](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/replication-management/mv-replication-management-orphans-state.md) | 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 | | [MV\_­REPLICATION\_­MANAGEMENT\_­PARTITIONS\_­STATE](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/replication-management/mv-replication-management-partitions-state.md) | This view shows the state of partition instances relevant to the node, which are listed in cluster metadata. | N/A | | [MV\_­REPLICATION\_­MANAGEMENT\_­REF\_DB\_­STATE](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/replication-management/mv-replication-management-ref-db-state.md) | This view shows the state of the reference database replica on the node. | N/A | | [MV\_­REPLICATION\_­MANAGEMENT\_­STATE](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/replication-management/mv-replication-management-state.md) | This view shows the aggregated state of replication management. | N/A | | [MV\_REPLICATION\_STATUS](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/replication-management/mv-replication-status.md) | This view provides the replication status of each replication link in all nodes of thecluster. | N/A | | [MV\_RESOURCE\_POOL\_STATUS](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/resource-and-user-management/mv-resource-pool-status.md) | This view contains information about the status of resource pools aggregating this information across all nodes in the cluster. | N/A | | [MV\_ROW\_CHANGE\_COUNTS](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/management/mv-row-change-counts.md) | As this view is primarily for internal use, SingleStore recommends using[MV\_COLLECTED\_ROW\_CHANGE\_COUNTS](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/management/mv-collected-row-change-counts.md)instead. | N/A | | [MV\_SYSINFO\_CPU](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/management/mv-sysinfo-cpu.md) | This view describes the total CPU usage breakdown ofSingleStoreand other processes per node. | N/A | | [MV\_SYSINFO\_CPULIST](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/management/mv-sysinfo-cpulist.md) | This view describes the total CPU usage breakdown ofSingleStoreand other processes per core. | N/A | | [MV\_SYSINFO\_DISK](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/management/mv-sysinfo-disk.md) | This view describes the total disk usage breakdown ofSingleStoreand other processes. | N/A | | [MV\_SYSINFO\_MEM](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/management/mv-sysinfo-mem.md) | This view describes the total memory usage breakdown ofSingleStoreand other processes. | N/A | | [MV\_SYSINFO\_NET](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/management/mv-sysinfo-net.md) | This view describes the total network usage by interface. | N/A | | [MV\_TABLE\_COUNTERS](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/management/mv-table-counters.md) | This view shows cumulative per-table, per-node metrics.For example, one metric provides information about the amount of work performed by the merger for a specific table on a specific node. | N/A | | [MV\_TASKS](https://docs.singlestore.com/db/v9.1/query-data/query-tuning/workload-profiling/mv-tasks.md) | This view provides a detailed profile of all currently running tasks on all nodes of thecluster. | N/A | | [MV\_TRANSACTION\_TABLE](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/cluster-component/mv-transaction-table.md) | 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. | | [MV\_VERSION\_HISTORY](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/management/mv-version-history.md)(and lmv\_version\_history\_extended) | This view shows an aggregate view of every upgrade theclusterhas gone through. | This information is historical and remains unless intentionally deleted. | | [MV\_WORKLOAD\_MANAGEMENT\_STATUS](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/query-performance-workload-management-and-statistics/mv-workload-management-status.md) | 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](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/query-performance-workload-management-and-statistics/optimizer-statistics.md) | This view contains[column statistics](https://docs.singlestore.com/db/v9.1/query-data/query-tuning/statistics-and-sampling/statistics-and-sampling-tasks.md)calculated on columns when a table is processed by autostats or the`ANALYZE`command. | N/A | | [PARAMETERS](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/cluster-component/parameters.md) | This view contains information about parameters. | N/A | | [PIPELINES](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/data-ingest/pipelines.md) | This view stores high-level information about any pipelines that have been created in thecluster. Each row represents a single pipeline. | N/A | | [PIPELINES\_BATCHES](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/data-ingest/pipelines-batches.md) | 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 METADATA](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/data-ingest/pipelines-batches-metadata.md) | This view contains metadata about individual batches as they are loaded into the database. It includes information that provides batch-level tracking details. | N/A | | | | | | [PIPELINES\_BATCHES\_SUMMARY](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/data-ingest/pipelines-batches-summary.md) | 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](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/data-ingest/pipelines-cursors.md) | This view contains information about a pipeline’s offset ranges. Each row represents a single data source partition. | N/A | | [PIPELINES\_ERRORS](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/data-ingest/pipelines-errors.md) | 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](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/data-ingest/pipelines-files.md) | 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 | | [PIPELINES\_ICEBERG\_FILES](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/data-ingest/pipelines-iceberg-files.md) | This view stores information about Iceberg data files ingested using pipelines with[`FORMAT ICEBERG`](https://docs.singlestore.com/db/v9.1/load-data/data-sources/iceberg-ingest.md). | N/A | | [PLANCACHE](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/query-performance-workload-management-and-statistics/plancache.md) | This view contains information about all query statements thatSingleStorehas 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) | | [PROJECTIONS](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/cluster-component/projections.md) | This view contains information about projections. | N/A | | [RANGE\_STATISTICS](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/query-performance-workload-management-and-statistics/range-statistics.md) | 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](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/resource-and-user-management/resource-pools.md) | This view contains information about resource pools. | N/A | | [RESOURCE\_POOL\_PRIVILEGES](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/resource-and-user-management/resource-pool-privileges.md) | This view contains information about resource pool grants and privileges. | N/A | | [ROLES](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/resource-and-user-management/roles.md) | This view is a list of all roles and their properties related to audit permissions or security compliance. | N/A | | [ROLE\_PRIVILEGES](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/resource-and-user-management/role-privileges.md) | This view contains information about roles as they relate to privileges in acluster. | N/A | | [ROUTINES](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/cluster-component/routines.md) | This view contains information about routines in acluster. | N/A | | [SCHEMA\_PRIVILEGES](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/resource-and-user-management/schema-privileges.md) | This view contains information about the privileges in a givencluster. | N/A | | [SCHEMATA](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/cluster-component/schemata.md) | This view contains information about schemas (databases). | N/A | | [SITES](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/cluster-component/sites.md) | This view contains information about sites, and is available withSingleStore. | N/A | | [STATISTICS](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/query-performance-workload-management-and-statistics/statistics.md) | This view contains statistics about table indexes. It displays one row per column per index. | N/A | | [TABLE\_CONSTRAINTS](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/cluster-component/table-constraints.md) | This view contains information about table constraints. | N/A | | [TABLE\_PRIVILEGES](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/resource-and-user-management/table-privileges.md) | This view contains information about tables and their related privileges in a givencluster. | N/A | | [TABLE\_STATISTICS / INTERNAL\_TABLE\_STATISTICS](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/query-performance-workload-management-and-statistics/table-statistics-and-internal-table-statistics.md) | This view contains information about table statistics. It contains one row per table, per partition.`INTERNAL_TABLE_STATICS`(an internal use-only table added in v7.8) contains the same columns, and shows information forSingleStoreinternal metadata tables. | N/A | | [TABLES](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/cluster-component/tables.md) | This view contains information about the tables visible to the current node. | N/A | | [USAGE\_TELEMETRY\_STATUS](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/query-performance-workload-management-and-statistics/usage-telemetry-status.md) | This view contains information about the usage telemetry data feature. | N/A | | [USER\_PRIVILEGES](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/resource-and-user-management/user-privileges.md) | This view contains information about the users and their related privileges in a givencluster. | N/A | | [USER\_VARIABLES](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/query-performance-workload-management-and-statistics/user-variables.md) | This view contains information about user defined variables. See more about how to define these in[User-Defined Variables](https://docs.singlestore.com/db/v9.1/reference/sql-reference/user-defined-variables.md). | N/A | | [USERS](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/resource-and-user-management/users.md) | This view contains information about users for a givencluster. | N/A | | [USERS\_GROUPS](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/resource-and-user-management/users-groups.md) | This view contains information about how groups and users are related for a givencluster. | N/A | | [VECTOR\_INDEX](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/query-performance-workload-management-and-statistics/vector-index.md) | This view contains information about the in-memory and on-disk sizes of[vector indexes](https://docs.singlestore.com/db/v9.1/reference/sql-reference/vector-functions/vector-indexing.md). | N/a | | [VIEWS](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/cluster-component/views.md) | This view contains information about the views in acluster. | N/A | ## Unused Tables Unlisted and unused tables included only for backward compatibility. | Table Name | | ------------------------ | | COLUMN\_PRIVILEGES | | EVENTS | | FILES | | PLUGINS | | PROFILING | | REFERENTIAL\_CONSTRAINTS | | TABLESPACES | | TRIGGERS | *** Modified at: May 11, 2026 Source: [/db/v9.1/reference/information-schema-reference/information-schema-view-list/](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/information-schema-view-list/) (An index of the documentation is available at /llms.txt)