COLUMN_STORAGE

Returns the amount of disk storage used by each column of each projection on each node.

Column Name Data Type Description
NODE_NAME

VARCHAR

The node name for which information is listed.

COLUMN_ID

INTEGER

Catalog-assigned integer value that uniquely identifies the column.

COLUMN_NAME

VARCHAR

The column name for which information is listed.

ROW_COUNT

INTEGER

The number of rows in the column.

USED_BYTES

INTEGER

The disk storage allocation of the column in bytes.

ENCODINGS

VARCHAR

The encoding type for the column.

COMPRESSION

VARCHAR

The compression type for the column. You can compare ENCODINGS and COMPRESSION columns to see how different encoding types affect column storage when optimizing for compression.

WOS_ROW_COUNT

INTEGER

(Deprecated) The number of WOS rows in the column.

ROS_ROW_COUNT

INTEGER

The number of ROS rows in the column.

ROS_USED_BYTES

INTEGER

The number of ROS bytes in the column.

ROS_COUNT

INTEGER

The number of ROS containers.

PROJECTION_ID

INTEGER

Catalog-assigned numeric value that uniquely identifies the projection.

PROJECTION_NAME

VARCHAR

The associated projection name for the column.

PROJECTION_SCHEMA

VARCHAR

The name of the schema associated with the projection.

ANCHOR_TABLE_ID

INTEGER

Catalog-assigned integer value that uniquely identifies the anchor table.

ANCHOR_TABLE_NAME

VARCHAR

The associated table name.

ANCHOR_TABLE_SCHEMA

VARCHAR

The associated table's schema name.

ANCHOR_TABLE_COLUMN_ID

VARCHAR

Catalog-assigned VARCHAR value that uniquely identifies a table column.

ANCHOR_TABLE_COLUMN_NAME

VARCHAR

The name of the anchor table.