Thread: On-line / off-line trace of SQL statements presented to the Postgres SQL engine
On-line / off-line trace of SQL statements presented to the Postgres SQL engine
From
Gino.Barille@gmail.com
Date:
We are using a three-tier application with J2EE, JBoss, Hibernate and a Postgres database. It would be a nice thing to monitor or trace the actual SQL statements processed by the DB. I do not really need the result set as I can get this - if required - using SQL against the DB through the Pgsql interface. Main thing is to know exactly what the database is presented after a GUI click. Very likely that this is more of a Hibernate question but I assume the same desire has been satisfied in some way by this audience.
Re: On-line / off-line trace of SQL statements presented to the Postgres SQL engine
From
Bill Moran
Date:
In response to Gino.Barille@gmail.com: > We are using a three-tier application with J2EE, JBoss, Hibernate and > a Postgres database. > > It would be a nice thing to monitor or trace the actual SQL statements > processed by the DB. I do not really need the result set as I can get > this - if required - using SQL against the DB through the Pgsql > interface. > > Main thing is to know exactly what the database is presented after a > GUI click. > > Very likely that this is more of a Hibernate question but I assume the > same desire has been satisfied in some way by this audience. See the docs. postgresql.conf has options to log every SQL statement, or to log only the SQL statements that exceed a certain time limit. Unless I'm misunderstanding your question? -- Bill Moran http://www.potentialtech.com
Re: On-line / off-line trace of SQL statements presented to the Postgres SQL engine
From
Aurynn Shaw
Date:
> We are using a three-tier application with J2EE, JBoss, Hibernate and > a Postgres database. > > It would be a nice thing to monitor or trace the actual SQL statements > processed by the DB. I do not really need the result set as I can get > this - if required - using SQL against the DB through the Pgsql > interface. You can configure Postgres to give you this information in the logfiles, or before you execute any queries on your connection. The configuration option in postgresql.conf is, I believe, log_statement. Alternatively, you can run SET log_statement to 'all'; on your JDBC connection before your application begins to query the database. http://www.postgresql.org/docs/8.2/static/runtime-config-logging.html Hope that helps. Aurynn Shaw The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564 PostgreSQL Replication, Consulting, Custom Development, 24x7 support ashaw@commandprompt.com