Re: session time - Mailing list pgsql-hackers-win32

From Andrew Dunstan
Subject Re: session time
Date
Msg-id 1123.68.16.180.225.1089125836.squirrel@www.dunslane.net
Whole thread Raw
In response to Re: session time  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-hackers-win32
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



pgsql-hackers-win32 by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: session time
Next
From: "Neil Harrilall"
Date:
Subject: Re: initdb crash