Re: Waiting connections postgres 10

2018-07-23 Thread Michael Paquier
On Mon, Jul 23, 2018 at 04:41:59PM +, Nicola Contu wrote: > we used to monitor waiting connections with postgres 9.6.6 via this > query: > > select count (*) from pg_stat_activity where wait_event IS NOT NULL Please note that a wait event becomes NULL once it is reset, so what this query doe

Waiting connections postgres 10

2018-07-23 Thread Nicola Contu
Hello, we used to monitor waiting connections with postgres 9.6.6 via this query : select count (*) from pg_stat_activity where wait_event IS NOT NULL Now with postgres 10 it seems a bit harder to understand when a query from the application is waiting. I built this query but not sure I'm