When does a Postgres index NOT get used?

Question

Randhir Jassal · Accepted Answer

Common causes: leading-column omitted from a composite index, function applied to the column (WHERE lower(email) = ...), data type mismatch in the predicate, planner statistics out of date, or the table is small enough that a sequential scan is faster.

Run EXPLAIN (ANALYZE, BUFFERS) to confirm.

When does a Postgres index NOT get used?

Explain the difference between READ COMMITTED and REPEATABLE READ.

When does a Postgres index NOT get used?

Explain the difference between READ COMMITTED and REPEATABLE READ.

Related questions

Explain the difference between READ COMMITTED and REPEATABLE READ.

Related questions

Explain the difference between READ COMMITTED and REPEATABLE READ.