Re: [HACKERS] Changing the result set to contain the cost of the optimizer's chosen plan

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

Re: [HACKERS] Changing the result set to contain the cost of the optimizer's chosen plan

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

Re: [HACKERS] Changing the result set to contain the cost of the optimizer's chosen plan

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

[HACKERS] Changing the result set to contain the cost of the optimizer's chosen plan

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.