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
|
| Список | 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,
--
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
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 по дате отправления: