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 по дате отправления:

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: [HACKERS] OK, so culicidae is *still* broken
Следующее
От: Andres Freund
Дата:
Сообщение: Re: [HACKERS] StandbyRecoverPreparedTransactions recovers subtranslinks incorrectly