Postgres Pro
Downloads
Home   >   mailing lists

explain HashAggregate to report bucket and memory stats - Mailing list pgsql-hackers

From Justin Pryzby
Subject explain HashAggregate to report bucket and memory stats
Date
Msg-id 20200103161925.GM12066@telsasoft.com
Whole thread Raw
Responses Re: explain HashAggregate to report bucket and memory stats  (Justin Pryzby <pryzby@telsasoft.com>)
Re: explain HashAggregate to report bucket and memory stats  (Andres Freund <andres@anarazel.de>)
List pgsql-hackers
Tree view 
On Sun, Feb 17, 2019 at 11:29:56AM -0500, Jeff Janes wrote:
https://www.postgresql.org/message-id/CAMkU%3D1zBJNVo2DGYBgLJqpu8fyjCE_ys%2Bmsr6pOEoiwA7y5jrA%40mail.gmail.com
> What would I find very useful is [...] if the HashAggregate node under
> "explain analyze" would report memory and bucket stats; and if the Aggregate
> node would report...anything.

Find attached my WIP attempt to implement this.

Jeff: can you suggest what details Aggregate should show ?

Justin
Attachment

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Greatest Common Divisor
Next
From: Robert Haas
Date:
Subject: Re: Greatest Common Divisor