Thread: Explain with schema

Explain with schema

From
Cristiano Duarte
Date:
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


Re: Explain with schema

From
Tom Lane
Date:
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