SetOp
Implements the selected INTERSECT or EXCEPT operation using a sorted or hashed strategy.
Reading PG 18·Select a recorded version
- Core node tag
- T_SetOp
- Structured EXPLAIN Node Type
- SetOp
- Inputs
- Set-operation input plans
- Output
- Set-operation result tuples
- Executor initializer
- ExecInitSetOp
- Memory mechanism
- unclassified
- EXPLAIN strategies
- Sorted, Hashed
- evidence kind
- source and documentation
- explain names
- SetOp, HashSetOp
- explain prefixes
- Parallel, Async
- node tag
- T_SetOp
- parallel callbacks
- Unknown
- partial modes
- Unknown
- runtime verified
- false
- strategies
- Sorted, Hashed
Definition PG 18
Implements the selected INTERSECT or EXCEPT operation using a sorted or hashed strategy.
EXPLAIN labels in this source build
| Text-format label | Structured node identity |
|---|---|
| SetOp | SetOp |
| HashSetOp | SetOp |
Compare versions
Complete source facts
memory
{"description":"This extraction does not assign a universal memory limit or spill policy to this node. Inspect the same-build implementation and its expressions or provider.","evidence":[{"archive_sha256":"555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f","label":"src/backend/executor/nodeSetOp.c","path":"src/backend/executor/nodeSetOp.c","sha256":"337c8a4ab549bd36155243da4f71384647d63b6475bb548f6fcdfd1a663bd8a7","url":"https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2"}],"mechanism":"unclassified","source_notes":[]}source inventory
{"executor":"src/backend/executor/execProcnode.c","explain":"src/backend/commands/explain.c","implementation":"src/backend/executor/nodeSetOp.c"}Source references
- src/backend/commands/explain.c:1580
- src/backend/executor/execProcnode.c:370
- src/backend/executor/nodeSetOp.c
- src/include/nodes/plannodes.h
Full definition and evidence JSON
Definition sources
center · PostgreSQL 18 · 555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f
Text language: en · 555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f