Skip to content
Telemetry
Interactive SaaS SQL lab

Database reliability · Beginner

Audit database migration reliability

Did a release make database migrations less reliable?

Measure migration success, rollback behavior, and duration by application release.

Reviewed by the Telemetry product team on . We checked the read-only SQL, table joins, sample results and chart, and what the results mean. Who reviews this page

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.

Database reliabilityBeginner

Audit database migration reliability

Did a release make database migrations less reliable?

Measure migration success, rollback behavior, and duration by application release.

The dataset and query remain in this browser.

Expected result

Migration success rate by release

releasemigration_runssuccessful_runsfailed_runssuccess_rate_pctaverage_duration_ms
2026.07.13301001,300
2026.07.2422501,450
2026.07.32201001,125

How to read the query

  • The release reliability rate counts rolled-back operations as unsuccessful.
  • Duration trends can reveal increasingly expensive schema changes before they fail.
  • The migration identifier remains available for drilling into individual executions.

How to interpret the results

  1. 1Block promotion when a release contains an unexplained failed or rolled-back migration.
  2. 2Review long-running migrations for locking and deploy-window risk.
  3. 3Separate retry success from first-attempt success if your runner emits attempts.

Related lessons

Keep the result

Run this query on your own events

Create a free workspace only when you are ready to save the query, connect real events, and monitor the result. No credit card is required.

Save with my events