Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 338019FBDAE for ; Wed, 25 Apr 2007 16:57:39 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 02831-06 for ; Wed, 25 Apr 2007 16:57:33 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from mail01.enterprisedb.com (mail01.enterprisedb.com [63.246.7.168]) by postgresql.org (Postfix) with ESMTP id 432039FBDB0 for ; Wed, 25 Apr 2007 16:57:36 -0300 (ADT) thread-index: AceHdACl7RQU5fZDQ1ewixAbvkJW1w== Received: from [192.168.0.5] ([85.211.22.118]) by mail01.enterprisedb.com with Microsoft SMTPSVC(6.0.3790.1830); Wed, 25 Apr 2007 15:57:49 -0400 Content-Class: urn:content-classes:message Importance: normal X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.2826 Subject: Re: Finding time in WAL logs From: "Simon Riggs" To: "Pascal Robert" Cc: In-Reply-To: References: <5B0132B1-646A-432C-8261-973E4BB42999@os.ca> <1177515789.20637.160.camel@silverbirch.site> <7697F772-07E3-469C-8E51-1450AEBC5F39@os.ca> <1177524100.20637.167.camel@silverbirch.site> Content-Type: text/plain; charset="iso-8859-1" Date: Wed, 25 Apr 2007 20:53:04 +0100 Message-ID: <1177530784.20637.230.camel@silverbirch.site> MIME-Version: 1.0 X-Mailer: Evolution 2.6.0 Content-Transfer-Encoding: 7bit X-OriginalArrivalTime: 25 Apr 2007 19:57:49.0796 (UTC) FILETIME=[00841240:01C78774] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200704/239 X-Sequence-Number: 25303 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