Re: finding the procpid (or pid) for a prepared transaction

CS DBA <cs_dba@consistentstate.com> writes:
> I have several prepared tx which are running for a long long time. I
> want to kill 'em but I dont know the process id.

If they're prepared, they're *not* running, and they don't have a
process id.  They're just going to sit there until you do COMMIT
PREPARED or ROLLBACK PREPARED.

            regards, tom lane