On Mon, Nov 25, 2013 at 11:57 AM, Scott Marlowe <scott.marl...@gmail.com>wrote:
> So I'm running 8.4 and go to this > page:http://wiki.postgresql.org/wiki/Lock_Monitoring > > I have a query that is definitely blocked by another query. I run the > first or third queries, the ones that explicitly say that they're for > <9.2 and neither produces any output. The third query gives me a list > of 182 rows, only a few of which are actually locked in any meaningful > ways. > Those queries only find row-level locks, not object-level locks (as indicated). I suspect that you are blocking on object-level locks. Maybe you will have better luck with http://wiki.postgresql.org/wiki/Lock_dependency_information. > > Now if I run this query: > > select relname,pg_locks.* from pg_class,pg_locks where > relfilenode=relation and not granted; > > I get the one row for the update / insert / delete that is getting blocked. > Can you show us that row? Cheers, Jeff
