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.