gp_size_of_table_disk
The gp_toolkit.gp_size_of_table_disk view shows the size of a table on disk.
This view is accessible to all users.
However, non‑superusers will only be able to see tables that they have permission to access.
| Column | Description |
|---|---|
sotdoid |
Object ID of the table |
sotdsize |
Size of the table in bytes. The size is only the main table size. The size does not include auxiliary objects such as oversized (TOAST) attributes or additional storage objects for AO tables |
sotdtoastsize |
Size of the TOAST table (oversized attribute storage), if there is one |
sotdadditionalsize |
Reflects the segment and block directory table sizes for append-optimized (AO) tables |
sotdschemaname |
Schema name |
sotdtablename |
Table name |