Re: How many connections are in use?

From: Rodrigo De León <rdeleonp(at)gmail(dot)com>
To: "Campbell, Lance" <lance(at)uiuc(dot)edu>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: How many connections are in use?
Date: 2007-11-02 08:42:31
Message-ID: a55915760711020142x2b4b8a30q88d353f9b87c42d5@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On 11/2/07, Campbell, Lance <lance(at)uiuc(dot)edu> wrote:
> Is there a way to log into PostgreSQL and determine how many database
> connections are in use?

Use pg_stat_activity.

See:
http://www.postgresql.org/docs/8.2/static/monitoring-stats.html#MONITORING-STATS-VIEWS

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Jessica Richard 2007-11-02 12:50:20 Re: how to check objects dependency??
Previous Message Campbell, Lance 2007-11-02 07:02:22 How many connections are in use?