Background
We just released a new major feature on pganalyze: Automated EXPLAIN plan analysis and plan visualization.Learn more

EXPLAIN - CTE Scan

Description:

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.

Important Fields:

  • CTE Name
  • Filter
  • Rows Removed by Filter

Couldn't find what you were looking for or want to talk about something specific?
Start a conversation with us →