On Fri, 2020-03-13 at 10:27 -0700, Andres Freund wrote: > On 2020-03-13 10:15:46 -0700, Jeff Davis wrote: > > Also, is there a reason you report two different memory values > > (hashtable and tuples)? I don't object, but it seems like a little > > too > > much detail. > > Seems useful to me - the hashtable is pre-allocated based on > estimates, > whereas the tuples are allocated "on demand". So seeing the > difference > will allow to investigate the more crucial issue...
Then do we also want to report separately on the by-ref transition values? That could be useful if you are using ARRAY_AGG and the states grow larger than you might expect. Regards, Jeff Davis