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:...