X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id EC459D1D643 for ; Fri, 21 Nov 2003 10:19:35 +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 47972-02 for ; Fri, 21 Nov 2003 06:19:07 -0400 (AST) Received: from nitrogen.id.pl (nitrogen.id.pl [193.178.214.5]) by svr1.postgresql.org (Postfix) with SMTP id 7F8EED1B553 for ; Fri, 21 Nov 2003 06:19:03 -0400 (AST) Received: (qmail 31948 invoked by uid 0); 21 Nov 2003 10:18:59 -0000 Received: from unknown (HELO siaco.id.pl) (213.25.114.8) by smtp.id.pl with SMTP; 21 Nov 2003 10:18:58 -0000 Received: (qmail 1823 invoked by uid 1000); 21 Nov 2003 10:18:54 -0000 Date: Fri, 21 Nov 2003 11:18:54 +0100 From: Ryszard Lach To: Tom Lane Cc: pgsql-performance@postgresql.org, Bruce Momjian Subject: Re: duration logging setting in 7.4 Message-ID: <20031121101854.GA1106@siaco.id.pl> Reply-To: Ryszard Lach References: <20031117222058.GD3248@siaco.id.pl> <200311180237.hAI2b7s29417@candle.pha.pa.us> <20031118091646.GA8223@siaco.id.pl> <7948.1069373821@sss.pgh.pa.us> Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-2 Content-Disposition: inline In-Reply-To: <7948.1069373821@sss.pgh.pa.us> 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/217 X-Sequence-Number: 4777 Hi, again. I've turned on only log_connections and log_statement. See the following log fragment (I've included lines only related to opening of new connection); Nov 21 11:06:44 postgres[3359]: [3-1] LOG: connection received: host= port= Nov 21 11:06:44 postgres[3359]: [4-1] LOG: connection authorized: user=pracuj database=pracuj Nov 21 11:06:44 postgres[3359]: [5-1] LOG: statement: set datestyle to 'ISO'; select version(), case when pg_encoding_to_char(1) = 'SQL_ASCII' then 'UNKNOWN' else Nov 21 11:06:44 postgres[3359]: [5-2] getdatabaseencoding() end; Nov 21 11:06:44 postgres[3359]: [6-1] LOG: statement: Nov 21 11:06:44 postgres[3359]: [7-1] LOG: statement: select * from ... Nov 21 11:06:45 postgres[3376]: [3-1] LOG: connection received: host= port= Nov 21 11:06:45 postgres[3376]: [4-1] LOG: connection authorized: user=pracuj database=pracuj Nov 21 11:06:45 postgres[3376]: [5-1] LOG: statement: set datestyle to 'ISO'; select version(), case when pg_encoding_to_char(1) = 'S QL_ASCII' then ' else Nov 21 11:06:45 postgres[3376]: [5-2] getdatabaseencoding() end; Nov 21 11:06:45 postgres[3376]: [6-1] LOG: statement: It seems, that empty statements are generated during opening of connection. Please, note also: 1. We are using an older jdbc driver (pgjdbc2) 2. We ar using encoding in URL (jdbc:postgresql://localhost:5432/database?charSet=iso-8859-1) Richard. -- "First they ignore you. Then they laugh at you. Then they fight you. Then you win." - Mohandas Gandhi.