bb10955b605cb255c442abe0188d7029d7df0986

Home / Branches / cursor/sqitch-plan-file-marker-6ecf / bb10955b605cb255c442abe0188d7029d7df0986

Aggregation: measureAggregations

Factorallocated MiBpeak allocated MiBtime_s
cache=n
dps=1
iters=10
policies=100
mean54.580
σ0.344
min54.450
max55.558
mean420.000
σ0.000
min420.000
max420.000
mean0.139
σ0.006
min0.132
max0.149
cache=y
dps=1
iters=10
policies=100
mean43.704
σ0.007
min43.693
max43.715
mean420.000
σ0.000
min420.000
max420.000
mean0.123
σ0.004
min0.118
max0.131

CSV - indexed operations

Factorallocated MiBpeak allocated MiBtime (ms)
op=column_set() on indexed
mean36.618
σ0.002
min36.616
max36.620
mean4147.875
σ1889.278
min1555.000
max7266.000
mean12.133
σ0.324
min11.674
max12.645
op=column_set() on indexed, repeat
mean36.617
σ0.002
min36.616
max36.620
mean4147.875
σ1889.278
min1555.000
max7266.000
mean12.349
σ0.492
min11.598
max12.868
op=table_records(), no indexes
mean41.932
σ0.001
min41.928
max41.933
mean7266.000
σ0.000
min7266.000
max7266.000
mean14.778
σ0.374
min14.059
max15.218
op=table_records(), repeat
mean41.928
σ0.002
min41.927
max41.931
mean4147.875
σ1889.278
min1555.000
max7266.000
mean12.115
σ1.478
min10.167
max13.919
op=vertical_lookup_list() on indexed, after table_records()
mean27.653
σ0.136
min27.603
max27.990
mean4147.875
σ1889.278
min1555.000
max7266.000
mean8.428
σ0.240
min8.110
max8.779
op=vertical_lookup_list() on indexed, after table_records(), repeat
mean26.400
σ0.002
min26.399
max26.403
mean4147.875
σ1889.278
min1555.000
max7266.000
mean6.446
σ0.091
min6.331
max6.579
op=vertical_lookup_row_list() on 2 indexed
mean25.666
σ0.002
min25.664
max25.668
mean4147.875
σ1889.278
min1555.000
max7266.000
mean5.505
σ0.114
min5.337
max5.633
op=vertical_lookup_row_list() on 3 (1 unindexed)
mean25.968
σ0.002
min25.967
max25.972
mean4147.875
σ1889.278
min1555.000
max7266.000
mean5.312
σ0.069
min5.188
max5.427

CSV - loading a lazy table

Factorallocated MiBpeak allocated MiBtime (ms)
op=load_product(), no indexes
mean2524.606
σ0.000
min2524.606
max2524.606
mean7266.000
σ0.000
min7266.000
max7266.000
mean1591.955
σ998.526
min1039.225
max3910.155
op=load_product(), with indexes
mean8744.721
σ0.469
min8744.553
max8745.882
mean3570.000
σ1789.698
min1046.000
max5775.000
mean4985.535
σ1575.285
min3536.147
max6955.204

CSV - unindexed operations

Factorallocated MiBpeak allocated MiBtime (ms)
op=column_set() on unindexed, dense
mean62.078
σ0.002
min62.076
max62.081
mean4147.875
σ1889.278
min1555.000
max7266.000
mean82.820
σ11.800
min69.078
max97.581
op=vertical_lookup_list() on unindexed missing Int
mean40.944
σ0.001
min40.944
max40.945
mean7266.000
σ0.000
min7266.000
max7266.000
mean106.794
σ2.781
min102.257
max110.451
op=vertical_lookup_row_list() on unindexed small unique Int
mean66.686
σ0.000
min66.685
max66.687
mean7266.000
σ0.000
min7266.000
max7266.000
mean163.681
σ4.045
min155.371
max166.965

CSV - warmup

Factorallocated MiBpeak allocated MiBtime (ms)
op=table_records()
mean11656.836
σ4.324
min11655.305
max11667.538
mean4147.875
σ1889.278
min1555.000
max7266.000
mean6610.197
σ1234.155
min4948.154
max8254.761
op=vertical_lookup_list() on indexed
mean11560.065
σ0.001
min11560.064
max11560.066
mean7266.000
σ0.000
min7266.000
max7266.000
mean5423.435
σ1365.023
min4391.282
max7867.250

CSV internal benchmark: pointedIndexFromKvs

Factorallocated MiBpeak allocated MiBtime (ms)
op=pointedIndexFromKvs
rows=200000
mean172.559
σ0.001
min172.558
max172.562
mean478.000
σ0.000
min478.000
max478.000
mean365.133
σ33.312
min298.798
max394.332
op=pointedIndexFromKvs
rows=400000
mean357.322
σ0.001
min357.321
max357.325
mean560.625
σ0.518
min560.000
max561.000
mean761.492
σ57.854
min619.958
max795.417

Marine Hull: transactPolicy

Factorallocated MiBpeak allocated MiBtime
datapoints=1
iterations=20
mean1008.500
σ0.759
min1008.027
max1011.636
mean1048.700
σ312.186
min584.000
max1511.000
mean1.540
σ0.075
min1.459
max1.744

Parser: Comma Sep

