doris-10亿数据和100万表join高并发测试

select count(*), sum(p1),vin from tj23 as a where EXISTS(select null from bak1 as b where a.vin = b.vin ) and inday between '2023-09-01' and '2023-12-01' group by vin order by sum(p1) desc limit 13 ;

1个并发:
Thread[Thread-0,5,main]===>Mon Nov 08 13:51:04 CST 2021-----Mon Nov 08 13:51:10 CST 2021----69.69758352125064
Thread[Thread-0,5,main]===>Mon Nov 08 13:51:10 CST 2021-----Mon Nov 08 13:51:17 CST 2021----75.61548687145114
Thread[Thread-0,5,main]===>Mon Nov 08 13:51:17 CST 2021-----Mon Nov 08 13:51:25 CST 2021----75.01122639887035
Thread[Thread-0,5,main]===>Mon Nov 08 13:51:25 CST 2021-----Mon Nov 08 13:51:33 CST 2021----75.6454560579732
Thread[Thread-0,5,main]===>Mon Nov 08 13:51:33 CST 2021-----Mon Nov 08 13:51:40 CST 2021----72.6295442506671
Thread[Thread-0,5,main]===>Mon Nov 08 13:51:40 CST 2021-----Mon Nov 08 13:51:48 CST 2021----67.04518285393715
Thread[Thread-0,5,main]===>Mon Nov 08 13:51:48 CST 2021-----Mon Nov 08 13:51:55 CST 2021----75.28153388621286
Thread[Thread-0,5,main]===>Mon Nov 08 13:51:55 CST 2021-----Mon Nov 08 13:52:02 CST 2021----74.8282328848727
Thread[Thread-0,5,main]===>Mon Nov 08 13:52:02 CST 2021-----Mon Nov 08 13:52:09 CST 2021----79.1857900749892
Thread[Thread-0,5,main]===>Mon Nov 08 13:52:09 CST 2021-----Mon Nov 08 13:52:15 CST 2021----73.69948476646096

10个并发:
Thread[Thread-5,5,main]===>Mon Nov 08 13:53:53 CST 2021-----Mon Nov 08 13:54:05 CST 2021----76.70274531841278
Thread[Thread-0,5,main]===>Mon Nov 08 13:53:50 CST 2021-----Mon Nov 08 13:54:05 CST 2021----81.98508107708767
Thread[Thread-7,5,main]===>Mon Nov 08 13:53:54 CST 2021-----Mon Nov 08 13:54:05 CST 2021----76.1042479109019
Thread[Thread-2,5,main]===>Mon Nov 08 13:53:53 CST 2021-----Mon Nov 08 13:54:08 CST 2021----71.85184497525916
Thread[Thread-9,5,main]===>Mon Nov 08 13:53:57 CST 2021-----Mon Nov 08 13:54:09 CST 2021----73.82595011917874
Thread[Thread-1,5,main]===>Mon Nov 08 13:53:53 CST 2021-----Mon Nov 08 13:54:10 CST 2021----81.12992838025093
Thread[Thread-8,5,main]===>Mon Nov 08 13:53:57 CST 2021-----Mon Nov 08 13:54:12 CST 2021----85.47376806288958
Thread[Thread-4,5,main]===>Mon Nov 08 13:53:57 CST 2021-----Mon Nov 08 13:54:13 CST 2021----69.88316673412919
Thread[Thread-6,5,main]===>Mon Nov 08 13:54:05 CST 2021-----Mon Nov 08 13:54:13 CST 2021----77.55705825146288
Thread[Thread-3,5,main]===>Mon Nov 08 13:54:01 CST 2021-----Mon Nov 08 13:54:13 CST 2021----66.28211343288422
Thread[Thread-0,5,main]===>Mon Nov 08 13:54:05 CST 2021-----Mon Nov 08 13:54:14 CST 2021----73.14776773750782
Thread[Thread-7,5,main]===>Mon Nov 08 13:54:05 CST 2021-----Mon Nov 08 13:54:14 CST 2021----78.26349581684917

