Log Analyzer : pgFouine http://pgfoundry.org/projects/pgfouine/ Regards, Le samedi 29 décembre 2007, Ivan Sergio Borgonovo a écrit : > On Sat, 29 Dec 2007 10:16:50 +0100 > > Andreas Kretschmer <akretschmer@xxxxxxxxxxxxx> wrote: > > Ivan Sergio Borgonovo <mail@xxxxxxxxxxxxxxx> schrieb: > > > or/and is there something to spot what are the most critical sql > > > queries/function behind an application? > > > > You can set "log_min_duration_statement" in your postgresql.conf to > > log all querys with a duration highter than that value. > > That is interesting but it may be misleading (something that is below > the threshold but get used thousands time won't be spotted). > > What about a log analyser? > What about a configuration wizard that eat your logs and suggest > improvement to the config? -- Hervé Piedvache ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
