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?
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