PARTITION_STATUS
For each projection of each partitioned table, shows the fraction of its data that is actually partitioned according to the current partition expression.
For each projection of each partitioned table, shows the fraction of its data that is actually partitioned according to the current partition expression. When the partitioning of a table is altered, the value in PARTITION_REORGANIZE_PERCENT for each of its projections drops to zero and goes back up to 100 when all the data is repartitioned.
| Column Name | Data Type | Description |
|---|---|---|
PROJECTION_ID |
INTEGER | Unique numeric ID assigned by the Vertica catalog, which identifies the projection. |
TABLE_SCHEMA |
VARCHAR | Name of the schema that contains the partitioned table. |
TABLE_NAME |
VARCHAR | Table name that is partitioned. |
TABLE_ID |
INTEGER | Unique numeric ID assigned by the Vertica, which identifies the table. |
PROJECTION_SCHEMA |
VARCHAR | Schema containing the projection. |
PROJECTION_NAME |
VARCHAR | Projection name for which information is listed. |
PARTITION_REORGANIZE_PERCENT |
INTEGER | For each projection, drops to zero and goes back up to 100 when all the data is repartitioned after the partitioning of a table has been altered. Ideally all rows will show 100 (%). |
Privileges
Non-superuser: No explicit privileges required. You only see records for tables that you have privileges to view.