Re: How to see what SQL queries are associated with pg_locks?

Поиск
Список
Период
Сортировка
От Joshua Tolley
Тема Re: How to see what SQL queries are associated with pg_locks?
Дата
Msg-id 4ca9d71c.2765730a.2ca8.35f4@mx.google.com
обсуждение исходный текст
Ответ на How to see what SQL queries are associated with pg_locks?  (Aleksey Tsalolikhin <atsaloli.tech@gmail.com>)
Список pgsql-general
Дерево обсуждения 
On Fri, Oct 01, 2010 at 11:27:11AM -0700, Aleksey Tsalolikhin wrote:
> How to see what SQL queries are associated with pg_locks, please?

Look at the pid column in pg_locks. It will match the procpid column in
pg_stat_activity.

--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com
Вложения

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

Предыдущее
От: Alexander Farber
Дата:
Сообщение: Re: Any advice on debugging hanging postgresql-8.1.21 (many postmaster's)
Следующее
От: Vick Khera
Дата:
Сообщение: Re: Merge replication with Postgresql on Windows?