Re: pg_stat_activity return all connections

From: Erik Jones <ejones(at)engineyard(dot)com>
To: emilu(at)encs(dot)concordia(dot)ca
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: pg_stat_activity return all connections
Date: 2009-04-28 20:35:19
Message-ID: 498EF6C7-119F-401C-83E0-CADC919050F0@engineyard.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


On Apr 28, 2009, at 8:43 AM, Emi Lu wrote:

> Good morning,
>
> A question about pg_stat_activity:
>
> If believe that "select * from pg_stat_activity where
> usename='db_user1'" returns all connections based on db_user1, no
> matter the connection is through terminal command or jdbc, am I right?

Yes.

Erik Jones, Database Administrator
Engine Yard
Support, Scalability, Reliability
866.518.9273 x 260
Location: US/Pacific
IRC: mage2k

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Nicholas I 2009-04-29 06:39:42 Comparing two tables of different database
Previous Message Andy Shellam 2009-04-28 16:48:56 Re: Storing null bytes in bytea