# Query Performance, Workload Management, and Statistics

This section includes information schema views that contain statistics and other data which are useful for monitoring and improving query performance, as well as managing the workload of a cluster.

## In this section

* [ADVANCED\_HISTOGRAMS](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/query-performance-workload-management-and-statistics/advanced-histograms.md)
* [AGGREGATE\_FUNCTIONS](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/query-performance-workload-management-and-statistics/aggregate-functions.md)
* [COLUMN\_STATISTICS](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/query-performance-workload-management-and-statistics/column-statistics.md)
* [CORRELATED\_COLUMN\_STATISTICS](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/query-performance-workload-management-and-statistics/correlated-column-statistics.md)
* [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)
* [INDEX\_STATISTICS](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/query-performance-workload-management-and-statistics/index-statistics.md)
* [LMV\_ASYNC\_COMPILES](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/query-performance-workload-management-and-statistics/lmv-async-compiles.md)
* [LMV\_CONNECTION\_ATTRIBUTES](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/query-performance-workload-management-and-statistics/lmv-connection-attributes.md)
* [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)
* [LMV\_LOCAL\_DATABASES](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/query-performance-workload-management-and-statistics/lmv-local-databases.md)
* [LMV\_PROFILE\_STATS](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/query-performance-workload-management-and-statistics/lmv-profile-stats.md)
* [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)
* [MV\_BACKUP\_HISTORY](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/query-performance-workload-management-and-statistics/mv-backup-history.md)
* [MV\_BACKUP\_STATUS](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/query-performance-workload-management-and-statistics/mv-backup-status.md)
* [MV\_BT](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/query-performance-workload-management-and-statistics/mv-bt.md)
* [MV\_CONNECTION\_ATTRIBUTES](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/query-performance-workload-management-and-statistics/mv-connection-attributes.md)
* [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)
* [MV\_FULLTEXT\_INDEXES](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/query-performance-workload-management-and-statistics/mv-fulltext-indexes.md)
* [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)
* [MV\_MEMORY\_USAGE](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/query-performance-workload-management-and-statistics/mv-memory-usage.md)
* [MV\_PLANCACHE](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/query-performance-workload-management-and-statistics/mv-plancache.md)
* [MV\_PROCESSLIST](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/query-performance-workload-management-and-statistics/mv-processlist.md)
* [MV\_PROSPECTIVE\_HISTOGRAMS](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/query-performance-workload-management-and-statistics/mv-prospective-histograms.md)
* [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)
* [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)
* [OPTIMIZER\_STATISTICS](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/query-performance-workload-management-and-statistics/optimizer-statistics.md)
* [PLANCACHE](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/query-performance-workload-management-and-statistics/plancache.md)
* [RANGE\_STATISTICS](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/query-performance-workload-management-and-statistics/range-statistics.md)
* [STATISTICS](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/query-performance-workload-management-and-statistics/statistics.md)
* [TABLE\_STATISTICS and 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)
* [USAGE\_TELEMETRY\_STATUS](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/query-performance-workload-management-and-statistics/usage-telemetry-status.md)
* [USER\_VARIABLES](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/query-performance-workload-management-and-statistics/user-variables.md)
* [VECTOR\_INDEX](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/query-performance-workload-management-and-statistics/vector-index.md)
* [WORKLOAD\_MANAGEMENT\_QUEUE](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/query-performance-workload-management-and-statistics/workload-management-queue.md)

***

Modified at: March 9, 2026

Source: [/db/v9.1/reference/information-schema-reference/query-performance-workload-management-and-statistics/](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/query-performance-workload-management-and-statistics/)

(An index of the documentation is available at /llms.txt)