gp_size_of_partition_and_indexes_disk
The gp_toolkit.gp_size_of_partition_and_indexes_disk view shows the size on disk of partitioned child tables and their indexes.
This view is accessible to all users.
However, non‑superusers will only be able to see relations that they have permission to access.
| Column | Description |
|---|---|
sopaidparentoid |
The object ID of the parent table |
sopaidpartitionoid |
The object ID of the partition table |
sopaidpartitiontablesize |
The partition table size in bytes |
sopaidpartitionindexessize |
The total size of all indexes on this partition |
sopaidparentschemaname |
The name of the parent schema |
sopaidparenttablename |
The name of the parent table |
sopaidpartitionschemaname |
The name of the partition schema |
sopaidpartitiontablename |
The name of the partition table |