Postgres Pro
Downloads
Home   >   mailing lists

Re: [PATCH] Add extra statistics to explain for Nested Loop - Mailing list pgsql-hackers

From David G. Johnston
Subject Re: [PATCH] Add extra statistics to explain for Nested Loop
Date
Msg-id CAKFQuwaD8h2wjuxs8CS9D5d1a5zmJk0xx32HceDxn=eMyw6Tqw@mail.gmail.com
Whole thread Raw
In response to Re: [PATCH] Add extra statistics to explain for Nested Loop  (Anastasia Lubennikova <a.lubennikova@postgrespro.ru>)
Responses Re: [PATCH] Add extra statistics to explain for Nested Loop
List pgsql-hackers
Tree view
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 by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: Sometimes the output to the stdout in Windows disappears
Next
From: Peter Geoghegan
Date:
Subject: Re: pgstat_report_activity() and parallel CREATE INDEX (was: Parallel index creation & pg_stat_activity)