Re: [HACKERS] log_duration_sample config option patch

2009-01-28 Thread Timo Savola
Euler Taveira de Oliveira wrote: 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

Re: [HACKERS] log_duration_sample config option patch

2009-01-27 Thread Euler Taveira de Oliveira
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 quer

[HACKERS] log_duration_sample config option patch

2009-01-27 Thread Timo Savola
Sorry for the attachment; here's the patch inline. timo From a4d5b489f462ad31b62774ec98af08f184cb0754 Mon Sep 17 00:00:00 2001 From: Timo Savola Date: Thu, 22 Jan 2009 13:02:10 +0200 Subject: [PATCH] log_duration_sample config option When used with the log_duration or the log_min_duration_s

[HACKERS] log_duration_sample config option patch

2009-01-27 Thread Timo Savola
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. timo >From a4d5b489f462ad31b62774ec98af08f184cb0754 Mon Sep 17 00:00:00