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 20180629182217.ycqdq4dvu2ieryv5@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-Jun-08, Robert Haas wrote:

> On Wed, Jun 6, 2018 at 12:08 PM, Alvaro Herrera
> <alvherre@2ndquadrant.com> wrote:
> > 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.
> 
> Yeah.  I'm not willing to do anything here unilaterally.  There is
> neither universal agreement that there is a problem here nor agreement
> on a fix.  Unless that changes, I don't know what to do here.

After going over this whole thing once more, my opinion is that this
reporting is broken.  IMO if we want to display per-process counts, then
let's display them all, or none; if we're going to display aggregated
counts, then we should mark them as such.  Otherwise it's pretty much
impossible to read the output unless you know exactly what the code does
for each value.  (The other option would be to document what the code
does for each value, but that seems suboptimal -- that just requires
people to glue one more cheat sheet to their walls, which is not Pg
style.)

I'm CCing Tom here, as author of the patch that caused (most of) the
issue.

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


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Regression on PostgreSQL 10 ORDER/GROUP BY expression not found in targetlist
Next
From: Tomas Vondra
Date:
Subject: Re: ERROR: cannot start subtransactions during a parallel operation