PostgreSQL index bloat: why VACUUM never shrinks an index, and how to measure it with avg_leaf_density
Short answer: If a PostgreSQL table's heap is healthy and its indexes are six times larger than the heap, autovacuum is not broken and never was. VA…