Wiki / Plan Nodes

Execution plan nodes, source interfaces, strategies, resource behavior and examples.

Reading PostgreSQL 18.6.

Find an entry GroupAll groupsAggregation (3)Bitmap (3)Combination (5)Control (4)Extensibility (2)Join (4)Materialization (2)Modification (1)Ordering (2)Parallelism (2)Scan (14) Apply

42 entries; 42 recorded in PostgreSQL 18.6.

• Aggregate Aggregation

  Agg

  Computes aggregate results using the selected grouping strategy and aggregation stage.

  1011121314151617181920
• Group Aggregation

  Group

  Groups an ordered input stream by its grouping columns.

  1011121314151617181920
• WindowAgg Aggregation

  WindowAgg

  Evaluates window functions over ordered partitions of its child output.

  1011121314151617181920
• Bitmap Index Scan Bitmap

  BitmapIndexScan

  Scans an index and produces a bitmap of matching tuple locations.

  1011121314151617181920
• BitmapAnd Bitmap

  BitmapAnd

  Intersects bitmaps produced by its child plans.

  1011121314151617181920
• BitmapOr Bitmap

  BitmapOr

  Unions bitmaps produced by its child plans.

  1011121314151617181920
• Append Combination

  Append

  Visits its child plans and combines their rows.

  1011121314151617181920
• Merge Append Combination

  MergeAppend

  Merges sorted child streams while preserving the required ordering.

  1011121314151617181920
• Recursive Union Combination

  RecursiveUnion

  Executes the non-recursive and recursive terms of a recursive union using working and intermediate tables.

  1011121314151617181920
• SetOp Combination

  SetOp

  Implements the selected INTERSECT or EXCEPT operation using a sorted or hashed strategy.

  1011121314151617181920
• Unique Combination

  Unique

  Removes adjacent duplicates from a sorted input stream.

  1011121314151617181920
• Limit Control

  Limit

  Applies the plan row-count and offset bounds to its child output.

  1011121314151617181920
• LockRows Control

  LockRows

  Locks rows selected by its child for row-locking clauses.

  1011121314151617181920
• ProjectSet Control

  ProjectSet

  Evaluates set-returning expressions in the target list for rows from its child.

  1011121314151617181920
• Result Control

  Result

  Evaluates a projection and an optional one-time condition, with or without an input plan.

  1011121314151617181920
• Custom Scan Extensibility

  CustomScan

  Executes a plan supplied by a custom-scan provider.

  1011121314151617181920
• Foreign Scan Extensibility

  ForeignScan

  Delegates a foreign scan or supported direct modification to the foreign-data wrapper.

  1011121314151617181920
• Hash Join

  Hash

  Builds the hash table consumed by a hash join.

  1011121314151617181920
• Hash Join Join

  HashJoin

  Probes a hash table built from its inner input while reading its outer input.

  1011121314151617181920
• Merge Join Join

  MergeJoin

  Joins ordered input streams using merge clauses.

  1011121314151617181920
• Nested Loop Join

  NestLoop

  Rescans the inner plan for outer rows and evaluates the join qualifications.

  1011121314151617181920
• Materialize Materialization

  Material

  Stores its child output so the rows can be read again.

  1011121314151617181920
• Memoize Materialization

  Memoize

  Caches results from a parameterized child and reuses them when the same parameter values recur.

  1011121314151617181920
• ModifyTable Modification

  ModifyTable

  Performs the data-modification operation selected by the plan and produces RETURNING rows when requested.

  1011121314151617181920
• Incremental Sort Ordering

  IncrementalSort

  Extends an existing ordering by sorting groups that share the presorted key prefix.

  1011121314151617181920
• Sort Ordering

  Sort

  Sorts rows from its child according to the plan sort keys.

  1011121314151617181920
• Gather Parallelism

  Gather

  Combines tuples from parallel workers and any participating leader execution.

  1011121314151617181920
• Gather Merge Parallelism

  GatherMerge

  Merges ordered tuple streams from parallel workers and any participating leader execution.

  1011121314151617181920
• Bitmap Heap Scan Scan

  BitmapHeapScan

  Visits heap pages selected by a bitmap and performs required rechecks.

  1011121314151617181920
• CTE Scan Scan

  CteScan

  Reads the shared tuplestore of a common-table-expression plan, asking that plan for more rows when needed.

  1011121314151617181920
• Function Scan Scan

  FunctionScan

  Scans table-function results from a FROM clause.

  1011121314151617181920
• Index Only Scan Scan

  IndexOnlyScan

  Uses index values for the result and checks tuple visibility, visiting the heap when the visibility map does not suffice.

  1011121314151617181920
• Index Scan Scan

  IndexScan

  Uses an index to identify table tuples and fetches them from the relation.

  1011121314151617181920
• Named Tuplestore Scan Scan

  NamedTuplestoreScan

  Scans a named tuplestore registered in the query environment.

  1011121314151617181920
• Sample Scan Scan

  SampleScan

  Reads a relation using the selected table-sampling method.

  1011121314151617181920
• Seq Scan Scan

  SeqScan

  Reads a relation through a sequential scan and applies its scan qualifications.

  1011121314151617181920
• Subquery Scan Scan

  SubqueryScan

  Scans the output of a subquery plan.

  1011121314151617181920
• Table Function Scan Scan

  TableFuncScan

  Scans the rows produced by a table function such as XMLTABLE.

  1011121314151617181920
• Tid Range Scan Scan

  TidRangeScan

  Scans a relation over a range of tuple identifiers.

  1011121314151617181920
• Tid Scan Scan

  TidScan

  Fetches table tuples using tuple identifiers.

  1011121314151617181920
• Values Scan Scan

  ValuesScan

  Evaluates and scans a VALUES row list.

  1011121314151617181920
• WorkTable Scan Scan

  WorkTableScan

  Reads the current working table of a recursive union.

  1011121314151617181920

RecordedFirst recordedInterface or attribute changeNo longer recorded

Squares indicate presence in sampled builds, not first introduction. Select a square for the same-version definition and sources.

Changes in PostgreSQL 18.6 · Export JSON

Reading this collection

Core plan-node identities are reconciled with EXPLAIN and executor dispatch. Text strategies and parallel or partial modifiers are attributes of a node. Manual examples are not new benchmark measurements.