↑↓ select↵ open⌫ change scopeOpen full search

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

Wiki / Plan Nodes

Foreign Scan

Delegates a foreign scan or supported direct modification to the foreign-data wrapper.

Reading PG 18·Select a recorded version

Core node tag
T_ForeignScan
Structured EXPLAIN Node Type
Foreign Scan
Inputs
Foreign-data wrapper plan and callbacks
Output
Provider-defined scan or RETURNING tuples
Executor initializer
ExecInitForeignScan
Memory mechanism
unclassified
evidence kind
source and documentation
explain names
Foreign Scan, Foreign Insert, Foreign Update, Foreign Delete
explain prefixes
Parallel, Async
node tag
T_ForeignScan
parallel callbacks
ExecForeignScanEstimate, ExecForeignScanInitializeDSM, ExecForeignScanInitializeWorker, ExecForeignScanReInitializeDSM
partial modes
Unknown
runtime verified
false
strategies
Unknown

Definition PG 18

Delegates a foreign scan or supported direct modification to the foreign-data wrapper.

EXPLAIN labels in this source build

Text-format labelStructured node identity
Foreign ScanForeign Scan
Foreign InsertForeign Scan
Foreign UpdateForeign Scan
Foreign DeleteForeign 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/nodeForeignscan.c","path":"src/backend/executor/nodeForeignscan.c","sha256":"37b85b68b6fc26d94e40d9173dbfed8b69c70877c54ee72ffc761e2f7b876a0c","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/nodeForeignscan.c"}

Source references

Full definition and evidence JSON

Definition sources

center · PostgreSQL 18 · 555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f

Text language: en · 555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f