retrieve statement from catalogs

Jaime Casanova <el_vigia_ec@hotmail.com>

From: "Jaime Casanova" <el_vigia_ec@hotmail.com>
To: pgsql-general@postgresql.org
Date: 2003-10-28T09:03:12Z
Lists: pgsql-general
Hi everybody, can anyone tell me if there's a way to retrieve the select 
instruction executed from the catalogs, or maybe via some structure in a 
trigger?

The reason is that i have some selects constructed on-the-fly (just part of 
it) and i want to save that in a table in order to know what are the most 
used for optimizing them.

Another reason for doing that is that i don't know all the selects in the 
program nor the page and this is an easier solution than examine all the 
code.

thanx in advance, el_vigia

_________________________________________________________________
STOP MORE SPAM with the new MSN 8 and get 2 months FREE* 
http://join.msn.com/?page=features/junkmail