EXPLAIN - CTE Scan
Scan the result of a common table expression. Note that until Postgres 12, common table expressions are an optimization fence; the CTE result is materialized, and is essentially treated as a temporary table and not optimized as part of the query. If you depend on this behavior, be aware performance of your queries may change when you upgrade.
- CTE Name
- Rows Removed by Filter
Couldn't find what you were looking for or want to talk about something specific?
Start a conversation with us →