1 carefully structured article in this topic.
A working guide to the reasons Postgres ignores an index you were sure it would use, and how to read the plan instead of guessing at it.