↑↓ select↵ open⌫ change scopeOpen full search

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

Wiki / Plan Nodes

Table Function Scan

Scans the rows produced by a table function such as XMLTABLE.

Reading PG 18·Select a recorded version

Core node tag
T_TableFuncScan
Structured EXPLAIN Node Type
Table Function Scan
Inputs
A table-function expression
Output
Table-function result tuples
Executor initializer
ExecInitTableFuncScan
Memory mechanism
tuplestore
evidence kind
source and documentation
explain names
Table Function Scan
explain prefixes
Parallel, Async
node tag
T_TableFuncScan
parallel callbacks
Unknown
partial modes
Unknown
runtime verified
false
strategies
Unknown

Definition PG 18

Scans the rows produced by a table function such as XMLTABLE.

EXPLAIN labels in this source build

Text-format labelStructured node identity
Table Function ScanTable Function Scan

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/nodeTableFuncscan.c","path":"src/backend/executor/nodeTableFuncscan.c","sha256":"0a9faaa9e45bb460dd98e4688f088711d459333eb8bd94255779f2c0218df82b","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/nodeTableFuncscan.c"}

Source references

Full definition and evidence JSON

Definition sources

center · PostgreSQL 18 · 555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f

Text language: en · 555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f