Missing Group Key in grouped aggregate

From: Erik Nordström <erik(at)timescale(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Missing Group Key in grouped aggregate
Date: 2024-02-20 10:31:21
Message-ID: CACAa4VK=JBxbgt11YrBjz=z4sHY0rhVVS2ykDFb-QLsHKRZTEA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hello,

I noticed that, beginning with PG16, grouped aggregates are missing the
"Group Key" in the EXPLAIN output.

It seems the Agg node has numCols (number of grouping cols) set to zero in
queries like

SELECT foo, count(*) FROM bar WHERE foo=1 GROUP BY foo;

In PG15, the "Group Key" is shown and the Agg node has numCols set as
expected.

Is this intentional or a bug?

Best regards,

Erik

--
Database Architect, Timescale

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message vignesh C 2024-02-20 10:33:34 Re: speed up a logical replica setup
Previous Message Tomas Vondra 2024-02-20 10:31:12 Re: JIT compilation per plan node