PARTITIONS

Displays partition metadata, one row per partition key, per ROS container.

Displays partition metadata, one row per partition key, per ROS container.

Column Name Data Type Description
PARTITION_KEY VARCHAR The partition value(s).
PROJECTION_ID INTEGER Unique numeric ID assigned by the Vertica catalog, which identifies the projection.
TABLE_SCHEMA VARCHAR The schema name for which information is listed.
PROJECTION_NAME VARCHAR The projection name for which information is listed.
ROS_ID VARCHAR A unique numeric ID assigned by the Vertica catalog, which identifies the ROS container.
ROS_SIZE_BYTES INTEGER The ROS container size in bytes.
ROS_ROW_COUNT INTEGER Number of rows in the ROS container.
NODE_NAME VARCHAR Node where the ROS container resides.
DELETED_ROW_COUNT INTEGER The number of deleted rows in the partition.
LOCATION_LABEL VARCHAR The location label of the default storage location.

Notes

  • A many-to-many relationship exists between partitions and ROS containers. PARTITIONS displays information in a denormalized fashion.

  • To find the number of ROS containers having data of a specific partition, aggregate PARTITIONS over the partition_key column.

  • To find the number of partitions stored in a ROS container, aggregate PARTITIONS over the ros_id column.

Examples

See Viewing partition storage data.