Factorallocated MiBpeak allocated MiBtime (ms)
name=ambiguous_item.art
mean0.913
σ0.020
min0.903
max0.949
mean402.000
σ0.000
min402.000
max402.000
mean0.378
σ0.481
min0.137
max1.236
name=error_case.art
mean2.339
σ0.012
min2.333
max2.361
mean402.000
σ0.000
min402.000
max402.000
mean0.486
σ0.328
min0.330
max1.073
name=heavy_item.art
mean1.522
σ0.002
min1.521
max1.525
mean402.000
σ0.000
min402.000
max402.000
mean0.224
σ0.027
min0.202
max0.272
name=nested_use.art
mean2.357
σ0.002
min2.356
max2.360
mean402.000
σ0.000
min402.000
max402.000
mean0.336
σ0.018
min0.325
max0.367

Parser: Real World

Factorallocated MiBpeak allocated MiBtime (sec)
name=aon_gpf25_7k_loc.art
mean964.741
σ0.011
min964.736
max964.760
mean436.200
σ5.541
min431.000
max442.000
mean0.532
σ0.036
min0.496
max0.585
name=cdr_enhanced_4k_loc.art
mean885.814
σ0.002
min885.812
max885.816
mean442.000
σ0.000
min442.000
max442.000
mean0.506
σ0.028
min0.473
max0.528

Parser: Record Parsing

Factorallocated MiBpeak allocated MiBtime (ms)
name=record_render_large_success.art
mean7.708
σ0.002
min7.707
max7.711
mean442.000
σ0.000
min442.000
max442.000
mean2.621
σ0.102
min2.457
max3.056
name=record_render_large_syntax_err.art
mean7.656
σ0.002
min7.655
max7.659
mean442.000
σ0.000
min442.000
max442.000
mean2.645
σ0.100
min2.468
max3.127
name=record_render_success.art
mean2.289
σ0.002
min2.288
max2.292
mean442.000
σ0.000
min442.000
max442.000
mean0.310
σ0.009
min0.295
max0.364
name=record_render_syntax_err.art
mean2.165
σ0.002
min2.164
max2.168
mean442.000
σ0.000
min442.000
max442.000
mean0.296
σ0.008
min0.282
max0.341

SoV import

Factorallocated MiBpeak allocated MiBtime_s
iters=10
rows=1000
mean298.168
σ0.982
min297.780
max300.959
mean441.900
σ13.691
min420.000
max461.000
mean0.609
σ0.022
min0.570
max0.647

Timed compile per phase

Factorallocated MiBpeak allocated MiBtime (ms)
phase=buildDeclTree
mean222.008
σ0.000
min222.008
max222.008
mean1753.500
σ8.018
min1746.000
max1761.000
mean204.323
σ2.360
min201.497
max208.548
phase=macro expansion
mean6.130
σ0.000
min6.130
max6.130
mean1753.500
σ8.018
min1746.000
max1761.000
mean10.862
σ2.449
min7.289
max12.611
phase=parser
mean1042.099
σ0.000
min1042.098
max1042.099
mean1753.500
σ8.018
min1746.000
max1761.000
mean650.894
σ108.404
min424.540
max724.012
phase=processProdDef
mean6169.656
σ0.000
min6169.655
max6169.656
mean1755.375
σ7.763
min1746.000
max1761.000
mean5116.243
σ768.172
min3980.437
max6528.519
phase=renaming
mean21.667
σ0.000
min21.667
max21.667
mean1753.500
σ8.018
min1746.000
max1761.000
mean41.253
σ9.434
min26.331
max47.834
phase=type checker
mean958.457
σ0.066
min958.360
max958.547
mean1753.500
σ8.018
min1746.000
max1761.000
mean768.492
σ96.646
min633.489
max878.644

Workflow: transactPolicy

Factorallocated MiBpeak allocated MiBtime
iters=5
new-facts=1
prior-facts=1
mean293.694
σ0.045
min293.630
max293.737
mean446.000
σ0.000
min446.000
max446.000
mean0.399
σ0.001
min0.398
max0.401
iters=5
new-facts=1
prior-facts=6402
mean1303.758
σ0.051
min1303.711
max1303.823
mean1106.600
σ171.208
min894.000
max1331.000
mean2.009
σ0.139
min1.852
max2.148
iters=5
new-facts=6402
prior-facts=1
mean1546.837
σ4.009
min1544.884
max1554.005
mean619.200
σ87.964
min523.000
max728.000
mean2.342
σ0.201
min2.142
max2.585
iters=5
new-facts=6402
prior-facts=6402
mean1865.828
σ0.065
min1865.751
max1865.910
mean1756.200
σ213.024
min1476.000
max1958.000
mean3.231
σ0.337
min2.873
max3.721

newProductH/cdr_auton/broker

Factortime_s
iterations=5
mean1.663
σ0.164
min1.490
max1.928

policy addition benchmark

Factorallocated MiBdb queriespeak allocated MiBtime
policies=2
mean450.089
σ579.265
min160.452
max1318.986
mean102.250
σ8.500
min98.000
max115.000
mean442.000
σ0.000
min442.000
max442.000
mean0.518
σ0.499
min0.268
max1.267
policies=20
mean1604.880
σ0.405
min1604.603
max1605.481
mean980.000
σ0.000
min980.000
max980.000
mean445.750
σ2.500
min442.000
max447.000
mean2.676
σ0.019
min2.664
max2.704
policies=200
mean16057.078
σ0.119
min16056.919
max16057.207
mean9800.000
σ0.000
min9800.000
max9800.000
mean497.250
σ3.862
min492.000
max501.000
mean27.090
σ0.053
min27.033
max27.142