Re: EXPLAIN of Parallel Append

2018-07-10 Thread Amit Kapila
On Mon, Jul 9, 2018 at 7:00 PM, Jesper Pedersen wrote: > 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)". >>> >

Re: EXPLAIN of Parallel Append

2018-07-09 Thread Jesper Pedersen
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 y

Re: EXPLAIN of Parallel Append

2018-07-06 Thread Amit Kapila
On Wed, Mar 14, 2018 at 8:58 PM, Jesper Pedersen wrote: > Hi, > > Given > > -- test.sql -- > CREATE TABLE t1 ( > a integer NOT NULL, > b integer NOT NULL > ) PARTITION BY HASH (b); > CREATE TABLE t1_p00 PARTITION OF t1 FOR VALUES WITH (MODULUS 4, REMAINDER > 0); > CREATE TABLE t1_p01 PARTI