OK, I have finished the first version of my performance monitor. You
can get the TCL code at:
ftp://candle.pha.pa.us/pub/postgresql/pgtop.tcl
Once people like it, I will add it to CVS /contrib. It probably will
only work only *BSD and Linux right now. It tries to find the USER and
COMMAND columns of ps, and gets the PostgreSQL username by looking at
the owner of the /tmp socket file or the owner of the postmaster
process.
I have added many comments, so hopefully people can make suggestions to
get it working on more platforms. Right now, it doesn't show anything
except 'ps' output. I also want to add the ability for it to sort on
certain columns.
Attached is a screenshot for the curious.
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026