Re: Query timing - Mailing list pgsql-general

From Robert Treat
Subject Re: Query timing
Date
Msg-id 200703052251.58901.xzilla@users.sourceforge.net
Whole thread Raw
In response to Re: Query timing  (Naz Gassiep <naz@mira.net>)
List pgsql-general
On Monday 05 March 2007 02:38, Naz Gassiep wrote:
> That's not quite as fast as I would like to do it, that throws in a few
> more steps which slow down the development process. However if there is
> no way I will persevere with the method I have now.
> Thanks,
> - Naz.
>

There are several logging parameters in the postgresql.conf, including
log_duration.  Logging to a file also has a bonus that you can feed it into a
query analyzing program like pgfouine or pqa.

--
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: pq_flush: send() failed: Broken pipe
Next
From: Robert Treat
Date:
Subject: Re: real multi-master replication?