Hosting Provided By

Re: [GENERAL] Is there something like MySQL enterprise monitor for Postgres?

From: Ivan Sergio Borgonovo <mail(at)webthatworks.it>
Date: Sat Dec 29 2007 - 06:04:55 EST

On Sat, 29 Dec 2007 10:16:50 +0100
Andreas Kretschmer <akretschmer@spamfence.net> wrote:

> Ivan Sergio Borgonovo <mail@webthatworks.it> 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

Received on Sat Dec 29 05:56:18 2007

This message: [ Message body ]
Next message: Hervé Piedvache: "Re: [GENERAL] Is there something like MySQL enterprise monitor for Postgres?"
Previous message: Andreas Kretschmer: "Re: [GENERAL] Is there something like MySQL enterprise monitor for Postgres?"
In reply to: Andreas Kretschmer: "Re: [GENERAL] Is there something like MySQL enterprise monitor for Postgres?"
Next in thread: Hervé Piedvache: "Re: [GENERAL] Is there something like MySQL enterprise monitor for Postgres?"
Reply: Hervé Piedvache: "Re: [GENERAL] Is there something like MySQL enterprise monitor for Postgres?"

Contemporary messages sorted: [ By Date ] [ By Thread ] [ By Subject ] [ By Author ] [ By messages with attachments ]

This archive was generated by hypermail 2.1.8 : Mon Jun 16 2008 - 23:01:06 EDT