Re: Finding time in WAL logs

From: Pascal Robert <probert(at)os(dot)ca>
To: Simon Riggs <simon(at)2ndquadrant(dot)com>
Cc: <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Finding time in WAL logs
Date: 2007-04-25 18:49:14
Message-ID: F5E43794-6983-4026-BB18-A6CD89D890BC@os.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 ?

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Pascal Robert 2007-04-25 19:20:28 Re: Finding time in WAL logs
Previous Message Karthikeyan Sundaram 2007-04-25 18:27:44 question about installing perl module