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.9080...@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
