On Tue, Aug 1, 2017 at 6:35 PM, Remi Colinet <remi(dot)colinet(at)gmail(dot)com> wrote:
> I'am skeptical about the use of JSON, XML, and others in such output.
You should not.
> Does anyone use these formats (XML, JSON, YAML) for EXPLAIN output?
> I suspect only TEXT format is being used.
I think that Depesz makes use of a non-default format for its
explain.depesz.com, or he would have a hard time maintaining a
deparsing API for its application. JSON is for example easy to extract
and reformat when doing analysis of the inner planner nodes, and
Postgres has json and xml data types, which makes analysis with SQL
even easier sometimes.
--
Michael