Hi Tom,
Yes, we indeed get the cost of the plan at the first line itself. Somehow,
I missed this point. We just in fact implemented this functionality and its
working. Thanks again.
Regards,
Srinivas Karthik
On Tue, Jul 12, 2016 at 6:43 AM, Craig Ringer wrote:
> On 11 July 2016 at 23:29, Tom L
On 11 July 2016 at 23:29, Tom Lane wrote:
> Srinivas Karthik V 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 contai
Srinivas Karthik V 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
Hello,
I am Srinivas and have been working inside PostgreSQL (mostly in the
optimizer module and few times in the executor module). I would like to
change PostgreSQL code such that it also returns the cost of the optimizer
chosen plan to the Java program (through JDBC) as part of the result set.