Re: Printing query durations - Mailing list pgsql-jdbc

From Oliver Jowett
Subject Re: Printing query durations
Date
Msg-id 4429E96F.5000502@opencloud.com
Whole thread Raw
In response to Re: Printing query durations  (Dave Cramer <pg@fastcrypt.com>)
Responses Re: Printing query durations  (Kevin Dorne <kevin@catalyst.net.nz>)
List pgsql-jdbc
Dave Cramer wrote:
> Kevin,
>
> Well, the server doesn't really know the difference between a query
> from jdbc vs a query from psql. The only difference is how they
> connect. psql usually connects to a unix domain socket, whereas jdbc
> connects via a tcpip socket. Even this behaviour can be changed in  psql
> by specifying -h <hostname>

Well, there is actually quite a big difference.

psql uses the simple query protocol. JDBC uses the extended query protocol.

See previous discussion on -hackers about the difficulties in logging
the extended query protocol usefully..

-O

pgsql-jdbc by date:

Previous
From: Dave Cramer
Date:
Subject: Re: Printing query durations
Next
From: Kevin Dorne
Date:
Subject: Re: Printing query durations