> 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