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 по дате отправления:

Предыдущее
От: Hari Babu
Дата:
Сообщение: Re: Backend process is still runs even postmaster got killed
Следующее
От: hubert depesz lubaczewski
Дата:
Сообщение: Re: How to find which query a waiting query waiting for?