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
=?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
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
