TPC-H-test/time_with_switchjoin at main · Alena0704/TPC-H-test · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
vm.drop_caches = 3
queries/1.sql
Time: 454502,732 ms (07:34,503)
vm.drop_caches = 3
queries/3.sql
Time: 191488,420 ms (03:11,488)
vm.drop_caches = 3
queries/4.sql
Time: 168126,479 ms (02:48,126)
vm.drop_caches = 3
queries/5.sql
Time: 165520,779 ms (02:45,521)
vm.drop_caches = 3
queries/6.sql
Time: 96552,807 ms (01:36,553)
vm.drop_caches = 3
queries/7.sql
Time: 143698,824 ms (02:23,699)
vm.drop_caches = 3
queries/8.sql
Time: 96382,397 ms (01:36,382)
vm.drop_caches = 3
queries/9.sql
 Planning Time: 10.524 ms
 Execution Time: 433749.700 ms
Time: 433767,200 ms (07:13,767)
vm.drop_caches = 3
queries/10.sql
Time: 176324,266 ms (02:56,324)
vm.drop_caches = 3
queries/11.sql
Time: 22539,606 ms (00:22,540)
vm.drop_caches = 3
queries/12.sql
Time: 170816,650 ms (02:50,817)
vm.drop_caches = 3
queries/13.sql
Time: 124799,310 ms (02:04,799)
vm.drop_caches = 3
queries/14.sql
Time: 96251,578 ms (01:36,252)
vm.drop_caches = 3
queries/15.sql
 Planning Time: 2.759 ms
 Execution Time: 334281.212 ms
Time: 334311,032 ms (05:34,311)
vm.drop_caches = 3
queries/16.sql
Time: 217258,549 ms (03:37,259)
vm.drop_caches = 3
queries/17.sql
Time: 590809,040 ms (09:50,809)
vm.drop_caches = 3
queries/18.sql
Time: 1337173,094 ms (22:17,173)
vm.drop_caches = 3
queries/19.sql
Time: 129968,933 ms (02:09,969)
vm.drop_caches = 3
queries/20.sql
 Planning Time: 5.431 ms
 Execution Time: 229518.214 ms
Time: 229532,245 ms (03:49,532)
vm.drop_caches = 3
queries/21.sql
Time: 520687,676 ms (08:40,688)
vm.drop_caches = 3
queries/22.sql
Time: 186547,845 ms (03:06,548)