Re: BUG #15614: Query plan: buffer stats from workers in child operations 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(at)cantab(dot)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,