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

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

From
Chris Barnes
Date:
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.

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

From
Tom Lane
Date:
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

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

From
Chris Barnes
Date:
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

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

From
Chris Barnes
Date:
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.

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

From
Gurjeet Singh
Date:
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\\_%';

Best regards,

On Wed, Sep 23, 2009 at 3:13 AM, Chris Barnes <compuguruchrisbarnes@hotmail.com> wrote:
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.



--
Lets call it Postgres

EnterpriseDB      http://www.enterprisedb.com

gurjeet[.singh]@EnterpriseDB.com

singh.gurjeet@{ gmail | hotmail | indiatimes | yahoo }.com
Twitter: singh_gurjeet
Skype: singh_gurjeet

Mail sent from my BlackLaptop device

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

From
Scott Marlowe
Date:
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;