Plan Nodes
Version coverage matrixDefinitions for PostgreSQL 18
Reading PG 18·Select a recorded version
Computes aggregate results using the selected grouping strategy and aggregation stage.
Visits its child plans and combines their rows.
Visits heap pages selected by a bitmap and performs required rechecks.
Scans an index and produces a bitmap of matching tuple locations.
Intersects bitmaps produced by its child plans.
Unions bitmaps produced by its child plans.
Reads the shared tuplestore of a common-table-expression plan, asking that plan for more rows when needed.
Executes a plan supplied by a custom-scan provider.
Delegates a foreign scan or supported direct modification to the foreign-data wrapper.
Scans table-function results from a FROM clause.
Combines tuples from parallel workers and any participating leader execution.
Merges ordered tuple streams from parallel workers and any participating leader execution.
Groups an ordered input stream by its grouping columns.
Builds the hash table consumed by a hash join.
Probes a hash table built from its inner input while reading its outer input.
Extends an existing ordering by sorting groups that share the presorted key prefix.
Uses index values for the result and checks tuple visibility, visiting the heap when the visibility map does not suffice.
Uses an index to identify table tuples and fetches them from the relation.
Applies the plan row-count and offset bounds to its child output.
Locks rows selected by its child for row-locking clauses.
Stores its child output so the rows can be read again.
Caches results from a parameterized child and reuses them when the same parameter values recur.
Merges sorted child streams while preserving the required ordering.
Joins ordered input streams using merge clauses.
Performs the data-modification operation selected by the plan and produces RETURNING rows when requested.
Scans a named tuplestore registered in the query environment.
Rescans the inner plan for outer rows and evaluates the join qualifications.
Evaluates set-returning expressions in the target list for rows from its child.
Executes the non-recursive and recursive terms of a recursive union using working and intermediate tables.
Evaluates a projection and an optional one-time condition, with or without an input plan.
Reads a relation using the selected table-sampling method.
Reads a relation through a sequential scan and applies its scan qualifications.
Implements the selected INTERSECT or EXCEPT operation using a sorted or hashed strategy.
Sorts rows from its child according to the plan sort keys.
Scans the output of a subquery plan.
Scans the rows produced by a table function such as XMLTABLE.
Scans a relation over a range of tuple identifiers.
Fetches table tuples using tuple identifiers.
Removes adjacent duplicates from a sorted input stream.
Evaluates and scans a VALUES row list.
Evaluates window functions over ordered partitions of its child output.
Reads the current working table of a recursive union.