Skip site navigation (1) Skip section navigation (2)

Server Status window work

From: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
To: pgadmin-hackers(at)postgresql(dot)org
Subject: Server Status window work
Date: 2008-06-15 07:45:18
Message-ID: 4854C88E.7010202@lelarge.info (view raw or flat)
Thread:
Lists: pgadmin-hackers
Hi,

The roadmap still shows I need to work on the server status window. But 
it doesn't explain what I have in mind. Dave gave me some hints and 
todos. Here is my todo list on this :

  * Replace the wxNotebook widget with the wxAuiNotebook so users can
    close tabs and rearrange tabs order via drag-and-drop.

  * Add the possibility to open many Server Status windows (we can
    already do this with the SQL query tool) so a user can see many
    reports at the same time.

  * Add a dockable toolbar to enable changing connection server, timer
    slider, filter and sort options.

  * Add graph reports for different statistics views, something like
    the Gnome System Monitor but specific to PostgreSQL (transaction
    rate, read/hit ratio, number of connections, bgwriter stats come to
    mind).

  * Better display of the logfile (probably using the log_line_prefix
    option to know which informations are available).

  * Command line options to start the Server Status window on it's own,
    much as we can already do with the query tool.

  * Colour coding for the backend lines. 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.

  * The ability to select a running backend, and copy the query straight
    into a new query tool window (caveat: the stats command string may be
    truncated, and still contain parameter placeholders).

  * Ability to select a backend process and display just the locks
    it's holding, and the one it's waiting on.

  * (bit more complex) Display the locks in a logical tree rather than a
    list (applies to the previous point as well as the current tab).

The last five are Dave's ideas. I just copy/paste one of his emails.

I know this is a huge todo list and I don't pretend doing everything 
alone and for the next release. Actually, I think I'll do one patch for 
each todo. I hope to begin the work on this next week.

Comments? Ideas?


-- 
Guillaume.
  http://www.postgresqlfr.org
  http://dalibo.com

Responses

pgadmin-hackers by date

Next:From: Magnus HaganderDate: 2008-06-15 18:46:55
Subject: Re: Dialogs review
Previous:From: Guillaume LelargeDate: 2008-06-15 07:21:54
Subject: Dialogs review

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group