Vertica Analytics Platform Version 9.2.x Documentation

STORAGE_CONTAINERS

Monitors information about WOS and ROS storage containers in the database.

* Column values cached for faster query performance
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_TYPE*

VARCHAR

Type of storage container: ROS or WOS.

STORAGE_OID*

INTEGER

Numeric ID assigned by the Vertica catalog, which identifies the storage.

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.

IS_SORTED

BOOLEAN

Whether the storage container's data is sorted (WOS containers only).

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.

Privileges

No explicit privileges are required. You only see the records for tables that you have privileges to view.