Viewing a SQL query execution plan lets you analyze query run time and cost to ensure that your queries run as efficiently as possible.

You are logged in to Data Director as a user with appropriate privileges on the database or schema.

You know how to enter and run a SQL query. See Enter and Run a SQL Query.


Click the Manage and Monitor tab.


Right-click a database and select Open vPostgres Console.


Expand Schemas in the left pane.


Select a schema and click Enter SQL.


Enter a SQL query in the entry pane, or click Open to open a SQL script file.


Click Execute to run the query.


Click Explain to view the query plan, runtime, and CPU cost.

Adjust the SQL query, rerun, and reexamine the query plan to tune performance.