Re: duration logging setting in 7.4

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Ryszard Lach <siaco(at)autograf(dot)pl>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: duration logging setting in 7.4
Date: 2003-11-18 02:37:07
Message-ID: 200311180237.hAI2b7s29417@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Ryszard Lach wrote:
>
> Hi.
>
> I'm trying to set run-time environment in pgsql7.4 so, that it prints
> all statements with duration time, but I can't understand why setting
> log_min_duration_statement to '0' causes printing to syslog plenty of
> lines ending with 'duration: statement:', i.e. without any statement
> string (except expected ones). Can anybody help me?

Can you show us some of the log file? If I do:

test=> set log_min_duration_statement = 0;
SET
test=> select 1;
?column?
----------
1
(1 row)

I get:

LOG: duration: 0.861 ms statement: select 1;

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2003-11-18 07:34:52 Re: start of transaction (was: Re: [PERFORM] Help with count(*))
Previous Message Bruce Momjian 2003-11-18 00:52:51 Re: start of transaction (was: Re: [PERFORM] Help with count(*))