Re: Missing Group Key in grouped aggregate

2024-02-20 Thread Tomas Vondra
On 2/20/24 16:53, Tom Lane wrote: > =?UTF-8?Q?Erik_Nordstr=C3=B6m?= writes: >> 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

Re: Missing Group Key in grouped aggregate

2024-02-20 Thread Tom Lane
=?UTF-8?Q?Erik_Nordstr=C3=B6m?= writes: > 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