Waiting connections postgres 10

[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 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