Analyze SQL query in DBeaver

Question

I would like to get some info about a running query to analyze it. In PgAdmin 3 I could at least use 'Explain Query', while in DBeaver, after clicking '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 how to analyze the query, I just would like to know if it is possible to open an analyzer in DBeaver and how to do it.

Answer 1

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.

Answer 2

Click on a query and press Ctrl+Shift+E

https://dbeaver.com/docs/wiki/Query-Execution-Plan/