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.

Last modified: December 12, 2023

Was this article helpful?