Materialize

Stores its child output so the rows can be read again.

Reading PG 18·Select a recorded version

Core node tag: T_Material
Structured EXPLAIN Node Type: Materialize
Inputs: One child plan
Output: Materialized tuples
Executor initializer: ExecInitMaterial
Memory mechanism: tuplestore
evidence kind: source and documentation
explain names: Materialize
explain prefixes: Parallel, Async
node tag: T_Material
parallel callbacks: Unknown
partial modes: Unknown
runtime verified: false
strategies: Unknown

Definition PG 18

Stores its child output so the rows can be read again.

EXPLAIN labels in this source build

Text-format label	Structured node identity
Materialize	Materialize

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/nodeMaterial.c","path":"src/backend/executor/nodeMaterial.c","sha256":"410b7129ca7e86ce3cf59ed7afed813fc6a47d68f5195e14df36559c75c7ef91","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/nodeMaterial.c"}

Source references

Full definition and evidence JSON

Definition sources

center · PostgreSQL 18 · 555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f

Text language: en · 555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f