How to find which query a waiting query waiting for?

Поиск
Список
Период
Сортировка
От wd
Тема How to find which query a waiting query waiting for?
Дата
Msg-id CABexzmgN+6inTwsHnNZMxGEkFsuamHSSSOrp6VR79oX5GDPdDw@mail.gmail.com
обсуждение исходный текст
Ответы Re: How to find which query a waiting query waiting for?
Re: How to find which query a waiting query waiting for?
Список pgsql-general
Дерево обсуждения
hi,

From pg_stat_activity I can find a query is at waiting state, and from pg_locks and pg_class can find which relation the query is waiting for, But how to find witch query is lock the relation?

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