Postgres Pro
Downloads
Home   >   mailing lists

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

From Justin Pryzby
Subject Re: explain HashAggregate to report bucket and memory stats
Date
Msg-id 20200126141425.GQ13621@telsasoft.com
Whole thread Raw
In response to explain HashAggregate to report bucket and memory stats  (Justin Pryzby <pryzby@telsasoft.com>)
Responses Re: explain HashAggregate to report bucket and memory stats
List pgsql-hackers
Tree view 
On Fri, Jan 03, 2020 at 10:19:25AM -0600, Justin Pryzby wrote:
> 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 ?

Rebased on top of 10013684970453a0ddc86050bba813c611114321
And added https://commitfest.postgresql.org/27/2428/

pgsql-hackers by date:

Previous
From: Justin Pryzby
Date:
Subject: vacuum verbose: show pages marked allvisible/frozen/hintbits
Next
From: Magnus Hagander
Date:
Subject: Re: pg_stat_bgwriter.buffers_backend is pretty meaningless (and more?)