Query Execution Plan
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.
- 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
- Open the SQL Editor.
- Write a query.
- Click Explain Execution Plan (
) in the editor toolbar.
The table plan view displays the execution plan as a table.
Select a row to view 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.
- Getting started
- Create connection
- Connection network options
- Supported databases
-
Drivers management
- Database authentication methods
- Database navigator
- Properties editor
- Data editor
- SQL editor
-
Entity relation diagrams
- Cloud services
- Data transfer
- General user guide
- Administration
- Server configuration
-
Server security and access configuration
- Authentication methods
- Access management
- Proxy configuration
-
Secret management
- Logs
-
Query manager
- Workspace location
- Command line parameters
-
Session manager
- Deployment options
- CloudBeaver Editions
- FAQ
- Development