Thread: Logging statements longer than 1000ms doesn't appear to work

I've have set the parameter in my postgresql.conf file and have restarted postgres.
When reviewing the log file I am finding that all of the statements are being logged (0.108 ms)?
 
Is there some other parameter that I have missed?
 
 
log_min_duration_statement = 1000       # -1 is disabled, 0 logs all statements
 
Chris

---

Windows Live helps you keep up with all your friends, in one place.

Chris Barnes <compuguruchrisbarnes@hotmail.com> writes:
> I've have set the parameter in my postgresql.conf file and have restarted postgres.

> When reviewing the log file I am finding that all of the statements are being logged (0.108 ms)?

Perhaps you also set log_statement = all, or some other reason that
would cause them to be logged?

            regards, tom lane

I checked and this is the only refererences. Were usng 8.3.3.
 
#log_statement = 'none'                 # none, ddl, mod, all
#log_statement_stats = off
 
> To: compuguruchrisbarnes@hotmail.com
> CC: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] Logging statements longer than 1000ms doesn't appear to work
> Date: Tue, 22 Sep 2009 15:08:39 -0400
> From: tgl@sss.pgh.pa.us
>
> Chris Barnes <compuguruchrisbarnes@hotmail.com> writes:
> > I've have set the parameter in my postgresql.conf file and have restarted postgres.
>
> > When reviewing the log file I am finding that all of the statements are being logged (0.108 ms)?
>
> Perhaps you also set log_statement = all, or some other reason that
> would cause them to be logged?
>
> regards, tom lane
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general

---

Create a cool, new character for your Windows Live™ Messenger. Check it out

Hello,
 
I looked for log_statement and it appears to be off? Strange.
 
#log_statement = 'none'
#log_statement_stats = off
 
> To: compuguruchrisbarnes@hotmail.com
> CC: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] Logging statements longer than 1000ms doesn't appear to work
> Date: Tue, 22 Sep 2009 15:08:39 -0400
> From: tgl@sss.pgh.pa.us
>
> Chris Barnes <compuguruchrisbarnes@hotmail.com> writes:
> > I've have set the parameter in my postgresql.conf file and have restarted postgres.
>
> > When reviewing the log file I am finding that all of the statements are being logged (0.108 ms)?
>
> Perhaps you also set log_statement = all, or some other reason that
> would cause them to be logged?
>
> regards, tom lane

---

We are your photos. Share us now with Windows Live Photos.

On Tue, Sep 22, 2009 at 3:55 PM, Gurjeet Singh <singh.gurjeet@gmail.com> wrote:
> Sometimes, your current postgresql.conf might not be in sync with server
> settings, for various reasons. I'd suggest looking at the output of:
>
> select name, setting, source from pg_settings where name like E'log\\_%';

Or

psql dbname
show log_statement;