Thread: Tools / Monitoring
Hi all, I learned mysql has some sort of "top like" tool, to easily see what is going on in the DB. AFAIK no such cmdline tool exists for Postgres (yet) ? For my own monitoring, I have been using the ever simple "ps axfu" to show processes and usage. I tried using the pgmonitor Tcl thingie, which was sort of nice, but not what I really needed (console based would be ideal). I also tested out Nagios, but found the typical problem of observing inflicting on the performance. (If the frequency of checks was to be high enough to really be useful they would actually produce a non negligeble load on the server just by checking all clusters..) What do other people use to monitor Postgres in a high availability setup ? Any tools I am not aware of ? (must be, there is so much to Postgres by now..) I know a lot of performance / monitoring data can be switched on and accessed low level in postgresql, but have anyone else than Bruce (with his Pgmonitor) done anything with regards to tools ? -- Denis Braekhus - ABC Startsiden AS http://www.startsiden.no
On Wed, 16 Oct 2002 04:47:21 -0400, Denis Braekhus wrote: > I know a lot of performance / monitoring data can be switched on and > access= ed=20 > low level in postgresql, but have anyone else than Bruce (with his > Pgmonito= r)=20 > done anything with regards to tools ?=20 Well, I've written a Perl script for my own use that monitors the contents of the various pg_stat* tables. It's not immediately portable, because it uses local modules not available on CPAN. However, if anyone's interested (and my management will let me*) I could provide it in a form suitable for use or at least as a starting point. *I haven't heard yet whether I may, so don't get your hopes up. But feel free to flood me with email so I have leverage ... -- Jeff Boes vox 616.226.9550 ext 24 Database Engineer fax 616.349.9076 Nexcerpt, Inc. http://www.nexcerpt.com ...Nexcerpt... Extend your Expertise
that would be excellent if you were allowed to release your work...save some of us from reinventing the wheel ;) What do you use from CPAN, anything special beside Pg or DBI? ----- Original Message ----- From: "Jeff Boes" <jboes@nexcerpt.com> To: <pgsql-admin@postgresql.org> Sent: Wednesday, October 16, 2002 6:42 AM Subject: Re: [ADMIN] Tools / Monitoring > On Wed, 16 Oct 2002 04:47:21 -0400, Denis Braekhus wrote: > > > I know a lot of performance / monitoring data can be switched on and > > access= ed=20 > > low level in postgresql, but have anyone else than Bruce (with his > > Pgmonito= r)=20 > > done anything with regards to tools ?=20 > > Well, I've written a Perl script for my own use that monitors the contents of > the various pg_stat* tables. It's not immediately portable, because it > uses local modules not available on CPAN. However, if anyone's > interested (and my management will let me*) I could provide it in a form > suitable for use or at least as a starting point. > > *I haven't heard yet whether I may, so don't get your hopes up. But feel > free to flood me with email so I have leverage ... > > -- > Jeff Boes vox 616.226.9550 ext 24 > Database Engineer fax 616.349.9076 > Nexcerpt, Inc. http://www.nexcerpt.com > ...Nexcerpt... Extend your Expertise > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org) >