Missing Group Key in grouped aggregate - Mailing list pgsql-hackers

From Erik Nordström
Subject Missing Group Key in grouped aggregate
Date
Msg-id CACAa4VK=JBxbgt11YrBjz=z4sHY0rhVVS2ykDFb-QLsHKRZTEA@mail.gmail.com
Whole thread Raw
Responses Re: Missing Group Key in grouped aggregate
List 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

pgsql-hackers by date:

Previous
From: Tomas Vondra
Date:
Subject: Re: JIT compilation per plan node
Next
From: vignesh C
Date:
Subject: Re: speed up a logical replica setup