PostgreSQL index decision guide
Should I add this PostgreSQL index?
Check whether a proposed PostgreSQL index is supported by the queries your database actually runs before merging it.
The problem
A migration adds an index, but which real queries need it?
How IndexPilot helps
IndexPilot matches the exact CREATE INDEX to aggregate pg_stat_statements workload, existing indexes, and optional HypoPG plans. It returns evidence for a benchmark decision without applying the migration.
Try it
$ pipx install indexpilot
$ indexpilot review --migration-file migration.sql --hypopg
$ indexpilot review --migration-file migration.sql --hypopg
- Observed query shapes and call counts
- Comparable existing indexes
- Optional hypothetical planner selection
Important limit
IndexPilot decides whether an index has enough evidence to benchmark. It does not claim that planner cost equals production latency or that an index is safe to ship.