Horton

Re: Missing HashAgg EXPLAIN ANALYZE details for parallel plans

David Rowley <dgrowleyml@gmail.com>

View thread View on postgr.es
From: David Rowley <dgrowleyml@gmail.com>
To: Jeff Davis <pgsql@j-davis.com>
Cc: PostgreSQL Developers <pgsql-hackers@lists.postgresql.org>
Date: 2020-06-19T05:27:13Z
Lists: pgsql-hackers 
On Fri, 19 Jun 2020 at 15:28, Jeff Davis <pgsql@j-davis.com> wrote:
>
> On Thu, 2020-06-18 at 15:37 +1200, David Rowley wrote:
> > The attached patch fixes both the missing parallel worker information
> > and puts the properties on a single line for format=text.
>
> Thank you.
>
> I noticed some strange results in one case where one worker had a lot
> more batches than another. After I investigated, I think everything is
> fine -- it seems that one worker was getting more tuples from the
> underlying parallel scan. So everything looks good to me.

Thanks for having a look at this. I just pushed it.

David

Commits

  1. Fix whitespace in HashAgg EXPLAIN ANALYZE

  2. Fix EXPLAIN ANALYZE for parallel HashAgg plans

  3. Rework EXPLAIN format for incremental sort