From 3964c072076baa39f58823f1c124d8f02d35dd7e Mon Sep 17 00:00:00 2001 From: dumpfmprod Date: Wed, 19 May 2010 20:58:20 -0400 Subject: Set slow query threshold to 250ms --- conf/postgresql.conf | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'conf') diff --git a/conf/postgresql.conf b/conf/postgresql.conf index 9f4c629..d89fca0 100644 --- a/conf/postgresql.conf +++ b/conf/postgresql.conf @@ -237,7 +237,7 @@ shared_buffers = 28MB # min 128kB # requires logging_collector to be on. # This is used when logging to stderr: -#logging_collector = off # Enable capturing of stderr and csvlog +#logging_collector = off # Enable capturing of stderr and csvlog # into log files. Required to be on for # csvlogs. # (change requires restart) @@ -314,7 +314,7 @@ shared_buffers = 28MB # min 128kB # fatal # panic (effectively off) -#log_min_duration_statement = -1 # -1 is disabled, 0 logs all statements +log_min_duration_statement = 250 # -1 is disabled, 0 logs all statements # and their durations, > 0 logs only # statements running at least this number # of milliseconds -- cgit v1.2.3-70-g09d2