bfb80c7ab21316466e605d6e0010cd2d34b0ad20

Home / Branches / marcelkalveram/exp-1635-add-support-for-node-types-of-select-tests / bfb80c7ab21316466e605d6e0010cd2d34b0ad20

Aggregation: measureAggregations

Factorallocated MiBpeak allocated MiBtime_s
cache=n
dps=1
iters=10
policies=100
mean54.679
σ0.359
min54.540
max55.701
mean416.000
σ0.000
min416.000
max416.000
mean0.141
σ0.004
min0.138
max0.150
cache=y
dps=1
iters=10
policies=100
mean43.705
σ0.006
min43.697
max43.713
mean416.000
σ0.000
min416.000
max416.000
mean0.121
σ0.004
min0.116
max0.130

CSV - indexed operations

Factorallocated MiBpeak allocated MiBtime (ms)
op=column_set() on indexed
mean36.618
σ0.002
min36.616
max36.620
mean4157.625
σ1906.379
min1556.000
max7323.000
mean12.765
σ0.203
min12.468
max12.998
op=column_set() on indexed, repeat
mean36.617
σ0.002
min36.616
max36.620
mean4157.625
σ1906.379
min1556.000
max7323.000
mean13.128
σ0.604
min11.761
max13.678
op=table_records(), no indexes
mean41.932
σ0.001
min41.929
max41.932
mean7323.000
σ0.000
min7323.000
max7323.000
mean14.498
σ0.873
min12.442
max15.241
op=table_records(), repeat
mean41.929
σ0.002
min41.927
max41.931
mean4157.625
σ1906.379
min1556.000
max7323.000
mean12.167
σ1.562
min10.709
max14.204
op=vertical_lookup_list() on indexed, after table_records()
mean27.654
σ0.136
min27.604
max27.991
mean4157.625
σ1906.379
min1556.000
max7323.000
mean8.937
σ0.372
min8.474
max9.418
op=vertical_lookup_list() on indexed, after table_records(), repeat
mean26.401
σ0.002
min26.400
max26.404
mean4157.625
σ1906.379
min1556.000
max7323.000
mean7.042
σ0.119
min6.863
max7.221
op=vertical_lookup_row_list() on 2 indexed
mean25.668
σ0.003
min25.666
max25.674
mean4157.625
σ1906.379
min1556.000
max7323.000
mean6.045
σ0.084
min5.913
max6.128
op=vertical_lookup_row_list() on 3 (1 unindexed)
mean25.970
σ0.002
min25.968
max25.974
mean4157.625
σ1906.379
min1556.000
max7323.000
mean5.847
σ0.084
min5.713
max5.993

CSV - loading a lazy table

Factorallocated MiBpeak allocated MiBtime (ms)
op=load_product(), no indexes
mean2524.606
σ0.000
min2524.606
max2524.606
mean7323.000
σ0.000
min7323.000
max7323.000
mean1049.725
σ10.660
min1036.114
max1070.103
op=load_product(), with indexes
mean8744.721
σ0.469
min8744.553
max8745.882
mean3580.000
σ1803.660
min1044.000
max5819.000
mean4728.413
σ1561.377
min3524.247
max7087.058

CSV - unindexed operations

Factorallocated MiBpeak allocated MiBtime (ms)
op=column_set() on unindexed, dense
mean62.078
σ0.002
min62.076
max62.081
mean4157.625
σ1906.379
min1556.000
max7323.000
mean79.406
σ9.036
min69.706
max93.521
op=vertical_lookup_list() on unindexed missing Int
mean40.945
σ0.001
min40.945
max40.946
mean7323.000
σ0.000
min7323.000
max7323.000
mean104.557
σ6.960
min90.628
max112.575
op=vertical_lookup_row_list() on unindexed small unique Int
mean66.686
σ0.000
min66.686
max66.687
mean7323.000
σ0.000
min7323.000
max7323.000
mean161.798
σ9.378
min140.275
max168.443

CSV - warmup

Factorallocated MiBpeak allocated MiBtime (ms)
op=table_records()
mean11656.901
σ4.304
min11655.306
max11667.552
mean4157.625
σ1906.379
min1556.000
max7323.000
mean6280.822
σ1034.593
min4921.505
max7985.012
op=vertical_lookup_list() on indexed
mean11560.066
σ0.001
min11560.065
max11560.067
mean7323.000
σ0.000
min7323.000
max7323.000
mean5716.575
σ1845.258
min4332.851
max8843.386

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
mean386.289
σ12.928
min355.505
max393.945
op=pointedIndexFromKvs
rows=400000
mean357.322
σ0.001
min357.321
max357.325
mean560.000
σ0.000
min560.000
max560.000
mean752.665
σ61.276
min641.277
max812.845

Marine Hull: transactPolicy

Factorallocated MiBpeak allocated MiBtime
datapoints=1
iterations=20
mean1024.328
σ0.758
min1023.853
max1027.465
mean1055.300
σ320.272
min576.000
max1532.000
mean1.567
σ0.090
min1.399
max1.766

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.306
σ0.305
min0.143
max0.847
name=error_case.art
mean2.339
σ0.012
min2.333
max2.361
mean402.000
σ0.000
min402.000
max402.000
mean0.476
σ0.322
min0.319
max1.052
name=heavy_item.art
mean1.522
σ0.002
min1.521
max1.525
mean402.000
σ0.000
min402.000
max402.000
mean0.227
σ0.025
min0.205
max0.269
name=nested_use.art
mean2.357
σ0.002
min2.356
max2.360
mean402.000
σ0.000
min402.000
max402.000
mean0.344
σ0.019
min0.328
max0.376

