Determining DML is used most???

From: "King_Henree(at)yahoo(dot)com" <king_henree(at)yahoo(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Determining DML is used most???
Date: 2003-01-16 18:53:26
Message-ID: 20030116185326.56917.qmail@web12907.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello All,

I am using Java J2EE with CMP 2.0 with finders and
selectors with a JBoss 3.0.4 application server and
would like to determine which queries and other DML
are being executed the most. I have thought about
setting up triggers to execute and populate a table
with that information every time a DML statement is
ran, but that does not solve the problem of
determining which SELECT statements are being run
most. Does anyone have any solutions for this?

Thanks.

__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2003-01-16 18:56:53 Re: asynchronous psql command options?
Previous Message Bjoern Metzdorf 2003-01-16 18:06:30 Re: asynchronous psql command options?