Skip to navigation
Watch our latest webinar on demand: Optimizing Postgres with Claude Code and the pganalyze MCP Server.
pganalyze
  • Docs
  • Our Key Features
    Query AdvisorDetect and fix Postgres query plan problemsIndex AdvisorFaster queries, less guessworkVACUUM AdvisorOptimize bloat, freezing and VACUUM performanceWorkbooksDedicated environment for query optimization
    All features
  • Fix Slow QueriesEnterprise Scale
  • Pricing
  • Blog
  • WebinarseBooksToolsCustomer StoriesBlogNewsletter
  • About usCareers
  • Contact
LoginFree Trial
pganalyze
Docs
Query AdvisorDetect and fix Postgres query plan problemsIndex AdvisorFaster queries, less guessworkVACUUM AdvisorOptimize bloat, freezing and VACUUM performanceWorkbooksDedicated environment for query optimization
See all features
Fix Slow QueriesEnterprise Scale
PricingBlog
WebinarseBooksToolsCustomer StoriesBlogNewsletter
About usCareers
Contact
Free TrialLog in
    • Overview
    • Installation Guide
    • pganalyze Collector
    • Query Performance
    • Query Advisor
    • EXPLAIN Plans
      • Overview
      • The Basics of Postgres Query Planning
      • EXPLAIN Grid view
      • Comparing EXPLAIN plans
      • Insights
      • Scan nodes
      • Join nodes
      • Other nodes
        • Aggregate
        • Append
        • Bitmap And
        • Bitmap Or
        • Gather Merge
        • Gather
        • Group
        • Hash
        • Limit
        • Lock Rows
        • Materialize
        • Merge Append
        • Modify Table
        • Project Set
        • Recursive Union
        • Result
        • SetOp
        • Sort
        • Unique
        • Window Aggregate
    • Workbooks
    • Index Advisor
    • Indexing Engine
    • VACUUM Advisor
    • Schema Statistics
    • Log Insights
    • Connections
    • Alerts & Check-Up
    • Account Management
    • MCP Server (Preview)
    • OpenTelemetry Integration
    • pganalyze Enterprise Server
    • pganalyze GraphQL API
    • Open-Source Components
❮ Documentation: EXPLAIN - Other Nodes

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 →

Logo
  • Contact
  • Plans & Pricing
  • Resources
  • Enterprise
  • Documentation
  • Customer Stories
  • Careers
  • Index Advisor
  • Security
  • Status
  • Postgres Query Formatter
  • Compare pganalyze
  • Terms of Service
  • Privacy Policy
  • Newsletter
  • SOC 2 Type 2
  • Do Not Sell My Personal Information

Get in touch

Use the contact us form or email sales:
 sales@pganalyze.com

SOC 2 certification

pganalyze is SOC 2 Type 2 certified

pganalyze is SOC 2 Type 2 certified
© 2026 Duboce Labs, Inc.