How do you read an execution plan? Seq scan, index scan, nested loop, hash join, merge join.

Question

Accepted Answer

An execution plan is a tree of operators — each node reads rows from its children, transforms them, and passes them up. Reading bottom-up tells you where time and I/O are spent.