# TABLE\_STATISTICS and INTERNAL\_TABLE\_STATISTICS 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 for SingleStore internal metadata tables. This information can be useful for [Detecting and Resolving Data Skew](https://docs.singlestore.com/db/v9.1/create-a-database/detecting-and-resolving-data-skew.md). | Column Name | Description | | ---------------- | ----------------------------------------------------------------------------------------------------------------------------------------- | | `DATABASE_NAME` | The name of the related database. | | `TABLE_NAME` | The name of the related table. | | `ORDINAL` | The partition ID number. | | `HOST` | The hostname or IP address for the related node. | | `PORT` | The port number of the related node. | | `NODE_TYPE` | The type of node: master aggregator (MA), child aggregator (CA), or leaf node (LEAF). | | `PARTITION_TYPE` | The type of partition: master or secondary. | | `ROWS` | The number of rows in a given table and partition. | | `MEMORY_USE` | The memory use, in bytes, of a given table and partition. | | `STORAGE_TYPE` | The[storage type](https://docs.singlestore.com/db/v9.1/create-a-database/choosing-a-table-storage-type.md)of a given table and partition. | | `ROWS_IN_MEMORY` | The number of rows stored in memory for a given table and partition. | | `STORAGE_ID` | Storage Id of the database. | | `COMPUTE_ID` | Compute Id of the database. | ## Metadata Table Listing The following metadata tables can be included in the `INTERNAL_TABLE_STATISTICS.TABLE_NAME` column: | Component | Table Name | Description | | ------------- | --------------------------------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | Columnstore | `md_committed_blobs` | Stores file-level information about columnstore data files. | | Columnstore | `md_gc_blobs` | Stores information about columnstore data files that has been logically deleted. | | Columnstore | `md_columnar_sec_index` | Stores information about on-disk index blobs created for columnstore secondary hash indexes. | | Columnstore | `md_blob_deletion_lsns` | Stores more information about columnstore data files that have been logically deleted. | | Columnstore | `md_columnar_sec_index_is_built` | For each columnstore secondary index added through an alter table statement, stores whether the index has been fully built or not. | | Columnstore | `md_columnar_blobs` | Stores information about all column segments in the columnstore tables. The size of this table is proportional to the total row count and the column count across the columnstore tables. See for more info. | | Columnstore | `md_segments` | Stores information about all row segments in the columnstore tables. The size of this table is proportional to the total row count across the columnstore tables. See[How the Columnstore Works](https://docs.singlestore.com/db/v9.1/create-a-database/columnstore/how-the-columnstore-works.md)for more info. | | Miscellaneous | `md_bottomless_gc_deadlines` | Stores information about unlimited storage GC deadlines used to support the unlimited storage retention period. | | Miscellaneous | `md_partition_instances` | Tracks the states of the database partitions. | | Miscellaneous | `md_logical_partitions` | Stores a mapping from logical partitions to the actual partitions. | | Miscellaneous | `md_queries` | Deprecated. | | Miscellaneous | `md_attributes` | Stores database-level attributes for internal use. | | Miscellaneous | `md_transaction_table` | Tracks the states of ongoing distributed transactions. | | Miscellaneous | `md_transaction_outcome` | Temporarily tracks the outcome of some distributed transactions. | | Miscellaneous | `md_task_queue` | A queue of pending internal maintence tasks. | | Miscellaneous | `md_auto_incr_limit` | For each auto increment column, stores an upper bound of previously generated auto increment values. | | Pipelines | `md_pipeline_transform_templates` | Deprecated. | | Pipelines | `md_pipelines` | For each auto increment column, stores an upper bound of previously generated auto increment values. | | Pipelines | `md_extractors_offsets` | Contains information about a pipeline's offset ranges for every data source partition. That includes files for FS-like data sources, e.g. S3. | | Pipelines | `md_extractors` | Deprecated. | | Pipelines | `md_pipelines_aux_files` | Tracks on-disk files used for storing pipeline errors. It contains information such as file size, number of errors stored in a file, information about a table, pipeline, batches, etc. | | Statistics | `md_range_statistics` | Deprecated. Replaced by`md_advanced_histograms`. | | Statistics | `md_advanced_histograms` | Details all of the histograms that have been built in the cluster. | | Statistics | `md_column_statistics` | Contains the cardinality stats for all user tables. | | User Objects | `md_credentials` | Store the connection links created in the database. | | User Objects | `md_indexes` | Stores the index definition for all tables. | | User Objects | `md_user_aggregate_params` | Lists parameter definitions for each function in`md_user_aggregates`. | | User Objects | `md_indexColumns` | Stores the list of columns contained in each index. | | User Objects | `md_user_aggregates` | Lists all user defined aggregate function definitions. This includes PSQL, external, and Wasm aggregate functions. | | User Objects | `md_foreign_key_columns` | Stores the list of columns contained in each foreign key. | | User Objects | `md_foreign_keys` | Stores the foreign key definition for all tables. | | User Objects | `md_columns` | Stores the column definition for all tables. | | User Objects | `md_user_functions` | Lists all scalar UDF and TVF definitions. This includes PSQL, external, and Wasm functions. | | User Objects | `md_user_object_names` | Lists all routine names from`md_user_functions`and`md_user_aggregates`. | | User Objects | `md_user_function_params` | Lists parameter definitions for each function in`md_user_functions`. | | User Objects | `md_tables` | List all tables in a database. | *** Modified at: July 31, 2025 Source: [/db/v9.1/reference/information-schema-reference/query-performance-workload-management-and-statistics/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/) (An index of the documentation is available at /llms.txt)