COLUMN_STORAGE

Returns the amount of disk storage used by each column of each projection on each node. WOS data is stored by row, so per-column byte counts are not available.

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

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

A unique numeric ID assigned by the Vertica catalog, which 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

A unique VARCHAR ID, assigned by the Vertica catalog, that identifies a column in a table.

ANCHOR_TABLE_COLUMN_NAME

VARCHAR

The name of the anchor table.