↑↓ select↵ open⌫ change scopeOpen full search

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

Wiki / Plan Nodes

Seq Scan

Reads a relation through a sequential scan and applies its scan qualifications.

Reading PG 18·Select a recorded version

Core node tag
T_SeqScan
Structured EXPLAIN Node Type
Seq Scan
Inputs
A relation
Output
Qualified relation tuples
Executor initializer
ExecInitSeqScan
Memory mechanism
unclassified
evidence kind
source and documentation
explain names
Seq Scan
explain prefixes
Parallel, Async
node tag
T_SeqScan
parallel callbacks
ExecSeqScanEstimate, ExecSeqScanInitializeDSM, ExecSeqScanInitializeWorker, ExecSeqScanReInitializeDSM
partial modes
Unknown
runtime verified
false
strategies
Unknown

Definition PG 18

Reads a relation through a sequential scan and applies its scan qualifications.

EXPLAIN labels in this source build

Text-format labelStructured node identity
Seq ScanSeq 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/nodeSeqscan.c","path":"src/backend/executor/nodeSeqscan.c","sha256":"e6c9800872e17a6cfb6e58613de7e82da082b4d430557a3065a3caa6fe24f34d","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/nodeSeqscan.c"}

Source references

Full definition and evidence JSON

Definition sources

center · PostgreSQL 18 · 555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f

Text language: en · 555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f