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,