| From: | Richard Huxton <dev(at)archonet(dot)com> |
|---|---|
| To: | "Areski" <areski5(at)hotmail(dot)com>, <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Last queries |
| Date: | 2002-11-26 10:54:51 |
| Message-ID: | 200211261054.51064.dev@archonet.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Tuesday 26 Nov 2002 10:31 am, Areski wrote:
> Hello All,
>
>
> I would like to know if there are a way to see the lasts queries executed.
> For example, if you work with php then apache interact with the postmaster
> to run your queries. Then it's could be really interresting to intend to
> find
> the slowest queries of my web application.
>
> I know that in Mysql there are a log file in which it is stored !
There are settings in postgresql.conf to control what gets logged - I
personally like to log using the system logger, but that's not your only
option.
See the administrator's manual - 3.4.2. Logging and Debugging
--
Richard Huxton
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Shridhar Daithankar | 2002-11-26 11:00:03 | Re: COPY COMMAND |
| Previous Message | Tino Wildenhain | 2002-11-26 10:52:37 | Re: COPY COMMAND |