Re: Finding time in WAL logs

Поиск
Список
Период
Сортировка
От Pascal Robert
Тема Re: Finding time in WAL logs
Дата
Msg-id F5E43794-6983-4026-BB18-A6CD89D890BC@os.ca
обсуждение исходный текст
Ответ на Re: Finding time in WAL logs  ("Simon Riggs" <simon@2ndquadrant.com>)
Ответы Re: Finding time in WAL logs  (Pascal Robert <probert@os.ca>)
Re: Finding time in WAL logs  ("Simon Riggs" <simon@2ndquadrant.com>)
Список pgsql-admin
>> BTW, the statements look like this :
>>
>>     0/15FFE470: prv 0/15FFE440; xid 2332; HEAP  info 10 len 18
>> tot_len 46
>>     DELETE FROM 16612 WHERE ...delete: ts 1663 db 16384 rel 16612 block
>> 1413 off 5
>>
>> (this is for a DELETE FROM table without any WHERE clause).  I see
>> the XID, but can you also display date and time in the ouput ?
>
> Original date/time is available only on COMMIT/ABORT records, so
> you'll
> need to search ahead/behind.

Ok, so I guess that auto commited statements will never have date/time ?

В списке pgsql-admin по дате отправления:

Предыдущее
От: Karthikeyan Sundaram
Дата:
Сообщение: question about installing perl module
Следующее
От: Pascal Robert
Дата:
Сообщение: Re: Finding time in WAL logs