Show Kusto query plan like EXPLAIN

Viewed 398

I find myself using the Kusto query language (KQL) via Azure Log Analytics, and I'm struggling to find a way to get any sort of detailed execution report or query plan.

In PostgreSQL I'd use EXPLAIN to produce a report on how the DBMS intends to execute the query, or EXPLAIN ANALYZE for a report on how a query actually got executed. Is there anything akin to that in KQL?

Searches for "kql query plan", "kusto explain query" etc have been largely fruitless, but this probably just means I don't know the right terms.

1 Answers
  • Supporting the suggestion provided by David דודו Markovitz and posting that as an answer to help the other community members who are having the related discussions.
  • Yes I do agree that Log analytics has many limitations and we can't link or query log analytics from ADX web UI.
  • Here are the few documents related to Log Analytics and it's limitations.
Related