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

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: Gurjeet Singh <singh(dot)gurjeet(at)gmail(dot)com>
Cc: Chris Barnes <compuguruchrisbarnes(at)hotmail(dot)com>, tgl(at)sss(dot)pgh(dot)pa(dot)us, Postgres General Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Logging statements longer than 1000ms doesn't appear to work
Date: 2009-09-22 23:26:54
Message-ID: dcc563d10909221626r66548ce0y566b4ecdb40fb920@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Sep 22, 2009 at 3:55 PM, Gurjeet Singh <singh(dot)gurjeet(at)gmail(dot)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;

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Joe Kramer 2009-09-23 02:28:03 Help! Database restored with disabled triggers
Previous Message Greg Smith 2009-09-22 22:50:29 Re: VMWare file system / database corruption