Re: How to get information of active/inactive user - Mailing list pgsql-general

From Neil Conway
Subject Re: How to get information of active/inactive user
Date
Msg-id 1048092689.19802.370.camel@tokyo
Whole thread Raw
In response to How to get information of active/inactive user connection for postgresql  (Flower Sun <sun_2002_flower@yahoo.com>)
List pgsql-general
On Wed, 2003-03-19 at 10:59, Flower Sun wrote:
> Do you know what's the command to get information of active/inactive
> user connection(session) for postgresql?

I'm not sure what you mean by an "inactive user connection" -- but
presently connected clients can be viewed using either ps or the pg_stat
system views:

http://www.ca.postgresql.org/users-lounge/docs/7.3/postgres/monitoring.html

Cheers,

Neil


pgsql-general by date:

Previous
From: wsheldah@lexmark.com
Date:
Subject: Error loading /usr/lib/postgresql/plpgsql.so
Next
From: Dennis Gearon
Date:
Subject: Re: ssl