Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group