Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id D7D65632497 for ; Mon, 19 Jan 2009 11:56:32 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 18496-07 for ; Mon, 19 Jan 2009 11:56:26 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-fx0-f11.google.com (mail-fx0-f11.google.com [209.85.220.11]) by mail.postgresql.org (Postfix) with ESMTP id F3ABB632439 for ; Mon, 19 Jan 2009 11:56:26 -0400 (AST) Received: by fxm4 with SMTP id 4so656722fxm.19 for ; Mon, 19 Jan 2009 07:56:24 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to :subject:cc:in-reply-to:mime-version:content-type :content-transfer-encoding:content-disposition:references; bh=R7pL+HdNa5jg51m1Sv6FSDd1cUQ6w9pGxhVYcxAq/Tg=; b=Igvm9bHe3aGFMlioAFdC5XjojcvDNxsaDg/wXMZkcGn1tyNadfxbDTSBpB4lQ0yXGe lCOh58Fhv2DDTyUr6E8muIuZ5TfTjzSIO2N7MSF0Im7N2iI8c7p9cxT0rWr2VhPAygVZ pK7sxbBCsjV0X0PUsvtUvApF9i5UCQAgj0xhs= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version :content-type:content-transfer-encoding:content-disposition :references; b=xM4/q+Rlt1vO3WPNN+o5TX8YWy3Z+/d9xknfUg+tKCU+/c0yTeFkw0rvc6JNS97Bvf yF7sr08OWXWwjkdISdkQ2RKrjulFIPolvf6U4pEB33NrZVMcZIB1WW/V087f742br4RX ZROTbtsrkqtQcYNAcc6CJo5nXQ0L0K8j736hc= Received: by 10.103.11.7 with SMTP id o7mr61493mui.103.1232380583932; Mon, 19 Jan 2009 07:56:23 -0800 (PST) Received: by 10.103.165.9 with HTTP; Mon, 19 Jan 2009 07:56:23 -0800 (PST) Message-ID: <3786f7bb0901190756h5079eb3ap12bcedbe4ff2053@mail.gmail.com> Date: Mon, 19 Jan 2009 16:56:23 +0100 From: "Jaume Sabater" To: "Marcelo Martins" Subject: Re: PostgreSQL monitoring Cc: pgsql-admin@postgresql.org In-Reply-To: <14369888-7712-48EC-966C-7A0878360C22@zeroaccess.org> MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <14369888-7712-48EC-966C-7A0878360C22@zeroaccess.org> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200901/63 X-Sequence-Number: 31110 On Mon, Jan 19, 2009 at 4:38 PM, Marcelo Martins wrote: > Do you guys have any suggestions on monitoring tools for postgresql that > would provide graphing of data & alerts ? > I have looked and tried out hyperic, munin, Nimbus but was hoping to > something better. To monitor I use the following: - pg_osmem: http://www.kennygorman.com/wordpress/?p=250 - pg_buffercache (contrib package in Debian) - pg_top: http://ptop.projects.postgresql.org/ - ps - pgd: http://www.kennygorman.com/wordpress/?p=260 - iotop: http://guichaz.free.fr/iotop/ And I am in the process of writing a bunch of scripts that the Zabbix agent will execute to feed the server with information, so that alerts and graphs can be produced. -- Jaume Sabater http://linuxsilo.net/ "Ubi sapientas ibi libertas"