Query Performance, Workload Management, and Statistics
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.
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
- AGGREGATE_FUNCTIONS
- COLUMN_STATISTICS
- CORRELATED_COLUMN_STATISTICS
- INDEX_STATISTICS
- LMV_ASYNC_COMPILES
- LMV_CONNECTION_ATTRIBUTES
- LMV_JOIN_OPTIMIZATION_RESULTS
- information_schema.LMV_LOCAL_DATABASES
- LMV_PROFILE_STATS
- MV_ACTIVE_DISTRIBUTED_TRANSACTIONS
- MV_BACKUP_HISTORY
- MV_BACKUP_STATUS
- MV_BT
- MV_CONNECTION_ATTRIBUTES
- MV_PLANCACHE
- MV_PROCESSLIST
- MV_PROSPECTIVE_HISTOGRAMS
- MV_QUERY_PROSPECTIVE_HISTOGRAMS
- MV_WORKLOAD_MANAGEMENT_STATUS
- OPTIMIZER_STATISTICS
- PLANCACHE
- RANGE_STATISTICS
- STATISTICS
- TABLE_STATISTICS and INTERNAL_TABLE_STATISTICS
- USAGE_TELEMETRY_STATUS
- USER_VARIABLES
- VECTOR_INDEX
- WORKLOAD_MANAGEMENT_QUEUE
Last modified: June 2, 2025