From: Filippos <filippos.kal@gmail.com>
To: pgsql-admin@postgresql.org
Subject: postgresql monitoring tool (GUI)
Date: Fri, 9 Mar 2012 11:02:31 -0800 (PST)
Message-ID: <1331319751906-5551449.post@n5.nabble.com> (raw)
dear all,
i would like your suggestions about choosing a suitable monitoring tool (if
it exists) to cover our needs. during the last few days i have tried many of
them (i found the related info here ->
http://www.postgresql.org/download/products/1/) and so far, only EMS SQL
Manager for PostgreSQL seems to be covering most of my 'requirements'. in
general the most important requirement we have is to be able to handle the
active sessions of the server. This means, to have an overview of what is
actually running, kill the queries that cause some kind of problem and have
a view of the locks and more specifically of which query is locking what (so
as to be able to handle this situation). For the rest of my requirements, i
have already installed pgwatch which keeps useful information about
sizes,connections,idx_scans,transactions etc.
So, is there any other software that gives you an overview of what is
actually running on the server and the ability to resolve any such problems
(caused by locks, long-opened transactions etc).
thank you in advance for your suggestions
P.S(1) i dont need 'live' data from the db, i can live with polling the data
every minute or so (so i dont necessarily need an agent running and
collecting real-time data)
P.S(2) i know i could do all that from the psql client, using scripts, which
is what i am doing so far (thx to Greg Smith and Simon Riggs for their
wonderful books about postgresql's administration).
i would just like to have a GUI tool as well
--
View this message in context: http://postgresql.1045698.n5.nabble.com/postgresql-monitoring-tool-GUI-tp5551449p5551449.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: filippos.kal@gmail.com
Subject: Re: postgresql monitoring tool (GUI)
In-Reply-To: <1331319751906-5551449.post@n5.nabble.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox