Thread: Log Slow Queries
Hi Guys, Is there a feature in PostgreSQL like "--log-slow-queries"(MySQL) ??? Regards, Marcelo P. _______________________________________________________ Abra sua conta no Yahoo! Mail: 1GB de espaço, alertas de e-mail no celular e anti-spam realmente eficaz. http://br.info.mail.yahoo.com/
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 See http://www.postgresql.org/docs/8.1/interactive/runtime-config-logging.html#RUNTIME-CONFIG-LOGGING-WHEN for more info. This will go into the main log file, it won't create a separate log (as slow-queries allows you to do in mysql). -- Postgresql & php tutorials http://www.designmagick.com/
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.