[prev] 40 [next]

Example PostgreSQL Execution (cont)

The execution plan tree

[Diagram:Pics/qproc/qtree1.png]

contains three nodes:

  • NestedLoop with join condition (Outer.manager = Inner.name)
  • IndexScan on Departments with selection (name = 'Shoe')
  • SeqScan on Employees