Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 20220633BB6 for ; Tue, 28 Apr 2009 17:35:28 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 65663-08 for ; Tue, 28 Apr 2009 17:35:26 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from smtp206.iad.emailsrvr.com (smtp206.iad.emailsrvr.com [207.97.245.206]) by mail.postgresql.org (Postfix) with ESMTP id 567DC632922 for ; Tue, 28 Apr 2009 17:35:22 -0300 (ADT) Received: from relay30.relay.iad.mlsrvr.com (localhost [127.0.0.1]) by relay30.relay.iad.mlsrvr.com (SMTP Server) with ESMTP id CCFED1B409B; Tue, 28 Apr 2009 16:35:20 -0400 (EDT) Received: by relay30.relay.iad.mlsrvr.com (Authenticated sender: ejones-AT-engineyard.com) with ESMTPSA id 7F6F11B4091; Tue, 28 Apr 2009 16:35:20 -0400 (EDT) Cc: pgsql-sql@postgresql.org Message-Id: <498EF6C7-119F-401C-83E0-CADC919050F0@engineyard.com> From: Erik Jones To: emilu@encs.concordia.ca In-Reply-To: <49F7240D.2000604@encs.concordia.ca> Content-Type: text/plain; charset=US-ASCII; format=flowed; delsp=yes Content-Transfer-Encoding: 7bit Mime-Version: 1.0 (Apple Message framework v930.3) Subject: Re: pg_stat_activity return all connections Date: Tue, 28 Apr 2009 13:35:19 -0700 References: <49F7240D.2000604@encs.concordia.ca> X-Mailer: Apple Mail (2.930.3) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200904/134 X-Sequence-Number: 32480 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