Why your Postgres index isn't being used
The planner skipped an index on a 40-million-row table. Here is how to read EXPLAIN until it tells you why.
9 min read
~/blog $ ls --by-year
Every post on Stack & Heap, newest first. Pick a topic to narrow it down.
2 posts tagged #performance · clear
The planner skipped an index on a 40-million-row table. Here is how to read EXPLAIN until it tells you why.
9 min read
Width is time, height is depth, colour is usually noise. A short guide to finding the slow part on the first try.
7 min read