Materialize
Short Description
A result set from a child node is Materialized so that it can be referenced again without re-executing
Detailed Description​
A result set from a child node is Materialized so that it can be referenced again without re-executing. This can be the results of a scan or a set of joins and it saves the overhead of having to re-run the queries where they are needed again further up the plan.
Additional Links​
- PostgreSQL Documentation - Using Explain
- pgAnalyze - Explain
- eTutorials - Understanding How PostgreSQL Executes a Query
Search online​
If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.