Re: EXPLAIN of Parallel Append - Mailing list pgsql-hackers

From Jesper Pedersen
Subject Re: EXPLAIN of Parallel Append
Date
Msg-id 4bee1746-7851-b5eb-4350-21f723c8ba64@redhat.com
Whole thread Raw
In response to Re: EXPLAIN of Parallel Append  (Amit Kapila <amit.kapila16@gmail.com>)
Responses Re: EXPLAIN of Parallel Append  (Amit Kapila <amit.kapila16@gmail.com>)
List pgsql-hackers
Hi Amit,

On 07/07/2018 01:08 AM, Amit Kapila wrote:
> On Wed, Mar 14, 2018 at 8:58 PM, Jesper Pedersen
>> Parallel Append's ntuples is 1, but given nloops is 3 you end up with the
>> slightly confusing "(actual ... *rows=0* loops=3)".
>>
> 
> The number of rows displayed is total_rows / loops due to which you
> are seeing these numbers.  This behavior is the same for all parallel
> nodes, nothing specific to Parallel Append.
> 

Thanks !

Maybe something like the attached patch for the documentation is needed.

Best regards,
  Jesper

Attachment

pgsql-hackers by date:

Previous
From: Ashutosh Bapat
Date:
Subject: Re: [HACKERS] PoC: full merge join on comparison clause
Next
From: Heikki Linnakangas
Date:
Subject: Re: Simplify final sync in pg_rewind's target folder and add--no-sync