Skip site navigation (1) Skip section navigation (2)

Re: users connected

From: Gaetano Mendola <mendola(at)bigfoot(dot)com>
To: Cardoso Patrick <cardoso(at)iut-rodez(dot)fr>,"pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: users connected
Date: 2004-07-19 21:31:55
Message-ID: 40FC3DCB.2010706@bigfoot.com (view raw or flat)
Thread:
Lists: pgsql-admin
Cardoso Patrick wrote:
> Hi,
> 
>  
> 
>  Is it possible to know the number of users connected to a database ?

select * from pg_stat_activity.

I'm not sure about permissions you need for it, try.



Regards
Gaetano Mendola




In response to

pgsql-admin by date

Next:From: Bruce MomjianDate: 2004-07-19 21:36:38
Subject: Re: [HACKERS] Point in Time Recovery
Previous:From: Robert TreatDate: 2004-07-19 21:26:50
Subject: Re: users connected

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group