| From: | "Jaime Casanova" <el_vigia_ec(at)hotmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org, pgsql-admin(at)postgresql(dot)org, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: [GENERAL] [HACKERS] retrieve statement from catalogs |
| Date: | 2003-11-07 22:59:39 |
| Message-ID: | BAY8-F55gm0YQFM8NC500017346@hotmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-general pgsql-hackers |
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
_________________________________________________________________
Protect your PC - get McAfee.com VirusScan Online
http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Steven Tower | 2003-11-08 13:02:10 | Database Error (Bogus attribute number 24....) |
| Previous Message | Juan Miguel | 2003-11-07 22:56:04 | Re: Postgres Web Page |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Boris Popov | 2003-11-07 23:08:05 | Re: Temp rows - is it possible? |
| Previous Message | David Busby | 2003-11-07 22:54:32 | Re: [GENERAL] [HACKERS] retrieve statement from catalogs |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dave Cramer | 2003-11-07 23:08:45 | Re: What do you want me to do? |
| Previous Message | David Busby | 2003-11-07 22:54:32 | Re: [GENERAL] [HACKERS] retrieve statement from catalogs |