↑↓ select↵ open⌫ change scopeOpen full search

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

Wiki / Plan Nodes

Subquery Scan

Scans the output of a subquery plan.

Reading PG 18·Select a recorded version

Core node tag
T_SubqueryScan
Structured EXPLAIN Node Type
Subquery Scan
Inputs
A subquery child plan
Output
Subquery result tuples
Executor initializer
ExecInitSubqueryScan
Memory mechanism
unclassified
evidence kind
source and documentation
explain names
Subquery Scan
explain prefixes
Parallel, Async
node tag
T_SubqueryScan
parallel callbacks
Unknown
partial modes
Unknown
runtime verified
false
strategies
Unknown

Definition PG 18

Scans the output of a subquery plan.

EXPLAIN labels in this source build

Text-format labelStructured node identity
Subquery ScanSubquery 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/nodeSubqueryscan.c","path":"src/backend/executor/nodeSubqueryscan.c","sha256":"9e5a1653e5b1678c457026f940a36bb2927cbfb1fa1f6a6a296e1bd1453ef29b","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/nodeSubqueryscan.c"}

Source references

Full definition and evidence JSON

Definition sources

center · PostgreSQL 18 · 555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f

Text language: en · 555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f