Postgres Pro
Downloads
Home   >   mailing lists

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

From Andres Freund
Subject Re: [HACKERS] to-do item for explain analyze of hash aggregates?
Date
Msg-id 20170424185213.2mwnjqwggz72frr7@alap3.anarazel.de
Whole thread Raw
In response to [HACKERS] to-do item for explain analyze of hash aggregates?  (Jeff Janes <jeff.janes@gmail.com>)
Responses Re: [HACKERS] to-do item for explain analyze of hash aggregates?  (Tomas Vondra <tomas.vondra@2ndquadrant.com>)
List pgsql-hackers
Tree view 
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 by date:

Previous
From: Andres Freund
Date:
Subject: Re: [HACKERS] OK, so culicidae is *still* broken
Next
From: Andres Freund
Date:
Subject: Re: [HACKERS] StandbyRecoverPreparedTransactions recovers subtranslinks incorrectly