Check out our latest eBook: "Efficient Search in Rails with Postgres". We've updated our Terms of Service and Privacy Policy, effective Jan 30, 2021.

EXPLAIN - Subquery Scan

Description:

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 →