'Does QuestDB have EXPLAIN

Postgres has syntax to show the query plan for a SQL statement:

https://www.postgresql.org/docs/9.4/using-explain.html

Does QuestDB have something equivalent so that I can see the query plan that would result from my SQL before actually executing it?

questdb


Solution 1:[1]

The QuestDB docs show an explain option for the /exec HTTP endpoint. However, I can't get it to work on my instance running v6.2.

It should work like this:

curl -G \
    --data-urlencode "query=select * from t limit 2;" \
    --data-urlencode "explain=true" \
    http://localhost:9000/exec

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 nslocum

Related Questions