X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 06240D9A65 for ; Thu, 29 Sep 2005 18:15:13 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 70562-01 for ; Thu, 29 Sep 2005 21:15:09 +0000 (GMT) Received: from smtp0.libero.it (smtp0.libero.it [193.70.192.33]) by svr1.postgresql.org (Postfix) with ESMTP id D216AD706A for ; Thu, 29 Sep 2005 18:15:08 -0300 (ADT) Received: from localhost (172.16.1.47) by smtp0.libero.it (7.0.027-DD01) id 431C399301BD60B6; Thu, 29 Sep 2005 23:15:02 +0200 Received: from smtp3.libero.it ([172.16.1.53]) by localhost (asav7.libero.it [193.70.193.93]) (amavisd-new, port 10024) with ESMTP id 15673-07; Thu, 29 Sep 2005 23:15:01 +0200 (CEST) Received: from [151.25.72.68] (ppp-68-72.25-151.libero.it [151.25.72.68]) by smtp3.libero.it (Postfix) with ESMTP id 09785ABE0D; Thu, 29 Sep 2005 23:15:00 +0200 (MEST) Message-ID: <433C7687.20700@streppone.it> Date: Thu, 29 Sep 2005 23:19:35 +0000 From: Cosimo Streppone User-Agent: Mozilla Thunderbird 1.0.2 (X11/20050317) X-Accept-Language: it, it-it, en-us, en MIME-Version: 1.0 To: arnaulist@andromeiberica.com Cc: Postgresql Performance list Subject: Re: Monitoring Postgresql performance References: <433AA962.9020900@andromeiberica.com> In-Reply-To: <433AA962.9020900@andromeiberica.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Scanned: with antispam and antivirus automated system at libero.it X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.03 required=5 tests=[AWL=0.030] X-Spam-Level: X-Archive-Number: 200509/435 X-Sequence-Number: 14743 Arnau wrote: > Hi all, > > I have been "googling" a bit searching info about a way to monitor > postgresql (CPU & Memory, num processes, ... ) and I haven't found > anything relevant. I'm using munin to monitor others parameters of my > servers and I'd like to include postgresql or have a similar tool. Any > of you is using anything like that? all kind of hints are welcome :-) Probably, as you said, this is not so much relevant, as it is something at *early* stages of usability :-) but have you looked at pgtop? The basic requirement is that you enable your postmaster stats collector and query command strings. Here is the first announcement email: http://archives.postgresql.org/pgsql-announce/2005-05/msg00000.php And its home on the CPAN: http://search.cpan.org/dist/pgtop/pgtop -- Cosimo