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.