Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Pgsql Interfaces Pgadmin Hackers > Server Status w...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 2 Topic 4658 of 4873
Post > Topic >>

Server Status window work

by guillaume@[EMAIL PROTECTED] (Guillaume Lelarge) Jun 15, 2008 at 09:45 AM

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
    re****ts at the same time.

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

  * Add graph re****ts 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

-- 
Sent via pgadmin-hackers mailing list (pgadmin-hackers@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-hackers
 




 2 Posts in Topic:
Server Status window work
guillaume@[EMAIL PROTECTE  2008-06-15 09:45:18 
Re: Server Status window work
dpage@[EMAIL PROTECTED]   2008-06-16 09:27:27 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Mon Dec 1 22:59:15 CST 2008.