Postgres connection Monitor

Started by bastialmost 9 years ago2 messagesgeneral
Jump to latest
#1basti
mailinglist@unix-solution.de

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 ?

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

#2Jan de Visser
jan@de-visser.net
In reply to: basti (#1)
Re: Postgres connection Monitor

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.

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general