From Dev.to
I Added an Index and Postgres Still Does a Seq Scan (Here's Why)
You have a slow query. You add an index. You run the query again, check the plan, and there it is: Seq Scan. The usual reaction is "Postgres is ignoring my index." Sometimes that's true, and something...