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: (view raw, whole thread or download thread mbox)
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;"


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-2017 The PostgreSQL Global Development Group