Re: Explain buffers wrong counter with parallel plans - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: Explain buffers wrong counter with parallel plans
Date
Msg-id 20180606160840.amoed4vwlww5gtqq@alvherre.pgsql
Whole thread Raw
In response to Re: Explain buffers wrong counter with parallel plans  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: Explain buffers wrong counter with parallel plans
List pgsql-hackers
On 2018-May-07, Robert Haas wrote:

> On Sat, May 5, 2018 at 8:56 AM, Amit Kapila <amit.kapila16@gmail.com> wrote:
> > The reason why I think the current behavior is okay because it is
> > coincidental that they were displayed correctly.  We have not made any
> > effort to percolate it to upper nodes.  For ex., before that commit
> > also, it was not being displayed for Gather Merge or Gather with some
> > kind of node like 'Limit' where we have to stop before reaching the
> > end of the result.
> 
> It's not entirely coincidental.  I had the intention to try to ensure
> that the workers would be shut down before the Gather or Gather Merge,
> and I think that various things in the code testify to that intention.
> It sounds like I missed some cases, but now we're missing even more
> cases.

So, apparently this is not a Postgres 11 open item, but rather a bug
that goes back to pg10.  However, maybe it would be worth fixing soon
anyway?  In particular, if we want to perturb the explain output as
suggested upthread, maybe *that* should be considered an open item?

Anyway, this has stalled for a month now.

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services


pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: file cloning in pg_upgrade and CREATE DATABASE
Next
From: Alvaro Herrera
Date:
Subject: Re: Transform for pl/perl