1.0
Table Of Contents
- VMware vFabric Data Director Administrator and User Guide
- Contents
- About VMware vFabric Data Director
- Updated Information
- VMware vFabric Data Director and vFabric Postgres Overview
- Managing Data Director Resources
- Managing Users and Roles
- Managing Organizations
- Managing Database Groups
- Managing Database Templates
- Managing Databases
- Cloning Databases
- Managing Database Entities
- Safeguarding Data
- Monitoring the Data Director Environment
- Managing Licenses
- Reconfiguring Data Director Networks
- Change the vCenter IP Address
- Reconfigure the Web Console Network Mapping or Network Adapter
- Reconfigure the vCenter Network Mapping
- Reconfigure the vCenter Network Adapter Settings
- Reconfigure the DB Name Service Network or DB Name Service Network Adapter
- Reconfigure the Internal Network or Internal Network Adapter Mapping
- Verify Network Settings in Data Director
- Data Director Troubleshooting
- Index
View a Query Plan
Viewing a SQL query execution plan enables you to analyze query run time and cost to ensure that your queries
run as efficiently as possible.
Prerequisites
n
You are logged in to Data Director as a user with appropriate privileges on the database or schema.
n
You know how to enter and run a SQL query. See “Enter and Run a SQL Query,” on page 75.
Procedure
1 Click the Manage & Monitor tab and select the schema for which you want to view a query pane.
2 Select the schema, and click Enter SQL.
3 Enter a SQL query in the entry pane, or click Open to open a SQL script file.
4 Click Execute to run the query.
5 Click Explain to view the query plan, run time, and CPU cost.
What to do next
Adjust the SQL query, rerun, and reexamine the query plan as necessary to tune performance.
VMware vFabric Data Director Administrator and User Guide
76 VMware, Inc.