pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedpostgresql monitoring tool (GUI)
3+ messages / 2 participants
[nested] [flat]
* postgresql monitoring tool (GUI)
@ 2012-03-09 19:02 Filippos <filippos.kal@gmail.com>
0 siblings, 1 reply; 3+ messages in thread
From: Filippos @ 2012-03-09 19:02 UTC (permalink / raw)
To: pgsql-admin
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.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: postgresql monitoring tool (GUI)
@ 2012-03-09 19:33 Rick Dicaire <kritek@gmail.com>
parent: Filippos <filippos.kal@gmail.com>
0 siblings, 1 reply; 3+ messages in thread
From: Rick Dicaire @ 2012-03-09 19:33 UTC (permalink / raw)
To: Filippos <filippos.kal@gmail.com>; +Cc: pgsql-admin
On Fri, Mar 9, 2012 at 2:02 PM, Filippos <filippos.kal@gmail.com> wrote:
> 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
pgAdmin3 can do this. Runs in Windows, Linux, probably others as well.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: postgresql monitoring tool (GUI)
@ 2012-03-09 20:48 Filippos <filippos.kal@gmail.com>
parent: Rick Dicaire <kritek@gmail.com>
0 siblings, 0 replies; 3+ messages in thread
From: Filippos @ 2012-03-09 20:48 UTC (permalink / raw)
To: pgsql-admin
thx a lot
actually i have used pgadminIII a little but i hadnt noticed the 'server
status' before. thank you again for pointing it out :D
--
View this message in context: http://postgresql.1045698.n5.nabble.com/postgresql-monitoring-tool-GUI-tp5551449p5551693.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2012-03-09 20:48 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2012-03-09 19:02 postgresql monitoring tool (GUI) Filippos <filippos.kal@gmail.com>
2012-03-09 19:33 ` Rick Dicaire <kritek@gmail.com>
2012-03-09 20:48 ` Filippos <filippos.kal@gmail.com>
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