↑↓ select↵ open⌫ change scopeOpen full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Wiki / Plan Nodes

WorkTable Scan

Reads the current working table of a recursive union.

Reading PG 18·Select a recorded version

Core node tag
T_WorkTableScan
Structured EXPLAIN Node Type
WorkTable Scan
Inputs
The recursive query working table
Output
Working-table tuples
Executor initializer
ExecInitWorkTableScan
Memory mechanism
unclassified
evidence kind
source and documentation
explain names
WorkTable Scan
explain prefixes
Parallel, Async
node tag
T_WorkTableScan
parallel callbacks
Unknown
partial modes
Unknown
runtime verified
false
strategies
Unknown

Definition PG 18

Reads the current working table of a recursive union.

EXPLAIN labels in this source build

Text-format labelStructured node identity
WorkTable ScanWorkTable Scan

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/nodeWorktablescan.c","path":"src/backend/executor/nodeWorktablescan.c","sha256":"912d71e785d7f013d5889e3389deff289a01e35fa2c3aafa2345939fbb988834","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/nodeWorktablescan.c"}

Source references

Full definition and evidence JSON

Definition sources

center · PostgreSQL 18 · 555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f

Text language: en · 555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f