Search PostgreSQL documentation

AggregatePlan NodesWikiPlan Nodes · AggregationComputes aggregate results using the selected grouping strategy and aggregation stage. Agg Aggregation Core node tag T_Agg Structured EXPLAIN Node Type Aggregate Inputs One child plan Outpu… AppendPlan NodesWikiPlan Nodes · CombinationVisits its child plans and combines their rows. Append Combination Core node tag T_Append Structured EXPLAIN Node Type Append Inputs Multiple child plans Output Combined tuples Executor ini… Bitmap Heap ScanPlan NodesWikiPlan Nodes · ScanVisits heap pages selected by a bitmap and performs required rechecks. BitmapHeapScan Scan Core node tag T_BitmapHeapScan Structured EXPLAIN Node Type Bitmap Heap Scan Inputs A tuple-locati… Bitmap Index ScanPlan NodesWikiPlan Nodes · BitmapScans an index and produces a bitmap of matching tuple locations. BitmapIndexScan Bitmap Core node tag T_BitmapIndexScan Structured EXPLAIN Node Type Bitmap Index Scan Inputs An index Outpu… BitmapAndPlan NodesWikiPlan Nodes · BitmapIntersects bitmaps produced by its child plans. BitmapAnd Bitmap Core node tag T_BitmapAnd Structured EXPLAIN Node Type BitmapAnd Inputs Bitmap-producing child plans Output Tuple-location b… BitmapOrPlan NodesWikiPlan Nodes · BitmapUnions bitmaps produced by its child plans. BitmapOr Bitmap Core node tag T_BitmapOr Structured EXPLAIN Node Type BitmapOr Inputs Bitmap-producing child plans Output Tuple-location bitmap, … CTE ScanPlan NodesWikiPlan Nodes · ScanReads the shared tuplestore of a common-table-expression plan, asking that plan for more rows when needed. CteScan Scan Core node tag T_CteScan Structured EXPLAIN Node Type CTE Scan Inputs … Custom ScanPlan NodesWikiPlan Nodes · ExtensibilityExecutes a plan supplied by a custom-scan provider. CustomScan Extensibility Core node tag T_CustomScan Structured EXPLAIN Node Type Custom Scan Inputs Provider-defined plan, possibly with … Foreign ScanPlan NodesWikiPlan Nodes · ExtensibilityDelegates a foreign scan or supported direct modification to the foreign-data wrapper. ForeignScan Extensibility Core node tag T_ForeignScan Structured EXPLAIN Node Type Foreign Scan Inputs… Function ScanPlan NodesWikiPlan Nodes · ScanScans table-function results from a FROM clause. FunctionScan Scan Core node tag T_FunctionScan Structured EXPLAIN Node Type Function Scan Inputs One or more table functions Output Function… GatherPlan NodesWikiPlan Nodes · ParallelismCombines tuples from parallel workers and any participating leader execution. Gather Parallelism Core node tag T_Gather Structured EXPLAIN Node Type Gather Inputs One parallel child plan Ou… Gather MergePlan NodesWikiPlan Nodes · ParallelismMerges ordered tuple streams from parallel workers and any participating leader execution. GatherMerge Parallelism Core node tag T_GatherMerge Structured EXPLAIN Node Type Gather Merge Inpu… GroupPlan NodesWikiPlan Nodes · AggregationGroups an ordered input stream by its grouping columns. Group Aggregation Core node tag T_Group Structured EXPLAIN Node Type Group Inputs One ordered child plan Output One tuple per group E… HashPlan NodesWikiPlan Nodes · JoinBuilds the hash table consumed by a hash join. Hash Join Core node tag T_Hash Structured EXPLAIN Node Type Hash Inputs The hash join inner child plan Output Hash table, not a normal tuple s… Hash JoinPlan NodesWikiPlan Nodes · JoinProbes a hash table built from its inner input while reading its outer input. HashJoin Join Core node tag T_HashJoin Structured EXPLAIN Node Type Hash Join Inputs Outer child and inner Hash… Incremental SortPlan NodesWikiPlan Nodes · OrderingExtends an existing ordering by sorting groups that share the presorted key prefix. IncrementalSort Ordering Core node tag T_IncrementalSort Structured EXPLAIN Node Type Incremental Sort In… Index Only ScanPlan NodesWikiPlan Nodes · ScanUses index values for the result and checks tuple visibility, visiting the heap when the visibility map does not suffice. IndexOnlyScan Scan Core node tag T_IndexOnlyScan Structured EXPLAIN… Index ScanPlan NodesWikiPlan Nodes · ScanUses an index to identify table tuples and fetches them from the relation. IndexScan Scan Core node tag T_IndexScan Structured EXPLAIN Node Type Index Scan Inputs An index and its relation … LimitPlan NodesWikiPlan Nodes · ControlApplies the plan row-count and offset bounds to its child output. Limit Control Core node tag T_Limit Structured EXPLAIN Node Type Limit Inputs One child plan Output The selected slice of t… LockRowsPlan NodesWikiPlan Nodes · ControlLocks rows selected by its child for row-locking clauses. LockRows Control Core node tag T_LockRows Structured EXPLAIN Node Type LockRows Inputs One child plan with row identity information… MaterializePlan NodesWikiPlan Nodes · MaterializationStores its child output so the rows can be read again. Material Materialization Core node tag T_Material Structured EXPLAIN Node Type Materialize Inputs One child plan Output Materialized t… MemoizePlan NodesWikiPlan Nodes · MaterializationCaches results from a parameterized child and reuses them when the same parameter values recur. Memoize Materialization Core node tag T_Memoize Structured EXPLAIN Node Type Memoize Inputs O… Merge AppendPlan NodesWikiPlan Nodes · CombinationMerges sorted child streams while preserving the required ordering. MergeAppend Combination Core node tag T_MergeAppend Structured EXPLAIN Node Type Merge Append Inputs Multiple sorted chil… Merge JoinPlan NodesWikiPlan Nodes · JoinJoins ordered input streams using merge clauses. MergeJoin Join Core node tag T_MergeJoin Structured EXPLAIN Node Type Merge Join Inputs Ordered outer and inner child plans Output Joined tu… ModifyTablePlan NodesWikiPlan Nodes · ModificationPerforms the data-modification operation selected by the plan and produces RETURNING rows when requested. ModifyTable Modification Core node tag T_ModifyTable Structured EXPLAIN Node Type M… Named Tuplestore ScanPlan NodesWikiPlan Nodes · ScanScans a named tuplestore registered in the query environment. NamedTuplestoreScan Scan Core node tag T_NamedTuplestoreScan Structured EXPLAIN Node Type Named Tuplestore Scan Inputs A named … Nested LoopPlan NodesWikiPlan Nodes · JoinRescans the inner plan for outer rows and evaluates the join qualifications. NestLoop Join Core node tag T_NestLoop Structured EXPLAIN Node Type Nested Loop Inputs Outer and inner child pla… ProjectSetPlan NodesWikiPlan Nodes · ControlEvaluates set-returning expressions in the target list for rows from its child. ProjectSet Control Core node tag T_ProjectSet Structured EXPLAIN Node Type ProjectSet Inputs One child plan O… Recursive UnionPlan NodesWikiPlan Nodes · CombinationExecutes the non-recursive and recursive terms of a recursive union using working and intermediate tables. RecursiveUnion Combination Core node tag T_RecursiveUnion Structured EXPLAIN Node … ResultPlan NodesWikiPlan Nodes · ControlEvaluates a projection and an optional one-time condition, with or without an input plan. Result Control Core node tag T_Result Structured EXPLAIN Node Type Result Inputs Optional child pla… Sample ScanPlan NodesWikiPlan Nodes · ScanReads a relation using the selected table-sampling method. SampleScan Scan Core node tag T_SampleScan Structured EXPLAIN Node Type Sample Scan Inputs A relation and sampling method Output S… Seq ScanPlan NodesWikiPlan Nodes · ScanReads a relation through a sequential scan and applies its scan qualifications. SeqScan Scan Core node tag T_SeqScan Structured EXPLAIN Node Type Seq Scan Inputs A relation Output Qualified… SetOpPlan NodesWikiPlan Nodes · CombinationImplements the selected INTERSECT or EXCEPT operation using a sorted or hashed strategy. SetOp Combination Core node tag T_SetOp Structured EXPLAIN Node Type SetOp Inputs Set-operation inpu… SortPlan NodesWikiPlan Nodes · OrderingSorts rows from its child according to the plan sort keys. Sort Ordering Core node tag T_Sort Structured EXPLAIN Node Type Sort Inputs One child plan Output Sorted tuples Executor initializ… Subquery ScanPlan NodesWikiPlan Nodes · ScanScans the output of a subquery plan. SubqueryScan Scan Core node tag T_SubqueryScan Structured EXPLAIN Node Type Subquery Scan Inputs A subquery child plan Output Subquery result tuples Exe… Table Function ScanPlan NodesWikiPlan Nodes · ScanScans the rows produced by a table function such as XMLTABLE. TableFuncScan Scan Core node tag T_TableFuncScan Structured EXPLAIN Node Type Table Function Scan Inputs A table-function expre… Tid Range ScanPlan NodesWikiPlan Nodes · ScanScans a relation over a range of tuple identifiers. TidRangeScan Scan Core node tag T_TidRangeScan Structured EXPLAIN Node Type Tid Range Scan Inputs A relation and tuple-identifier bounds … Tid ScanPlan NodesWikiPlan Nodes · ScanFetches table tuples using tuple identifiers. TidScan Scan Core node tag T_TidScan Structured EXPLAIN Node Type Tid Scan Inputs A relation and tuple identifiers Output Selected table tuples… UniquePlan NodesWikiPlan Nodes · CombinationRemoves adjacent duplicates from a sorted input stream. Unique Combination Core node tag T_Unique Structured EXPLAIN Node Type Unique Inputs One sorted child plan Output Distinct tuples Exe… Values ScanPlan NodesWikiPlan Nodes · ScanEvaluates and scans a VALUES row list. ValuesScan Scan Core node tag T_ValuesScan Structured EXPLAIN Node Type Values Scan Inputs A list of row expressions Output VALUES tuples Executor ini…