Missing Group Key in grouped aggregate

Поиск
Список
Период
Сортировка
От Erik Nordström
Тема Missing Group Key in grouped aggregate
Дата
Msg-id CACAa4VK=JBxbgt11YrBjz=z4sHY0rhVVS2ykDFb-QLsHKRZTEA@mail.gmail.com
обсуждение исходный текст
Ответы Re: Missing Group Key in grouped aggregate  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Tomas Vondra
Дата:
Сообщение: Re: JIT compilation per plan node
Следующее
От: vignesh C
Дата:
Сообщение: Re: speed up a logical replica setup