20个并发:
Thread[Thread-7,5,main]===>Mon Nov 08 13:54:36 CST 2021-----Mon Nov 08 13:54:54 CST 2021----75.63684319076128
Thread[Thread-3,5,main]===>Mon Nov 08 13:54:36 CST 2021-----Mon Nov 08 13:54:55 CST 2021----75.13778598047793
Thread[Thread-18,5,main]===>Mon Nov 08 13:54:37 CST 2021-----Mon Nov 08 13:54:55 CST 2021----76.76337063754909
Thread[Thread-19,5,main]===>Mon Nov 08 13:54:37 CST 2021-----Mon Nov 08 13:54:55 CST 2021----80.37383390031755
Thread[Thread-6,5,main]===>Mon Nov 08 13:54:36 CST 2021-----Mon Nov 08 13:54:56 CST 2021----72.20376470685005
Thread[Thread-0,5,main]===>Mon Nov 08 13:54:36 CST 2021-----Mon Nov 08 13:54:56 CST 2021----73.25465437071398
Thread[Thread-5,5,main]===>Mon Nov 08 13:54:36 CST 2021-----Mon Nov 08 13:54:56 CST 2021----77.09346708850353
Thread[Thread-4,5,main]===>Mon Nov 08 13:54:36 CST 2021-----Mon Nov 08 13:54:56 CST 2021----69.57754974812269
Thread[Thread-11,5,main]===>Mon Nov 08 13:54:36 CST 2021-----Mon Nov 08 13:54:57 CST 2021----79.98439491726458
Thread[Thread-10,5,main]===>Mon Nov 08 13:54:36 CST 2021-----Mon Nov 08 13:54:57 CST 2021----73.98017222806811
Thread[Thread-9,5,main]===>Mon Nov 08 13:54:36 CST 2021-----Mon Nov 08 13:54:58 CST 2021----73.63904846366495
Thread[Thread-8,5,main]===>Mon Nov 08 13:54:36 CST 2021-----Mon Nov 08 13:54:58 CST 2021----69.15546788275242
Thread[Thread-16,5,main]===>Mon Nov 08 13:54:37 CST 2021-----Mon Nov 08 13:54:58 CST 2021----73.62081560306251

30个并发:
Thread[Thread-1,5,main]===>Mon Nov 08 13:55:17 CST 2021-----Mon Nov 08 13:55:38 CST 2021----79.55167627474293
Thread[Thread-4,5,main]===>Mon Nov 08 13:55:17 CST 2021-----Mon Nov 08 13:55:38 CST 2021----78.7448261640966
Thread[Thread-3,5,main]===>Mon Nov 08 13:55:17 CST 2021-----Mon Nov 08 13:55:38 CST 2021----75.68853535223752
Thread[Thread-2,5,main]===>Mon Nov 08 13:55:17 CST 2021-----Mon Nov 08 13:55:38 CST 2021----72.79424087423831
Thread[Thread-13,5,main]===>Mon Nov 08 13:55:18 CST 2021-----Mon Nov 08 13:55:38 CST 2021----78.7448261640966
Thread[Thread-8,5,main]===>Mon Nov 08 13:55:17 CST 2021-----Mon Nov 08 13:55:39 CST 2021----74.22074684873223
Thread[Thread-11,5,main]===>Mon Nov 08 13:55:18 CST 2021-----Mon Nov 08 13:55:39 CST 2021----74.05824535153806
Thread[Thread-19,5,main]===>Mon Nov 08 13:55:18 CST 2021-----Mon Nov 08 13:55:40 CST 2021----74.9476554512512
Thread[Thread-23,5,main]===>Mon Nov 08 13:55:19 CST 2021-----Mon Nov 08 13:55:41 CST 2021----75.48850557208061
Thread[Thread-21,5,main]===>Mon Nov 08 13:55:19 CST 2021-----Mon Nov 08 13:55:43 CST 2021----75.12452369183302
Thread[Thread-27,5,main]===>Mon Nov 08 13:55:20 CST 2021-----Mon Nov 08 13:55:43 CST 2021----76.6415466349572
Thread[Thread-26,5,main]===>Mon Nov 08 13:55:20 CST 2021-----Mon Nov 08 13:55:43 CST 2021----79.34849312063307

