Vertica Analytics Platform Version 9.2.x Documentation

PARTITIONS

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 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.

Example

See Viewing Partition Storage Data in the Administrator's Guide.