admin管理员组

文章数量:1221290

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 ?

Share Improve this question asked Feb 7 at 19:18 voidMainReturnvoidMainReturn 3,5077 gold badges40 silver badges71 bronze badges 2
  • 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
Add a comment  | 

1 Answer 1

Reset to default 0

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:

本文标签: azureMicrosoft kusto show queryplan documentationStack Overflow