Plan nodes (Seq Scan, Index Scan, Hash Join...)

An execution plan is a tree of nodes: Seq Scan reads the whole table, Index Scan and Index Only Scan go through an index, Bitmap Heap Scan combines several pages, Nested Loop, Hash Join and Merge Join perform joins, Sort and Aggregate sort and aggregate. Reading them from the inside out reveals the costly points.

The whole glossary