Re: SELECT .. FOR UPDATE: find out who locked a row

Поиск

Список

Период

Сортировка

От	David G. Johnston
Тема	Re: SELECT .. FOR UPDATE: find out who locked a row
Дата	16 марта 2018 г. 02:38:03
Msg-id	CAKFQuwY3mECA+qiJcOSATxvvrXeEV0OXTk38h7-XNs=5UuvvQA@mail.gmail.com обсуждение исходный текст
Ответ на	SELECT .. FOR UPDATE: find out who locked a row ("Enrico Thierbach" <eno@open-lab.org>)
Список	pgsql-general

Дерево обсуждения

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:

https://www.postgresql.org/docs/10/static/view-pg-locks.html

and the pg_stat_activity view:

https://www.postgresql.org/docs/10/static/monitoring-stats.html#MONITORING-STATS-VIEWS-TABLE

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

David J.

В списке pgsql-general по дате отправления: