Diffing two EXPLAIN plans as trees, not text (opens in new tab)
You added an index, re-ran EXPLAIN, and now you want the obvious answer: did the plan actually change? So you diff the two outputs as text. And it lights up red everywhere — because cost= and rows= shift on nearly every line, even when the strategy is identical. The one line you cared about — Seq Scan on orders becoming Index Scan using orders_created_idx on orders — is buried in a wall of numeric churn. Text is the wrong representation. An EXPLAIN plan is a tree, and the question "what chang...
Read the original article