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

Re: users connected

From: Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>
To: Cardoso Patrick <cardoso(at)iut-rodez(dot)fr>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: users connected
Date: 2004-07-19 21:26:50
Message-ID: 1090272411.2711.48.camel@camel (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
On Fri, 2004-07-16 at 10:42, Cardoso Patrick wrote:
> Hi,
>             Is it possible to know the number of users connected to a
> database ?
>             Regards

select * from pg_stat_activity;

Robert Treat
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL

In response to

pgsql-admin by date

Next:From: Gaetano MendolaDate: 2004-07-19 21:31:55
Subject: Re: users connected
Previous:From: Tom LaneDate: 2004-07-19 21:24:06
Subject: Re: [HACKERS] Point in Time Recovery

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