Re: [HACKERS] to-do item for explain analyze of hash aggregates?

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: [HACKERS] to-do item for explain analyze of hash aggregates?
Дата
Msg-id 20170424185213.2mwnjqwggz72frr7@alap3.anarazel.de
обсуждение исходный текст
Ответ на [HACKERS] to-do item for explain analyze of hash aggregates?  (Jeff Janes <jeff.janes@gmail.com>)
Ответы Re: [HACKERS] to-do item for explain analyze of hash aggregates?
Список pgsql-hackers
On 2017-04-24 11:42:12 -0700, Jeff Janes wrote:
> The explain analyze of the hash step of a hash join reports something like
> this:
> 
>    ->  Hash  (cost=458287.68..458287.68 rows=24995368 width=37) (actual
> rows=24995353 loops=1)
>          Buckets: 33554432  Batches: 1  Memory Usage: 2019630kB
> 
> 
> Should the HashAggregate node also report on Buckets and Memory Usage?  I
> would have found that useful several times.  Is there some reason this is
> not wanted, or not possible?

I've wanted that too.  It's not impossible at all.

- Andres



В списке pgsql-hackers по дате отправления: