| From: | Jesper Pedersen <jesper(dot)pedersen(at)redhat(dot)com> |
|---|---|
| To: | Amit Kapila <amit(dot)kapila16(at)gmail(dot)com> |
| Cc: | PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>, Amit Khandekar <amitdkhan(dot)pg(at)gmail(dot)com> |
| Subject: | Re: EXPLAIN of Parallel Append |
| Date: | 2018-07-09 13:30:43 |
| Message-ID: | 4bee1746-7851-b5eb-4350-21f723c8ba64@redhat.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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 | Content-Type | Size |
|---|---|---|
| parallel-docs.patch | text/x-patch | 747 bytes |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Heikki Linnakangas | 2018-07-09 13:38:11 | Re: Simplify final sync in pg_rewind's target folder and add --no-sync |
| Previous Message | Ashutosh Bapat | 2018-07-09 13:12:36 | Re: [HACKERS] PoC: full merge join on comparison clause |