| 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 |
| 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 |