1
|
MongoDB
|
2
|
Running testplan
|
3
|
!2016-08-26T14:49:02 Init
|
4
|
TS1.1: Impact of fragmentation on INSERT
|
5
|
!2016-08-26T14:56:42 TS1.1
|
6
|
Run Empty [s] First [s] Middle [s] Delete [s] Fragmented [s]
|
7
|
1 127.922201 129.392131 129.354367 7.603520 130.301279
|
8
|
2 130.302063 129.946774 132.418760 7.608551 131.156769
|
9
|
3 129.552224 128.700161 132.994419 7.542808 130.664446
|
10
|
4 126.847849 127.684087 131.240836 7.597966 130.372580
|
11
|
5 129.696564 128.195218 132.982633 7.562814 130.898716
|
12
|
6 128.377722 126.907665 130.065722 7.521640 130.169196
|
13
|
7 129.502944 128.030488 131.437991 7.643319 131.553265
|
14
|
8 129.240116 129.007747 130.110507 7.581124 131.880039
|
15
|
9 130.553518 128.646558 132.235081 7.515750 131.059796
|
16
|
TS1.2: Impact of indexing and fragmentation on INSERT
|
17
|
!2016-08-26T16:16:58 TS1.2
|
18
|
Run Empty [s] First [s] Middle [s] Delete [s] Fragmented [s]
|
19
|
1 173.647710 177.968113 183.993663 30.069588 184.758466
|
20
|
2 173.629722 178.415824 183.969028 30.070325 186.556422
|
21
|
3 174.022939 176.095028 182.031965 30.170620 184.657400
|
22
|
4 175.535268 177.974228 184.986954 29.766625 185.885353
|
23
|
5 175.615344 179.148640 187.290543 30.439705 187.112232
|
24
|
6 174.830304 178.366894 182.815570 30.042563 185.856504
|
25
|
7 173.601921 177.102745 182.955350 30.025276 184.144057
|
26
|
8 176.025728 177.213952 184.054311 30.023341 185.719333
|
27
|
9 175.469983 176.546728 184.125221 30.591613 185.935915
|
28
|
TS1.3: Index creation timing
|
29
|
!2016-08-26T18:10:56 TS1.3
|
30
|
Run INSERT [s] DetectTime [s] ts [s] Name [s] !Detector [s] Src IP [s] !Src Range [s]
|
31
|
1 394.282975 6.756382 4.112482 17.050397 22.302891 8.520851 11.711954
|
32
|
2 394.209425 6.736578 4.117324 17.118401 22.194257 8.574414 11.774997
|
33
|
3 390.860696 6.710911 4.086974 17.112138 22.305206 8.593174 11.757838
|
34
|
4 391.908978 6.699310 4.100555 17.210869 22.235549 8.535727 11.632488
|
35
|
5 397.137158 6.729598 4.116091 17.489018 22.386854 8.523736 11.559902
|
36
|
6 391.927438 6.690400 4.126439 17.397926 22.480825 8.386318 11.796966
|
37
|
7 396.679676 6.602872 4.042784 16.909235 22.115287 8.416613 11.833548
|
38
|
8 394.259255 6.670743 4.076836 16.968165 22.299115 8.469255 11.620068
|
39
|
9 393.093860 6.720491 4.070675 16.935772 22.103473 8.478802 11.750964
|
40
|
TS1.4: Impact of indexing on INSERT time
|
41
|
!2016-08-26T19:21:39 TS1.4
|
42
|
Run DetectTime [s] ts [s] Name [s] !Detector [s] Src IP [s] !Src Range [s] INSERT [s]
|
43
|
1 0.095333 0.007732 0.007909 0.009209 0.008688 0.008170 542.007565
|
44
|
2 0.028094 0.004556 0.005994 0.006236 0.005891 0.005027 551.804655
|
45
|
3 0.031046 0.004694 0.006085 0.008681 0.008709 0.004849 549.001550
|
46
|
4 0.035373 0.009057 0.007306 0.006811 0.007153 0.008803 546.248195
|
47
|
5 0.035590 0.009269 0.008941 0.009804 0.009003 0.006746 545.113158
|
48
|
6 0.036306 0.005918 0.007224 0.009196 0.007952 0.008808 552.632978
|
49
|
7 0.038022 0.008932 0.008672 0.008664 0.008570 0.009038 547.686718
|
50
|
8 0.072588 0.009210 0.008470 0.007839 0.007578 0.008251 546.923785
|
51
|
9 0.037439 0.009226 0.009427 0.008425 0.005091 0.008515 547.406995
|
52
|
TS2.1: Cold read
|
53
|
!2016-08-26T20:45:10 TS2.1
|
54
|
Query Run find [s] sort [s] iterate [s] Results [-] Total Time [s]
|
55
|
MENTAT 1 0.000283 0.000187 511.033009 6747529 511.035800
|
56
|
MENTAT 2 0.000268 0.000187 515.743728 6747529 515.746490
|
57
|
MENTAT 3 0.000262 0.000187 420.844979 6747529 420.847032
|
58
|
MENTAT 4 0.000265 0.000187 508.426094 6747529 508.427047
|
59
|
MENTAT 5 0.000267 0.000189 507.606699 6747529 507.607818
|
60
|
MENTAT 6 0.000268 0.000190 506.150227 6747529 506.151223
|
61
|
MENTAT 7 0.000264 0.000188 509.515272 6747529 509.517369
|
62
|
MENTAT 8 0.000264 0.000185 520.272144 6747529 520.274866
|
63
|
MENTAT 9 0.000268 0.000186 418.551855 6747529 418.553592
|
64
|
HAWAT1 1 0.000263 0.000193 86.109275 364527 86.109964
|
65
|
HAWAT1 2 0.000268 0.000190 86.152511 364527 86.153862
|
66
|
HAWAT1 3 0.000267 0.000192 85.538912 364527 85.540184
|
67
|
HAWAT1 4 0.000268 0.000188 84.850769 364527 84.851902
|
68
|
HAWAT1 5 0.000271 0.000194 81.707942 364527 81.708961
|
69
|
HAWAT1 6 0.000268 0.000193 85.110888 364527 85.112008
|
70
|
HAWAT1 7 0.000273 0.000193 78.681353 364527 78.682369
|
71
|
HAWAT1 8 0.000267 0.000188 86.021770 364527 86.022532
|
72
|
HAWAT1 9 0.000302 0.000195 78.741570 364527 78.742354
|
73
|
HAWAT2 1 0.000268 0.000190 87.096650 72334 87.097303
|
74
|
HAWAT2 2 0.000266 0.000198 87.789435 72334 87.790144
|
75
|
HAWAT2 3 0.000268 0.000211 88.842009 72334 88.842721
|
76
|
HAWAT2 4 0.000269 0.000196 88.513749 72334 88.514447
|
77
|
HAWAT2 5 0.000290 0.000196 87.926340 72334 87.927062
|
78
|
HAWAT2 6 0.000267 0.000195 88.451478 72334 88.452186
|
79
|
HAWAT2 7 0.000271 0.000196 87.127282 72334 87.127966
|
80
|
HAWAT2 8 0.000263 0.000198 88.195420 72334 88.196128
|
81
|
HAWAT2 9 0.000270 0.000195 90.182639 72334 90.183338
|
82
|
HAWAT3 1 0.000269 0.000195 490.509768 6237248 490.511532
|
83
|
HAWAT3 2 0.000270 0.000190 432.371037 6237248 432.372198
|
84
|
HAWAT3 3 0.000144 0.000096 454.269072 6237248 454.269495
|
85
|
HAWAT3 4 0.000266 0.000184 475.578615 6237248 475.579316
|
86
|
HAWAT3 5 0.000263 0.000183 461.287815 6237248 461.289052
|
87
|
HAWAT3 6 0.000268 0.000184 479.793021 6237248 479.793863
|
88
|
HAWAT3 7 0.000265 0.000187 487.537971 6237248 487.539051
|
89
|
HAWAT3 8 0.000267 0.000188 479.156575 6237248 479.158198
|
90
|
HAWAT3 9 0.000293 0.000195 418.960975 6237248 418.962579
|
91
|
HAWAT4 1 0.000263 0.000189 97.757782 961836 97.759354
|
92
|
HAWAT4 2 0.000268 0.000191 88.001651 961836 88.002373
|
93
|
HAWAT4 3 0.000267 0.000187 99.461632 961836 99.462742
|
94
|
HAWAT4 4 0.000271 0.000189 94.231371 961836 94.232250
|
95
|
HAWAT4 5 0.000272 0.000189 94.985798 961836 94.986669
|
96
|
HAWAT4 6 0.000267 0.000189 98.964201 961836 98.965096
|
97
|
HAWAT4 7 0.000268 0.000188 98.502563 961836 98.503450
|
98
|
HAWAT4 8 0.000268 0.000188 98.322375 961836 98.323237
|
99
|
HAWAT4 9 0.000265 0.000189 97.203095 961836 97.204188
|
100
|
HAWAT5 1 0.000264 0.000185 101.429182 961071 101.429867
|
101
|
HAWAT5 2 0.000269 0.000187 93.023187 961071 93.023861
|
102
|
HAWAT5 3 0.000273 0.000186 101.553183 961071 101.553852
|
103
|
HAWAT5 4 0.000298 0.000185 102.023856 961071 102.024561
|
104
|
HAWAT5 5 0.000269 0.000203 100.491724 961071 100.492429
|
105
|
HAWAT5 6 0.000305 0.000184 101.747961 961071 101.748663
|
106
|
HAWAT5 7 0.000268 0.000188 94.446469 961071 94.447141
|
107
|
HAWAT5 8 0.000272 0.000185 98.728326 961071 98.729004
|
108
|
HAWAT5 9 0.000275 0.000206 101.019464 961071 101.020175
|
109
|
HAWAT6 1 0.000268 0.000183 79.173390 364527 79.174537
|
110
|
HAWAT6 2 0.000270 0.000190 86.328840 364527 86.329747
|
111
|
HAWAT6 3 0.000269 0.000188 79.272074 364527 79.272844
|
112
|
HAWAT6 4 0.000273 0.000187 85.984156 364527 85.984929
|
113
|
HAWAT6 5 0.000270 0.000212 86.358828 364527 86.360034
|
114
|
HAWAT6 6 0.000270 0.000210 85.367100 364527 85.367907
|
115
|
HAWAT6 7 0.000263 0.000206 81.383568 364527 81.384375
|
116
|
HAWAT6 8 0.000265 0.000186 79.754849 364527 79.755697
|
117
|
HAWAT6 9 0.000269 0.000189 86.168911 364527 86.169820
|
118
|
HAWAT7 1 0.000268 0.000185 91.493113 68964 91.494022
|
119
|
HAWAT7 2 0.000270 0.000190 92.099406 68964 92.100378
|
120
|
HAWAT7 3 0.000271 0.000205 92.915546 68964 92.916550
|
121
|
HAWAT7 4 0.000276 0.000211 92.386829 68964 92.387583
|
122
|
HAWAT7 5 0.000268 0.000187 91.476902 68964 91.477834
|
123
|
HAWAT7 6 0.000274 0.000193 92.603941 68964 92.605127
|
124
|
HAWAT7 7 0.000270 0.000208 92.466109 68964 92.467113
|
125
|
HAWAT7 8 0.000271 0.000192 92.373811 68964 92.374530
|
126
|
HAWAT7 9 0.000273 0.000196 94.189761 68964 94.190721
|
127
|
TS2.2: Hot read
|
128
|
!2016-08-27T00:38:02 TS2.2
|
129
|
Query Run find [s] sort [s] iterate [s] Results [-] Total Time [s]
|
130
|
HAWAT1 COLD1 0.000271 0.000195 86.350134 364527 86.351100
|
131
|
HAWAT1 HOT1 0.000056 0.000065 59.839078 364525 59.839830
|
132
|
HAWAT2 COLD1 0.000266 0.000194 88.124338 72334 88.125024
|
133
|
HAWAT2 HOT1 0.000045 0.000054 51.832817 72334 51.832992
|
134
|
HAWAT3 COLD1 0.000273 0.000198 480.688220 6237248 480.689853
|
135
|
HAWAT3 HOT1 0.000056 0.000050 374.665166 6237343 374.666367
|
136
|
HAWAT4 COLD1 0.000269 0.000192 98.394072 961836 98.394850
|
137
|
HAWAT4 HOT1 0.000056 0.000050 61.603166 961836 61.603455
|
138
|
HAWAT5 COLD1 0.000273 0.000193 92.285556 961071 92.286211
|
139
|
HAWAT5 HOT1 0.000051 0.000045 65.179411 961071 65.179566
|
140
|
HAWAT6 COLD1 0.000268 0.000191 80.367874 364527 80.369202
|
141
|
HAWAT6 HOT1 0.000056 0.000050 59.492005 364525 59.492206
|
142
|
HAWAT7 COLD1 0.000263 0.000193 92.588143 68964 92.589450
|
143
|
HAWAT7 HOT1 0.000057 0.000049 50.524505 68964 50.524996
|
144
|
HAWAT1 COLD2 0.000269 0.000195 79.422035 364527 79.423050
|
145
|
HAWAT1 HOT2 0.000056 0.000049 56.223618 364525 56.224339
|
146
|
HAWAT2 COLD2 0.000319 0.000193 88.068263 72334 88.068986
|
147
|
HAWAT2 HOT2 0.000049 0.000042 51.055803 72334 51.055965
|
148
|
HAWAT3 COLD2 0.000270 0.000196 488.767272 6237248 488.769152
|
149
|
HAWAT3 HOT2 0.000058 0.000067 465.471592 6237343 465.473117
|
150
|
HAWAT4 COLD2 0.000269 0.000191 97.345328 961836 97.346322
|
151
|
HAWAT4 HOT2 0.000055 0.000064 71.348367 961836 71.348870
|
152
|
HAWAT5 COLD2 0.000274 0.000190 93.040005 961071 93.040659
|
153
|
HAWAT5 HOT2 0.000051 0.000044 68.285577 961071 68.285740
|
154
|
HAWAT6 COLD2 0.000269 0.000194 86.099274 364527 86.100787
|
155
|
HAWAT6 HOT2 0.000056 0.000065 59.075523 364525 59.075996
|
156
|
HAWAT7 COLD2 0.000268 0.000192 92.084753 68964 92.085677
|
157
|
HAWAT7 HOT2 0.000057 0.000050 50.771242 68964 50.771631
|
158
|
HAWAT1 COLD3 0.000269 0.000196 84.866414 364527 84.867539
|
159
|
HAWAT1 HOT3 0.000056 0.000065 58.278766 364525 58.279309
|
160
|
HAWAT2 COLD3 0.000274 0.000191 86.297139 72334 86.297853
|
161
|
HAWAT2 HOT3 0.000046 0.000041 54.607638 72334 54.607778
|
162
|
HAWAT3 COLD3 0.000268 0.000197 413.218996 6237248 413.220676
|
163
|
HAWAT3 HOT3 0.000055 0.000064 436.428298 6237343 436.429414
|
164
|
HAWAT4 COLD3 0.000274 0.000192 106.867295 961836 106.868316
|
165
|
HAWAT4 HOT3 0.000056 0.000066 70.525083 961836 70.525443
|
166
|
HAWAT5 COLD3 0.000118 0.000084 110.904617 961071 110.904935
|
167
|
HAWAT5 HOT3 0.000048 0.000057 75.227087 961071 75.227395
|
168
|
HAWAT6 COLD3 0.000271 0.000188 80.026302 364527 80.028014
|
169
|
HAWAT6 HOT3 0.000058 0.000051 56.913023 364525 56.914016
|
170
|
HAWAT7 COLD3 0.000268 0.000193 90.350966 68964 90.352011
|
171
|
HAWAT7 HOT3 0.000055 0.000067 51.701086 68964 51.701642
|
172
|
HAWAT1 COLD4 0.000271 0.000192 82.217079 364527 82.219270
|
173
|
HAWAT1 HOT4 0.000058 0.000064 56.243818 364525 56.244493
|
174
|
HAWAT2 COLD4 0.000272 0.000193 85.977842 72334 85.978574
|
175
|
HAWAT2 HOT4 0.000098 0.000097 51.059915 72334 51.060270
|
176
|
HAWAT3 COLD4 0.000273 0.000198 464.269669 6237248 464.271135
|
177
|
HAWAT3 HOT4 0.000057 0.000050 424.541086 6237343 424.542459
|
178
|
HAWAT4 COLD4 0.000264 0.000192 97.655963 961836 97.657040
|
179
|
HAWAT4 HOT4 0.000054 0.000064 65.650673 961836 65.651183
|
180
|
HAWAT5 COLD4 0.000270 0.000192 98.188798 961071 98.189462
|
181
|
HAWAT5 HOT4 0.000047 0.000056 74.329437 961071 74.329614
|
182
|
HAWAT6 COLD4 0.000269 0.000188 80.682261 364527 80.683353
|
183
|
HAWAT6 HOT4 0.000055 0.000062 58.936366 364525 58.936718
|
184
|
HAWAT7 COLD4 0.000268 0.000192 90.840174 68964 90.841126
|
185
|
HAWAT7 HOT4 0.000055 0.000050 51.019533 68964 51.020015
|
186
|
HAWAT1 COLD5 0.000305 0.000192 79.443524 364527 79.444369
|
187
|
HAWAT1 HOT5 0.000055 0.000049 58.925452 364525 58.925958
|
188
|
HAWAT2 COLD5 0.000269 0.000195 86.481730 72334 86.482396
|
189
|
HAWAT2 HOT5 0.000051 0.000054 51.852800 72334 51.852974
|
190
|
HAWAT3 COLD5 0.000270 0.000196 491.774496 6237248 491.775254
|
191
|
HAWAT3 HOT5 0.000054 0.000064 467.174607 6237343 467.175539
|
192
|
HAWAT4 COLD5 0.000271 0.000191 92.083364 961836 92.084231
|
193
|
HAWAT4 HOT5 0.000055 0.000048 61.444613 961836 61.444865
|
194
|
HAWAT5 COLD5 0.000273 0.000207 98.199694 961071 98.200372
|
195
|
HAWAT5 HOT5 0.000049 0.000044 73.102331 961071 73.102562
|
196
|
HAWAT6 COLD5 0.000274 0.000207 79.850924 364527 79.852113
|
197
|
HAWAT6 HOT5 0.000056 0.000049 53.353052 364525 53.354438
|
198
|
HAWAT7 COLD5 0.000289 0.000190 90.780127 68964 90.781174
|
199
|
HAWAT7 HOT5 0.000055 0.000063 52.026994 68964 52.027561
|
200
|
HAWAT1 COLD6 0.000269 0.000195 85.158191 364527 85.159693
|
201
|
HAWAT1 HOT6 0.000056 0.000065 59.340312 364525 59.340586
|
202
|
HAWAT2 COLD6 0.000273 0.000209 86.355776 72334 86.356491
|
203
|
HAWAT2 HOT6 0.000045 0.000053 52.247903 72334 52.248070
|
204
|
HAWAT3 COLD6 0.000273 0.000215 452.424948 6237248 452.425812
|
205
|
HAWAT3 HOT6 0.000056 0.000066 454.966447 6237343 454.966741
|
206
|
HAWAT4 COLD6 0.000270 0.000240 88.347305 961836 88.348448
|
207
|
HAWAT4 HOT6 0.000055 0.000051 61.724150 961836 61.724722
|
208
|
HAWAT5 COLD6 0.000271 0.000192 98.887185 961071 98.887846
|
209
|
HAWAT5 HOT6 0.000050 0.000045 69.763538 961071 69.763829
|
210
|
HAWAT6 COLD6 0.000263 0.000191 79.578916 364527 79.580157
|
211
|
HAWAT6 HOT6 0.000055 0.000049 53.637540 364525 53.638302
|
212
|
HAWAT7 COLD6 0.000268 0.000189 91.595693 68964 91.596700
|
213
|
HAWAT7 HOT6 0.000055 0.000064 51.864407 68964 51.864981
|
214
|
HAWAT1 COLD7 0.000269 0.000192 85.153012 364527 85.154322
|
215
|
HAWAT1 HOT7 0.000057 0.000064 58.296536 364525 58.298232
|
216
|
HAWAT2 COLD7 0.000269 0.000192 85.811315 72334 85.811977
|
217
|
HAWAT2 HOT7 0.000046 0.000041 50.432978 72334 50.433130
|
218
|
HAWAT3 COLD7 0.000277 0.000222 419.991227 6237248 419.992487
|
219
|
HAWAT3 HOT7 0.000056 0.000058 439.848673 6237343 439.850127
|
220
|
HAWAT4 COLD7 0.000266 0.000191 89.880599 961836 89.881574
|
221
|
HAWAT4 HOT7 0.000056 0.000049 70.705241 961836 70.705764
|
222
|
HAWAT5 COLD7 0.000268 0.000336 101.883743 961071 101.884555
|
223
|
HAWAT5 HOT7 0.000049 0.000058 75.197966 961071 75.198167
|
224
|
HAWAT6 COLD7 0.000306 0.000193 85.612869 364527 85.614216
|
225
|
HAWAT6 HOT7 0.000056 0.000064 59.178073 364525 59.179053
|
226
|
HAWAT7 COLD7 0.000264 0.000186 89.705307 68964 89.706367
|
227
|
HAWAT7 HOT7 0.000056 0.000065 51.739018 68964 51.740064
|
228
|
HAWAT1 COLD8 0.000267 0.000191 85.592848 364527 85.594331
|
229
|
HAWAT1 HOT8 0.000057 0.000067 59.510033 364525 59.510559
|
230
|
HAWAT2 COLD8 0.000270 0.000192 85.085181 72334 85.085845
|
231
|
HAWAT2 HOT8 0.000048 0.000042 50.468642 72334 50.468900
|
232
|
HAWAT3 COLD8 0.000273 0.000197 477.129824 6237248 477.131536
|
233
|
HAWAT3 HOT8 0.000055 0.000064 459.945071 6237343 459.946546
|
234
|
HAWAT4 COLD8 0.000272 0.000193 95.979044 961836 95.979838
|
235
|
HAWAT4 HOT8 0.000055 0.000065 71.386775 961836 71.387086
|
236
|
HAWAT5 COLD8 0.000271 0.000188 100.400267 961071 100.400928
|
237
|
HAWAT5 HOT8 0.000049 0.000058 74.688736 961071 74.688917
|
238
|
HAWAT6 COLD8 0.000269 0.000196 79.192888 364527 79.194048
|
239
|
HAWAT6 HOT8 0.000057 0.000050 53.385759 364525 53.386327
|
240
|
HAWAT7 COLD8 0.000267 0.000187 90.875301 68964 90.876903
|
241
|
HAWAT7 HOT8 0.000056 0.000049 50.837946 68964 50.838133
|
242
|
HAWAT1 COLD9 0.000269 0.000195 84.566740 364527 84.568187
|
243
|
HAWAT1 HOT9 0.000054 0.000065 54.371072 364525 54.371272
|
244
|
HAWAT2 COLD9 0.000267 0.000192 86.409299 72334 86.410055
|
245
|
HAWAT2 HOT9 0.000097 0.000108 51.874347 72334 51.874673
|
246
|
HAWAT3 COLD9 0.000268 0.000195 402.670680 6237248 402.672175
|
247
|
HAWAT3 HOT9 0.000057 0.000050 371.736473 6237343 371.737121
|
248
|
HAWAT4 COLD9 0.000269 0.000195 98.993367 961836 98.994545
|
249
|
HAWAT4 HOT9 0.000056 0.000067 71.850909 961836 71.851500
|
250
|
HAWAT5 COLD9 0.000271 0.000192 101.040562 961071 101.041226
|
251
|
HAWAT5 HOT9 0.000049 0.000058 69.058299 961071 69.058480
|
252
|
HAWAT6 COLD9 0.000271 0.000194 81.434117 364527 81.435546
|
253
|
HAWAT6 HOT9 0.000055 0.000065 59.390276 364525 59.391805
|
254
|
HAWAT7 COLD9 0.000266 0.000194 88.817852 68964 88.819276
|
255
|
HAWAT7 HOT9 0.000056 0.000050 50.447492 68964 50.447922
|
256
|
TS2.3: Impact of count()
|
257
|
!2016-08-27T05:12:21 TS2.3
|
258
|
Query Run find [s] count [s] sort [s] iterate [s] Results [-] Total Time [s]
|
259
|
HAWAT1 1 0.000265 56.128928 0.000105 55.175659 364527 111.305859
|
260
|
HAWAT1 2 0.000275 56.619195 0.000118 58.982486 364527 115.603125
|
261
|
HAWAT1 3 0.000270 57.923089 0.000116 53.116699 364527 111.040879
|
262
|
HAWAT1 4 0.000272 56.409457 0.000123 53.672709 364527 110.083271
|
263
|
HAWAT1 5 0.000301 56.407964 0.000121 56.473951 364527 112.882714
|
264
|
HAWAT1 6 0.000268 56.517492 0.000116 53.885593 364527 110.404270
|
265
|
HAWAT1 7 0.000273 56.580462 0.000114 53.781483 364527 110.362589
|
266
|
HAWAT1 8 0.000270 57.892323 0.000125 53.933985 364527 111.827511
|
267
|
HAWAT1 9 0.000271 56.875050 0.000125 53.746121 364527 110.622045
|
268
|
HAWAT2 1 0.000275 545.386286 0.000138 67.437590 72334 612.824560
|
269
|
HAWAT2 2 0.000274 520.923400 0.000116 66.635103 72334 587.559189
|
270
|
HAWAT2 3 0.000271 521.423326 0.000106 66.282444 72334 587.706428
|
271
|
HAWAT2 4 0.000270 535.550393 0.000116 66.925380 72334 602.476458
|
272
|
HAWAT2 5 0.000269 525.072939 0.000106 65.986712 72334 591.060318
|
273
|
HAWAT2 6 0.000268 530.178149 0.000113 66.356582 72334 596.535399
|
274
|
HAWAT2 7 0.000274 525.080818 0.000116 65.649010 72334 590.730485
|
275
|
HAWAT2 8 0.000270 526.597107 0.000115 66.585503 72334 593.183272
|
276
|
HAWAT2 9 0.000270 532.462767 0.000116 65.148566 72334 597.611981
|
277
|
HAWAT3 1 0.000272 40.610421 0.000105 425.069880 6237248 465.681156
|
278
|
HAWAT3 2 0.000272 42.287293 0.000104 407.870217 6237248 450.158406
|
279
|
HAWAT3 3 0.000264 42.015835 0.000105 405.769728 6237248 447.786370
|
280
|
HAWAT3 4 0.000269 41.534883 0.000104 393.948733 6237248 435.485238
|
281
|
HAWAT3 5 0.000266 41.808353 0.000103 446.122121 6237248 487.931374
|
282
|
HAWAT3 6 0.000267 41.466127 0.000114 440.741263 6237248 482.208312
|
283
|
HAWAT3 7 0.000269 41.480116 0.000116 462.657218 6237248 504.138291
|
284
|
HAWAT3 8 0.000272 41.759483 0.000115 405.576725 6237248 447.337284
|
285
|
HAWAT3 9 0.000270 41.365098 0.000104 368.848111 6237248 410.214217
|
286
|
HAWAT4 1 0.000277 50.185940 0.000103 64.458868 961836 114.645810
|
287
|
HAWAT4 2 0.000303 49.284152 0.000114 71.929763 961836 121.215014
|
288
|
HAWAT4 3 0.000275 50.194549 0.000114 72.467082 961836 122.662324
|
289
|
HAWAT4 4 0.000274 51.620420 0.000115 72.732308 961836 124.353441
|
290
|
HAWAT4 5 0.000278 50.334418 0.000105 63.241550 961836 113.576600
|
291
|
HAWAT4 6 0.000277 50.400753 0.000105 72.326241 961836 122.727770
|
292
|
HAWAT4 7 0.000279 49.781486 0.000105 62.670643 961836 112.453159
|
293
|
HAWAT4 8 0.000272 49.506952 0.000103 63.869591 961836 113.377262
|
294
|
HAWAT4 9 0.000275 49.393610 0.000104 62.248968 961836 111.643352
|
295
|
HAWAT5 1 0.000272 52.819272 0.000105 74.995112 961071 127.815008
|
296
|
HAWAT5 2 0.000273 54.081149 0.000105 65.552282 961071 119.634043
|
297
|
HAWAT5 3 0.000274 53.047477 0.000104 72.203634 961071 125.251757
|
298
|
HAWAT5 4 0.000271 53.931743 0.000103 74.637085 961071 128.569446
|
299
|
HAWAT5 5 0.000267 53.681319 0.000103 67.185935 961071 120.867864
|
300
|
HAWAT5 6 0.000274 53.130693 0.000105 68.430763 961071 121.562081
|
301
|
HAWAT5 7 0.000268 52.953536 0.000105 70.264384 961071 123.218541
|
302
|
HAWAT5 8 0.000272 52.782377 0.000105 66.269955 961071 119.052940
|
303
|
HAWAT5 9 0.000269 55.683445 0.000107 67.374636 961071 123.058842
|
304
|
HAWAT6 1 0.000118 57.452906 0.000103 53.904840 364527 111.358372
|
305
|
HAWAT6 2 0.000273 57.116536 0.000121 57.293111 364527 114.410359
|
306
|
HAWAT6 3 0.000275 56.867077 0.000118 53.684758 364527 110.552542
|
307
|
HAWAT6 4 0.000276 57.427454 0.000126 59.469088 364527 116.897273
|
308
|
HAWAT6 5 0.000270 58.479639 0.000065 56.234956 364527 114.715174
|
309
|
HAWAT6 6 0.000272 57.427493 0.000119 58.090372 364527 115.518521
|
310
|
HAWAT6 7 0.000272 57.433875 0.000119 54.067726 364527 111.502295
|
311
|
HAWAT6 8 0.000271 57.681110 0.000055 56.305394 364527 113.987071
|
312
|
HAWAT6 9 0.000276 57.611272 0.000118 54.256333 364527 111.868387
|
313
|
HAWAT7 1 0.000268 523.119257 0.000135 68.386140 68964 591.506137
|
314
|
HAWAT7 2 0.000275 521.163840 0.000118 68.011978 68964 589.176545
|
315
|
HAWAT7 3 0.000273 516.672529 0.000107 68.624607 68964 585.297777
|
316
|
HAWAT7 4 0.000272 522.729522 0.000121 69.636561 68964 592.367445
|
317
|
HAWAT7 5 0.000345 519.303917 0.000120 70.638318 68964 589.943218
|
318
|
HAWAT7 6 0.000273 527.421646 0.000119 69.414657 68964 596.836961
|
319
|
HAWAT7 7 0.000175 522.820333 0.000108 69.777803 68964 592.598865
|
320
|
HAWAT7 8 0.000272 523.975258 0.000115 69.591383 68964 593.567577
|
321
|
HAWAT7 9 0.000274 523.020736 0.000115 69.817426 68964 592.839587
|
322
|
OTHER2 1 0.000276 59.960017 0.000117 60.012506 353365 119.973234
|
323
|
OTHER2 2 0.000116 58.370723 0.000104 54.329250 353365 112.700368
|
324
|
OTHER2 3 0.000273 57.669037 0.000114 57.791307 353365 115.461017
|
325
|
OTHER2 4 0.000274 58.107281 0.000046 53.999477 353365 112.107297
|
326
|
OTHER2 5 0.000300 57.776713 0.000103 53.757529 353365 111.534904
|
327
|
OTHER2 6 0.000269 59.177150 0.000104 57.460360 353365 116.638291
|
328
|
OTHER2 7 0.000275 58.156169 0.000104 54.444806 353365 112.601741
|
329
|
OTHER2 8 0.000275 57.770462 0.000104 57.488160 353365 115.259349
|
330
|
OTHER2 9 0.000267 57.737532 0.000104 53.876072 353365 111.614220
|
331
|
TS2.4: Descending sort
|
332
|
!2016-08-27T10:54:20 TS2.4
|
333
|
Query Run find [s] sort [s] iterate [s] Results [-] Total Time [s]
|
334
|
HAWAT1 1 0.000262 0.000190 303.946681 364527 303.947616
|
335
|
HAWAT1 2 0.000271 0.000190 304.008823 364527 304.009784
|
336
|
HAWAT1 3 0.000265 0.000190 308.690606 364527 308.691580
|
337
|
HAWAT1 4 0.000270 0.000191 309.447409 364527 309.448667
|
338
|
HAWAT1 5 0.000273 0.000194 302.190748 364527 302.191455
|
339
|
HAWAT1 6 0.000264 0.000189 306.066466 364527 306.067569
|
340
|
HAWAT1 7 0.000264 0.000189 300.134607 364527 300.135810
|
341
|
HAWAT1 8 0.000270 0.000191 312.552629 364527 312.553873
|
342
|
HAWAT1 9 0.000269 0.000190 307.377933 364527 307.378777
|
343
|
HAWAT2 1 0.000311 0.000189 296.082076 72334 296.082824
|
344
|
HAWAT2 2 0.000271 0.000196 296.880929 72334 296.881668
|
345
|
HAWAT2 3 0.000270 0.000197 292.862825 72334 292.863523
|
346
|
HAWAT2 4 0.000277 0.000196 293.976519 72334 293.977413
|
347
|
HAWAT2 5 0.000115 0.000099 303.263950 72334 303.264529
|
348
|
HAWAT2 6 0.000273 0.000194 301.593339 72334 301.594052
|
349
|
HAWAT2 7 0.000276 0.000198 294.940591 72334 294.941358
|
350
|
HAWAT2 8 0.000273 0.000197 301.273740 72334 301.274544
|
351
|
HAWAT2 9 0.000270 0.000210 298.578141 72334 298.578881
|
352
|
HAWAT3 1 0.000314 0.000216 625.641411 6237248 625.642276
|
353
|
HAWAT3 2 0.000268 0.000226 633.984323 6237248 633.985146
|
354
|
HAWAT3 3 0.000267 0.000216 625.320163 6237248 625.320983
|
355
|
HAWAT3 4 0.000267 0.000211 637.394384 6237248 637.395193
|
356
|
HAWAT3 5 0.000269 0.000222 643.048944 6237248 643.049749
|
357
|
HAWAT3 6 0.000267 0.000197 627.043752 6237248 627.044628
|
358
|
HAWAT3 7 0.000268 0.000195 640.376453 6237248 640.377227
|
359
|
HAWAT3 8 0.000264 0.000196 655.550836 6237248 655.552005
|
360
|
HAWAT3 9 0.000268 0.000192 632.926614 6237248 632.927758
|
361
|
HAWAT4 1 0.000265 0.000194 309.587799 961836 309.588707
|
362
|
HAWAT4 2 0.000269 0.000195 320.926643 961836 320.927893
|
363
|
HAWAT4 3 0.000268 0.000190 316.522752 961836 316.523815
|
364
|
HAWAT4 4 0.000271 0.000192 311.558165 961836 311.559136
|
365
|
HAWAT4 5 0.000271 0.000193 310.167622 961836 310.168983
|
366
|
HAWAT4 6 0.000271 0.000188 309.826669 961836 309.827691
|
367
|
HAWAT4 7 0.000268 0.000190 311.627138 961836 311.627991
|
368
|
HAWAT4 8 0.000270 0.000193 320.967746 961836 320.969014
|
369
|
HAWAT4 9 0.000270 0.000187 309.000765 961836 309.001744
|
370
|
HAWAT5 1 0.000269 0.000192 318.498921 961071 318.499641
|
371
|
HAWAT5 2 0.000270 0.000195 318.273743 961071 318.274469
|
372
|
HAWAT5 3 0.000270 0.000195 320.479179 961071 320.479978
|
373
|
HAWAT5 4 0.000270 0.000195 311.816791 961071 311.817543
|
374
|
HAWAT5 5 0.000271 0.000209 324.863733 961071 324.864540
|
375
|
HAWAT5 6 0.000269 0.000246 321.490107 961071 321.490934
|
376
|
HAWAT5 7 0.000267 0.000193 346.196830 961071 346.197648
|
377
|
HAWAT5 8 0.000270 0.000195 363.158751 961071 363.159541
|
378
|
HAWAT5 9 0.000268 0.000192 379.695570 961071 379.696242
|
379
|
HAWAT6 1 0.000306 0.000197 359.229975 364527 359.231253
|
380
|
HAWAT6 2 0.000267 0.000191 377.495457 364527 377.497386
|
381
|
HAWAT6 3 0.000268 0.000195 351.360839 364527 351.361630
|
382
|
HAWAT6 4 0.000274 0.000194 349.121862 364527 349.122673
|
383
|
HAWAT6 5 0.000272 0.000193 357.726026 364527 357.727948
|
384
|
HAWAT6 6 0.000268 0.000188 352.029644 364527 352.030874
|
385
|
HAWAT6 7 0.000264 0.000190 368.647001 364527 368.648114
|
386
|
HAWAT6 8 0.000265 0.000190 362.230575 364527 362.231702
|
387
|
HAWAT6 9 0.000267 0.000191 373.849453 364527 373.851310
|
388
|
HAWAT7 1 0.000272 0.000191 364.863858 68964 364.865528
|
389
|
HAWAT7 2 0.000270 0.000198 360.247088 68964 360.248008
|
390
|
HAWAT7 3 0.000273 0.000195 380.012131 68964 380.013898
|
391
|
HAWAT7 4 0.000272 0.000196 380.327933 68964 380.328910
|
392
|
HAWAT7 5 0.000270 0.000193 347.522429 68964 347.523425
|
393
|
HAWAT7 6 0.000272 0.000192 349.819539 68964 349.820275
|
394
|
HAWAT7 7 0.000268 0.000194 391.997389 68964 391.998318
|
395
|
HAWAT7 8 0.000275 0.000193 393.938469 68964 393.939606
|
396
|
HAWAT7 9 0.000299 0.000191 382.269969 68964 382.270966
|
397
|
End
|
398
|
!2016-08-27T17:34:34 TS2.5
|
399
|
TS2.5: Impact of list size on query time
|
400
|
!2016-08-28T19:29:12 TS2.5
|
401
|
Query Run find [s] iterate [s] Results [-] Total Time [s]
|
402
|
OTHER1 LIST(2) 1 0.000292 85.309108 585092 85.309621
|
403
|
OTHER1 LIST(2) 2 0.000248 85.403787 585092 85.404724
|
404
|
OTHER1 LIST(2) 3 0.000246 85.158338 585092 85.159557
|
405
|
OTHER1 LIST(2) 4 0.000275 84.714374 585092 84.715073
|
406
|
OTHER1 LIST(2) 5 0.000243 84.193268 585092 84.193941
|
407
|
OTHER1 LIST(2) 6 0.000249 85.336396 585092 85.337574
|
408
|
OTHER1 LIST(2) 7 0.000249 84.581644 585092 84.583087
|
409
|
OTHER1 LIST(2) 8 0.000248 83.842330 585092 83.843740
|
410
|
OTHER1 LIST(2) 9 0.000247 84.939007 585092 84.939798
|
411
|
OTHER1 LIST(4) 1 0.000256 106.617359 1065895 106.620152
|
412
|
OTHER1 LIST(4) 2 0.000251 107.545930 1065895 107.547145
|
413
|
OTHER1 LIST(4) 3 0.000244 108.144930 1065895 108.146751
|
414
|
OTHER1 LIST(4) 4 0.000245 107.500582 1065895 107.502743
|
415
|
OTHER1 LIST(4) 5 0.000244 108.707623 1065895 108.710490
|
416
|
OTHER1 LIST(4) 6 0.000248 107.563322 1065895 107.566289
|
417
|
OTHER1 LIST(4) 7 0.000248 107.839557 1065895 107.842582
|
418
|
OTHER1 LIST(4) 8 0.000245 108.215022 1065895 108.217696
|
419
|
OTHER1 LIST(4) 9 0.000245 108.293715 1065895 108.296603
|
420
|
OTHER1 LIST(8) 1 0.000255 148.623771 1949772 148.624436
|
421
|
OTHER1 LIST(8) 2 0.000246 149.623780 1949772 149.624517
|
422
|
OTHER1 LIST(8) 3 0.000249 151.038550 1949772 151.039086
|
423
|
OTHER1 LIST(8) 4 0.000252 149.656575 1949772 149.657225
|
424
|
OTHER1 LIST(8) 5 0.000254 151.882990 1949772 151.883733
|
425
|
OTHER1 LIST(8) 6 0.000252 152.948044 1949772 152.948698
|
426
|
OTHER1 LIST(8) 7 0.000255 153.823821 1949772 153.825296
|
427
|
OTHER1 LIST(8) 8 0.000250 153.956117 1949772 153.957514
|
428
|
OTHER1 LIST(8) 9 0.000253 152.646311 1949772 152.646977
|
429
|
OTHER1 LIST(16) 1 0.000259 252.003717 2141519 252.004172
|
430
|
OTHER1 LIST(16) 2 0.000253 247.438853 2141519 247.439316
|
431
|
OTHER1 LIST(16) 3 0.000248 246.683937 2141519 246.684413
|
432
|
OTHER1 LIST(16) 4 0.000253 249.808197 2141519 249.808634
|
433
|
OTHER1 LIST(16) 5 0.000253 247.054645 2141519 247.055120
|
434
|
OTHER1 LIST(16) 6 0.000249 249.880643 2141519 249.881075
|
435
|
OTHER1 LIST(16) 7 0.000250 247.243855 2141519 247.244303
|
436
|
OTHER1 LIST(16) 8 0.000251 247.447255 2141519 247.447695
|
437
|
OTHER1 LIST(16) 9 0.000248 247.579152 2141519 247.579582
|
438
|
OTHER1 LIST(32) 1 0.000260 176.692752 2454499 176.695219
|
439
|
OTHER1 LIST(32) 2 0.000250 173.962569 2454499 173.964572
|
440
|
OTHER1 LIST(32) 3 0.000250 176.502946 2454499 176.505006
|
441
|
OTHER1 LIST(32) 4 0.000249 171.298658 2454499 171.300236
|
442
|
OTHER1 LIST(32) 5 0.000248 171.208730 2454499 171.211086
|
443
|
OTHER1 LIST(32) 6 0.000252 174.746956 2454499 174.749243
|
444
|
OTHER1 LIST(32) 7 0.000249 170.800640 2454499 170.801110
|
445
|
OTHER1 LIST(32) 8 0.000284 173.521612 2454499 173.522413
|
446
|
OTHER1 LIST(32) 9 0.000250 172.459550 2454499 172.460370
|
447
|
OTHER1 LIST(64) 1 0.000263 192.689700 2877964 192.691241
|
448
|
OTHER1 LIST(64) 2 0.000257 191.558554 2877964 191.559122
|
449
|
OTHER1 LIST(64) 3 0.000260 191.924855 2877964 191.926381
|
450
|
OTHER1 LIST(64) 4 0.000262 199.189215 2877964 199.190691
|
451
|
OTHER1 LIST(64) 5 0.000170 196.708135 2877964 196.709518
|
452
|
OTHER1 LIST(64) 6 0.000260 197.146672 2877964 197.147262
|
453
|
OTHER1 LIST(64) 7 0.000258 196.663581 2877964 196.665028
|
454
|
OTHER1 LIST(64) 8 0.000303 195.885461 2877964 195.886906
|
455
|
OTHER1 LIST(64) 9 0.000256 195.093681 2877964 195.095290
|
456
|
OTHER1 LIST(128) 1 0.000264 540.932335 3274716 540.932839
|
457
|
OTHER1 LIST(128) 2 0.000255 536.876381 3274716 536.876819
|
458
|
OTHER1 LIST(128) 3 0.000259 532.903233 3274716 532.903668
|
459
|
OTHER1 LIST(128) 4 0.000259 534.650791 3274716 534.651276
|
460
|
OTHER1 LIST(128) 5 0.000258 534.705771 3274716 534.706209
|
461
|
OTHER1 LIST(128) 6 0.000255 533.465872 3274716 533.466307
|
462
|
OTHER1 LIST(128) 7 0.000256 534.572861 3274716 534.573309
|
463
|
OTHER1 LIST(128) 8 0.000262 531.801165 3274716 531.801703
|
464
|
OTHER1 LIST(128) 9 0.000259 532.657019 3274716 532.657574
|
465
|
TS3.1: Batched read using SKIP+LIMIT, COLD
|
466
|
!2016-08-28T23:19:39 TS3.1
|
467
|
Query Run Results [-] Total Time [s]
|
468
|
HAWAT1 S1 7068 2.041117
|
469
|
HAWAT1 B1 7068 46.274450
|
470
|
HAWAT1 S2 7068 1.974957
|
471
|
HAWAT1 B2 7068 46.484994
|
472
|
HAWAT1 S3 7068 2.637872
|
473
|
HAWAT1 B3 7068 46.374636
|
474
|
HAWAT1 S4 7068 2.202773
|
475
|
HAWAT1 B4 7068 46.513879
|
476
|
HAWAT1 S5 7068 2.014362
|
477
|
HAWAT1 B5 7068 46.504773
|
478
|
HAWAT1 S6 7068 2.111150
|
479
|
HAWAT1 B6 7068 46.234607
|
480
|
HAWAT1 S7 7068 2.103107
|
481
|
HAWAT1 B7 7068 46.546200
|
482
|
HAWAT1 S8 7068 2.123680
|
483
|
HAWAT1 B8 7068 46.408190
|
484
|
HAWAT1 S9 7068 2.117512
|
485
|
HAWAT1 B9 7068 46.958138
|
486
|
HAWAT3 S1 143657 7.759152
|
487
|
HAWAT3 B1 143657 502.120570
|
488
|
HAWAT3 S2 143657 7.739480
|
489
|
HAWAT3 B2 143657 501.900951
|
490
|
HAWAT3 S3 143657 7.812472
|
491
|
HAWAT3 B3 143657 502.277066
|
492
|
HAWAT3 S4 143657 7.792722
|
493
|
HAWAT3 B4 143657 492.111689
|
494
|
HAWAT3 S5 143657 7.823419
|
495
|
HAWAT3 B5 143657 496.734792
|
496
|
HAWAT3 S6 143657 7.921954
|
497
|
HAWAT3 B6 143657 498.273288
|
498
|
HAWAT3 S7 143657 7.854594
|
499
|
HAWAT3 B7 143657 500.296681
|
500
|
HAWAT3 S8 143657 7.541185
|
501
|
HAWAT3 B8 143657 500.481219
|
502
|
HAWAT3 S9 143657 7.759399
|
503
|
HAWAT3 B9 143657 492.787675
|
504
|
HAWAT4 S1 17730 2.143916
|
505
|
HAWAT4 B1 17730 102.667594
|
506
|
HAWAT4 S2 17730 2.058725
|
507
|
HAWAT4 B2 17730 105.092041
|
508
|
HAWAT4 S3 17730 2.096076
|
509
|
HAWAT4 B3 17730 104.796015
|
510
|
HAWAT4 S4 17730 1.975656
|
511
|
HAWAT4 B4 17730 102.386076
|
512
|
HAWAT4 S5 17730 1.954580
|
513
|
HAWAT4 B5 17730 102.946305
|
514
|
HAWAT4 S6 17730 1.883833
|
515
|
HAWAT4 B6 17730 102.850934
|
516
|
HAWAT4 S7 17730 2.044334
|
517
|
HAWAT4 B7 17730 103.603665
|
518
|
HAWAT4 S8 17730 1.985562
|
519
|
HAWAT4 B8 17730 101.773075
|
520
|
HAWAT4 S9 17730 2.396481
|
521
|
HAWAT4 B9 17730 104.955900
|
522
|
HAWAT5 S1 17724 1.963812
|
523
|
HAWAT5 B1 17724 119.895189
|
524
|
HAWAT5 S2 17724 2.225648
|
525
|
HAWAT5 B2 17724 119.853201
|
526
|
HAWAT5 S3 17724 2.171825
|
527
|
HAWAT5 B3 17724 118.239951
|
528
|
HAWAT5 S4 17724 2.113179
|
529
|
HAWAT5 B4 17724 121.077077
|
530
|
HAWAT5 S5 17724 1.996060
|
531
|
HAWAT5 B5 17724 120.299923
|
532
|
HAWAT5 S6 17724 2.215032
|
533
|
HAWAT5 B6 17724 120.410087
|
534
|
HAWAT5 S7 17724 2.170963
|
535
|
HAWAT5 B7 17724 119.963739
|
536
|
HAWAT5 S8 17724 2.186691
|
537
|
HAWAT5 B8 17724 119.405156
|
538
|
HAWAT5 S9 17724 2.106899
|
539
|
HAWAT5 B9 17724 120.339450
|
540
|
HAWAT6 S1 7068 2.193597
|
541
|
HAWAT6 B1 7068 47.367378
|
542
|
HAWAT6 S2 7068 2.324118
|
543
|
HAWAT6 B2 7068 47.020386
|
544
|
HAWAT6 S3 7068 2.261488
|
545
|
HAWAT6 B3 7068 46.744962
|
546
|
HAWAT6 S4 7068 2.222433
|
547
|
HAWAT6 B4 7068 47.698421
|
548
|
HAWAT6 S5 7068 2.232777
|
549
|
HAWAT6 B5 7068 46.406152
|
550
|
HAWAT6 S6 7068 2.210899
|
551
|
HAWAT6 B6 7068 46.876552
|
552
|
HAWAT6 S7 7068 2.172889
|
553
|
HAWAT6 B7 7068 46.948755
|
554
|
HAWAT6 S8 7068 2.223305
|
555
|
HAWAT6 B8 7068 46.523153
|
556
|
HAWAT6 S9 7068 2.351850
|
557
|
HAWAT6 B9 7068 47.924846
|
558
|
TS3.2: Batched read using SKIP+LIMIT, COLD, descending sort
|
559
|
!2016-08-29T01:32:33 TS3.2
|
560
|
Query Run Results [-] Total Time [s]
|
561
|
HAWAT1 S1 7068 6.832209
|
562
|
HAWAT1 B1 7068 68.421570
|
563
|
HAWAT1 S2 7068 6.871713
|
564
|
HAWAT1 B2 7068 69.937015
|
565
|
HAWAT1 S3 7068 6.643312
|
566
|
HAWAT1 B3 7068 68.553704
|
567
|
HAWAT1 S4 7068 6.718763
|
568
|
HAWAT1 B4 7068 69.297647
|
569
|
HAWAT1 S5 7068 6.948518
|
570
|
HAWAT1 B5 7068 69.523425
|
571
|
HAWAT1 S6 7068 6.724933
|
572
|
HAWAT1 B6 7068 68.820351
|
573
|
HAWAT1 S7 7068 6.918917
|
574
|
HAWAT1 B7 7068 69.978024
|
575
|
HAWAT1 S8 7068 6.738763
|
576
|
HAWAT1 B8 7068 68.904353
|
577
|
HAWAT1 S9 7068 6.762707
|
578
|
HAWAT1 B9 7068 68.711615
|
579
|
HAWAT3 S1 143657 11.885667
|
580
|
HAWAT3 B1 143657 548.665974
|
581
|
HAWAT3 S2 143657 11.998656
|
582
|
HAWAT3 B2 143657 547.565119
|
583
|
HAWAT3 S3 143657 12.258986
|
584
|
HAWAT3 B3 143657 559.434639
|
585
|
HAWAT3 S4 143657 11.833114
|
586
|
HAWAT3 B4 143657 538.467030
|
587
|
HAWAT3 S5 143657 11.813205
|
588
|
HAWAT3 B5 143657 529.839122
|
589
|
HAWAT3 S6 143657 11.985153
|
590
|
HAWAT3 B6 143657 540.301619
|
591
|
HAWAT3 S7 143657 11.644954
|
592
|
HAWAT3 B7 143657 534.533140
|
593
|
HAWAT3 S8 143657 12.674420
|
594
|
HAWAT3 B8 143657 531.582379
|
595
|
HAWAT3 S9 143657 12.186682
|
596
|
HAWAT3 B9 143657 558.585608
|
597
|
HAWAT4 S1 17730 6.700466
|
598
|
HAWAT4 B1 17730 101.522750
|
599
|
HAWAT4 S2 17730 6.615232
|
600
|
HAWAT4 B2 17730 101.912969
|
601
|
HAWAT4 S3 17730 6.481664
|
602
|
HAWAT4 B3 17730 98.587956
|
603
|
HAWAT4 S4 17730 6.308944
|
604
|
HAWAT4 B4 17730 100.744002
|
605
|
HAWAT4 S5 17730 6.508421
|
606
|
HAWAT4 B5 17730 99.489153
|
607
|
HAWAT4 S6 17730 6.502958
|
608
|
HAWAT4 B6 17730 102.499532
|
609
|
HAWAT4 S7 17730 6.545856
|
610
|
HAWAT4 B7 17730 98.543858
|
611
|
HAWAT4 S8 17730 6.655805
|
612
|
HAWAT4 B8 17730 100.065373
|
613
|
HAWAT4 S9 17730 6.555724
|
614
|
HAWAT4 B9 17730 99.887305
|
615
|
HAWAT5 S1 17724 6.744722
|
616
|
HAWAT5 B1 17724 117.729866
|
617
|
HAWAT5 S2 17724 6.508594
|
618
|
HAWAT5 B2 17724 115.029915
|
619
|
HAWAT5 S3 17724 6.529837
|
620
|
HAWAT5 B3 17724 116.285848
|
621
|
HAWAT5 S4 17724 6.516873
|
622
|
HAWAT5 B4 17724 119.371877
|
623
|
HAWAT5 S5 17724 6.572405
|
624
|
HAWAT5 B5 17724 115.309178
|
625
|
HAWAT5 S6 17724 6.528806
|
626
|
HAWAT5 B6 17724 114.658110
|
627
|
HAWAT5 S7 17724 6.758385
|
628
|
HAWAT5 B7 17724 117.408255
|
629
|
HAWAT5 S8 17724 6.587494
|
630
|
HAWAT5 B8 17724 116.239774
|
631
|
HAWAT5 S9 17724 6.720783
|
632
|
HAWAT5 B9 17724 116.343932
|
633
|
HAWAT6 S1 7068 6.728187
|
634
|
HAWAT6 B1 7068 69.895496
|
635
|
HAWAT6 S2 7068 6.662333
|
636
|
HAWAT6 B2 7068 70.071798
|
637
|
HAWAT6 S3 7068 7.035845
|
638
|
HAWAT6 B3 7068 68.708470
|
639
|
HAWAT6 S4 7068 6.819496
|
640
|
HAWAT6 B4 7068 68.976871
|
641
|
HAWAT6 S5 7068 6.694632
|
642
|
HAWAT6 B5 7068 69.143331
|
643
|
HAWAT6 S6 7068 6.924413
|
644
|
HAWAT6 B6 7068 69.497977
|
645
|
HAWAT6 S7 7068 6.835949
|
646
|
HAWAT6 B7 7068 69.471609
|
647
|
HAWAT6 S8 7068 6.778259
|
648
|
HAWAT6 B8 7068 68.931042
|
649
|
HAWAT6 S9 7068 6.639160
|
650
|
HAWAT6 B9 7068 68.883142
|
651
|
TS3.3: Batched read using SKIP+LIMIT, HOT
|
652
|
!2016-08-29T04:01:09 TS3.3
|
653
|
Query Run Results [-] Total Time [s]
|
654
|
HAWAT1 COLD1 50 0.278733
|
655
|
HAWAT1 THREE1 150 0.329743
|
656
|
HAWAT1 HOT1 50 0.020097
|
657
|
HAWAT3 COLD1 50 0.067436
|
658
|
HAWAT3 THREE1 150 0.066342
|
659
|
HAWAT3 HOT1 50 0.001818
|
660
|
HAWAT4 COLD1 50 0.134319
|
661
|
HAWAT4 THREE1 150 0.128998
|
662
|
HAWAT4 HOT1 50 0.008289
|
663
|
HAWAT5 COLD1 50 0.220432
|
664
|
HAWAT5 THREE1 150 0.166561
|
665
|
HAWAT5 HOT1 50 0.010344
|
666
|
HAWAT6 COLD1 50 0.344678
|
667
|
HAWAT6 THREE1 150 0.381098
|
668
|
HAWAT6 HOT1 50 0.018687
|
669
|
HAWAT1 COLD2 50 0.286649
|
670
|
HAWAT1 THREE2 150 0.352596
|
671
|
HAWAT1 HOT2 50 0.019889
|
672
|
HAWAT3 COLD2 50 0.061187
|
673
|
HAWAT3 THREE2 150 0.065349
|
674
|
HAWAT3 HOT2 50 0.001997
|
675
|
HAWAT4 COLD2 50 0.130636
|
676
|
HAWAT4 THREE2 150 0.141123
|
677
|
HAWAT4 HOT2 50 0.008501
|
678
|
HAWAT5 COLD2 50 0.156581
|
679
|
HAWAT5 THREE2 150 0.183726
|
680
|
HAWAT5 HOT2 50 0.010956
|
681
|
HAWAT6 COLD2 50 0.339211
|
682
|
HAWAT6 THREE2 150 0.382840
|
683
|
HAWAT6 HOT2 50 0.028312
|
684
|
HAWAT1 COLD3 50 0.287384
|
685
|
HAWAT1 THREE3 150 0.368686
|
686
|
HAWAT1 HOT3 50 0.018125
|
687
|
HAWAT3 COLD3 50 0.057564
|
688
|
HAWAT3 THREE3 150 0.066732
|
689
|
HAWAT3 HOT3 50 0.002119
|
690
|
HAWAT4 COLD3 50 0.128341
|
691
|
HAWAT4 THREE3 150 0.134054
|
692
|
HAWAT4 HOT3 50 0.009560
|
693
|
HAWAT5 COLD3 50 0.154989
|
694
|
HAWAT5 THREE3 150 0.188828
|
695
|
HAWAT5 HOT3 50 0.009799
|
696
|
HAWAT6 COLD3 50 0.352284
|
697
|
HAWAT6 THREE3 150 0.375376
|
698
|
HAWAT6 HOT3 50 0.019983
|
699
|
HAWAT1 COLD4 50 0.289518
|
700
|
HAWAT1 THREE4 150 0.339122
|
701
|
HAWAT1 HOT4 50 0.020648
|
702
|
HAWAT3 COLD4 50 0.063436
|
703
|
HAWAT3 THREE4 150 0.076769
|
704
|
HAWAT3 HOT4 50 0.002339
|
705
|
HAWAT4 COLD4 50 0.130035
|
706
|
HAWAT4 THREE4 150 0.141575
|
707
|
HAWAT4 HOT4 50 0.010565
|
708
|
HAWAT5 COLD4 50 0.168916
|
709
|
HAWAT5 THREE4 150 0.181826
|
710
|
HAWAT5 HOT4 50 0.009660
|
711
|
HAWAT6 COLD4 50 0.341016
|
712
|
HAWAT6 THREE4 150 0.398718
|
713
|
HAWAT6 HOT4 50 0.020076
|
714
|
HAWAT1 COLD5 50 0.332977
|
715
|
HAWAT1 THREE5 150 0.343529
|
716
|
HAWAT1 HOT5 50 0.020070
|
717
|
HAWAT3 COLD5 50 0.059369
|
718
|
HAWAT3 THREE5 150 0.071662
|
719
|
HAWAT3 HOT5 50 0.002133
|
720
|
HAWAT4 COLD5 50 0.132725
|
721
|
HAWAT4 THREE5 150 0.129857
|
722
|
HAWAT4 HOT5 50 0.008815
|
723
|
HAWAT5 COLD5 50 0.162713
|
724
|
HAWAT5 THREE5 150 0.188010
|
725
|
HAWAT5 HOT5 50 0.009627
|
726
|
HAWAT6 COLD5 50 0.339471
|
727
|
HAWAT6 THREE5 150 0.369050
|
728
|
HAWAT6 HOT5 50 0.020359
|
729
|
HAWAT1 COLD6 50 0.288665
|
730
|
HAWAT1 THREE6 150 0.361659
|
731
|
HAWAT1 HOT6 50 0.018608
|
732
|
HAWAT3 COLD6 50 0.059126
|
733
|
HAWAT3 THREE6 150 0.068089
|
734
|
HAWAT3 HOT6 50 0.002689
|
735
|
HAWAT4 COLD6 50 0.109814
|
736
|
HAWAT4 THREE6 150 0.139188
|
737
|
HAWAT4 HOT6 50 0.008901
|
738
|
HAWAT5 COLD6 50 0.165926
|
739
|
HAWAT5 THREE6 150 0.178364
|
740
|
HAWAT5 HOT6 50 0.009939
|
741
|
HAWAT6 COLD6 50 0.452627
|
742
|
HAWAT6 THREE6 150 0.386198
|
743
|
HAWAT6 HOT6 50 0.017823
|
744
|
HAWAT1 COLD7 50 0.306619
|
745
|
HAWAT1 THREE7 150 0.331932
|
746
|
HAWAT1 HOT7 50 0.019387
|
747
|
HAWAT3 COLD7 50 0.058720
|
748
|
HAWAT3 THREE7 150 0.079863
|
749
|
HAWAT3 HOT7 50 0.002816
|
750
|
HAWAT4 COLD7 50 0.130145
|
751
|
HAWAT4 THREE7 150 0.143578
|
752
|
HAWAT4 HOT7 50 0.009174
|
753
|
HAWAT5 COLD7 50 0.151356
|
754
|
HAWAT5 THREE7 150 0.185967
|
755
|
HAWAT5 HOT7 50 0.009257
|
756
|
HAWAT6 COLD7 50 0.336810
|
757
|
HAWAT6 THREE7 150 0.384950
|
758
|
HAWAT6 HOT7 50 0.017582
|
759
|
HAWAT1 COLD8 50 0.288099
|
760
|
HAWAT1 THREE8 150 0.332176
|
761
|
HAWAT1 HOT8 50 0.020650
|
762
|
HAWAT3 COLD8 50 0.063274
|
763
|
HAWAT3 THREE8 150 0.070790
|
764
|
HAWAT3 HOT8 50 0.002840
|
765
|
HAWAT4 COLD8 50 0.128762
|
766
|
HAWAT4 THREE8 150 0.133202
|
767
|
HAWAT4 HOT8 50 0.009512
|
768
|
HAWAT5 COLD8 50 0.155758
|
769
|
HAWAT5 THREE8 150 0.182928
|
770
|
HAWAT5 HOT8 50 0.012838
|
771
|
HAWAT6 COLD8 50 0.348620
|
772
|
HAWAT6 THREE8 150 0.402376
|
773
|
HAWAT6 HOT8 50 0.019534
|
774
|
HAWAT1 COLD9 50 0.311904
|
775
|
HAWAT1 THREE9 150 0.351017
|
776
|
HAWAT1 HOT9 50 0.021685
|
777
|
HAWAT3 COLD9 50 0.063418
|
778
|
HAWAT3 THREE9 150 0.068045
|
779
|
HAWAT3 HOT9 50 0.001852
|
780
|
HAWAT4 COLD9 50 0.130207
|
781
|
HAWAT4 THREE9 150 0.130562
|
782
|
HAWAT4 HOT9 50 0.008250
|
783
|
HAWAT5 COLD9 50 0.168705
|
784
|
HAWAT5 THREE9 150 0.178656
|
785
|
HAWAT5 HOT9 50 0.009238
|
786
|
HAWAT6 COLD9 50 0.343381
|
787
|
HAWAT6 THREE9 150 0.385462
|
788
|
HAWAT6 HOT9 50 0.018114
|
789
|
TS3.4: Batched read using SKIP+LIMIT, HOT, descending order
|
790
|
!2016-08-29T04:09:28 TS3.4
|
791
|
Query Run Results [-] Total Time [s]
|
792
|
HAWAT1 COLD1 50 0.376849
|
793
|
HAWAT1 THREE1 150 0.643383
|
794
|
HAWAT1 HOT1 50 0.035493
|
795
|
HAWAT3 COLD1 50 0.076166
|
796
|
HAWAT3 THREE1 150 0.090699
|
797
|
HAWAT3 HOT1 50 0.008745
|
798
|
HAWAT4 COLD1 50 0.131166
|
799
|
HAWAT4 THREE1 150 0.101464
|
800
|
HAWAT4 HOT1 50 0.010781
|
801
|
HAWAT5 COLD1 50 0.105577
|
802
|
HAWAT5 THREE1 150 0.121844
|
803
|
HAWAT5 HOT1 50 0.010110
|
804
|
HAWAT6 COLD1 50 0.424986
|
805
|
HAWAT6 THREE1 150 0.773769
|
806
|
HAWAT6 HOT1 50 0.041624
|
807
|
HAWAT1 COLD2 50 0.368931
|
808
|
HAWAT1 THREE2 150 0.681875
|
809
|
HAWAT1 HOT2 50 0.028119
|
810
|
HAWAT3 COLD2 50 0.072713
|
811
|
HAWAT3 THREE2 150 0.088781
|
812
|
HAWAT3 HOT2 50 0.009618
|
813
|
HAWAT4 COLD2 50 0.110219
|
814
|
HAWAT4 THREE2 150 0.103166
|
815
|
HAWAT4 HOT2 50 0.011984
|
816
|
HAWAT5 COLD2 50 0.113746
|
817
|
HAWAT5 THREE2 150 0.118670
|
818
|
HAWAT5 HOT2 50 0.014767
|
819
|
HAWAT6 COLD2 50 0.421266
|
820
|
HAWAT6 THREE2 150 0.677665
|
821
|
HAWAT6 HOT2 50 0.036158
|
822
|
HAWAT1 COLD3 50 0.361327
|
823
|
HAWAT1 THREE3 150 0.641746
|
824
|
HAWAT1 HOT3 50 0.032243
|
825
|
HAWAT3 COLD3 50 0.072916
|
826
|
HAWAT3 THREE3 150 0.125911
|
827
|
HAWAT3 HOT3 50 0.048249
|
828
|
HAWAT4 COLD3 50 0.093690
|
829
|
HAWAT4 THREE3 150 0.100123
|
830
|
HAWAT4 HOT3 50 0.015383
|
831
|
HAWAT5 COLD3 50 0.108173
|
832
|
HAWAT5 THREE3 150 0.123933
|
833
|
HAWAT5 HOT3 50 0.014082
|
834
|
HAWAT6 COLD3 50 0.425276
|
835
|
HAWAT6 THREE3 150 0.709894
|
836
|
HAWAT6 HOT3 50 0.035248
|
837
|
HAWAT1 COLD4 50 0.369732
|
838
|
HAWAT1 THREE4 150 0.642046
|
839
|
HAWAT1 HOT4 50 0.037910
|
840
|
HAWAT3 COLD4 50 0.076105
|
841
|
HAWAT3 THREE4 150 0.092706
|
842
|
HAWAT3 HOT4 50 0.011200
|
843
|
HAWAT4 COLD4 50 0.099613
|
844
|
HAWAT4 THREE4 150 0.129716
|
845
|
HAWAT4 HOT4 50 0.014992
|
846
|
HAWAT5 COLD4 50 0.114889
|
847
|
HAWAT5 THREE4 150 0.122415
|
848
|
HAWAT5 HOT4 50 0.013883
|
849
|
HAWAT6 COLD4 50 0.408770
|
850
|
HAWAT6 THREE4 150 0.717548
|
851
|
HAWAT6 HOT4 50 0.032633
|
852
|
HAWAT1 COLD5 50 0.394298
|
853
|
HAWAT1 THREE5 150 0.625751
|
854
|
HAWAT1 HOT5 50 0.036592
|
855
|
HAWAT3 COLD5 50 0.072117
|
856
|
HAWAT3 THREE5 150 0.089744
|
857
|
HAWAT3 HOT5 50 0.009250
|
858
|
HAWAT4 COLD5 50 0.100378
|
859
|
HAWAT4 THREE5 150 0.104867
|
860
|
HAWAT4 HOT5 50 0.010904
|
861
|
HAWAT5 COLD5 50 0.116917
|
862
|
HAWAT5 THREE5 150 0.120457
|
863
|
HAWAT5 HOT5 50 0.012706
|
864
|
HAWAT6 COLD5 50 0.416855
|
865
|
HAWAT6 THREE5 150 0.673236
|
866
|
HAWAT6 HOT5 50 0.035178
|
867
|
HAWAT1 COLD6 50 0.371882
|
868
|
HAWAT1 THREE6 150 0.635888
|
869
|
HAWAT1 HOT6 50 0.037244
|
870
|
HAWAT3 COLD6 50 0.076056
|
871
|
HAWAT3 THREE6 150 0.089355
|
872
|
HAWAT3 HOT6 50 0.009076
|
873
|
HAWAT4 COLD6 50 0.095267
|
874
|
HAWAT4 THREE6 150 0.097756
|
875
|
HAWAT4 HOT6 50 0.015809
|
876
|
HAWAT5 COLD6 50 0.105297
|
877
|
HAWAT5 THREE6 150 0.124330
|
878
|
HAWAT5 HOT6 50 0.014937
|
879
|
HAWAT6 COLD6 50 0.421190
|
880
|
HAWAT6 THREE6 150 0.789711
|
881
|
HAWAT6 HOT6 50 0.028590
|
882
|
HAWAT1 COLD7 50 0.396029
|
883
|
HAWAT1 THREE7 150 0.645980
|
884
|
HAWAT1 HOT7 50 0.035208
|
885
|
HAWAT3 COLD7 50 0.084196
|
886
|
HAWAT3 THREE7 150 0.094293
|
887
|
HAWAT3 HOT7 50 0.008628
|
888
|
HAWAT4 COLD7 50 0.101437
|
889
|
HAWAT4 THREE7 150 0.105299
|
890
|
HAWAT4 HOT7 50 0.010170
|
891
|
HAWAT5 COLD7 50 0.109393
|
892
|
HAWAT5 THREE7 150 0.114172
|
893
|
HAWAT5 HOT7 50 0.014517
|
894
|
HAWAT6 COLD7 50 0.438680
|
895
|
HAWAT6 THREE7 150 0.717870
|
896
|
HAWAT6 HOT7 50 0.028345
|
897
|
HAWAT1 COLD8 50 0.356971
|
898
|
HAWAT1 THREE8 150 0.725775
|
899
|
HAWAT1 HOT8 50 0.029471
|
900
|
HAWAT3 COLD8 50 0.075919
|
901
|
HAWAT3 THREE8 150 0.087727
|
902
|
HAWAT3 HOT8 50 0.013277
|
903
|
HAWAT4 COLD8 50 0.094454
|
904
|
HAWAT4 THREE8 150 0.103936
|
905
|
HAWAT4 HOT8 50 0.012673
|
906
|
HAWAT5 COLD8 50 0.108493
|
907
|
HAWAT5 THREE8 150 0.134076
|
908
|
HAWAT5 HOT8 50 0.016344
|
909
|
HAWAT6 COLD8 50 0.421305
|
910
|
HAWAT6 THREE8 150 0.693844
|
911
|
HAWAT6 HOT8 50 0.040571
|
912
|
HAWAT1 COLD9 50 0.376871
|
913
|
HAWAT1 THREE9 150 0.654656
|
914
|
HAWAT1 HOT9 50 0.037762
|
915
|
HAWAT3 COLD9 50 0.076160
|
916
|
HAWAT3 THREE9 150 0.087668
|
917
|
HAWAT3 HOT9 50 0.013826
|
918
|
HAWAT4 COLD9 50 0.094395
|
919
|
HAWAT4 THREE9 150 0.096633
|
920
|
HAWAT4 HOT9 50 0.010132
|
921
|
HAWAT5 COLD9 50 0.115535
|
922
|
HAWAT5 THREE9 150 0.129056
|
923
|
HAWAT5 HOT9 50 0.011085
|
924
|
HAWAT6 COLD9 50 0.429119
|
925
|
HAWAT6 THREE9 150 0.710183
|
926
|
HAWAT6 HOT9 50 0.041005
|