Recursive Union
Executes the non-recursive and recursive terms of a recursive union using working and intermediate tables.
Reading PG 18·Select a recorded version
- Core node tag
- T_RecursiveUnion
- Structured EXPLAIN Node Type
- Recursive Union
- Inputs
- Non-recursive and recursive child plans
- Output
- Recursive query tuples
- Executor initializer
- ExecInitRecursiveUnion
- Memory mechanism
- tuplestore
- evidence kind
- source and documentation
- explain names
- Recursive Union
- explain prefixes
- Parallel, Async
- node tag
- T_RecursiveUnion
- parallel callbacks
- Unknown
- partial modes
- Unknown
- runtime verified
- false
- strategies
- Unknown
Definition PG 18
Executes the non-recursive and recursive terms of a recursive union using working and intermediate tables.
EXPLAIN labels in this source build
| Text-format label | Structured node identity |
|---|---|
| Recursive Union | Recursive Union |
Compare versions
Complete source facts
memory
{"description":"This node creates a tuplestore with work_mem. The tuplestore can move stored tuples to temporary files; this does not make work_mem a cap on every allocation made by the node.","evidence":[{"archive_sha256":"555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f","label":"src/backend/executor/nodeRecursiveunion.c","path":"src/backend/executor/nodeRecursiveunion.c","sha256":"315c2d4d0a7a1ddf362ad19357cb62c7615592d2f51aaee87d313b4fe0d9536a","url":"https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2"},{"archive_sha256":"555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f","label":"src/backend/utils/sort/tuplestore.c","path":"src/backend/utils/sort/tuplestore.c","sha256":"27a85416bafed557006c705ab5d0c5dce3d3c1702812bb54d136f2ac4c41055a","url":"https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2"}],"mechanism":"tuplestore","source_notes":[]}source inventory
{"executor":"src/backend/executor/execProcnode.c","explain":"src/backend/commands/explain.c","implementation":"src/backend/executor/nodeRecursiveunion.c"}Source references
- src/backend/commands/explain.c:1412
- src/backend/executor/execProcnode.c:191
- src/backend/executor/nodeRecursiveunion.c
- src/include/nodes/plannodes.h
- src/backend/utils/sort/tuplestore.c
Full definition and evidence JSON
Definition sources
center · PostgreSQL 18 · 555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f
Text language: en · 555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f