Re: BUG #15614: Query plan: buffer stats from workers in childoperations discarded. - Mailing list pgsql-bugs

From David Conlin
Subject Re: BUG #15614: Query plan: buffer stats from workers in childoperations discarded.
Date
Msg-id 1f5ac84b-1899-b908-746d-655a0abe3d87@cantab.net
Whole thread Raw
In response to Re: BUG #15614: Query plan: buffer stats from workers in childoperations discarded.  (Adrien NAYRAT <adrien.nayrat@anayrat.info>)
List pgsql-bugs
It is, thanks a lot.

Sorry, I should have checked - I thought the minor versions were getting
bugfixes, but I was just confused with the pre v10 way of numbering I think

Thanks

Dave

On 31/01/2019 10:28, Adrien NAYRAT wrote:
> 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,
>


pgsql-bugs by date:

Previous
From: Дилян Палаузов
Date:
Subject: Re: psql and readline comments
Next
From: Bruce Momjian
Date:
Subject: Re: BUG #15609: synchronous_commit=off insert performance regressionwith secondary indexes