Search code examples
azureazure-functionsazure-application-insightskqlazure-durable-functions

What the Application Insights query represents


Assume I am sending 1 request per 10 minutes in Azure Durable Functions. Then, in the Applications Insights log, enter the following in the query

requests
| where timestamp > ago(10m) 
| summarize avg(duration) by bin(timestamp, 1m)
| render scatterchart

In this case, the "avg_duration" displayed in the result is the response time from the time one request is triggered to the time the result is returned?

In the case of a picture, Trigger -> client function -> ... -> client function -> return Does this picture mean that this entire sequence took 3075ms? Or is this time a fragment of the sequence? enter image description here


Solution

  • In the case of a picture, Trigger -> client function -> ... -> client function -> return Does this picture mean that this entire sequence took 3075ms? Or is this time a fragment of the sequence?

    requests
    | where name == "client_function"
    | where timestamp > ago(10m)
    | summarize avg(duration) by bin(timestamp, 1m)
    | render scatterchart  
    

    Yes, it is providing the total time taken by the entire sequence to complete.

    enter image description here

    You can verify the same in Monitor blade of client_function.

    enter image description here

    You can also get the duration from logs using requests.

    enter image description here