In the main window, the structure of the databases is displayed. It consists of three primary elements: Object browser, Query Analyzer and Result Set. And three usual elements: Menu bar, Tool bar, and Status bar.

Object Browser. The top-level view side of the main window is called object browser. It allows you to fully browse any database you created, it's also showing the databases and their sizes in the system. The view also displays Greenplum-specific objects and information such as Partitions and the Distributed By clause in a table definition. To see that, simply expand the database till needed field is met.
Hint: if you want to toggle object browser press CTRL+B.




By right-clicking database, table, server, etc. you can access functions specific to each object that both DBAs and developers can use to be much more efficient. Here are some randomly selected options of the Database and Server type. To read the full list go to our Object menu page. 

Functions specific to Database type:

• Show User Session - brings up a Session List window with a grid showing all users connected to the server.
• Show Query History - shows all executed queries history. This option also allows different setup parameters to be added to the displayed result.
• Script Database - this option allows you to publish a sql command file with all of the necessary commands to completely rebuild your database structure.You can also customize which objects need should be included in the script.
• Show Tables Size - brings up a new window with detailed description (i.e. Data and Processing Skew) of currently selected database tables.

• Server monitor - allows server monitoring (GP States, Process, Disk Free Space, etc.)
• Server explorer - shows segments and appliances' detailed structure.

Query Analyzer. The upper right side is called query analyzer. It contains the SQL Editor where you can type and manage (Cut,Copy, Replace, Change Selection Case etc.) your SQL commands. If you click 'New' tab, it will add a new tab to write queries in. The editor also offers a number of features for helping with code formatting. Right-clicking anywhere in query analyzer will give access to the features and additional query options.

Hint: Press CTRL/SHIFT + F6 to switch back/forth between the tabs in query analyzer, and CTRL+T to add a new tab.
To access even more options, navigate to Tools >> Options >> Query Analyzer.

Result Set. The bottom side is called Result Set. It shows results of executed SQL query in two tabs: Output and Result. The Output tab has three sub-tabs: Standard (a brief summary of executed query), Text (more detailed description) and Grid (basic grid view). The Result tab opens by default if the query was executed successfully. If  an error was encountered, the result tab will not be shown: only the Output tab with error(s) description.
Hint: if you double click on the table's cell or column header it will insert the table's cell or column header value into the active SQL editor.

If you don't want to have Text and Grid sub-tabs for the Output tab, navigate to Tools >> Options >> Result set options >> Output options, and uncheck 'Enable text/grid output' check-boxes.

Result set allows you to drag a column from Results tab and group by that column. To do that, simply drag the column you want to group by to 'drag a column header here' zone.

Among other features it can also export results to Excel 2003 XML or CSV format. To do that, right click anywhere in the Result tab and select Export. Additional functions can be achieved by right-clicking on the table itself and selecting Actions for 'name' column (can create Pareto and Frequency Distribution Charts).
Hint: If you hold CTRL and double click on the result set's headers - it will expand it on the whole screen.


Menu bar. Menu bar consists of menus which help working with Workbench. More detailed description of each menu item is available on the main WorkBench Help page.

Tool bar. Tool bar is located under the menu bar and provides access to frequently used options. Just hover over each button to read the description.

Status bar. There is a status bar under the result set. It shows helpful status information. If you select more that 1 row in result set, status bar can show minimum, maximum, average and other data in status bar. To enable this feature click on the down arrow on the right side of the status bar, and selected options you want to be shown.



Note: Notice the right size of the status bar showing Min, Max and Sum for selected 4 rows.

You can resize the main window, and change the size of three main regions as you prefer. These adjustments will be preserved when you exit the program.



Go up  |  Go To WorkBench Help page