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

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема Re: [PATCH] Add extra statistics to explain for Nested Loop
Дата
Msg-id CAFj8pRA=wMP+yebbssQByL9nV5FJe6vnkw-ZB7zta1j2W9ftjg@mail.gmail.com
обсуждение исходный текст
Ответ на [PATCH] Add extra statistics to explain for Nested Loop  (e.sokolova@postgrespro.ru)
Ответы Re: [PATCH] Add extra statistics to explain for Nested Loop  (Julien Rouhaud <rjuju123@gmail.com>)
Список pgsql-hackers


pá 16. 10. 2020 v 9:43 odesílatel <e.sokolova@postgrespro.ru> napsal:
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!

+1

This is great feature - sometimes it can be pretty messy current limited format

Pavel

--
Ekaterina Sokolova
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company

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

Предыдущее
От: Kyotaro Horiguchi
Дата:
Сообщение: Re: shared-memory based stats collector
Следующее
От: "movead.li@highgo.ca"
Дата:
Сообщение: Re: Wrong statistics for size of XLOG_SWITCH during pg_waldump.