checking session status

Поиск
Список
Период
Сортировка
Искать

checking session status

От:
s.chava@wcom.com (Srinivasa Rao Chava)
Дата:
Hi,
How to check the session status in postgresql.Say, I want to check who 
is logged in to the database at the moment. In ,oracle , I use v$session view
which gives the users logged in to the database. But I don't know how 
to do it postgresql. With ps -ef | grep postmaster* command , I can know
how many postgres processes are running. But How to know which process 
belong to which database user account.
Thanks for any help
chava
FAQ