Re: [ADMIN] Monitoring Database Sessions

[Bruce Momjian]

> Hello,
> 
> I was wondering if there was a way in postgres to monitor 
> database sessions.
> 
> I'd like to be able to get a list of currently open sessions
> with information like user id, connection time etc.
> 
> Also I'd like to be able to see a history of sessions; again
> user id with session start & end times.
> 

You can look at 'ps' output to see user, database, and current command
type.

-- 
  Bruce Momjian                        |  http://www.op.net/~candle
  [EMAIL PROTECTED]            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

************