From: Steve Crawford <scrawford@pinpointresearch.com>
To: AA <araskoktas@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: min duration logging
Date: Tue, 11 Oct 2011 12:52:35 -0700
Message-ID: <4E949E83.20603@pinpointresearch.com> (raw)
In-Reply-To: <CAC44bgq-74gpZHRY=tNQrHVdeXD_r7ut7L_gXcakA1i_VC2mgw@mail.gmail.com>
References: <CAC44bgq-74gpZHRY=tNQrHVdeXD_r7ut7L_gXcakA1i_VC2mgw@mail.gmail.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: scrawford@pinpointresearch.com, araskoktas@gmail.com
Subject: Re: min duration logging
In-Reply-To: <4E949E83.20603@pinpointresearch.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox