| From: | "Simon Riggs" <simon(at)2ndquadrant(dot)com> |
|---|---|
| To: | "Pascal Robert" <probert(at)os(dot)ca> |
| Cc: | <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: Finding time in WAL logs |
| Date: | 2007-04-25 19:53:04 |
| Message-ID: | 1177530784.20637.230.camel@silverbirch.site |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Wed, 2007-04-25 at 14:49 -0400, Pascal Robert wrote:
> >> 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 ?
There'll be a COMMIT record for every transaction, however it was
initiated, unless the server crashed/shutdown before it could be issued.
--
Simon Riggs
EnterpriseDB http://www.enterprisedb.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dan Dan | 2007-04-25 20:03:35 | continuous archive with v823 |
| Previous Message | Pascal Robert | 2007-04-25 19:20:28 | Re: Finding time in WAL logs |