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

Поиск

Список

Период

Сортировка

От	David G. Johnston
Тема	Re: [PATCH] Add extra statistics to explain for Nested Loop
Дата	17 октября 2020 г. 15:11:34
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 по дате отправления: