Doris SQL解析慢

Summary:
- Profile ID: d0a039b89e344c13-95bd0e4ed2d77729
- Task Type: QUERY
- Start Time: 2025-07-22 18:12:39
- End Time: 2025-07-22 18:12:57
- Total: 18s654ms
- Task State: EOF
- User: root
- Default Catalog: internal
- Default Db: data_gdp
- Sql Statement: WITH tmp_3616 AS (SELECT f2_3616, f17_3616, f21_3616, f24_3616, f29_3616, f30_3616, f51_3616, f57_3616, f55_3616, f58_3616, f68_3616, f69_3616, f70_3616, f72_3616, f73_3616, f74_3616, f75_3616, f78_3616, f34_3616, f36_3616, f37_3616, f38_3616, f39_3616, f40_3616, f31_3616, ROW_NUMBER() OVER (PARTITION BY f2_3616 ORDER BY f3_3616 DESC, f4_3616 DESC) AS rank_num FROM tb_3616 WHERE f4_3616 NOT IN (103200106, 103200107) AND f1_3616 = 'C900001951'), tmp_3612 AS (SELECT f2_3612, f8_3612, f47_3612, ROW_NUMBER() OVER (PARTITION BY f2_3612 ORDER BY f3_3612 DESC) AS rank_num FROM tb_3612 WHERE f1_3612 = 'C900001951' AND f4_3612 IN (103200101, 103200105)), tmp_3300 AS (SELECT B.f1_3300, A.f3_3619, MAX(B.f2_3300) AS f2_3300, MAX(C.f3_3105) AS f3_3105 FROM tb_3619 AS A INNER JOIN tb_3300 AS B ON B.f1_3300 = 'F103003870' AND A.f3_3619 >= B.f2_3300 LEFT JOIN tb_3105 AS C ON A.f1_3619 = C.f1_3105 AND A.f3_3619 >= C.f3_3105 WHERE A.f1_3619 = 'C900001951' GROUP BY B.f1_3300, A.f3_3619), tmp_3105 AS (SELECT A.f3_3105, A.f7_3105 / IFNULL(C.f5_3006, 1) AS f7_3105 FROM tb_3105 AS A INNER JOIN tb_0002 AS B ON A.f1_3105 = B.f15_0002 AND B.f1_0002 = 'F103003870' LEFT JOIN tb_3006 AS C ON B.f1_0002 = C.f1_3006 AND A.f3_3105 >= C.f6_3006 AND (C.f7_3006 IS NULL OR A.f3_3105 < C.f7_3006) WHERE A.f1_3105 = 'C900001951'), tmp_3617_pre AS (SELECT A.f3_3619, MAX(B.f2_3617) AS f2_3617, MAX(IF(DATE_FORMAT(B.f2_3617, '%m%d') = '1231', B.f2_3617, NULL)) AS f2_3617_lyr FROM tb_3619 AS A INNER JOIN tb_3617 AS B ON A.f1_3619 = B.f1_3617 AND f4_3617 IN (103200101, 103200102, 103200103, 103200104, 103200105) AND A.f3_3619 > B.f2_3617 AND A.f3_3619 > B.f3_3617 WHERE A.f1_3619 = 'C900001951' GROUP BY A.f3_3619), tmp_3617 AS (SELECT f2_3617, f25_3617, f41_3617, ROW_NUMBER() OVER (PARTITION BY f2_3617 ORDER BY f3_3617 DESC) AS rank_num FROM tb_3617 WHERE f1_3617 = 'C900001951' AND f4_3617 IN (103200101, 103200102, 103200103, 103200104, 103200105)), tmp_3611 AS (SELECT f2_3611, IFNULL(f185_3611, IFNULL(f185_3611, 0) + IFNULL(f187_3611, 0)) AS f185_3611, ROW_NUMBER() OVER (PARTITION BY f2_3611 ORDER BY f3_3611 DESC) AS rank_num FROM tb_3611 WHERE f1_3611 = 'C900001951' AND f4_3611 IN (103200101, 103200102, 103200103, 103200104, 103200105)) SELECT 1 AS dimension, C.f1_3619 AS party_id, C.f3_3619 AS reportDate, CONCAT(YEAR(C.f3_3619), CASE WHEN DATE_FORMAT(C.f3_3619, '%m%d') = '0331' THEN '年一季报' WHEN DATE_FORMAT(C.f3_3619, '%m%d') = '0630' THEN '年中报' WHEN DATE_FORMAT(C.f3_3619, '%m%d') = '0930' THEN '年三季报' WHEN DATE_FORMAT(C.f3_3619, '%m%d') = '1231' THEN '年年报' END) AS f2_3616, IF(C.f3_3619 > D.f9_0002, '上市后', '上市前') AS listed, '合并报表' AS rptType, ROUND(C.f4_3619, 2) AS f4_3619, ROUND(C.f5_3619, 2) AS f5_3619, ROUND(C.f7_3619, 2) AS f7_3619, ROUND(C.f6_3619, 2) AS f6_3619, ROUND(C.f10_3619, 2) AS f10_3619, ROUND(C.f9_3619, 2) AS f9_3619, ROUND(C.f30_3619, 2) AS f30_3619, ROUND(C.f31_3619, 2) AS f31_3619, ROUND(C.f29_3619, 2) AS f29_3619, ROUND(C.f32_3619, 2) AS f32_3619, ROUND(C.f8_3612, 2) AS f8_3612, ROUND(C.f140_3619, 2) AS f8_3612_yoy, ROUND(C.f47_3612, 2) AS f47_3612, ROUND(C.f21_3616, 2) AS f21_3616, ROUND(C.f134_3619, 2) AS f21_3616_yoy, ROUND(C.f24_3616, 2) AS f24_3616, ROUND(C.f136_3619, 2) AS f24_3616_yoy, ROUND(C.f29_3616, 2) AS f29_3616, ROUND(C.f138_3619, 2) AS f29_3616_yoy, ROUND(C.f77_3619, 2) AS f77_3619, ROUND(C.f142_3619, 2) AS f77_3619_yoy, ROUND(C.f30_3616, 2) AS f30_3616, ROUND(C.f79_3619, 2) AS f79_3619, ROUND(C.f144_3619, 2) AS f79_3619_yoy, ROUND(C.f51_3616, 2) AS f51_3616, ROUND(C.f57_3616, 2) AS f57_3616, ROUND(C.f55_3616, 2) AS f55_3616, ROUND(C.f58_3616, 2) AS f58_3616, ROUND(C.f155_3619, 2) AS f58_3616_yoy, ROUND(C.f68_3616, 2) AS f68_3616, ROUND(C.f69_3616, 2) AS f69_3616, ROUND(C.f70_3616, 2) AS f70_3616, ROUND(C.f158_3619, 2) AS f70_3616_yoy, ROUND(C.f72_3616, 2) AS f72_3616, ROUND(C.f73_3616, 2) AS f73_3616, ROUND(C.f74_3616, 2) AS f74_3616, ROUND(C.f75_3616, 2) AS f75_3616, ROUND(C.f153_3619, 2) AS f75_3616_yoy, ROUND(C.f78_3616, 2) AS f78_3616, ROUND(C.f34_3616, 2) AS f34_3616, ROUND(C.f147_3619, 2) AS f147_3619, ROUND(C.f36_3616, 2) AS f36_3616, ROUND(C.f209_3619, 2) AS f209_3619, ROUND(C.f37_3616, 2) AS f37_3616, ROUND(C.f208_3619, 2) AS f208_3619, ROUND(C.f38_3616, 2) AS f38_3616, ROUND(C.f194_3619, 2) AS f194_3619, ROUND(C.f39_3616, 2) AS f39_3616, ROUND(C.f40_3616, 2) AS f40_3616, ROUND(C.f33_3619, 2) AS f33_3619, ROUND(C.f36_3619, 2) AS f36_3619, ROUND(C.f43_3619, 2) AS f43_3619, ROUND(C.f45_3619, 2) AS f45_3619, ROUND(C.f47_3619, 2) AS f47_3619, ROUND(C.f31_3616 / NULLIF(C.f8_3612, 0) * 100, 2) AS f31_3616_sss, ROUND(C.f11_3619, 2) AS f12_3619, ROUND(C.f22_3619, 2) AS f22_3619, ROUND(C.f24_3619, 2) AS f24_3619, ROUND(C.f26_3619, 2) AS f26_3619, ROUND(C.f57_3619, 2) AS f57_3619, ROUND(C.f62_3619, 2) AS f62_3619, ROUND(C.f225_3619, 2) AS f225_3619, ROUND(C.f181_3619, 2) AS f181_3619, ROUND(C.f186_3619, 2) AS f186_3619, ROUND(C.f7_3300 * C.f7_3105 / NULLIF(C.f41_3617, 0), 2) AS P/E(TTM), ROUND(C.f7_3300 * C.f7_3105 / NULLIF(C.f77_3619_lyr, 0), 2) AS P/E(LYR), ROUND(C.f7_3300 * C.f7_3105 / NULLIF((C.f75_3616_pre - C.f185_3611_pre), 0), 2) AS P/B(MRQ), ROUND(C.f7_3300 * C.f7_3105 / NULLIF(C.f25_3617, 0), 2) AS P/S(TTM) FROM (SELECT A.f1_3619, A.f3_3619, A.f4_3619, A.f5_3619, A.f7_3619, A.f6_3619, A.f10_3619, A.f9_3619, A.f30_3619, A.f31_3619, A.f29_3619, A.f32_3619, B.f17_3616, E.f8_3612, E.f47_3612, A.f140_3619, B.f21_3616, A.f134_3619, B.f24_3616, A.f136_3619, B.f29_3616, A.f138_3619, A.f77_3619, A.f142_3619, B.f30_3616, A.f79_3619, A.f144_3619, B.f51_3616, B.f57_3616, B.f55_3616, B.f58_3616, A.f155_3619, B.f68_3616, B.f69_3616, B.f70_3616, A.f158_3619, B.f72_3616, B.f73_3616, B.f74_3616, B.f75_3616, A.f153_3619, B.f78_3616, B.f34_3616, A.f147_3619, B.f36_3616, A.f209_3619, B.f37_3616, A.f208_3619, B.f38_3616, A.f194_3619, B.f39_3616, B.f40_3616, A.f33_3619, A.f36_3619, A.f43_3619, A.f45_3619, A.f47_3619, B.f31_3616, A.f11_3619, A.f22_3619, A.f24_3619, A.f26_3619, A.f57_3619, A.f62_3619, A.f225_3619, A.f181_3619, A.f186_3619, G.f7_3300 AS f7_3300, H.f7_3105 AS f7_3105, I.f25_3617, I.f41_3617, J.f77_3619 AS f77_3619_lyr, K.f75_3616 AS f75_3616_pre, M.f185_3611 AS f185_3611_pre FROM tb_3619 AS A LEFT JOIN tmp_3616 AS B ON A.f3_3619 = B.f2_3616 AND B.rank_num = 1 LEFT JOIN tmp_3612 AS E ON A.f3_3619 = E.f2_3612 AND E.rank_num = 1 LEFT JOIN tmp_3300 AS F ON A.f3_3619 = F.f3_3619 LEFT JOIN tb_3300 AS G ON F.f1_3300 = G.f1_3300 AND F.f2_3300 = G.f2_3300 LEFT JOIN tmp_3105 AS H ON F.f3_3105 = H.f3_3105 LEFT JOIN tmp_3617_pre AS L ON A.f3_3619 = L.f3_3619 LEFT JOIN tmp_3617 AS I ON L.f2_3617 = I.f2_3617 AND I.rank_num = 1 LEFT JOIN tb_3619 AS J ON A.f1_3619 = J.f1_3619 AND L.f2_3617_lyr = J.f3_3619 LEFT JOIN tmp_3616 AS K ON L.f2_3617 = K.f2_3616 AND K.rank_num = 1 LEFT JOIN tmp_3611 AS M ON L.f2_3617 = M.f2_3611 AND M.rank_num = 1 WHERE A.f1_3619 = 'C900001951' AND (FIND_IN_SET(CASE WHEN DATE_FORMAT(A.f3_3619, '%m%d') = '0331' THEN 'Q1' WHEN DATE_FORMAT(A.f3_3619, '%m%d') = '0630' THEN 'Q2' WHEN DATE_FORMAT(A.f3_3619, '%m%d') = '0930' THEN 'Q3' WHEN DATE_FORMAT(A.f3_3619, '%m%d') = '1231' THEN 'Q4' END, 'Q2,Q3,Q1')) AND YEAR(A.f3_3619) >= YEAR((SELECT MAX(f3_3619) FROM tb_3619 WHERE f1_3619 = 'C900001951')) - 3) AS C INNER JOIN tb_0002 AS D ON D.f1_0002 = 'F103003870' ORDER BY C.f3_3619 DESC LIMIT 1001;
Execution Summary:
- Parse SQL Time: 4ms
- Nereids Lock Table Time: 6ms
- Nereids Analysis Time: 6ms
- Nereids Rewrite Time: 30ms
- Nereids Optimize Time: 18s397ms
- Nereids Translate Time: 2ms
- Workload Group: normal
- Analysis Time: 8ms
- Plan Time: 18s434ms
- JoinReorder Time: N/A
- CreateSingleNode Time: N/A
- QueryDistributed Time: N/A
- Init Scan Node Time: N/A
- Finalize Scan Node Time: N/A
- Get Splits Time: N/A
- Get Partitions Time: N/A
- Get Partition Files Time: N/A
- Create Scan Range Time: N/A
- Schedule Time: 65ms
- Fragment Assign Time: 3ms
- Fragment Serialize Time: 24ms
- Fragment RPC Phase1 Time: 36ms
- Fragment RPC Phase2 Time: 2ms
- Fragment Compressed Size: 1.48 MB
- Fragment RPC Count: 12
- Schedule Time Of BE: {"phase1":{"172.16.10.68: 8060":{"RPC Work Time":"22ms","RPC Latency From FE To BE":"2ms","RPC Work Queue Time":"0ms","RPC Latency From BE To FE":"12ms"},"172.16.10.170: 8060":{"RPC Work Time":"21ms","RPC Latency From FE To BE":"0ms","RPC Work Queue Time":"0ms","RPC Latency From BE To FE":"15ms"},"172.16.10.230: 8060":{"RPC Work Time":"35ms","RPC Latency From FE To BE":"1ms","RPC Work Queue Time":"0ms","RPC Latency From BE To FE":"0ms"},"172.16.10.252: 8060":{"RPC Work Time":"23ms","RPC Latency From FE To BE":"1ms","RPC Work Queue Time":"0ms","RPC Latency From BE To FE":"0ms"},"172.16.10.108: 8060":{"RPC Work Time":"22ms","RPC Latency From FE To BE":"1ms","RPC Work Queue Time":"1ms","RPC Latency From BE To FE":"0ms"},"172.16.10.164: 8060":{"RPC Work Time":"22ms","RPC Latency From FE To BE":"1ms","RPC Work Queue Time":"0ms","RPC Latency From BE To FE":"1ms"}},"phase2":{"172.16.10.68: 8060":{"RPC Work Time":"0ms","RPC Latency From FE To BE":"1ms","RPC Work Queue Time":"0ms","RPC Latency From BE To FE":"1ms"},"172.16.10.170: 8060":{"RPC Work Time":"1ms","RPC Latency From FE To BE":"1ms","RPC Work Queue Time":"0ms","RPC Latency From BE To FE":"0ms"},"172.16.10.230: 8060":{"RPC Work Time":"1ms","RPC Latency From FE To BE":"0ms","RPC Work Queue Time":"0ms","RPC Latency From BE To FE":"0ms"},"172.16.10.252: 8060":{"RPC Work Time":"0ms","RPC Latency From FE To BE":"1ms","RPC Work Queue Time":"0ms","RPC Latency From BE To FE":"0ms"},"172.16.10.108: 8060":{"RPC Work Time":"0ms","RPC Latency From FE To BE":"1ms","RPC Work Queue Time":"0ms","RPC Latency From BE To FE":"0ms"},"172.16.10.164: 8060":{"RPC Work Time":"0ms","RPC Latency From FE To BE":"1ms","RPC Work Queue Time":"0ms","RPC Latency From BE To FE":"0ms"}}}
- Wait and Fetch Result Time: 147ms
- Fetch Result Time: 139ms
- Write Result Time: 0ms
- Doris Version: selectdb-doris-2.1.10-rc01-5d0d1fda36
- Is Nereids: Yes
- Is Pipeline: Yes
- Is Cached: No
- Total Instances Num: 342
- Instances Num Per BE: 172.16.10.108:8060:56,172.16.10.164:8060:61,172.16.10.170:8060:52,172.16.10.230:8060:64,172.16.10.252:8060:53,172.16.10.68:8060:56
- Parallel Fragment Exec Instance Num: 4
- Trace ID: 79616185-0961-4aa7-bed6-e19d74eca85c
- Transaction Commit Time: N/A
- Executed By Frontend: N/A
- Nereids GarbageCollect Time: 170ms
- Nereids BeFoldConst Time: 0ms

Changed Session Variables: