Postgres Pro
Downloads
Home   >   mailing lists

Re: SELECT .. FOR UPDATE: find out who locked a row - Mailing list pgsql-general

From David G. Johnston
Subject Re: SELECT .. FOR UPDATE: find out who locked a row
Date
Msg-id CAKFQuwY3mECA+qiJcOSATxvvrXeEV0OXTk38h7-XNs=5UuvvQA@mail.gmail.com
Whole thread Raw
In response to SELECT .. FOR UPDATE: find out who locked a row  ("Enrico Thierbach" <eno@open-lab.org>)
List pgsql-general
Tree view
On Thu, Mar 15, 2018 at 1:30 PM, Enrico Thierbach <eno@open-lab.org> wrote:

Now I wonder if it is possible, given the id of one of the locked rows in the queue table, to find out which connection/which transaction owns the lock

​I'd start here:​


and the pg_stat_activity view:


The system doesn't really understand your model ID/PK field - the system views and catalogs using system identifiers.

David J.

pgsql-general by date:

Previous
From: pinker
Date:
Subject: Re: SELECT .. FOR UPDATE: find out who locked a row
Next
From: Tiffany Thang
Date:
Subject: Re: psql output result