retrieve statement from catalogs - Mailing list pgsql-general

From Jaime Casanova
Subject retrieve statement from catalogs
Date
Msg-id BAY8-F59TEF8ta3IaUv00003c9c@hotmail.com
Whole thread Raw
Responses Re: retrieve statement from catalogs
Re: retrieve statement from catalogs
List 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


pgsql-general by date:

Previous
From: Mark Kirkwood
Date:
Subject: Re: Recomended FS
Next
From: Tino Wildenhain
Date:
Subject: Re: PostgreSQL with MS Query?