Waiting connections postgres 10

Поиск
Список
Период
Сортировка
От Nicola Contu
Тема Waiting connections postgres 10
Дата
Msg-id e7a0c47ac21d455ca8e4ba9642c83dd5@gtt.net
обсуждение исходный текст
Ответы Re: Waiting connections postgres 10
Список 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 по дате отправления:

Предыдущее
От: Sandy Becker
Дата:
Сообщение: Re: Connections on cluster not being logged
Следующее
От: Andres Freund
Дата:
Сообщение: Re: Improving pg_dump performance