STORAGE_CONTAINERS

Monitors information about Vertica storage containers.

Monitors information about Vertica storage containers.

Column Name Data Type Description
NODE_NAME* VARCHAR Node name for which information is listed.
SCHEMA_NAME* VARCHAR Schema name for which information is listed.
PROJECTION_ID* INTEGER Unique numeric ID assigned by the Vertica catalog, which identifies the projection.
PROJECTION_NAME* VARCHAR Projection name for which information is listed on that node.
STORAGE_OID* INTEGER Numeric ID assigned by the Vertica catalog, which identifies the storage. The same OID can appear on more than one node.
SAL_STORAGE_ID VARCHAR Unique hexadecimal numeric ID assigned by the Vertica catalog, which identifies the storage.
TOTAL_ROW_COUNT* VARCHAR Total rows in the storage container listed for that projection.
DELETED_ROW_COUNT* INTEGER Total rows in the storage container deleted for that projection.
USED_BYTES* INTEGER Total bytes in the storage container listed for that projection.
START_EPOCH* INTEGER Number of the start epoch in the storage container for which information is listed.
END_EPOCH* INTEGER Number of the end epoch in the storage container for which information is listed.
GROUPING VARCHAR

The group by which columns are stored:

  • ALL: All columns are grouped

  • PROJECTION: Columns grouped according to projection definition

  • NONE: No columns grouped, despite grouping in the projection definition

  • OTHER: Some grouping but neither all nor according to projection (e.g., results from add column)

SEGMENT_LOWER_BOUND INTEGER Lower bound of the segment range spanned by the storage container or NULL if the corresponding projection is not elastic.
SEGMENT_UPPER_BOUND INTEGER Upper bound of the segment range spanned by the storage container or NULL if the corresponding projection is not elastic.
LOCATION_LABEL VARCHAR (128) The location label (if any) for the storage container is stored.
DELETE_VECTOR_COUNT INTEGER The number of delete vectors in the storage container.
SHARD_ID INTEGER Set only for an Eon Mode database, ID of the shard that this container belongs to.
SHARD_NAME VARCHAR(128) Set only for an Eon Mode database, name of the shard that this container belongs to.

* Column values cached for faster query performance

Privileges

Non-superuser: No explicit privileges required. You only see records for tables that you have privileges to view.