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?