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? -- Ivan Sergio Borgonovo http://www.webthatworks.it ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
