From: | Guillaume Lelarge <guillaume(at)lelarge(dot)info> |
---|---|
To: | Magnus Hagander <magnus(at)hagander(dot)net> |
Cc: | pgadmin-hackers <pgadmin-hackers(at)postgresql(dot)org> |
Subject: | Re: Bug in server status view |
Date: | 2011-05-04 19:04:17 |
Message-ID: | 4DC1A331.9060303@lelarge.info |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-hackers |
On 05/04/2011 07:57 PM, Magnus Hagander wrote:
> The server status view does not properly display the "blocked by"
> field, unless it's blocked by a table level lock. In particular, if
> you create a row-lock, it shows empty.
>
> Attached patch changes two things:
> 1) Detects lock conflicts on transaction id's, which is where row
> locks normally show up
> 2) Change it so that if we know the query is blocked, but we can't
> figure out who it's blocked by, it shows -1. Today, it just shows
> NULL, which is exactly the same as it shows if it is not blocked at
> all - making it quite useless...
>
>
> Comments?
>
Seems great to me.
--
Guillaume
http://www.postgresql.fr
http://dalibo.com
From | Date | Subject | |
---|---|---|---|
Next Message | Guillaume Lelarge | 2011-05-04 19:06:45 | Re: pgAdmin 1.14 Visual Tour |
Previous Message | Dave Page | 2011-05-04 18:05:19 | Re: pgAdmin 1.14 Visual Tour |