Thread: Output format of explain

Output format of explain

From

Johann Spies

Date:

02 November 2017, 19:34:24

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?

Regards
Johann
-- 
Johann Spies                            Telefoon: 021-808 4699
Databestuurder /  Data manager        Faks: 021-883 3691

Sentrum vir Navorsing oor Evaluasie, Wetenskap en Tegnologie
Centre for Research on Evaluation, Science and Technology 
Universiteit Stellenbosch.

The integrity and confidentiality of this email is governed by these terms / Hierdie terme bepaal die integriteit en
vertroulikheidvan hierdie epos. http://www.sun.ac.za/emaildisclaimer

Re: Output format of explain

From

Dave Page

Date:

02 November 2017, 20:09:53

On Thu, Nov 2, 2017 at 1:34 PM, Johann Spies <jspies@sun.ac.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