Queries for the OTelSpans table

For information on using these queries in the Azure portal, see Log Analytics tutorial. For the REST API, see Query.

Application performance overview

Show span count and average duration by service and operation name over the last hour.

OTelSpans
| where TimeGenerated > ago(1h)
| summarize
    SpanCount = count(),
    AvgDurationMs = avg(DurationMs),
    P50DurationMs = percentile(DurationMs, 50),
    P95DurationMs = percentile(DurationMs, 95),
    ErrorCount = countif(Success == false)
    by ServiceName, Name
| extend ErrorRate = round(100.0 * ErrorCount / SpanCount, 2)
| order by SpanCount desc
| limit 100