retrieve statement from catalogs

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: Raw Message | Whole Thread | 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

Responses

Browse pgsql-general by date

  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