Background
We just released a new major feature on pganalyze: Automated EXPLAIN plan analysis and plan visualization.Learn more

EXPLAIN - Aggregate

Description:

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 →