On 2020-Jul-10, Daniel Wood wrote:
> After nearly 5 years does something like the following yet exist?
> https://www.postgresql.org/message-id/559D4729.9080704@postgrespro.ru
Yes, we have pg_stat_activity.wait_events which implement pretty much
what Ildus describes there.
> 1) An option to "explain" to produce a wait events profile.
> postgres=# explain (analyze, waitprofile) update pgbench_accounts set bid=bid+1 where aid < 2000000;
> ...
> Execution time: 23111.231 ms
There's an out-of-core extension, search for pg_wait_sampling. I
haven't tested it yet ...
--
Álvaro Herrera https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services