| From: | "Jaime Casanova" <el_vigia_ec(at)hotmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | retrieve statement from catalogs |
| Date: | 2003-10-28 09:03:12 |
| Message-ID: | BAY8-F59TEF8ta3IaUv00003c9c@hotmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Shridhar Daithankar | 2003-10-28 09:19:06 | Re: retrieve statement from catalogs |
| Previous Message | Tom Lane | 2003-10-28 05:44:45 | Re: SCSI vs. IDE performance test |