Re: Finding connected users

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "M(dot) Bastin" <marcbastin(at)mindspring(dot)com>
Cc: PgSQL Novice ML <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Finding connected users
Date: 2003-09-12 14:13:50
Message-ID: 10697.1063376030@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox
Thread:
Lists: pgsql-novice

"M. Bastin" <marcbastin(at)mindspring(dot)com> writes:
> How can I find the currently connected users?

The pg_stat_activity system view will help, assuming you haven't turned
off the stats-collection subsystem.

regards, tom lane

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2003-09-12 14:21:30 Re: Slow VACUUM
Previous Message Wim 2003-09-12 13:10:32 Re: operation logging