Lists: | pgsql-hackers |
---|
From: | "David Parker" <dparker(at)tazznetworks(dot)com> |
---|---|
To: | <pgsql-hackers(at)postgresql(dot)org> |
Subject: | logging sql from JDBC |
Date: | 2005-05-25 16:03:36 |
Message-ID: | 07FDEE0ED7455A48AC42AC2070EDFF7C7466C6@corpsrv2.tazznetworks.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-hackers |
It appears that SQL submited via the latest JDBC driver won't get logged
even if log_min_duration_statement is set appropriately. From what I've
found in the archives, this is because the driver uses an "extended"
version of the protocol.
Could somebody point me at the area of the source where this decision
gets made, and/or how difficult it would be to enable this logging?
Thanks!
- DAP
------------------------------------------------------------------------
----------
David Parker Tazz Networks (401) 709-5130
From: | Simon Riggs <simon(at)2ndquadrant(dot)com> |
---|---|
To: | David Parker <dparker(at)tazznetworks(dot)com> |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: logging sql from JDBC |
Date: | 2005-05-27 15:45:24 |
Message-ID: | 1117208724.3844.556.camel@localhost.localdomain |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-hackers |
On Wed, 2005-05-25 at 12:03 -0400, David Parker wrote:
> Could somebody point me at the area of the source where this decision
> gets made, and/or how difficult it would be to enable this logging?
This has just been fixed for 8.1, patch recently submitted.
In the meantime, use p6spy
Best Regards, Simon Riggs