Re: Constraint Exclusion on all tables - Mailing list pgsql-hackers

From Germán Poó Caamaño
Subject Re: Constraint Exclusion on all tables
Date
Msg-id 1122044393.5515.18.camel@cronos
Whole thread Raw
In response to Re: Constraint Exclusion on all tables  (Sam Mason <sam@samason.me.uk>)
List pgsql-hackers
Le vendredi 22 juillet 2005 à 15:44 +0100, Sam Mason a écrit :
> Dawid Kuroczko wrote:
> >Hmm, methinks it wouldn't be a very difficult "beginner's project" in
> >PostgreSQL hacking, to add "script-friendly" format for EXPLAIN
> >command.  I am not sure if I'll make it, but I'm willing to try...
> 
> It occured to me that it may be good to create a new datatype for
> the results.  The data type's default textual format could be the
> same as the current output, but you could then provide functions
> that operate on these structures to extract the relavent bits in a
> format that your extrnal analysis tool can use.

Denys (in CC) wrote an XML output for EXPLAIN to be used by any
program in a easy way.  In that way, he replaced the current output
of explain.  So, I'm working in a patch that extends EXPLAIN and
give the chance to get the output as text (as usual) or xml.

So, you'd be able to run EXPLAIN ANALYZE XML to get the output
in XML, that could be parsed by whatever script/program.

I hope to get a patch in the next days, according to my spare
time.

Regards,

-- 
Germán Poó Caamaño
http://www.ubiobio.cl/~gpoo/



pgsql-hackers by date:

Previous
From: Sam Mason
Date:
Subject: Re: Constraint Exclusion on all tables
Next
From: Tom Lane
Date:
Subject: Re: [PERFORM] Planner doesn't look at LIMIT?