50个并发:
Thread[Thread-6,5,main]===>Mon Nov 08 13:47:54 CST 2021-----Mon Nov 08 13:49:31 CST 2021----75.83465198101476
Thread[Thread-7,5,main]===>Mon Nov 08 13:48:53 CST 2021-----Mon Nov 08 13:49:31 CST 2021----76.70274531841278
Thread[Thread-8,5,main]===>Mon Nov 08 13:48:54 CST 2021-----Mon Nov 08 13:49:31 CST 2021----68.87036582455039
Thread[Thread-35,5,main]===>Mon Nov 08 13:47:58 CST 2021-----Mon Nov 08 13:49:32 CST 2021----85.4495001360774
Thread[Thread-3,5,main]===>Mon Nov 08 13:49:14 CST 2021-----Mon Nov 08 13:49:32 CST 2021----76.67595149762928
Thread[Thread-29,5,main]===>Mon Nov 08 13:48:54 CST 2021-----Mon Nov 08 13:49:32 CST 2021----74.4919117745012
Thread[Thread-21,5,main]===>Mon Nov 08 13:47:55 CST 2021-----Mon Nov 08 13:49:32 CST 2021----74.27140026167035
Thread[Thread-13,5,main]===>Mon Nov 08 13:49:08 CST 2021-----Mon Nov 08 13:49:32 CST 2021----66.39185803756118
Thread[Thread-41,5,main]===>Mon Nov 08 13:47:59 CST 2021-----Mon Nov 08 13:49:32 CST 2021----85.4495001360774
Thread[Thread-42,5,main]===>Mon Nov 08 13:48:56 CST 2021-----Mon Nov 08 13:49:32 CST 2021----75.284658908844
Thread[Thread-47,5,main]===>Mon Nov 08 13:48:57 CST 2021-----Mon Nov 08 13:49:32 CST 2021----66.48464036360383
Thread[Thread-40,5,main]===>Mon Nov 08 13:48:54 CST 2021-----Mon Nov 08 13:49:33 CST 2021----78.35571559891105
Thread[Thread-36,5,main]===>Mon Nov 08 13:48:54 CST 2021-----Mon Nov 08 13:49:33 CST 2021----76.18826809665188
Thread[Thread-46,5,main]===>Mon Nov 08 13:48:54 CST 2021-----Mon Nov 08 13:49:33 CST 2021----73.93106352142058

select count(*), sum(p1),vin from tj23 as a where EXISTS(select null from bak1 as b where a.vin = b.vin and b.type2=3) and inday between '2023-09-01' and '2023-10-01' group by vin order by sum(p1) desc limit 1

1个并发:
Thread[Thread-0,5,main]===>Mon Nov 08 14:08:38 CST 2021-----Mon Nov 08 14:08:40 CST 2021----15.164761524647474
Thread[Thread-0,5,main]===>Mon Nov 08 14:08:40 CST 2021-----Mon Nov 08 14:08:42 CST 2021----12.243838373105973
Thread[Thread-0,5,main]===>Mon Nov 08 14:08:42 CST 2021-----Mon Nov 08 14:08:44 CST 2021----79.87936189305037
Thread[Thread-0,5,main]===>Mon Nov 08 14:08:44 CST 2021-----Mon Nov 08 14:08:46 CST 2021----13.230856254696846
Thread[Thread-0,5,main]===>Mon Nov 08 14:08:46 CST 2021-----Mon Nov 08 14:08:48 CST 2021----15.575054794549942
Thread[Thread-0,5,main]===>Mon Nov 08 14:08:48 CST 2021-----Mon Nov 08 14:08:50 CST 2021----14.617374192923307
Thread[Thread-0,5,main]===>Mon Nov 08 14:08:50 CST 2021-----Mon Nov 08 14:08:52 CST 2021----16.098682841286063
Thread[Thread-0,5,main]===>Mon Nov 08 14:08:52 CST 2021-----Mon Nov 08 14:08:54 CST 2021----20.77381883561611

10个并发:
Thread[Thread-8,5,main]===>Mon Nov 08 14:09:42 CST 2021-----Mon Nov 08 14:09:44 CST 2021----13.156671326607466
Thread[Thread-4,5,main]===>Mon Nov 08 14:09:41 CST 2021-----Mon Nov 08 14:09:44 CST 2021----15.119492493569851
Thread[Thread-1,5,main]===>Mon Nov 08 14:09:41 CST 2021-----Mon Nov 08 14:09:44 CST 2021----75.66472220118158
Thread[Thread-3,5,main]===>Mon Nov 08 14:09:42 CST 2021-----Mon Nov 08 14:09:44 CST 2021----14.372891347389668
Thread[Thread-6,5,main]===>Mon Nov 08 14:09:40 CST 2021-----Mon Nov 08 14:09:44 CST 2021----15.113657234236598
Thread[Thread-7,5,main]===>Mon Nov 08 14:09:42 CST 2021-----Mon Nov 08 14:09:44 CST 2021----18.19708963809535
Thread[Thread-2,5,main]===>Mon Nov 08 14:09:42 CST 2021-----Mon Nov 08 14:09:44 CST 2021----16.146612730575725
Thread[Thread-5,5,main]===>Mon Nov 08 14:09:42 CST 2021-----Mon Nov 08 14:09:44 CST 2021----16.173066169023514

