Query plan without actually running the query?

Discussion of open issues, suggestions and bugs regarding database management and development tools for PostgreSQL
Post Reply
kenand
Posts: 2
Joined: Wed 25 Mar 2020 11:03

Query plan without actually running the query?

Post by kenand » Wed 25 Mar 2020 11:12

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.

alexa
Devart Team
Posts: 2890
Joined: Fri 24 Jun 2011 14:17

Re: Query plan without actually running the query?

Post by alexa » Wed 25 Mar 2020 13:11

There is no such a possibility.

kenand
Posts: 2
Joined: Wed 25 Mar 2020 11:03

Re: Query plan without actually running the query?

Post by kenand » Wed 25 Mar 2020 14:05

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.

alexa
Devart Team
Posts: 2890
Joined: Fri 24 Jun 2011 14:17

Re: Query plan without actually running the query?

Post by alexa » Wed 25 Mar 2020 15:26

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.

Post Reply