Re: nagios -- number of postgres connections

From: Scott Mead <scott(dot)lists(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:35
Message-ID: d3ab2ec80906162045u18395f81xe7ee58a49a0c5aba@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 Rafael Martinez 2009-06-17 06:00:56 Re: nagios -- number of postgres connections
Previous Message Scott Mead 2009-06-17 03:45:07 Re: nagios -- number of postgres connections