PostgreSQL3 min read
Why an Index Is Not Used: the Estimate, Not the Index
An index the planner ignores is usually a row-estimate problem. The fix starts with what the optimizer expected, not with the index definition.
- #query-optimization
- #indexing
- #execution-plans
- #statistics