On Mon, Mar 25, 2024 at 2:11 PM Melanie Plageman <melanieplage...@gmail.com> wrote: > As for whether or not per-worker stats should be displayed by default > or only with VERBOSE, it sounds like there are two different > precedents. I don't have a strong feeling one way or the other. > Whichever is most consistent. > Donghang, could you list again which plan nodes and explain options > always print per-worker stats and which only do with the VERBOSE > option?
I took a look at explain.c where workers info is printed out. These works for every parallel aware nodes: Buffers stats print for workers with VERBOSE and BUFFERS WAL stats print for workers with VERBOSE and WAL JIT stats print for workers with VERBOSE and COSTS Timing print for workers with VERBOSE and TIMING Rows and loops print for workers with VERBOSE Some specific nodes: Sort / Incremental Sort / Hash / HashAggregate / Memorize and Bitmap Heap Scan (this patch) nodes always print their specific stats for workers. > I did some logging and I do see workers with > counts of lossy/exact not making it into the final count. I haven't > had time to debug more, but it is worth looking into. Indeed, rescan overrides previous scan stats in workers. Attach v5 with v4 plus the fix to aggregate the counts. Regards, Donghang Lin (ServiceNow)
v5-0001-Parallel-Bitmap-Heap-Scan-reports-per-worker-stat.patch
Description: Binary data
