Waiting connections postgres 10 - Mailing list pgsql-general

From Nicola Contu
Subject Waiting connections postgres 10
Date
Msg-id e7a0c47ac21d455ca8e4ba9642c83dd5@gtt.net
Whole thread Raw
Responses Re: Waiting connections postgres 10  (Michael Paquier <michael@paquier.xyz>)
List pgsql-general

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

pgsql-general by date:

Previous
From: Sandy Becker
Date:
Subject: Re: Connections on cluster not being logged
Next
From: Andres Freund
Date:
Subject: Re: Improving pg_dump performance