On-line / off-line trace of SQL statements presented to the Postgres SQL engine

From: Gino(dot)Barille(at)gmail(dot)com
To: pgsql-general(at)postgresql(dot)org
Subject: On-line / off-line trace of SQL statements presented to the Postgres SQL engine
Date: 2007-05-30 14:32:41
Message-ID: 1180535561.575547.57820@p47g2000hsd.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Paul Tilles 2007-05-30 14:51:38 problem calling psql multiple times from a script ?
Previous Message Gino.Barille 2007-05-30 14:26:49 Database activity monitoring