Disable "executionPlan" in Rest API json response

[abdusahin]

OrientDB Version: 3.0.13

Java Version: 1.8-openjdk

OS: RedHat

Expected behavior

Do not return "executionPlan" field in the REST API response, or add configuration parameter to enable or disable it.

Actual behavior

"executionPlan" field is returned in REST API response, which results in a huge json response size.

{"result":[{"@type":"d"," ..... ,
"executionPlan":{"@type":"d","@version":0,"cost":0,"prettyPrint":"+ .....
}

Steps to reproduce

curl -v -u username:password http://localhost:2480/query/<db-name>/sql/select%20from%20<table>

[luigidellaquila]

Hi @abdusahin

It makes a lot of sense and we already discussed it internally.
We'll implement it ASAP, probably with a header parameter in the REST API

I'll keep you updated

Thanks

Luigi

[luigidellaquila]

Hi @abdusahin

I just added a quick fix for this, you can:

set HTTP header: return-execution-plan = false
or
from JSON request body: returnExecutionPlan:”false”

The fix will be released with v 3.0.15

Thanks

Luigi

[abdusahin]

Woow, that's the fastest response I've ever got on github.
Thanks @luigidellaquila, I'll give it a try.

[kevin-holbrook-epicor]

From the documentation this looks like it was only added to the POST command, but what about the "GET - Query" variant?

[luigidellaquila]

Hi @kevin-holbrook-epicor

As of now it is not supported, but we can consider to add it as a query string param, eg.

http://localhost:2480/query/test/sql/select from v?returnExecutionPlan=false

or as an http header

Thanks

Luigi

[octavonu]

Hello,

Do you have any solution for GET requests? It is still returning the executionPlan object.

Thank you