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 - Aggregate


An Agg node implements plain or grouped aggregation. For grouped aggregation, Postgres can work with presorted input or unsorted input; the latter strategy uses an internal hashtable.

Important Fields:

  • Filter
  • Group Key
  • Partial Mode
  • Rows Removed by Filter
  • Strategy

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