This commit updates the bloat query to correctly categorise
database objects, as previously the table_bloat CTE did not
sufficiently filter out indexes, so some indexes may have been
reported as tables incorrectly.
Add WHERE clauses to filter based on relkind for
table_bloat and index_bloat CTEs
This commit updates the bloat query to correctly categorise database objects, as previously the
table_bloat
CTE did not sufficiently filter out indexes, so some indexes may have been reported as tables incorrectly.WHERE
clauses to filter based onrelkind
fortable_bloat
andindex_bloat
CTEsFixes #143