Re: session time

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:[email protected]] 
> Sent: Wednesday, July 07, 2004 10:45 AM
> To: Andrew Dunstan; [email protected]
> Cc: [email protected]
> 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:[email protected]] Envoyé : 
> mardi 6 juillet 2004 16:57 À : [email protected] Cc : 
> [email protected]; [email protected]
> 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
> 
> 

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [email protected]