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

How to see what SQL queries are associated with pg_locks?

From
Aleksey Tsalolikhin
Date:
How to see what SQL queries are associated with pg_locks, please?

Could somebody help with the query?   I can then add it to
http://wiki.postgresql.org/wiki/Lock_Monitoring

Best,
-at

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

From
Joshua Tolley
Date:
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

Attachment