Skip site navigation (1) Skip section navigation (2)

Re: min duration logging

From: Steve Crawford <scrawford(at)pinpointresearch(dot)com>
To: AA <araskoktas(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: min duration logging
Date: 2011-10-11 19:52:35
Message-ID: 4E949E83.20603@pinpointresearch.com (view raw or flat)
Thread:
Lists: pgsql-admin
On 10/11/2011 11:23 AM, AA wrote:
> hey all
> trying to find non optimized queries and want to use this logging 
> feature, however postgresql seems to write every query to log.
>
> my conf is as follows...
>
> log_min_duration_statement = 450
> ...

What durations are showing in the log? Are lots/all of the queries you 
run longer than 450ms?


> #log_statement = 'all'
>

I don't know what the config looked like beforehand but did you reload 
PostgreSQL after changing it? You can check the current running settings 
with "show all;"

Cheers,
Steve


In response to

pgsql-admin by date

Next:From: gabriel12345Date: 2011-10-11 20:15:36
Subject: Re: Contents of WAL files
Previous:From: AADate: 2011-10-11 18:23:40
Subject: min duration logging

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group