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-16 17:53:07
Message-ID: 20200216175307.GJ31889@telsasoft.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Updated:

. remove from explain analyze those tests which would display sort
Memory/Disk. Oops.
. fix issue with the first patch showing zero "tuples" memory for some
grouping sets.
. reclassify memory as "tuples" if it has to do with "members". So hashtable
size is now redundant with nbuckets (if you know
sizeof(TupleHashEntryData));

--
Justin

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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bryn Llewellyn 2020-02-16 18:40:59 Re: jsonb_object() seems to be buggy. jsonb_build_object() is good.
Previous Message Pavel Stehule 2020-02-16 16:00:35 Re: plan cache overhead on plpgsql expression