Re: session time
"Andrew Dunstan" <[email protected]>
| Newsgroups | gmane.comp.db.postgresql.devel.win32 |
|---|---|
| Message-ID | <[email protected]> |
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 1: subscribe and unsubscribe commands go to [email protected]