Re: [Proposal] Add accumulated statistics for wait event

Поиск
Список
Период
Сортировка
От Egor Rogov
Тема Re: [Proposal] Add accumulated statistics for wait event
Дата
Msg-id 40e27596-90dc-1c24-9ad6-bebd3e7a31fa@postgrespro.ru
обсуждение исходный текст
Ответ на Re: [Proposal] Add accumulated statistics for wait event  (Michael Paquier <michael@paquier.xyz>)
Список pgsql-hackers
Hi,

that will be a great feature.


On 23.07.2018 10:53, Michael Paquier wrote:
> I have comments about your patch.  First, I don't think that you need to
> count precisely the number of wait events triggered as usually when it
> comes to analyzing a workload's bottleneck what counts is a periodic
> *sampling* of events

If I get it right, this patch is not about sampling. It gathers 
cumulative statistics, which is regrettably missing in PostgreSQL. 
That's why it should not only count exact number of wait events, but 
also min time and stddev would be helpful (as in pg_stat_statements).

--
Egor Rogov
Postgres Professional http://www.postgrespro.com



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

Предыдущее
От: Ashutosh Bapat
Дата:
Сообщение: Re: [HACKERS] advanced partition matching algorithm forpartition-wise join
Следующее
От: Michael Paquier
Дата:
Сообщение: Re: [bug fix] Produce a crash dump before main() on Windows