Home > mailing lists

Re: I want to find out who is using a database - Mailing list pgsql-admin

From	Shoaib Mir
Subject	Re: I want to find out who is using a database
Date	November 10, 2010 01:26:32
Msg-id	AANLkTim9YFOX0Q7hT1yE=+hdz3LhNdmjt9pYaTpYi2mY@mail.gmail.com Whole thread Raw
In response to	I want to find out who is using a database (Tena Sakai <tsakai@gallo.ucsf.edu>)
Responses	Re: I want to find out who is using a database (Tena Sakai <tsakai@gallo.ucsf.edu>)
List	pgsql-admin

On Wed, Nov 10, 2010 at 1:17 PM, Tena Sakai <tsakai@gallo.ucsf.edu> wrote:

Can somebody please tell me how I find who it is using the
xxxxx database?

select * from pg_stat_activity where datname = '<yourdbname>';

From: Samuel Stearns
Date: 10 November 2010, 01:25:57
Subject: Re: I want to find out who is using a database

From: Tena Sakai
Date: 10 November 2010, 01:32:09
Subject: Re: I want to find out who is using a database