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