Skip site navigation (1) Skip section navigation (2)

Re: top for postgresql (ptop?)

From: Satoshi Nagayasu <nagayasus(at)nttdata(dot)co(dot)jp>
To: Mark Wong <markwkm(at)gmail(dot)com>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: top for postgresql (ptop?)
Date: 2007-09-26 03:39:42
Message-ID: 46F9D47E.1070002@nttdata.co.jp (view raw or flat)
Thread:
Lists: pgsql-hackers
Mark,

Very interesting. I'm looking for such tool.

Unfortunately, I can't compile it on my Solaris right now,
but I hope it will be shipped with PostgreSQL distribution.

Mark Wong wrote:
> Hi everyone,
> 
> I was playing with converting unixtop (the version of top used in
> FreeBSD) to only show PostgreSQL processes pulled from the
> pg_stat_activity table.  I have a version that kind of works here:
> 
> http://pgfoundry.org/frs/download.php/1468/ptop-3.6.1-pre6.tar.gz
> 
> I've tried it on FreeBSD and Linux, not sure about other platforms
> though.  So it looks a lot like top and can currently do a few simple
> things like display the current_query from pg_stat_activity for a
> given process, show the locks held by a process and on which tables,
> and show the query plan for the current query.  It is a ways from
> polished (not really documented, etc.) but I wanted to see what people
> thought of a text/curses sort of monitoring tool like this.  Maybe
> something to distribute with PostgreSQL? :)
> 
> Forgive me if I didn't try out pgtop (the CPAN module.)
> 
> Regards,
> Mark
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster


-- 
NAGAYASU Satoshi <nagayasus(at)nttdata(dot)co(dot)jp>
Phone: +81-50-5546-2496


In response to

Responses

pgsql-hackers by date

Next:From: Tom LaneDate: 2007-09-26 03:42:14
Subject: Re: plpgsql TABLE patch
Previous:From: Neil ConwayDate: 2007-09-26 03:36:27
Subject: Re: plpgsql TABLE patch

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group