Jeff Davis <pgsql@j-davis.com> wrote:
> On Fri, 2011-04-01 at 13:00 -0400, Dan Ports wrote:
>> While looking into a SSI bug, I noticed that we don't actually
>> display the pid of the holding transaction, even though we have
>> that information available.
>
> Is there a chance that the PID will reference a backend that has
> either terminated or is idle?
Yes to both.
> That might be confusing.
With a barely larger patch we could suppress that, if that's
desirable. Of course, there is already the same issue for the
virtualtransaction column.
As Dan mentioned, it won't show for locks which are summarized using
SLRU, nor will it show for prepared transactions pending final
commit -- at least if they're loaded from disk after recovery. (I'm
not sure without some digging about a transaction which is prepared
and still pending commit if the server is still running from the
point of prepare.)
-Kevin