tinybird

SELECT * FROM tinybird.datasources_ops_log
WHERE datasource_id = 't_91b7f5fed9a74bf4a780da9d8599f5b4'
ORDER BY timestamp desc

SELECT neighbor(timestamp, -1) - timestamp delay
FROM madrid_rt_traffic_imports 
limit 300
offset 1

SELECT avg(delay) avg_delay, stddevPop(delay) stddev FROM delays

with (select avg_delay + 3*stddev from stats) as max_delay
select now() - timestamp > max_delay as alert
from madrid_rt_traffic_imports limit 1

SELECT delay x_delay, count() b_count FROM delays
group by x_delay