[ADMIN] Monitoring Database Sessions

[Stephen Turner]

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.

Any ideas?

Thanks,
Steve Turner


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