to-do item for explain analyze of hash aggregates?

From: Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
To: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: to-do item for explain analyze of hash aggregates?
Date: 2017-04-24 18:42:12
Message-ID: CAMkU=1zo+f5CnZ6N-57G0fqx28sY96KyiN5uBHacoYx+N7KjHA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2017-04-24 18:43:11 Re: OK, so culicidae is *still* broken
Previous Message Jeevan Ladhe 2017-04-24 18:39:14 Re: Adding support for Default partition in partitioning