Check out our free resources, like our pganalyze eBooks and sign up to our newsletter.

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 →