Re: [Proposal] Add accumulated statistics for wait event

Thomas Kellerer <spam_eater@gmx.net>

From: Thomas Kellerer <spam_eater@gmx.net>

To: pgsql-hackers@postgresql.org

Date: 2018-07-23T08:20:13Z

Lists: pgsql-hackers

> This proposal is about recording additional statistics&nbsp;of&nbsp;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