Explain with schema

Started by Cristiano Duarteabout 15 years ago2 messageshackers
Jump to latest
#1Cristiano Duarte
cunha17@gmail.com

Greetings,

I was thinking about an old 2007 topic, where schema
qualification was proposed on the EXPLAIN output
(http://archives.postgresql.org/pgsql-
hackers/2007-06/msg00473.php).

Besides my need for this "feature" for my own PgFoundry
project (that need to parse the explain output), at that time,
it seemed that a XML output maybe fit this requirement.

For some time, postgresql has XML output. So, is it possible
to place, at least on the XML output, the schema name of the
objects involved?

--
Regards,

Cristiano da Cunha Duarte

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Cristiano Duarte (#1)
Re: Explain with schema

Cristiano Duarte <cunha17@gmail.com> writes:

I was thinking about an old 2007 topic, where schema
qualification was proposed on the EXPLAIN output
(http://archives.postgresql.org/pgsql-
hackers/2007-06/msg00473.php).

Besides my need for this "feature" for my own PgFoundry
project (that need to parse the explain output), at that time,
it seemed that a XML output maybe fit this requirement.

For some time, postgresql has XML output. So, is it possible
to place, at least on the XML output, the schema name of the
objects involved?

See EXPLAIN (VERBOSE, FORMAT XML) ...

regards, tom lane