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

From: "Jeff Larsen" <jlar310(at)gmail(dot)com>
To: "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 22:54:28
Message-ID: d1f9b6f00711091454m4363fc98nec9811c2a0fde164@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> 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;

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2007-11-09 22:57:40 Re: any way to query for current connections to db?
Previous Message Coarr, Matt 2007-11-09 22:36:14 any way to query for current connections to db?