Re: Performance monitoring - Mailing list pgsql-hackers

From Zdenek Kotala
Subject Re: Performance monitoring
Date
Msg-id 46484431.1070307@sun.com
Whole thread Raw
In response to Re: Performance monitoring  (Heikki Linnakangas <heikki@enterprisedb.com>)
List pgsql-hackers
Heikki Linnakangas napsal(a):
> Jim C. Nasby wrote:

> 
> There is two counters for checkpoints in pgstats, the number of timed 
> (triggered by checkpoint_timeout) and requested (triggered by 
> checkpoint_segments) checkpoints.
> 
> 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..

Whats about add some DTrace probes?
    Zdenek



pgsql-hackers by date:

Previous
From: "Zeugswetter Andreas ADI SD"
Date:
Subject: Re: What is happening on buildfarm member baiji?
Next
From: Heikki Linnakangas
Date:
Subject: Re: Seq scans roadmap