* | selectround(compare[3], 4) as ratio,compare[1] as current_avg_request_time,compare[2] as yesterday_avg_request_timefrom(select compare(avg_request_time, 86400) as comparefrom(select avg("request_time") as avg_request_time))
ratio indicates the ratio of the current average API response time to the value yesterday (86,400 seconds earlier).current_avg_request_time indicates the current average API response time.yesterday_avg_request_time indicates the average API response time in the same period yesterday.compare function is used in the above statement. For more information, see Interval-Valued Comparison and Periodicity-Valued Comparison Functions.$1.ratio > 1.5
ratio exceeds 1.5, that is, the time is over 50% longer than that yesterday.Feedback