Thread: How to determine which long running session???

In Oracle you can look at the v$session view to get
session information and how long they have been
running.  What is the equivalent in PostgreSQL?

TIA.


__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com

King_Henree@yahoo.com wrote:
> In Oracle you can look at the v$session view to get
> session information and how long they have been
> running.  What is the equivalent in PostgreSQL?
>
> TIA.
>

I enable logging of the logins +date/time +pid in postgresql.conf
log_connections=true
log_timestamp=true
log_pid=true
I then just grep the postmaster log for the pid & look at the last entry
There may well be another method, but hth
- Stuart