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 23C1CD1C975 for ; Mon, 17 Nov 2003 22:22:07 +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 65292-09 for ; Mon, 17 Nov 2003 18:21:38 -0400 (AST) Received: from nitrogen.id.pl (nitrogen.id.pl [193.178.214.5]) by svr1.postgresql.org (Postfix) with SMTP id 4D5DDD1CA06 for ; Mon, 17 Nov 2003 18:21:14 -0400 (AST) Received: (qmail 8003 invoked by uid 0); 17 Nov 2003 22:21:00 -0000 Received: from unknown (HELO siaco.id.pl) (213.25.114.8) by smtp.id.pl with SMTP; 17 Nov 2003 22:21:00 -0000 Received: (qmail 4818 invoked by uid 1000); 17 Nov 2003 22:20:59 -0000 Date: Mon, 17 Nov 2003 23:20:58 +0100 From: Ryszard Lach To: pgsql-performance@postgresql.org Subject: duration logging setting in 7.4 Message-ID: <20031117222058.GD3248@siaco.id.pl> Reply-To: Ryszard Lach Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-2 Content-Disposition: inline X-My-GPG-Key: echo | mail -s "send key pub" ryszard@lach.name User-Agent: Mutt/1.5.4i X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200311/138 X-Sequence-Number: 4698 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? Richard. -- "First they ignore you. Then they laugh at you. Then they fight you. Then you win." - Mohandas Gandhi.