Re: EXPLAIN of Parallel Append

Поиск
Список
Период
Сортировка
От Jesper Pedersen
Тема Re: EXPLAIN of Parallel Append
Дата
Msg-id 4bee1746-7851-b5eb-4350-21f723c8ba64@redhat.com
обсуждение исходный текст
Ответ на Re: EXPLAIN of Parallel Append  (Amit Kapila <amit.kapila16@gmail.com>)
Ответы Re: EXPLAIN of Parallel Append  (Amit Kapila <amit.kapila16@gmail.com>)
Список 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
Вложения

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Ashutosh Bapat
Дата:
Сообщение: Re: [HACKERS] PoC: full merge join on comparison clause
Следующее
От: Heikki Linnakangas
Дата:
Сообщение: Re: Simplify final sync in pg_rewind's target folder and add--no-sync