It reads the whole table’s workload
It proposes one index set for each table’s whole workload, so one index can serve several queries instead of one index being added per query.
It says what to drop
- It says which indexes you can retire.
- Index removals are staged and reversible, and never happen in one step. With indexes set to Ask me first, they wait for your approval.
Beyond indexes
Also checks PostgreSQL maintenance health.