EXPLAIN ANALYZE is not enough: how to actually read a PostgreSQL execution plan
A real-world case where the optimizer chose a nested loop on 2 million rows because statistics were stale. How to read an execution plan, spot the red flags, and fix the root cause.
·8 mins