Viewing a Graphical Query Plan

Viewing a Graphical Query Plan

Using the pgAdmin III query tool, you can run a query with EXPLAIN to view the details of the query plan. The output includes details about operations unique to Greenplum distributed query processing such as plan slices and motions between segments. You can view a graphical depiction of the plan as well as the text-based data output.
  1. With the correct database highlighted in the object browser in the left pane, select Tools > Query tool.
  2. Enter the query by typing in the SQL Editor, dragging objects into the Graphical Query Builder, or opening a file.
  3. Select Query > Explain options and verify the following options:
    Option Description
    Verbose this must be deselected if you want to view a graphical depiction of the query plan
    Analyze select this option if you want to run the query in addition to viewing the plan
  4. Trigger the operation by clicking the Explain query option at the top of the pane, or by selecting Query > Explain.
    The query plan displays in the Output pane at the bottom of the screen. Select the Explain tab to view the graphical output. For example:
    Figure 1. Graphical Query Plan in pgAdmin III