Query Execution Plan

Table of contents

• Supported databases
• Generate an execution plan
• Table plan view
• Detailed execution information

View query execution plans to understand how a database executes SQL statements and identify expensive operations.

The execution plan view helps you:

• Identify expensive operations: Pinpoint which parts of your query consume the most resources.
• Analyze execution flow: Trace the sequence of database operations from start to finish.
• Find bottlenecks: Locate performance issues in joins, scans, and sorting operations.
• Understand relationships: Visualize how data moves between different query steps.

Supported databases

• MySQL
• PostgreSQL
• Microsoft SQL Server
• Oracle
• DB2 LUW
• SAP HANA
• Google Cloud SQL for PostgreSQL
• Google Cloud SQL for SQL Server
• Google Cloud SQL for MySQL
• Couchbase
• Firebird
• Exasol
• HSQLDB
• Vertica
• ClickHouse
• AlloyDB
• Netezza
• OceanBase
• Ocient

Generate an execution plan

1. Open the SQL Editor.
2. Write a query.
3. Click Explain Execution Plan () in the editor toolbar.

Table plan view

The table plan view displays the execution plan as a table.

Select a row to view detailed execution information.

Detailed execution information

Select a node to view detailed execution information.

Execution plan data is provided directly by the database engine. The meaning of specific operations, metrics, and attributes depends on the database system you are using. For detailed information about execution plan operations and metrics, see the documentation for your database system.