Thread: bug report: All queries incorrectly shown as blocking in server status

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)

Sachin, can you look into this please? Thanks.

On Thu, Oct 25, 2012 at 11:08 PM, Chris St Denis <chris@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