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

Re: session time

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Magnus Hagander <mha(at)sollentuna(dot)net>
Cc: Anass HAMMEDI <Anass(dot)HAMMEDI(at)asais(dot)fr>,Andrew Dunstan <andrew(at)dunslane(dot)net>,pgsql-hackers-win32(at)postgresql(dot)org
Subject: Re: session time
Date: 2004-07-12 00:39:27
Message-ID: 200407120039.i6C0dRa19798@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers-win32
Added to TODO:

	* Add session start time and last statement time to
	  pg_stat_activity


---------------------------------------------------------------------------

Magnus Hagander wrote:
> If you want it by a query, then log_prefix is not going to help :-(
> 
> It could perhaps be added as a column to pg_stat_activity? (Which has query_start at the moment, could also have session_start) Not having looked into the details, that could probably be added fairly easy.
> 
> But I assume it's too late to get something like that into 7.5, even if it's really small :-( Or?
> 
> //Magnus
> 
> 
> > -----Original Message-----
> > From: Anass HAMMEDI [mailto:Anass(dot)HAMMEDI(at)asais(dot)fr] 
> > Sent: Wednesday, July 07, 2004 10:45 AM
> > To: Andrew Dunstan; pgman(at)candle(dot)pha(dot)pa(dot)us
> > Cc: pgsql-hackers-win32(at)postgresql(dot)org
> > Subject: Re: [pgsql-hackers-win32] session time
> > 
> > I 'm trying to convince my chief to add PostgreSQL to RDBMS 
> > 's our software supports.
> > I need to know how to get the session time by a simple query 
> > , to prohibit idling on the server.
> > 
> > I think this feature would be useful not just for me , so if 
> > it can be added ,please, give it your best shot.
> > 
> > Thanx
> > 
> > Anass
> > 
> > -----Message d'origine-----
> > De : Andrew Dunstan [mailto:andrew(at)dunslane(dot)net] Envoy? : 
> > mardi 6 juillet 2004 16:57 ? : pgman(at)candle(dot)pha(dot)pa(dot)us Cc : 
> > Anass(dot)HAMMEDI(at)asais(dot)fr; pgsql-hackers-win32(at)postgresql(dot)org
> > Objet : Re: [pgsql-hackers-win32] session time
> > 
> > 
> > Bruce Momjian said:
> > > Anass HAMMEDI wrote:
> > >>
> > >> Help requested:
> > >>
> > >> Is there any way to get the session time with a query.
> > >> All I afforded to get is the start time of statement execution.
> > >
> > > You want session start time?  We don't supply that.  My only 
> > > suggestion would be to create a temp table on session start and put 
> > > current_timestamp into there.
> > >
> > 
> > log_line-prefex on 7.5 does session start time. We could also 
> > add a 'time since session start' if that was wanted quite easily.
> > 
> > cheers
> > 
> > andrew
> > 
> > 
> > ---------------------------(end of 
> > broadcast)---------------------------
> > TIP 7: don't forget to increase your free space map settings
> > 
> > 
> 

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman(at)candle(dot)pha(dot)pa(dot)us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

In response to

pgsql-hackers-win32 by date

Next:From: Bruce MomjianDate: 2004-07-12 00:54:48
Subject: Re: Finding zlib on MinGW
Previous:From: Bruce MomjianDate: 2004-07-11 23:53:11
Subject: Re: Backslash character in psql problem

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