[ANNOUNCE] echoping 6, with a PostgreSQL plugin

From: Stephane Bortzmeyer <bortzmeyer(at)nic(dot)fr>
To: pgsql-general(at)postgresql(dot)org
Subject: [ANNOUNCE] echoping 6, with a PostgreSQL plugin
Date: 2007-03-28 10:07:25
Message-ID: 20070328100725.GC15027@nic.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Browse pgsql-general by date

  From Date Subject
Next Message Ragnar 2007-03-28 10:11:42 Re: Query that does not use indexes
Previous Message andant 2007-03-28 09:27:45 Codifica database