Devart Forums

Is it possible to retrieve an execution plan without running the query.
The "Generate Execution Plan" appear to run a "EXPLAIN (ANALYZE, BUFFERS, FORMAT XML, VERBOSE) select .." .
My problem is that EXPLAIN ANALYZE will run the query, and if you have queries that have a hight cost, it will take a long time to get the plan.

I am searching for a way to run an explain without extra parameters. Which would then return without actually running the query.
I can ofcouse run it manually with the query: "explain select ...", but then i would not get any of the graphical layout of the plan.

There is no such a possibility.

Ok, that is a shame.
I cannot really wait +5 minutes for a query plan, I will probably need to continue using another tool then or live with the standard postgres textbased query plan.

Thank you for bringing this to our attention.

We will make such a possibility in the next version 2.3 of dbForge Studio for PostgreSQL.