I have sent a patch fixing the issue to the pgadmin-hacker mailing list. Chris, Thanks for providing the bug details.
On Mon, Oct 29, 2012 at 6:51 PM, Dave Page <dp...@pgadmin.org> wrote: > Sachin, can you look into this please? Thanks. > > On Thu, Oct 25, 2012 at 11:08 PM, Chris St Denis <ch...@ctgameinfo.com> > wrote: > > Platform: Windows 7 > > Language: English > > Dist: Binary Windows download from official site > > Version: 1.16.0 > > > > > > As shown in attached screenshot.png all queries are shown as blocked by > one > > of my queries. This is obviously incorrect since idle queries and queries > > from different databases are shown as blocked. > > > > A select from pg_stat_activity confirms that only 1 query (49244) is > > actually waiting (it is likely it is waiting on the 47825 that they are > all > > reported as waiting on) > > > > select pid, waiting, state from pg_stat_activity; > > pid | waiting | state > > -------+---------+-------- > > 58614 | f | idle > > 47225 | f | idle > > 48655 | f | idle > > 33051 | f | idle > > 58615 | f | idle > > 58726 | f | idle > > 48306 | f | idle > > 33054 | f | idle > > 48865 | f | idle > > 47819 | f | active > > 53037 | f | idle > > 47820 | f | active > > 49244 | t | active > > 45059 | f | active > > 44561 | f | idle > > 55098 | f | idle > > 47822 | f | active > > 52394 | f | idle > > 55058 | f | idle > > 34636 | f | idle > > 34642 | f | idle > > 45180 | f | idle > > 34718 | f | idle > > 45201 | f | idle > > 45585 | f | idle > > 44131 | f | idle > > 52395 | f | idle > > 50221 | f | idle > > 45397 | f | idle > > 47824 | f | active > > 49978 | f | idle > > 47825 | f | active > > 45414 | f | active > > 50520 | f | idle > > 54395 | f | idle > > 52825 | f | idle > > 11791 | f | active > > 53040 | f | idle > > 53043 | f | idle > > 53057 | f | idle > > 47823 | f | active > > 48659 | f | idle > > 53892 | f | idle > > 53056 | f | idle > > 53058 | f | idle > > 53893 | f | idle > > 53894 | f | idle > > 47835 | f | idle > > 46732 | f | idle > > 55059 | f | idle > > 53895 | f | idle > > 53896 | f | idle > > 47837 | f | idle > > 53897 | f | idle > > 47843 | f | idle > > 47845 | f | active > > 48658 | f | idle > > 48694 | f | idle > > 48868 | f | idle > > 48870 | f | idle > > 48893 | f | idle > > 48972 | f | idle > > 50526 | f | idle > > (63 rows) > > > > > > > > -- > > Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) > > To make changes to your subscription: > > http://www.postgresql.org/mailpref/pgadmin-support > > > > > > -- > Dave Page > Blog: http://pgsnake.blogspot.com > Twitter: @pgsnake > > EnterpriseDB UK: http://www.enterprisedb.com > The Enterprise PostgreSQL Company > -- Regards, Sachin Srivastava EnterpriseDB, India
