Why isn't Postgres using my index? | Postgres FM | Episode 85 (opens in new tab)

Nikolay and Michael discuss a common question — why Postgres isn't using an index, and what you can do about it! Here are some links to things they mentioned:Why isn’t Postgres using my index? (blog post by Michael) Why isn’t Postgres using my functional index? (Stack Exchange question from Brent Ozar) enable_seqscan (and similar parameters) Crunchy Bridge changed random_page_cost to 1.1 Make indexes invisible (trick from Haki Benita) ANALYZE Our episode on query hints transaction_timeout (co...