Horton

Re: explain analyze output with parallel workers - question about meaning of information for explain.depesz.com

Amit Kapila <amit.kapila16@gmail.com>

View thread View on postgr.es
From: Amit Kapila <amit.kapila16@gmail.com>
To: Robert Haas <robertmhaas@gmail.com>
Cc: Thomas Munro <thomas.munro@enterprisedb.com>, Hubert Lubaczewski <depesz@depesz.com>, pgsql-hackers mailing list <pgsql-hackers@postgresql.org>
Date: 2018-01-05T02:14:03Z
Lists: pgsql-hackers 
On Thu, Jan 4, 2018 at 11:29 PM, Robert Haas <robertmhaas@gmail.com> wrote:
> On Wed, Dec 20, 2017 at 3:38 AM, Amit Kapila <amit.kapila16@gmail.com> wrote:
>> On Tue, Dec 19, 2017 at 11:37 PM, Robert Haas <robertmhaas@gmail.com> wrote:
>>> On Wed, Dec 13, 2017 at 9:18 PM, Amit Kapila <amit.kapila16@gmail.com> wrote:
>>>> Thanks.  I think now we can proceed with
>>>> fix_accum_instr_parallel_workers_v8.patch posted above which will fix
>>>> the original issue and the problem we have found in sort and hash
>>>> nodes.
>>>
>>> Committed and back-patched to v10.
>>
>> Thanks and attached find the rebased version that can be applied to
>> v9.6.  I have to change the test case to produce a stable output and
>> the reason for the change is that 9.6 doesn't have 'summary off'
>> option for Explain.
>
> This thread got lost in my inbox over Christmas, but I've now
> committed this back-port to REL9_6_STABLE.
>

Thanks!



-- 
With Regards,
Amit Kapila.
EnterpriseDB: http://www.enterprisedb.com

Commits

  1. Back-port fix for accumulation of parallel worker instrumentation.

  2. Test instrumentation of Hash nodes with parallel query.

  3. Try again to fix accumulation of parallel worker instrumentation.

  4. Revert "Fix accumulation of parallel worker instrumentation."

  5. Fix accumulation of parallel worker instrumentation.