Re: [GENERAL] wiki on monitoring locks has queries that don't seem to work

2013-11-25 Thread Scott Marlowe
On Mon, Nov 25, 2013 at 1:47 PM, Jeff Janes wrote: > On Mon, Nov 25, 2013 at 11:57 AM, Scott Marlowe > 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 thi

Re: [GENERAL] wiki on monitoring locks has queries that don't seem to work

2013-11-25 Thread Jeff Janes
On Mon, Nov 25, 2013 at 11:57 AM, Scott Marlowe 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

[GENERAL] wiki on monitoring locks has queries that don't seem to work

2013-11-25 Thread Scott Marlowe
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 o