If you spend any amount of time working with Postgres, it’s likely that at
some point you’re going to wonder why it isn’t using an index that you
think it should be. Unlike some databases, you can’t force PostgreSQL to
use a specific index, but there are several things you can do to work out
what’s going on.