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
Views: Raw Message | Whole Thread | Download mbox
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

Browse pgadmin-hackers by date

  From Date Subject
Next Message Magnus Hagander 2008-06-15 18:46:55 Re: Dialogs review
Previous Message Guillaume Lelarge 2008-06-15 07:21:54 Dialogs review