Query Execution Plan
This feature is supported for the following data sources:
The Execution plan for databases marked with a star is supported only in Lite, Enterprise and Ultimate editions
- 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
If a database driver supports the visualization of the execution plan, you can see the execution plan of the current query (under cursor) by pressing Ctrl+Shift+E or clicking Explain execution plan on the context menu or in the SQL Editor toolbar: (Note: toolbar is customizable. See Toolbar Customization) The execution plan command generates a tree of query execution as one of the result tabs and is convenient in estimating if the query/script is quick/optimal enough:
You can click the rows of the execution plan to see their details (statistics) in the panels below and to the right of the plan.
To reevaluate the plan, click the Reevaluate button ().
To see the source script on which the plan is based, click the View Source button ().
In DBeaver Lite, Enterprise, and Ultimate editions you can use an advanced (graph) visualization of the execution plan.
This visualization shows the most expensive (cost-based) plan nodes. You can hide all irrelevant nodes (see node details), use horizontal or vertical plan layouts, export it to an image or save it as JSON to send to a colleague.
- Installation
- Application Window Overview
- Views
- Database Object Editor
- SQL Editor
- Search
- Schema compare
- Using Liquibase in DBeaver
- Data compare
- MockData generation
- Spelling
- Dashboards, DB monitoring
- Projects
- Managing Master password
- Security in PRO products
- Certificate Management
- Bookmarks
- Shortcuts
- Accessibility
- Sample Database
-
Database Connections
- Edit Connection
- Invalidate/Reconnect to Database
- Disconnect from Database
- Change current user password
- Advanced settings
- Cloud configuration settings
- Local Client Configuration
- Connection Types
- Configure Connection Initialization Settings
- Tableau integration
- Transactions
- Drivers
- Tasks
- Cloud Explorer
- Cloud Storage
- Classic
- Cloud
- Changing interface language
- DBeaver extensions - Office, Debugger, SVG
- Installing extensions - Themes, version control, etc
- User Interface Themes
- Command Line
- Reset UI settings
- Reset workspace
- Troubleshooting system issues
- Posting issues
- Log files
- JDBC trace
- Thread dump
- Managing connections
- Managing variables
- Managing drivers
- Managing preferences
- Managing restrictions
- Windows Silent Install
- Snap installation