Hello, I’m DocuDroid!
Submitting feedback
Thank you for rating our AI Search!
We would be grateful if you could share your thoughts so we can improve our AI Search for you and other readers.
GitHub

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