Glossary: PostgreSQL Beyond the Basics

Aggregate nodes (HashAggregate, GroupAggregate)

Also written: HashAggregate, GroupAggregate, Partial HashAggregate, Finalize GroupAggregate

Plan steps that do GROUP BY work. HashAggregate collects groups in a hash table, while GroupAggregate needs rows already sorted by the group key.