Check out our Resources section: Read through our eBooks, compare us to other solutions, and learn how customers are using pganalyze. See all resources.

EXPLAIN - Subquery Scan


A Subquery Scan is for scanning the output of a sub-query in the range table. We often need an extra plan node above the sub-query's plan to perform expression evaluations (which we can't push into the sub-query without risking changing its semantics).

Important Fields:

  • 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 →