Skip site navigation (1) Skip section navigation (2)

Re: log xid with duration

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Ed L(dot)" <pgsql(at)bluepolka(dot)net>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: log xid with duration
Date: 2006-03-31 17:27:04
Message-ID: 16066.1143826024@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
"Ed L." <pgsql(at)bluepolka(dot)net> writes:
> ...the transaction is not printed with the duration (it prints 0 
> instead).

It's already out of the transaction by the time it prints the duration,
if you're talking about a command that's not within an explicit BEGIN
block.  I think this is correct --- to do otherwise, we'd not be
counting the transaction commit as part of the command duration, which
would surely be quite misleading.

			regards, tom lane

In response to

pgsql-bugs by date

Next:From: Alvaro HerreraDate: 2006-03-31 23:43:18
Subject: Re: BUG #2366: Timestamptz data type is inaccurate
Previous:From: Ed L.Date: 2006-03-31 17:16:56
Subject: log xid with duration

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group