Telemetry
Interactive SaaS SQL Lab

Reliability · Intermediate

Compare release reliability

Which checkout release coincides with higher errors and average latency?

Compare equal 10-day release windows from the service-event table while keeping request volume, failures, rate, and latency together.

Reviewed by the Telemetry product team on . Read-only SQL, connected-table grain, deterministic result, visualization, and interpretation boundaries. Review standards and ownership

Runs against one versioned 15-table dataset

Edit and execute the query locally in your browser, then download the same synthetic schema and rows for DuckDB.

ReliabilityIntermediate

Compare release reliability

Which checkout release coincides with higher errors and average latency?

Compare equal 10-day release windows from the service-event table while keeping request volume, failures, rate, and latency together.

The dataset and query remain in this browser.

Published expected result

Checkout error rate by release

releasecheckout_requestserrorserror_rate_pctaverage_latency_ms
2026.06.4900222.44310.5
2026.07.1900849.33453.1
2026.07.2900242.67309.5

How to read the query

  • Filtering to one service avoids mixing workflows with different latency and error baselines.
  • Each synthetic release has equal volume and a complete 10-day window, making the comparison shape inspectable.
  • The query identifies correlation with a release; it does not establish that the deployment caused the regression.

Decisions the SQL cannot make

  1. 1Compare equivalent rollout populations, routes, regions, and observation windows.
  2. 2Use a tail percentile instead of an average when the engine-specific function has been validated.
  3. 3Confirm a suspected regression with deploy metadata, error categories, and traces.

Continue from this lesson