Re: session time

Поиск
Список
Период
Сортировка
От Andrew Dunstan
Тема Re: session time
Дата
Msg-id 1123.68.16.180.225.1089125836.squirrel@www.dunslane.net
обсуждение исходный текст
Ответ на Re: session time  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: session time
Следующее
От: "Neil Harrilall"
Дата:
Сообщение: Re: initdb crash