Re: [PATCH] Add extra statistics to explain for Nested Loop

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: [PATCH] Add extra statistics to explain for Nested Loop
Дата
Msg-id CAKFQuwaD8h2wjuxs8CS9D5d1a5zmJk0xx32HceDxn=eMyw6Tqw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [PATCH] Add extra statistics to explain for Nested Loop  (Anastasia Lubennikova <a.lubennikova@postgrespro.ru>)
Ответы Re: [PATCH] Add extra statistics to explain for Nested Loop
Список pgsql-hackers
Дерево обсуждения
On Fri, Oct 16, 2020 at 3:11 PM Anastasia Lubennikova <a.lubennikova@postgrespro.ru> wrote:
User visible change is:


-               ->  Nested Loop (actual rows=N loops=N)
+              ->  Nested Loop (actual min_rows=0 rows=0 max_rows=0 loops=2)

I'd be inclined to append both new rows to the end.

(actual rows=N loops=N min_rows=N max_rows=N)

rows * loops is still an important calculation.

Why not just add total_rows while we are at it - last in the listing?

(actual rows=N loops=N min_rows=N max_rows=N total_rows=N) 
 
David J.

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