Re: Last queries - Mailing list pgsql-general

From Richard Huxton
Subject Re: Last queries
Date
Msg-id 200211261054.51064.dev@archonet.com
Whole thread Raw
In response to Last queries  ("Areski" <areski5@hotmail.com>)
List 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

pgsql-general by date:

Previous
From: "Shridhar Daithankar"
Date:
Subject: Re: COPY COMMAND
Next
From: "SZŰCS Gábor"
Date:
Subject: Re: query visibility - trigger order - bug?