retrieve statement from catalogs

[Jaime Casanova]

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
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postgresql.org so that your
message can get through to the mailing list cleanly

[Andrew Sullivan]

On Tue, Oct 28, 2003 at 09:03:12AM +0000, Jaime Casanova wrote:

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?

You could turn on query logging and read the Postgres logs.

A

--
----
Andrew Sullivan 204-4141 Yonge Street
Afilias Canada Toronto, Ontario Canada
<an****@libertyrms.info> M2P 2A8
[phone] x110
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend