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

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