Waiting connections postgres 10

[Nicola Contu <Nicola.Contu@xxxxxxx>]

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 getting the right information.

select count (*) from pg_stat_activity where wait_event_type ='Client' and wait_event IN ('ClientRead','ClienteWrite') and state='idle'

Can anyone help me?

Thanks