[ANNOUNCE] echoping 6, with a PostgreSQL plugin - Mailing list pgsql-general

From Stephane Bortzmeyer
Subject [ANNOUNCE] echoping 6, with a PostgreSQL plugin
Date
Msg-id 20070328100725.GC15027@nic.fr
Whole thread Raw
List pgsql-general
echoping is a program to test and monitor the response time of network
servers, for instance DBMS servers. It is typically used from the
command-line or called repetitively by a monitoring framework such as
SmokePing (http://www.smokeping.org/).

http://echoping.sourceforge.net/

The new version, v6, just released, adds plugin support. Which means
that, if you are not satisfied with the hard-wired protocols, you can
easily develop a plugin for your favorite protocol.

For instance, here is a demo of the PostgreSQL plugin (included with
echoping):

% echoping -n 10 -m postgresql db.example.org -c dbname=lsr2 \
                'SELECT * FROM Languages'
Elapsed time: 0.027410 seconds
Elapsed time: 0.024084 seconds
Elapsed time: 0.021900 seconds
Elapsed time: 0.021903 seconds
Elapsed time: 0.021892 seconds
Elapsed time: 0.021865 seconds
Elapsed time: 0.021886 seconds
Elapsed time: 0.021922 seconds
Elapsed time: 0.021871 seconds
Elapsed time: 0.021873 seconds
---
Minimum time: 0.021865 seconds (11708 bytes per sec.)
Maximum time: 0.027410 seconds (9340 bytes per sec.)
Average time: 0.022660 seconds (11297 bytes per sec.)
Standard deviation: 0.001713
Median time: 0.021896 seconds (11692 bytes per sec.)

You can use echoping to debug performance problems, avoiding the fuzzy
"it seems a bit faster if I remove the constraint" or to monitor
automatically performance issues, to see the slowdowns when
checkpointing runs.

Attachment

pgsql-general by date:

Previous
From: Ragnar
Date:
Subject: Re: Query that does not use indexes
Next
From: "Dmitry Koterov"
Date:
Subject: Re: Strange behaviour under heavy load