Re: How to find which query a waiting query waiting for?

Поиск

Список

Период

Сортировка

От	Fabrízio de Royes Mello
Тема	Re: How to find which query a waiting query waiting for?
Дата	7 декабря 2012 г. 18:09:28
Msg-id	CAFcNs+or46avACveoS4Q34gZQeH2pFLaxK71mmBfon5bzpC1ig@mail.gmail.com обсуждение исходный текст
Ответ на	How to find which query a waiting query waiting for? (wd <wd@wdicc.com>)
Ответы	Re: How to find which query a waiting query waiting for?
Список	pgsql-general

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

On Fri, Dec 7, 2012 at 1:02 PM, wd <wd@wdicc.com> wrote:

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?

Maybe you found what you need here [1].

[1] http://wiki.postgresql.org/wiki/Lock_Monitoring

--
Fabrízio de Royes Mello

Consultoria/Coaching PostgreSQL
>> Blog sobre TI: http://fabriziomello.blogspot.com

>> Perfil Linkedin: http://br.linkedin.com/in/fabriziomello

>> Twitter: http://twitter.com/fabriziomello

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