I'm using ADX as one of my backend and trying to debug the query performance using .show queryplan command. Not able to find any documentation on the output of queryplan command. Anybody know what plansize, relopsize, replotree mean in the output ?

I'm using ADX as one of my backend and trying to debug the query performance using .show queryplan command. Not able to find any documentation on the output of queryplan command. Anybody know what plansize, relopsize, replotree mean in the output ?

• azure
• kql
• azure-data-explorer

• Can you provide your query and the output that you got? and what is your expected output here? – Rakesh Govindula Commented yesterday
• @RakeshGovindula : I'm trying to understand these terms irrespective of the output. I don't have any expected output because I don't understand what's replotree – voidMainReturn Commented yesterday

1 Answer 1

I have tried the above query and it is giving syntax error for me.

I have tried for the documentation but not able to find it.

I'm using ADX as one of my backend and trying to debug the query performance

You can use .show queries command for this requirement. This will give the query performance details like Memory usage, Totalcpu consumed time by the query, cacheStatistics..etc.

Sample demo: