Re: How to get information of active/inactive user

From: Neil Conway <neilc(at)samurai(dot)com>
To: Flower Sun <sun_2002_flower(at)yahoo(dot)com>
Cc: Pgsql Group <pgsql-general(at)postgresql(dot)org>
Subject: Re: How to get information of active/inactive user
Date: 2003-03-19 16:51:30
Message-ID: 1048092689.19802.370.camel@tokyo
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Dennis Gearon 2003-03-19 16:52:41 Re: ssl
Previous Message chamal desilva 2003-03-19 16:38:42 Starting postmaster