Re: explain HashAggregate to report bucket and memory stats

From: Justin Pryzby <pryzby(at)telsasoft(dot)com>
To: Andres Freund <andres(at)anarazel(dot)de>
Cc: pgsql-hackers(at)lists(dot)postgresql(dot)org, Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
Subject: Re: explain HashAggregate to report bucket and memory stats
Date: 2020-02-19 20:10:37
Message-ID: 20200219201037.GA21433@telsasoft.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Sun, Feb 16, 2020 at 11:53:07AM -0600, Justin Pryzby wrote:
> Updated:
>
> . remove from explain analyze those tests which would display sort
> Memory/Disk. Oops.

. Rebased on top of 5b618e1f48aecc66e3a9f60289491da520faae19
. Updated to avoid sort's Disk output, for real this time.
. And fixed a syntax error in an intermediate commit.

--
Justin

Attachment Content-Type Size
v4-0001-Run-some-existing-tests-with-explain-ANALYZE.patch text/x-diff 20.4 KB
v4-0002-explain-to-show-tuplehash-bucket-and-memory-stats.patch text/x-diff 20.5 KB
v4-0003-Gross-hack-to-put-hash-stats-of-subplans-in-the-r.patch text/x-diff 7.1 KB
v4-0004-implement-hash-stats-for-bitmapHeapScan.patch text/x-diff 5.5 KB
v4-0005-Refactor-for-consistency-symmetry.patch text/x-diff 14.3 KB
v4-0006-TupleHashTable.entrysize-was-unused-except-for-in.patch text/x-diff 1.6 KB
v4-0007-Update-comment-obsolete-since-69c3936a.patch text/x-diff 884 bytes

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Misha Patel 2020-02-19 20:13:01 Open Source Hackathon Mentorship Invitation
Previous Message Peter Eisentraut 2020-02-19 20:09:42 Re: Unicode normalization SQL functions