Re: Ticket #8: Colour coding for the backend lines in the server status window

On Wed, Sep 16, 2009 at 10:22, Dave Page <dpage(at)pgadmin(dot)org> wrote:
> On Tue, Sep 15, 2009 at 10:18 PM, Guillaume Lelarge
> <guillaume(at)lelarge(dot)info> wrote:
>> Hi,
>>
>> Here is partial patch to have colored lines for backends. I followed Dave's
>> proposition:
>>
>> Say green for running OK, orange for running, but with the query time being
>> past a configurable limit, blue for idle, and red when waiting for a lock etc.
>
> Looks pretty straightforward.
>
>> The patch is not complete because of these:
>>
>>  * Shouldn't the colors be customizable? I can add a tab on frmOptions.
>
> I think so.

Agreed.

I'd also think the default should be "not so colorful". Meaning the
one that will show the most (in most cases I've looked, that's idle)
should be the default gray color. Then the colors you suggested for
the rest (or maybe blue for running, because it's often a "softer"
color than green).

>>  * Where do I put the configuration of the time limit? on a toolbar of the
>>   frmStatus window, or in the frmOptions dialog?
>
> I think frmStatus. The time limits of interest may be different on
> your DW server than your OLTP system, so it would make sense to allow
> control on the window itself. I think a setting against the server is
> probably going a little too far, but if you can find a nice interface
> for it, I could be persuaded...

Actually, for starters I think we'd be fine even without the time
limit feature at all :-)

Now, if you can make the table sortable by "query start time", *that*
would be useful :-)

--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/