Subject: Re: Monitoring Postgresql performance
From: Juraj Holtak <juraj@proaut.org>
To: Tony Wasson <ajwasson@gmail.com>
Cc: pgsql-performance@postgresql.org
In-Reply-To: <6d8daee3050929130275807ff2@mail.gmail.com>
References: <433AA962.9020900@andromeiberica.com>
	<f3c0b40805092810562e05d94b@mail.gmail.com>
	<6d8daee3050929130275807ff2@mail.gmail.com>
Content-Type: text/plain
Date: Thu, 29 Sep 2005 22:56:42 +0200
Message-Id: <1128027402.10516.25.camel@localhost.localdomain>
Mime-Version: 1.0
Content-Transfer-Encoding: 7bit

Hi,

impressive

But you forgot to include those scipts as attachment or they got lost
somehow ;-)

could you post them (again)?

thanx,
Juraj

Am Donnerstag, den 29.09.2005, 13:02 -0700 schrieb Tony Wasson:
> On 9/28/05, Matthew Nuzum <mattnuzum@gmail.com> wrote:
> > On 9/28/05, Arnau <arnaulist@andromeiberica.com> 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 :-)
> 
> We are also using cricket + nagios.
> 
> On each DB server: Setup snmpd and use snmpd.conf to set disk quotas
> and mark processes that need to be running  (like
> postmaster,syslog,sshd)
> 
> On the monitoring server(s): Use cricket for long term trends &
> graphs. Use nagios for current status and alerting and some trending.
> (Nagios has plugins over SNMP for load,cpu,memory,disk and processes)
> 
> Here's the nagios plugins I have hacked up over the past few months
> and what they do. I'd imagine some could use better names. I can
> provide these of package them up if anyone is interested.
> 
> check_pgconn.pl - Shows percentage of connections available. It uses
> "SELECT COUNT(*) FROM pg_stat_activity" / "SHOW max_connections". It
> can also alert when less than a certain number of connections are
> available.
> 
> check_pgqueries.pl - If you have query logging enabled this summarizes
> the types of queries running (SELECT ,INSERT ,DELETE ,UPDATE ,ALTER
> ,CREATE ,TRUNCATE, VACUUM, COPY) and warns if any queries have been
> running longer than 5 minutes (configurable).
> 
> check_pglocks.pl - Look for locks that block and for baselining lock activity.
> 
> check_pgtime.pl - Makes sure that postgresql's time is in sync with
> the monitoring server.
> 
> check_pgqueries.pl - Whines if any queries are in the "waiting" state.
> The script that runs on each DB server does "ps auxww | grep postgres
> | grep -i "[W]aiting"" and exposes that through SNMP using the exec
> functionality. Nagios then alerts if queries are being blocked.
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
>        subscribe-nomail command to majordomo@postgresql.org so that your
>        message can get through to the mailing list cleanly
>