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.
signature.asc
Description: Digital signature