Skip site navigation (1) Skip section navigation (2)

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

From: "Henshall, Stuart - Design & Print" <SHenshall(at)westcountry-design-print(dot)co(dot)uk>
To: "'King_Henree(at)yahoo(dot)com'" <king_henree(at)yahoo(dot)com>,pgsql-cygwin(at)postgresql(dot)org
Subject: Re: How to determine which long running session???
Date: 2002-12-18 09:17:34
Message-ID: E382B5D8EDE1D6118DBE0008C759BCD6116B39@WCPEXCHANGE (view raw or flat)
Thread:
Lists: pgsql-cygwin
King_Henree(at)yahoo(dot)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

pgsql-cygwin by date

Next:From: King_Henree@yahoo.comDate: 2002-12-18 17:18:56
Subject: PostgeSQL equivalent to Oracle RAW column type???
Previous:From: King_Henree@yahoo.comDate: 2002-12-17 20:05:29
Subject: How to determine which long running session???

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group