Re: Performance monitoring - Mailing list pgsql-hackers

From Jim C. Nasby
Subject Re: Performance monitoring
Date
Msg-id 20070513204640.GL60707@nasby.net
Whole thread Raw
In response to Re: Performance monitoring  (Heikki Linnakangas <heikki@enterprisedb.com>)
List pgsql-hackers
On Sun, May 13, 2007 at 07:54:20AM +0100, Heikki Linnakangas wrote:
> Maybe we should improve the stats system so that we can collect events 
> with timestamps and durations, but in my experience log files actually 
> are the most reliable and universal way to collect real-time performance 
> information. Any serious tool has a generic log parser. The other 
> alternative is SNMP. I welcome the efforts on pgsnmpd..

Having timing information in the stats system would be useful, but I'm
not sure how it could actually be done. But at least if the information
is in the stats system it's easy to programatically collect and process.
SNMP is just one example of that (fwiw I agree with Magnus that it
probably doesn't make sense to turn pgsnmpd into a log parser...)
-- 
Jim Nasby                                      decibel@decibel.org
EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: What is happening on buildfarm member baiji?
Next
From: Andrew Dunstan
Date:
Subject: Re: small problem with compilation 8.3 on Fedora Core (contrib/uuid-ossp)