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

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