Skip site navigation (1) Skip section navigation (2)

Tracing SQL statements per page/request

From: Shahaf Abileah <shahaf(at)redfin(dot)com>
To: <pgsql-jdbc(at)postgresql(dot)org>
Subject: Tracing SQL statements per page/request
Date: 2008-08-20 21:05:43
Message-ID: 082D8A131DF72A4D88C908A1AD3DEB2204A2DABD@mail-1.rf.lan (view raw or flat)
Thread:
Lists: pgsql-jdbc
I'm looking for a general-purpose way to track and report the number of
SQL statements issued to Postgres during the processing of a single page
(a single URL0 on my company's website (www.redfin.com
<http://www.redfin.com/> ).

 

Does the Postgres JDBC driver have any features to help me do this?

 

If not, can someone recommend another approach?  In case it helps, we
use hibernate as our O-R mapping so hibernate is responsible for
generating most (not all) of our SQL queries (some are still issued by
direct SQL).  Also, we use the PostGIS JDBC driver, which is a wrapper
around the standard PostgreSQL JDBC driver.

 

Thanks,

 

--Shahaf

 

Responses

pgsql-jdbc by date

Next:From: John R PierceDate: 2008-08-20 21:48:10
Subject: Re: Tracing SQL statements per page/request
Previous:From: Albe LaurenzDate: 2008-08-19 06:42:10
Subject: Re: Problem escaping, nonstandard use of \\ in a string literal

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group