unexpectedly long query run time

[PsiACE]

Typically, most queries on the ontime dataset can be completed in less than 1 second.

However, in several recent performance tests, some statements may experience severe timeouts, even taking tens of minutes, until jwt expired.

query	expected	actual	history
SELECT DayOfWeek, count(*) AS c FROM default.ontime WHERE DepDelay>10 AND Year >= 2000 AND Year <= 2008 GROUP BY DayOfWeek ORDER BY c DESC;	< 0.5s	42min
SELECT IATA_CODE_Reporting_Airline AS Carrier, avg(DepDelay) * 1000 AS c3 FROM default.ontime WHERE Year >= 2000 AND Year <= 2008 GROUP BY Carrier;	< 1s	> 60min	https://github.com/datafuselabs/databend-perf/runs/7172566428?check_suite_focus=true
SELECT IATA_CODE_Reporting_Airline AS Carrier, avg(cast(DepDelay\u003e10 as Int8))*1000 AS c3 FROM default.ontime WHERE Year\u003e=2000 AND Year \u003c=2008 GROUP BY Carrier ORDER BY c3 DESC;	<0.5s		https://github.com/datafuselabs/databend-perf/runs/7159465292?check_suite_focus=true

[PsiACE]

It may be necessary to check if there is a scheduling problem, or if there is some other fault with the databend.

[flaneur2020]

it looks like these queries get slow again.