Re: Output format of explain

On Thu, Nov 2, 2017 at 1:34 PM, Johann Spies <jspies(at)sun(dot)ac(dot)za> wrote:

> Maybe because I do not spend enough time in reading the output of
> "explain" results, I made use of the website https://explain.depesz.com/
> in the past to quickly identify the problem areas in complicated
> queries.
>
> Now I cannot do it as the output is in json format and there is (as far
> as I could figure out) not an option to change the format.
>
> Or is there?
>

No, because JSON is what pgAdmin knows how to interpret so that's what it
requests to render the plan etc.

If you want other formats, you can run the explain query directly, e.g.

EXPLAIN SELECT ...

--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company