Index selection, EXPLAIN reading and lock diagnosis for PostgreSQL: which scan the planner chose and why, when an index is not used, and how to find the query holding the lock everyone else is waiting on.
Index selection, EXPLAIN reading and lock diagnosis for PostgreSQL: which scan the planner chose and why, when an index is not used, and how to find the query holding the lock everyone else is waiting on.