Re: Wait profiling

2020-07-11 Thread Julien Rouhaud
On Fri, Jul 10, 2020 at 10:37 PM Alvaro Herrera wrote: > > 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 implem

Re: Wait profiling

2020-07-10 Thread Alvaro Herrera
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 "expl

Wait profiling

2020-07-10 Thread Daniel Wood
After nearly 5 years does something like the following yet exist? https://www.postgresql.org/message-id/559d4729.9080...@postgrespro.ru I feel that it would be useful to have the following two things. One PG enhancement and one standard extension. 1) An option to "explain" to produce a wait eve