29 Dec
2007
29 Dec
'07
1:44 p.m.
On Sat, 29 Dec 2007 09:44:27 +0100 Dries Buytaert <dries.buytaert@gmail.com> wrote:
I just asked on pg mailing list if there are similar tools for postgress and I got 2 suggestions: 1) Log Analyzer : pgFouine http://pgfoundry.org/projects/pgfouine/ 2) "set "log_min_duration_statement" in your postgresql.conf to log all querys with a duration highter than that value" thx to Andreas Kretschmer and Hervé Piedvache. pfFouine is GPLed. They don't help in tuning pgsql config but they help to track down which are the most critical queries. -- Ivan Sergio Borgonovo http://www.webthatworks.it