Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229]) by mail.postgresql.org (Postfix) with ESMTP id A3439CE6EC for ; Fri, 15 Jun 2012 17:38:56 -0300 (ADT) Received: from gwmta.wicourts.gov ([165.219.244.99] helo=gw.wicourts.gov) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1SfdID-0004kt-K3 for pgsql-performance@postgresql.org; Fri, 15 Jun 2012 20:38:55 +0000 Received: from Courts-MTA by gw.wicourts.gov with Novell_GroupWise; Fri, 15 Jun 2012 15:38:40 -0500 Message-Id: <4FDB56FF0200002500048510@gw.wicourts.gov> X-Mailer: Novell GroupWise Internet Agent 8.0.2 Date: Fri, 15 Jun 2012 15:38:39 -0500 From: "Kevin Grittner" To: "Benedict Holland" Cc: Subject: Re: Update blocking a select count(*)? References: <4FDB3C0202000025000484E4@gw.wicourts.gov> <4FDB40B702000025000484EE@gw.wicourts.gov> <4FDB476A02000025000484F4@gw.wicourts.gov> <4FDB4DF602000025000484FE@gw.wicourts.gov> In-Reply-To: Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Content-Disposition: inline X-Pg-Spam-Score: -4.2 (----) X-Archive-Number: 201206/94 X-Sequence-Number: 47120 Benedict Holland wrote: > I ran the scripts on the page and both returned empty (though I > have queries running and currently nothing blocks). I don't know > what they should have been. It only shows information on blocking, so the list should be empty when there is none. :-) If it works as intended, it would have shown the chain of blocking, from the update to the alter to the select. > The output was from PgAdmin3 which is a UI for postgres. I assume > that they get this queried information from something inside of > postgres as I can't imagine the query tool doing something other > than querying the database for specs. They are probably doing something internally which is somewhat similar to the recursive query on that page. It sounds like when there is a chain or tree of blocking, they show the process at the front of the parade, rather than the immediate blocker. I can't say that's right or wrong, but it should be documented so that people can understand what they're looking at. Even better would be to make a nice graphical tree of the blocking, but that would be getting pretty fancy. :-) -Kevin