gp_bloat_diag
The gp_toolkit.gp_bloat_diag view shows heap tables that have bloat (the actual number of pages on disk exceeds the expected number of pages given the table statistics).
Tables that are bloated require a VACUUM or a VACUUM FULL in order to reclaim disk space occupied by deleted or obsolete rows.
This view is accessible to all users.
However, non‑superusers will only be able to see the tables that they have permission to access.
| Column | Description |
|---|---|
bdirelid |
The object ID of the table |
bdinspname |
Schema name |
bdirelname |
Table name |
bdirelpages |
Actual number of pages on disk |
bdiexppages |
Expected number of pages given the table data |
bdidiag |
Bloat diagnostic message |