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

From e.sokolova@postgrespro.ru
Subject [PATCH] Add extra statistics to explain for Nested Loop
Date
Msg-id f6490a9dec1b97118ac5a8509f095877@postgrespro.ru
Whole thread Raw
Responses Re: [PATCH] Add extra statistics to explain for Nested Loop
Re: [PATCH] Add extra statistics to explain for Nested Loop
List pgsql-hackers
Hi, hackers.
For some distributions of data in tables, different loops in nested loop 
joins can take different time and process different amounts of entries. 
It makes average statistics returned by explain analyze not very useful 
for DBA.
To fix it, here is the patch that add printing of min and max statistics 
for time and rows across all loops in Nested Loop to EXPLAIN ANALYSE.
Please don't hesitate to share any thoughts on this topic!
-- 
Ekaterina Sokolova
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company
Attachment

pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: upcoming API changes for LLVM 12
Next
From: Li Japin
Date:
Subject: Re: Enumize logical replication message actions