Diagnosing PostgreSQL Index Bloat, Write Amplification, and Buffer Cache Hit Ratios

Diagnose PostgreSQL index bloat, write amplification, and buffer cache hit ratios with system-catalog SQL queries, then reindex with zero downtime.