Why Postgres Won’t Always Use an Index Simon Taranto July 25, 2014 Uncategorized Use SQL EXPLAIN to understand when and why indexes are used (or not). Read more at the source