X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id EC552D1CA63 for ; Tue, 18 Nov 2003 02:38:44 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 14682-04 for ; Mon, 17 Nov 2003 22:38:17 -0400 (AST) Received: from candle.pha.pa.us (unknown [207.106.42.251]) by svr1.postgresql.org (Postfix) with ESMTP id 109B6D1CAD1 for ; Mon, 17 Nov 2003 22:37:05 -0400 (AST) Received: (from pgman@localhost) by candle.pha.pa.us (8.11.6/8.11.6) id hAI2b7s29417; Mon, 17 Nov 2003 21:37:07 -0500 (EST) From: Bruce Momjian Message-Id: <200311180237.hAI2b7s29417@candle.pha.pa.us> Subject: Re: duration logging setting in 7.4 In-Reply-To: <20031117222058.GD3248@siaco.id.pl> To: Ryszard Lach Date: Mon, 17 Nov 2003 21:37:07 -0500 (EST) Cc: pgsql-performance@postgresql.org X-Mailer: ELM [version 2.4ME+ PL108 (25)] MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=US-ASCII X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200311/139 X-Sequence-Number: 4699 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@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073