20个并发:
Thread[Thread-3,5,main]===>Mon Nov 08 14:10:12 CST 2021-----Mon Nov 08 14:10:17 CST 2021----16.30244186485652
Thread[Thread-2,5,main]===>Mon Nov 08 14:10:12 CST 2021-----Mon Nov 08 14:10:17 CST 2021----14.760695021599531
Thread[Thread-9,5,main]===>Mon Nov 08 14:10:12 CST 2021-----Mon Nov 08 14:10:17 CST 2021----12.42002581548877
Thread[Thread-19,5,main]===>Mon Nov 08 14:10:14 CST 2021-----Mon Nov 08 14:10:17 CST 2021----13.70673444122076
Thread[Thread-14,5,main]===>Mon Nov 08 14:10:14 CST 2021-----Mon Nov 08 14:10:18 CST 2021----15.03512493148446
Thread[Thread-12,5,main]===>Mon Nov 08 14:10:08 CST 2021-----Mon Nov 08 14:10:18 CST 2021----16.401009924709797
Thread[Thread-10,5,main]===>Mon Nov 08 14:10:14 CST 2021-----Mon Nov 08 14:10:18 CST 2021----12.67812643200159
Thread[Thread-11,5,main]===>Mon Nov 08 14:10:15 CST 2021-----Mon Nov 08 14:10:18 CST 2021----15.328360818326473
Thread[Thread-2,5,main]===>Mon Nov 08 14:10:17 CST 2021-----Mon Nov 08 14:10:19 CST 2021----15.917710054665804

30个并发:
Thread[Thread-14,5,main]===>Mon Nov 08 14:10:42 CST 2021-----Mon Nov 08 14:10:51 CST 2021----16.490235447883606
Thread[Thread-19,5,main]===>Mon Nov 08 14:10:43 CST 2021-----Mon Nov 08 14:10:53 CST 2021----13.608858592808247
Thread[Thread-24,5,main]===>Mon Nov 08 14:10:43 CST 2021-----Mon Nov 08 14:10:53 CST 2021----15.801446665078402
Thread[Thread-28,5,main]===>Mon Nov 08 14:10:44 CST 2021-----Mon Nov 08 14:10:54 CST 2021----13.854484288021922
Thread[Thread-9,5,main]===>Mon Nov 08 14:10:50 CST 2021-----Mon Nov 08 14:10:55 CST 2021----12.278781018103473
Thread[Thread-22,5,main]===>Mon Nov 08 14:10:50 CST 2021-----Mon Nov 08 14:10:55 CST 2021----16.226923575159162
Thread[Thread-26,5,main]===>Mon Nov 08 14:10:50 CST 2021-----Mon Nov 08 14:10:55 CST 2021----14.79777280986309
Thread[Thread-25,5,main]===>Mon Nov 08 14:10:44 CST 2021-----Mon Nov 08 14:10:55 CST 2021----13.555506654200144

50个并发:
Thread[Thread-24,5,main]===>Mon Nov 08 14:11:16 CST 2021-----Mon Nov 08 14:11:37 CST 2021----14.006272213358898
Thread[Thread-42,5,main]===>Mon Nov 08 14:11:18 CST 2021-----Mon Nov 08 14:11:37 CST 2021----16.984203532338142
Thread[Thread-34,5,main]===>Mon Nov 08 14:11:17 CST 2021-----Mon Nov 08 14:11:37 CST 2021----14.360773675143719
Thread[Thread-7,5,main]===>Mon Nov 08 14:11:14 CST 2021-----Mon Nov 08 14:11:37 CST 2021----13.290294121950865
Thread[Thread-41,5,main]===>Mon Nov 08 14:11:18 CST 2021-----Mon Nov 08 14:11:38 CST 2021----15.071852330118418
Thread[Thread-36,5,main]===>Mon Nov 08 14:11:17 CST 2021-----Mon Nov 08 14:11:38 CST 2021----16.579699765890837
Thread[Thread-20,5,main]===>Mon Nov 08 14:11:15 CST 2021-----Mon Nov 08 14:11:38 CST 2021----13.358949667715933

posted on 2021-11-08 14:14  李雷  阅读(914)  评论(0编辑  收藏  举报

导航