| From: | "Andrew Dunstan" <andrew(at)dunslane(dot)net> |
|---|---|
| To: | <pgman(at)candle(dot)pha(dot)pa(dot)us> |
| Cc: | <Anass(dot)HAMMEDI(at)asais(dot)fr>, <pgsql-hackers-win32(at)postgresql(dot)org> |
| Subject: | Re: session time |
| Date: | 2004-07-06 14:57:16 |
| Message-ID: | 1123.68.16.180.225.1089125836.squirrel@www.dunslane.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Neil Harrilall | 2004-07-06 22:13:43 | Re: initdb crash |
| Previous Message | Bruce Momjian | 2004-07-06 13:46:38 | Re: session time |