Re: BUG #15614: Query plan: buffer stats from workers in childoperations discarded.

On 1/31/19 10:33 AM, PG Bug reporting form wrote:
> The following bug has been logged on the website:
> 
> Bug reference:      15614
> Logged by:          Dave Conlin
> Email address:      dc345@cantab.net
> PostgreSQL version: 10.4
> Operating system:   Windows 10
> Description:
> 
> Hi folks -
> 
> In the output of an `EXPLAIN` query, normally child operations are included
> in the totals for the buffers values, eg "Shared Hit Blocks". It seems that
> when a parent operation is single-threaded, but a child operation starts
> workers, then only the buffers stats from the main thread in the child
> operation are included in the totals for the parent operation.
> 


Hello,

This should have been fixed in 10.5 :

https://www.postgresql.org/docs/current/release-10-5.html
 > Fix EXPLAIN's accounting for resource usage, particularly buffer 
accesses, in parallel workers (Amit Kapila, Robert Haas)

Could you apply the minor update and test again?

Regards,