Determining DML is used most??? - Mailing list pgsql-admin

From King_Henree@yahoo.com
Subject Determining DML is used most???
Date
Msg-id 20030116185326.56917.qmail@web12907.mail.yahoo.com
Whole thread Raw
List 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

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: asynchronous psql command options?
Next
From: Christopher Smith
Date:
Subject: Re: asynchronous psql command options?