Vertica documentation is moving! Use our new documentation site at https://docs.rocketsoftware.com/bundle/vertica_24.2/page/index.html

Accessing query plans in Management Console

You can access query plans in Management Console in two ways:.

You can access query plans in Management Console in two ways:

  • In the Detail page for query-related charts on the database's Activity page, click Explain next to a query to view a plan for that query.

  • Enter a query manually on the Explain page and click Explain Plan.

In both cases, the following window opens:

You can also enter the transaction ID and statement ID or browse running or completed queries in the Find a Query input window:

In the output window, you can perform the following tasks related to the query you entered: