How to convert time in 'slow query widget' in ADS?

Question

Hello,

I wanted to follow steps described in article 'how to analyze' ADS widget ' slow query'

I opened 'Manage' from right-click on database. Then I selected 'Show Details'. Selected one query and see that max_duration was 390180823

Now I want to understand it in seconds or minutes. I know that UI shows in milliseconds but table in microseconds. Hence I assume it's Table i.e. microseconds .. .I do the following:

390180823 / 1000 / 1000 / 60 and expect to see it in minutes i.e. 6.5 minutes.

Is my calculation correct?

Thanks

Answer 1

I looked again and I think it should make sense.

First I recall that when I installed app it suggested me to set execution time in UTC hence I see in 'Details' time e.g. 10:19:43 in UTC. In my SQL execution I see it in my local time i.e. 6:04:34.

Hence .. if I substract 4 hours from UTC I will get my local time in EDT ..

Had to think more before filing a ticket :)

Answer 2

I think that my last comment is an answer