title: PostgreSQL: specify an index to use
body: <p>If I have a couple of indexes on the same column in postgres, what is the way I can specify which one to use on the given query? Mostly for testing, not the production purposes.
  In other words, I need the MySQL alternative for USE INDEX or even FORCE INDEX.
  No, it's not the duplicate due to that's about forcing postgres to use index scans over plain scans which is not the topic.</p>