Re: [Proposal] Add accumulated statistics for wait event

Поиск
Список
Период
Сортировка
От Thomas Kellerer
Тема Re: [Proposal] Add accumulated statistics for wait event
Дата
Msg-id 1532334013158-0.post@n3.nabble.com
обсуждение исходный текст
Список pgsql-hackers
Дерево обсуждения 
> This proposal is about recording additional statistics of wait
events. 
> The pg_stat_activity view is very useful in analysis for performance
> issues. 
> But it is difficult to get information of wait events in detail, 
> when you need to deep dive into analysis of performance. 
> It is because pg_stat_activity just shows the current wait status of
> backend. 

There is an extension that samples the information from pg_stat_activity
(similar to Oracle's ASH). 

https://github.com/postgrespro/pg_wait_sampling

Maybe it's worthwhile to combine the efforts? 




--
Sent from: http://www.postgresql-archive.org/PostgreSQL-hackers-f1928748.html

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

Предыдущее
От: "Tsunakawa, Takayuki"
Дата:
Сообщение: RE: [bug fix] Produce a crash dump before main() on Windows
Следующее
От: Pavel Raiskup
Дата:
Сообщение: pgcrypto: is PGP_PUB_DSA_SIGN used?