Postgres Pro
Downloads
Home   >   mailing lists

Re: How to see what SQL queries are associated with pg_locks? - Mailing list pgsql-general

From Joshua Tolley
Subject Re: How to see what SQL queries are associated with pg_locks?
Date
Msg-id 4ca9d71c.2765730a.2ca8.35f4@mx.google.com
Whole thread Raw
In response to How to see what SQL queries are associated with pg_locks?  (Aleksey Tsalolikhin <atsaloli.tech@gmail.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Alexander Farber
Date:
Subject: Re: Any advice on debugging hanging postgresql-8.1.21 (many postmaster's)
Next
From: Vick Khera
Date:
Subject: Re: Merge replication with Postgresql on Windows?