From: | "David Busby" <busby(at)pnts(dot)com> |
---|---|
To: | "Jaime Casanova" <el_vigia_ec(at)hotmail(dot)com>, <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:54:32 |
Message-ID: | 006d01c3a582$1beb68d0$1100000a@busbydev |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-general pgsql-hackers |
Can you just use the SQL logging and read that file afterwords?
/djb
----- Original Message -----
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>
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
From | Date | Subject | |
---|---|---|---|
Next Message | Juan Miguel | 2003-11-07 22:56:04 | Re: Postgres Web Page |
Previous Message | Tom Lane | 2003-11-07 20:49:52 | Re: Out of buffer error |
From | Date | Subject | |
---|---|---|---|
Next Message | Jaime Casanova | 2003-11-07 22:59:39 | Re: [GENERAL] [HACKERS] retrieve statement from catalogs |
Previous Message | Ben | 2003-11-07 22:53:09 | Re: Temp rows - is it possible? |
From | Date | Subject | |
---|---|---|---|
Next Message | Jaime Casanova | 2003-11-07 22:59:39 | Re: [GENERAL] [HACKERS] retrieve statement from catalogs |
Previous Message | Brad | 2003-11-07 22:26:15 | Setting client encoding with jdbc |