pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Ryszard Lach <ryszard@lach.name>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-performance@postgresql.org, Bruce Momjian <pgman@candle.pha.pa.us>
Subject: Re: duration logging setting in 7.4
Date: Fri, 21 Nov 2003 11:18:54 +0100
Message-ID: <20031121101854.GA1106@siaco.id.pl> (raw)
In-Reply-To: <7948.1069373821@sss.pgh.pa.us>
References: <20031117222058.GD3248@siaco.id.pl>
	<200311180237.hAI2b7s29417@candle.pha.pa.us>
	<20031118091646.GA8223@siaco.id.pl>
	<7948.1069373821@sss.pgh.pa.us>


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.



view thread (12+ messages)  latest in thread

Message-ID: <20031121101854.GA1106@siaco.id.pl>
Permalink:  ../20031121101854.GA1106@siaco.id.pl/
Also on:    postgresql.org/message-id/20031121101854.GA1106@siaco.id.pl

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: ryszard@lach.name, tgl@sss.pgh.pa.us, pgman@candle.pha.pa.us
  Subject: Re: duration logging setting in 7.4
  In-Reply-To: <20031121101854.GA1106@siaco.id.pl>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox