[PATCH] Add extra statistics to explain for Nested Loop
Ekaterina Sokolova <e.sokolova@postgrespro.ru>
From: e.sokolova@postgrespro.ru
To: pgsql-hackers@postgresql.org
Date: 2020-10-16T07:42:43Z
Lists: pgsql-hackers
Attachments
- extra_statistics_v0.patch (text/x-diff) patch v0
- example_v0.sql (text/plain)
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
Commits
-
Fix wrong units in two ExplainPropertyFloat calls.
- f90c708a0486 14.0 cited