SingleStore Managed Service

information_schema.COLUMN_STATISTICS

This table 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, child aggregator, or leaf.

PARTITION_TYPE

The type of partition: master or secondary.

MEMORY_USE

The amount of memory, in MB, being used by a given column.

HISTOGRAM

This column exists for MySQL compatibility and is always blank.