Query plan view options

Vertica Management Console provides two views for displaying query plans:.

Vertica Management Console provides two views for displaying query plans:

Path Information
Tree Path

Note

Query Plan Drilldown and Profile Analysis output views are only available when you run PROFILE.

You can change the query plan view using the icons on the bottom portion of the Explain page.

The Path Information view displays the query plan path. You can expand or collapse the view to see different levels of detail. To view metadata for a projection or a column, click the object name in the path output. A pop-up window displays the metadata, if it is available.

The

The Tree Path view details the query plan in the form of a tree. When you run EXPLAIN, the tree view does not contain any metrics because the query has not yet executed.