Re: nagios -- number of postgres connections

From: Scott Mead <scott(dot)mead(at)enterprisedb(dot)com>
To: John R Pierce <pierce(at)hogranch(dot)com>
Cc: Whit Armstrong <armstrong(dot)whit(at)gmail(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: nagios -- number of postgres connections
Date: 2009-06-17 03:45:07
Message-ID: d3ab2ec80906162045s33effc49lc2fa44f11d0de8f7@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Jun 16, 2009 at 11:32 PM, John R Pierce <pierce(at)hogranch(dot)com> wrote:

> Whit Armstrong wrote:
>
>> anyone know a way to get nagios to monitor the number of postgres
>> connections?
>>
>>
>

You could also login to the database and run:

select count(1) from pg_stat_activity;

--Scott

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Scott Mead 2009-06-17 03:45:35 Re: nagios -- number of postgres connections
Previous Message Jeff Frost 2009-06-17 03:37:46 Re: nagios -- number of postgres connections