On 11 July 2016 at 23:29, Tom Lane <t...@sss.pgh.pa.us> wrote:

> Srinivas Karthik V <skarthikv.i...@gmail.com> writes:
> > Specifically, I have a Java program which calls
> > ResultSet rs = statement.executeQuery("explain select * from table");
> > I would like to change PostgreSQL such that ResultSet rs should contain a
> > field that contains also the cost of the optimizer chosen plan.
> Why do you need to change anything?  The cost is right there in the
> first line of the result text.  It might be easier to parse out if
> you use one of EXPLAIN's intended-to-be-machine-readable output
> formats, though. <http://www.postgresql.org/mailpref/pgsql-hackers>

Yeah - if we were going to do this at all, it'd want to be output that
decomposes _all_ the explain output into columns.  But since we can emit
json, xml, etc, I don't really see the point.

 Craig Ringer                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services

Reply via email to