Wiki / 执行计划

PostgreSQL 版本定义：18

• AggregateAggregation10 – 20

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

  此定义以英文显示

  1011121314151617181920
• AppendCombination10 – 20

  Visits its child plans and combines their rows.

  此定义以英文显示

  1011121314151617181920
• Bitmap Heap ScanScan10 – 20

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

  此定义以英文显示

  1011121314151617181920
• Bitmap Index ScanBitmap10 – 20

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

  此定义以英文显示

  1011121314151617181920
• BitmapAndBitmap10 – 20

  Intersects bitmaps produced by its child plans.

  此定义以英文显示

  1011121314151617181920
• BitmapOrBitmap10 – 20

  Unions bitmaps produced by its child plans.

  此定义以英文显示

  1011121314151617181920
• CTE ScanScan10 – 20

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

  此定义以英文显示

  1011121314151617181920
• Custom ScanExtensibility10 – 20

  Executes a plan supplied by a custom-scan provider.

  此定义以英文显示

  1011121314151617181920
• Foreign ScanExtensibility10 – 20

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

  此定义以英文显示

  1011121314151617181920
• Function ScanScan10 – 20

  Scans table-function results from a FROM clause.

  此定义以英文显示

  1011121314151617181920
• GatherParallelism10 – 20

  Combines tuples from parallel workers and any participating leader execution.

  此定义以英文显示

  1011121314151617181920
• Gather MergeParallelism10 – 20

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

  此定义以英文显示

  1011121314151617181920
• GroupAggregation10 – 20

  Groups an ordered input stream by its grouping columns.

  此定义以英文显示

  1011121314151617181920
• HashJoin10 – 20

  Builds the hash table consumed by a hash join.

  此定义以英文显示

  1011121314151617181920
• Hash JoinJoin10 – 20

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

  此定义以英文显示

  1011121314151617181920
• Incremental SortOrdering13 – 20

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

  此定义以英文显示

  1011121314151617181920
• Index Only ScanScan10 – 20

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

  此定义以英文显示

  1011121314151617181920
• Index ScanScan10 – 20

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

  此定义以英文显示

  1011121314151617181920
• LimitControl10 – 20

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

  此定义以英文显示

  1011121314151617181920
• LockRowsControl10 – 20

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

  此定义以英文显示

  1011121314151617181920
• MaterializeMaterialization10 – 20

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

  此定义以英文显示

  1011121314151617181920
• MemoizeMaterialization14 – 20

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

  此定义以英文显示

  1011121314151617181920
• Merge AppendCombination10 – 20

  Merges sorted child streams while preserving the required ordering.

  此定义以英文显示

  1011121314151617181920
• Merge JoinJoin10 – 20

  Joins ordered input streams using merge clauses.

  此定义以英文显示

  1011121314151617181920
• ModifyTableModification10 – 20

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

  此定义以英文显示

  1011121314151617181920
• Named Tuplestore ScanScan10 – 20

  Scans a named tuplestore registered in the query environment.

  此定义以英文显示

  1011121314151617181920
• Nested LoopJoin10 – 20

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

  此定义以英文显示

  1011121314151617181920
• ProjectSetControl10 – 20

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

  此定义以英文显示

  1011121314151617181920
• Recursive UnionCombination10 – 20

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

  此定义以英文显示

  1011121314151617181920
• ResultControl10 – 20

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

  此定义以英文显示

  1011121314151617181920
• Sample ScanScan10 – 20

  Reads a relation using the selected table-sampling method.

  此定义以英文显示

  1011121314151617181920
• Seq ScanScan10 – 20

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

  此定义以英文显示

  1011121314151617181920
• SetOpCombination10 – 20

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

  此定义以英文显示

  1011121314151617181920
• SortOrdering10 – 20

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

  此定义以英文显示

  1011121314151617181920
• Subquery ScanScan10 – 20

  Scans the output of a subquery plan.

  此定义以英文显示

  1011121314151617181920
• Table Function ScanScan10 – 20

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

  此定义以英文显示

  1011121314151617181920
• Tid Range ScanScan14 – 20

  Scans a relation over a range of tuple identifiers.

  此定义以英文显示

  1011121314151617181920
• Tid ScanScan10 – 20

  Fetches table tuples using tuple identifiers.

  此定义以英文显示

  1011121314151617181920
• UniqueCombination10 – 20

  Removes adjacent duplicates from a sorted input stream.

  此定义以英文显示

  1011121314151617181920
• Values ScanScan10 – 20

  Evaluates and scans a VALUES row list.

  此定义以英文显示

  1011121314151617181920
• WindowAggAggregation10 – 20

  Evaluates window functions over ordered partitions of its child output.

  此定义以英文显示

  1011121314151617181920
• WorkTable ScanScan10 – 20

  Reads the current working table of a recursive union.

  此定义以英文显示

  1011121314151617181920