Re: [GENERAL] Postgres connection Monitor

Поиск
Список
Период
Сортировка
От Jan de Visser
Тема Re: [GENERAL] Postgres connection Monitor
Дата
Msg-id CAD7bhkGQJ-PR_o0Kix=ZGJ7Q4_7PpQNFL-+QqR+osrctjRgZYw@mail.gmail.com
обсуждение исходный текст
Ответ на [GENERAL] Postgres connection Monitor  (basti <mailinglist@unix-solution.de>)
Список pgsql-general
On Thu, Apr 27, 2017 at 6:18 AM, basti <mailinglist@unix-solution.de> wrote:
> Hallo, we have a Postgres database Server and around that there are 8
> clients get data from it.
>
> All servers are the the same datacenter i think (traceroute only 4-5 hops)
>
> Now we plan to move the server to an other hoster/datacenter.
>
> I have done simple test with ping and traceroute.
> Is there a way to monitor "traffic times" in postgres ?
> How long a query would take to be answered ?

You could write a tiny little C program which connects and sends a
PQping(), and measure that.


В списке pgsql-general по дате отправления:

Предыдущее
От: pinker
Дата:
Сообщение: Re: [GENERAL] Query which "never" terminates
Следующее
От: Viktor Fougstedt
Дата:
Сообщение: Re: [GENERAL] Query which "never" terminates