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

From: Andres Freund <andres(at)anarazel(dot)de>
To: Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
Cc: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: to-do item for explain analyze of hash aggregates?
Date: 2017-04-24 18:52:13
Message-ID: 20170424185213.2mwnjqwggz72frr7@alap3.anarazel.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andres Freund 2017-04-24 18:59:44 Re: StandbyRecoverPreparedTransactions recovers subtrans links incorrectly
Previous Message Andres Freund 2017-04-24 18:51:28 Re: OK, so culicidae is *still* broken