with t1 (stat, ts, ndx) as ( select monitor_status, performed_at, row_number() over(order by performed_at) from uptime_checks ) , t2 (stat, startts, endts) as ( select t1.stat, t1.ts, coalesce(t2.ts, now()) from t1 left join t1 t2 on t2.ndx = t1.ndx + 1 ) select stat, startts, endts, timestampdiff(second, startts, endts) as elapsed from t2 order by startts
Created
April 26, 2020 12:55
-
-
Save 3YH/9691a1d94790f5552c01ccd4512aecdf to your computer and use it in GitHub Desktop.
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment