Waiting connections postgres 10

From: Nicola Contu <Nicola(dot)Contu(at)gtt(dot)net>
To: "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Cc: Alessandro Aste <alessandro(dot)aste(at)gtt(dot)net>
Subject: Waiting connections postgres 10
Date: 2018-07-23 16:41:59
Message-ID: e7a0c47ac21d455ca8e4ba9642c83dd5@gtt.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andres Freund 2018-07-23 18:41:22 Re: Improving pg_dump performance
Previous Message Sandy Becker 2018-07-23 16:20:13 Re: Connections on cluster not being logged