Re: [GENERAL] [ADMIN] retrieve statement from catalogs - Mailing list pgsql-hackers

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


pgsql-hackers by date:

Previous
From: "scott.marlowe"
Date:
Subject: Re: Performance features the 4th
Next
From: Dave Cramer
Date:
Subject: Re: What do you want me to do?