1、有一个sql查询时特别耗时，能分析下原因么？
sql如下：
SELECT
current,
ctime,
cellVoltages,
vin,
probeTemperatures
FROM
(
SELECT
vin,
ctime,
current,
cellVoltages,
probeTemperatures,
crc32(vin) AS vin_crc
FROM
battery_dwd.dwd_all
WHERE
dayOfYear IN ('2025-06-08', '2025-06-09')
AND vehicleFactory = 26
AND crc32(vin) BETWEEN 42949670 AND 51539603
AND IFNULL(json_extract(customField, '$.repeatCount'), 0) < 1
) AS subq
WHERE
(
(cellVoltages IS NOT NULL)
AND (probeTemperatures IS NOT NULL)
AND (vin IS NOT NULL)
)
AND (vin_crc >= 49392119)
2、查询的queryprofile文件如下
3、OLAP_SCAN_OPERATOR耗时详情如下
OLAP_SCAN_OPERATOR (id=0. table name = dwd_all(dwd_all)):
- BlocksProduced: sum 3.723K (3723), avg 232, max 433, min 0
- CloseTime: avg 6.316ms, max 36.797ms, min 0ns
- ExecTime: avg 3m50s, max 7m28s, min 7.161ms
- InitTime: avg 97.462us, max 122.823us, min 70.837us
- MemoryUsage: sum , avg , max , min
- PeakMemoryUsage: sum 0.00 , avg 0.00 , max 0.00 , min 0.00
- OpenTime: avg 860.17us, max 2.819ms, min 264.574us
- ProjectionTime: avg 0ns, max 0ns, min 0ns
- RowsProduced: sum 127.157K (127157), avg 7.947K (7947), max 18.484K (18484), min 0
- RuntimeFilterInfo: sum , avg , max , min
- filter id = -1 filtered: sum 0, avg 0, max 0, min 0
- filter id = -1 input: sum 3.452760071B (3452760071), avg 215.797504M (215797504), max 487.492658M (487492658), min 115.33032M (115330320)
- WaitForDependency[OLAP_SCAN_OPERATOR_DEPENDENCY]Time: avg 3m50s, max 7m28s, min 0ns
VScanner: - MemoryUsage: sum , avg , max , min
- FreeBlocks: sum 0.00 , avg 0.00 , max 0.00 , min 0.00
