COLUMN_STORAGE

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

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 thecolumn.
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.
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 theanchor table.
ANCHOR_TABLE_NAME VARCHAR The associated table name.
ANCHOR_TABLE_SCHEMA VARCHAR

The associated table's schema name.

If the schema belongs to a non-default namespace in an Eon Mode database, the schema name is front-qualified with the name of the schema's namespace. For example, n1.s refers to schema s in namespace n1.

ANCHOR_TABLE_NAMESPACE VARCHAR For Eon Mode databases, name of the namespace that contains the table.
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.