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

Поиск
Список
Период
Сортировка
От Gurjeet Singh
Тема Re: Logging statements longer than 1000ms doesn't appear to work
Дата
Msg-id 65937bea0909221455x724dffc8mb46a9059806d29ba@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Logging statements longer than 1000ms doesn't appear to work  (Chris Barnes <compuguruchrisbarnes@hotmail.com>)
Ответы Re: Logging statements longer than 1000ms doesn't appear to work  (Scott Marlowe <scott.marlowe@gmail.com>)
Список pgsql-general
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

В списке pgsql-general по дате отправления:

Предыдущее
От: Chris Barnes
Дата:
Сообщение: Re: Logging statements longer than 1000ms doesn't appear to work
Следующее
От: Greg Smith
Дата:
Сообщение: Re: VMWare file system / database corruption