PostgreSQL WHERE Clause Optimization

You added the index. The query still runs a sequential scan. You re-read the plan, the index, the definition — everything looks right — and yet the planner refuses to use it. Nine times out of ten, the problem isn't the index. It's the WHERE clause: ...