Re: duration logging setting in 7.4 - Mailing list pgsql-performance

From Ryszard Lach
Subject Re: duration logging setting in 7.4
Date
Msg-id 20031121101854.GA1106@siaco.id.pl
Whole thread Raw
In response to Re: duration logging setting in 7.4  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
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.

pgsql-performance by date:

Previous
From: "Matthew T. O'Connor"
Date:
Subject: Re: [HACKERS] More detail on settings for pgavd?
Next
From: Adam Witney
Date:
Subject: Re: Hardware advice