Red Hat Database (RHDB) 2.0 comes with RHDB Administrator and Visual Explain.
RHDB Administrator was developed to provide database administrators with a graphical tool to define and maintain their database clusters. This first release of the RHDB Administrator enables you to create, modify, drop, and browse database objects, users, and groups within multiple clusters. The tool also enables you to perform maintenance tasks such as VACUUM. Details on RHDB Administrator can be found in Chapter 3.
Visual Explain was developed to aid the database administrator and application developer in database schema design and application tuning. PostgreSQL provides commands, EXPLAIN and EXPLAIN ANALYZE, to display the query plan for an optimizable query. Output from these commands are plain-text trees that can be difficult to interpret for large or complex queries. Visual Explain provides a graphical representation of these trees that is easy to navigate and to interpret. Details on Visual Explain can be found in Chapter 5.
These Red Hat Database Graphical Tools, which are the first in a suite of tools that are currently under development by the Red Hat Database development team, are licensed under the GPL. The CVS repository at http://sources.redhat.com/rhdb provides the current development sources and information on the tools. Questions or comments about the tools should be directed to <[email protected]>.