Parser: Real World

Factorallocated MiBpeak allocated MiBtime (sec)
name=aon_gpf25_7k_loc.art
mean964.840
σ0.011
min964.835
max964.859
mean431.800
σ1.789
min431.000
max435.000
mean0.488
σ0.043
min0.428
max0.542
name=cdr_enhanced_4k_loc.art
mean885.820
σ0.002
min885.819
max885.823
mean442.000
σ0.000
min442.000
max442.000
mean0.436
σ0.038
min0.389
max0.495

Parser: Record Parsing

Factorallocated MiBpeak allocated MiBtime (ms)
name=record_render_large_success.art
mean7.709
σ0.002
min7.708
max7.712
mean442.000
σ0.000
min442.000
max442.000
mean2.640
σ0.106
min2.461
max2.898
name=record_render_large_syntax_err.art
mean7.657
σ0.002
min7.656
max7.660
mean442.000
σ0.000
min442.000
max442.000
mean2.576
σ0.098
min2.412
max3.016
name=record_render_success.art
mean2.289
σ0.002
min2.289
max2.293
mean442.000
σ0.000
min442.000
max442.000
mean0.311
σ0.010
min0.291
max0.361
name=record_render_syntax_err.art
mean2.165
σ0.002
min2.164
max2.168
mean442.000
σ0.000
min442.000
max442.000
mean0.295
σ0.038
min0.279
max0.658

SoV import

Factorallocated MiBpeak allocated MiBtime_s
iters=10
rows=1000
mean298.813
σ1.035
min298.377
max301.751
mean446.900
σ18.466
min418.000
max472.000
mean0.606
σ0.018
min0.570
max0.620

Timed compile per phase

Factorallocated MiBpeak allocated MiBtime (ms)
phase=buildDeclTree
mean239.532
σ0.000
min239.532
max239.532
mean1748.000
σ0.000
min1748.000
max1748.000
mean217.485
σ1.648
min215.632
max220.195
phase=macro expansion
mean6.130
σ0.000
min6.130
max6.130
mean1748.000
σ0.000
min1748.000
max1748.000
mean11.908
σ1.366
min9.554
max13.076
phase=parser
mean1042.362
σ0.000
min1042.361
max1042.362
mean1748.000
σ0.000
min1748.000
max1748.000
mean676.964
σ95.845
min561.788
max827.066
phase=processProdDef
mean6169.660
σ0.001
min6169.660
max6169.661
mean1748.000
σ0.000
min1748.000
max1748.000
mean5337.267
σ1696.287
min3676.409
max7898.141
phase=renaming
mean21.675
σ0.000
min21.675
max21.675
mean1748.000
σ0.000
min1748.000
max1748.000
mean53.660
σ26.877
min34.815
max118.289
phase=type checker
mean990.442
σ0.066
min990.344
max990.532
mean1748.000
σ0.000
min1748.000
max1748.000
mean833.859
σ55.813
min751.190
max922.268

Workflow: transactPolicy

Factorallocated MiBpeak allocated MiBtime
iters=5
new-facts=1
prior-facts=1
mean293.926
σ0.046
min293.861
max293.971
mean445.000
σ0.000
min445.000
max445.000
mean0.402
σ0.005
min0.399
max0.410
iters=5
new-facts=1
prior-facts=6402
mean1320.239
σ0.064
min1320.183
max1320.314
mean1068.600
σ168.841
min842.000
max1277.000
mean2.066
σ0.267
min1.870
max2.486
iters=5
new-facts=6402
prior-facts=1
mean1559.746
σ4.057
min1557.747
max1566.997
mean619.000
σ82.553
min494.000
max716.000
mean2.278
σ0.108
min2.172
max2.447
iters=5
new-facts=6402
prior-facts=6402
mean1882.276
σ0.062
min1882.196
max1882.345
mean1701.400
σ247.427
min1407.000
max2035.000
mean2.958
σ0.054
min2.911
max3.052

newProductH/cdr_auton/broker

Factortime_s
iterations=5
mean1.768
σ0.152
min1.569
max1.919

policy addition benchmark

Factorallocated MiBdb queriespeak allocated MiBtime
policies=2
mean453.537
σ585.528
min160.771
max1331.829
mean102.250
σ8.500
min98.000
max115.000
mean443.000
σ0.000
min443.000
max443.000
mean0.563
σ0.579
min0.272
max1.432
policies=20
mean1608.044
σ0.420
min1607.757
max1608.667
mean980.000
σ0.000
min980.000
max980.000
mean451.000
σ10.832
min443.000
max467.000
mean2.715
σ0.007
min2.706
max2.720
policies=200
mean16088.504
σ0.158
min16088.281
max16088.637
mean9800.000
σ0.000
min9800.000
max9800.000
mean500.000
σ6.055
min494.000
max507.000
mean27.379
σ0.121
min27.213
max27.500