Can you just use the SQL logging and read that file afterwords?

/djb

----- Original Message ----- 
From: "Jaime Casanova" <el_vigia_ec@hotmail.com>
To: <pgsql-general@postgresql.org>; <pgsql-admin@postgresql.org>;
<pgsql-hackers@postgresql.org>
Sent: Friday, November 07, 2003 14:59
Subject: Re: [GENERAL] [ADMIN] [HACKERS] retrieve statement from catalogs


>
> 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
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster


Fri, 7 Nov 2003 14:54:32 -0800
"David Busby" <busby@pnts.com>
Re: [GENERAL] [HACKERS] retrieve statement from catalogs

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


Fri, 07 Nov 2003 22:59:39 +0000
"Jaime Casanova" <el_vigia_ec@hotmail.com>
Re: [GENERAL] [HACKERS] retrieve statement from catalogs