Re: log xid with duration - Mailing list pgsql-bugs

From Tom Lane
Subject Re: log xid with duration
Date
Msg-id 16066.1143826024@sss.pgh.pa.us
Whole thread Raw
In response to log xid with duration  ("Ed L." <pgsql@bluepolka.net>)
List pgsql-bugs
"Ed L." <pgsql@bluepolka.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

pgsql-bugs by date:

Previous
From: "Ed L."
Date:
Subject: log xid with duration
Next
From: "Bujic Nikola"
Date:
Subject: BUG #2365: can't install