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