On Tue, Apr 04, 2006 at 12:25:09PM +1000, Chris wrote:
> MaRCeLO PeReiRA wrote:
> >Hi Guys,
> >
> >Is there a feature in PostgreSQL like
> >"--log-slow-queries"(MySQL) ???
>
> Unfortunately not.
>
> What you can do is edit your postgresql.conf file and set:
>
> log_min_duration_statement
You can also set it per connection:
test=# set log_min_duration_statement =1;
SET
If you only want it some times but not others.
--
Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/
> Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
> tool for doing 5% of the work and then sitting around waiting for someone
> else to do the other 95% so you can sue them.