Re: Printing query durations

From: Oliver Jowett <oliver(at)opencloud(dot)com>
To: Dave Cramer <pg(at)fastcrypt(dot)com>
Cc: Kevin Dorne <kevin(at)catalyst(dot)net(dot)nz>, pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Printing query durations
Date: 2006-03-29 01:57:03
Message-ID: 4429E96F.5000502@opencloud.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Kevin Dorne 2006-03-29 01:59:33 Re: Printing query durations
Previous Message Dave Cramer 2006-03-29 01:50:26 Re: Printing query durations