From: | Chris St Denis <chris(at)ctgameinfo(dot)com> |
---|---|
To: | pgadmin-support(at)postgresql(dot)org |
Subject: | bug report: All queries incorrectly shown as blocking in server status |
Date: | 2012-10-25 22:08:43 |
Message-ID: | 5089B86B.9090807@ctgameinfo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
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)
Attachment | Content-Type | Size |
---|---|---|
![]() |
image/png | 66.2 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Phil Freeman | 2012-10-28 20:59:56 | No more Delete/Drop constraints in 1.16 |
Previous Message | Linos | 2012-10-25 18:35:08 | serial column detection |