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