"Jeffrey W. Baker" <jwbaker@acm.org> writes:
> I would be very surprised but it isn't impossible. Is there a way to
> query the transaction counter for an open connection?
No easy way I can think of, short of gdb'ing each backend. But you
could use "ps" and look at the start time of each backend process
that isn't showing status "idle".
regards, tom lane