From: | John R Pierce <pierce(at)hogranch(dot)com> |
---|---|
To: | Shahaf Abileah <shahaf(at)redfin(dot)com> |
Cc: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | Re: Tracing SQL statements per page/request |
Date: | 2008-08-20 21:48:10 |
Message-ID: | 48AC911A.5060001@hogranch.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
Shahaf Abileah wrote:
>
> 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.
>
enable statement logging on the postgres server, then filter (grep) the
logfile to just list the connection and database you are interested in
and pipe that to wc -l
From | Date | Subject | |
---|---|---|---|
Next Message | Guillaume Cottenceau | 2008-08-21 09:28:36 | Re: Tracing SQL statements per page/request |
Previous Message | Shahaf Abileah | 2008-08-20 21:05:43 | Tracing SQL statements per page/request |