Postgres Pro
Downloads
Home   >   mailing lists

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

From Jeff Janes
Subject [HACKERS] to-do item for explain analyze of hash aggregates?
Date
Msg-id CAMkU=1zo+f5CnZ6N-57G0fqx28sY96KyiN5uBHacoYx+N7KjHA@mail.gmail.com
Whole thread Raw
Responses Re: [HACKERS] to-do item for explain analyze of hash aggregates?  (Andres Freund <andres@anarazel.de>)
List pgsql-hackers
Tree view
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?

Cheers,

Jeff


pgsql-hackers by date:

Previous
From: Jeevan Ladhe
Date:
Subject: Re: [HACKERS] Adding support for Default partition in partitioning
Next
From: Tom Lane
Date:
Subject: Re: [HACKERS] OK, so culicidae is *still* broken