Re: [GENERAL] Postgres connection Monitor - Mailing list pgsql-general

From Jan de Visser
Subject Re: [GENERAL] Postgres connection Monitor
Date
Msg-id CAD7bhkGQJ-PR_o0Kix=ZGJ7Q4_7PpQNFL-+QqR+osrctjRgZYw@mail.gmail.com
Whole thread Raw
In response to [GENERAL] Postgres connection Monitor  (basti <mailinglist@unix-solution.de>)
List 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 by date:

Previous
From: pinker
Date:
Subject: Re: [GENERAL] Query which "never" terminates
Next
From: Viktor Fougstedt
Date:
Subject: Re: [GENERAL] Query which "never" terminates