# COLUMN\_STATISTICS

This view contains information about each column in a given cluster. Each row displays information about a given column on a given database partition.

| Column Name      | Description                                                                                                                                                                                                                                                                                                                                                  |
| ---------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ |
| `DATABASE_NAME`  | The name of the related database.                                                                                                                                                                                                                                                                                                                            |
| `SCHEMA_NAME`    | The name of the related database (this is the same as`DATABASE_NAME`, and exists for MySQL compatibility).                                                                                                                                                                                                                                                   |
| `TABLE_NAME`     | The name of the related table.                                                                                                                                                                                                                                                                                                                               |
| `COLUMN_NAME`    | The name of a given column.                                                                                                                                                                                                                                                                                                                                  |
| `ORDINAL`        | The`ID`for the related partition.                                                                                                                                                                                                                                                                                                                            |
| `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.                                                                                                                                                                                                                                                                                                                  |
| `MEMORY_USE`     | The amount of memory, in MB, being used by a given column. Only applies to fixed-width fields in rowstore tables, otherwise it will be reported as NULL.For columnstore, use the TABLE\_STATISTICS view to see how much memory (RAM) the table is using. This will include all columns as there is no per-column memory use tracking for columnstore tables. |
| `HISTOGRAM`      | This column exists for MySQL compatibility and is always blank.                                                                                                                                                                                                                                                                                              |

***

Modified at: December 12, 2023

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

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