'Analyze SQL query DBeaver
I would like to get some info about running query to analyze it. In PgAdmin III I could at least use 'Explain Query', in DBeaver after click 'Explain Execution Plan' nothing happens.
How to obtain any information about query in DBeaver?
@Edit
Sorry if this question seems too broad. I don't expect explanation of query analyze, I just would like to know if it is possible to open analyzer in DBeaver and how to do it.
Solution 1:[1]
Solution 2:[2]
The shortcut does not work for me. Use a mouse-click instead:
Example with
SELECT 1;
Or use the EXPLAIN command:
EXPLAIN SELECT 1;
A longer query could look like this, see https://dbeaver.com/docs/wiki/Query-Execution-Plan/ as said in the other answer as well:
Simple plan view
Advanced plan view
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.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | Nastia |
| Solution 2 |