Re: any way to query for current connections to db?

From: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
To: "Bruce Momjian" <bruce(at)momjian(dot)us>
Cc: "Jeff Larsen" <jlar310(at)gmail(dot)com>, "Coarr, Matt" <mcoarr(at)mitre(dot)org>, pgsql-general(at)postgresql(dot)org
Subject: Re: any way to query for current connections to db?
Date: 2007-11-09 23:01:15
Message-ID: dcc563d10711091501wb5faebdie61cfcf2dcfdf1d8@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Nov 9, 2007 4:57 PM, Bruce Momjian <bruce(at)momjian(dot)us> wrote:
> Jeff Larsen wrote:
> > > Is there any way to query the database to identify what the current
> > > connections are (connections, sessions, or whatever you want to call them)?
> >
> > select * from pg_stat_activity;
>
> Is this an FAQ?

Yes, it gets asked a lot.

Is it in the FAQ? Don't know.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jeff Larsen 2007-11-09 23:06:11 Re: any way to query for current connections to db?
Previous Message volunteer 2007-11-09 23:00:27 Re: any way to query for current connections to db?