Re: log_duration_sample config option patch - Mailing list pgsql-hackers

From Euler Taveira de Oliveira
Subject Re: log_duration_sample config option patch
Date
Msg-id 497FC517.4000407@timbira.com
Whole thread Raw
In response to log_duration_sample config option patch  (Timo Savola <timo.savola@dynamoid.com>)
Responses Re: log_duration_sample config option patch
List pgsql-hackers
Timo Savola escreveu:
> Hello.  The attached patch has made it more feasible for us to gather
> profiling data on a production system for analysis with pgFouine.  It
> has been written against PostgreSQL 8.3.5 and tested on Linux.  Comments
> welcome.
> 
IIRC pgFouine shows exact percentage of query by type; this new GUC implies we
can not rely on it anymore. Also, you could skip us from logging long (and
bad) running queries. Another statistics data in pgFouine will suffer from the
same problem. I see your point in reducing amount of log data but I think it
will limit the tool usability (you can always start/stop statement collection
at runtime).


--  Euler Taveira de Oliveira http://www.timbira.com/


pgsql-hackers by date:

Previous
From: Ron Mayer
Date:
Subject: Re: 8.4 release planning
Next
From: KaiGai Kohei
Date:
Subject: Re: 8.4 release planning