784bd0af4a7b192a1d9fa20ee7c74a5cb13b4d91

Home / Branches / marcelkalveram/exp-1635-add-support-for-node-types-of-select / 784bd0af4a7b192a1d9fa20ee7c74a5cb13b4d91

Aggregation: measureAggregations

Factorallocated MiBpeak allocated MiBtime_s
cache=n
dps=1
iters=10
policies=100
mean54.577
σ0.349
min54.438
max55.569
mean418.000
σ0.000
min418.000
max418.000
mean0.138
σ0.006
min0.130
max0.150
cache=y
dps=1
iters=10
policies=100
mean43.706
σ0.007
min43.693
max43.716
mean418.000
σ0.000
min418.000
max418.000
mean0.123
σ0.004
min0.118
max0.130

CSV - indexed operations

Factorallocated MiBpeak allocated MiBtime (ms)
op=column_set() on indexed
mean36.618
σ0.002
min36.616
max36.620
mean4154.750
σ1901.993
min1552.000
max7311.000
mean12.762
σ0.259
min12.243
max13.077
op=column_set() on indexed, repeat
mean36.617
σ0.002
min36.615
max36.620
mean4154.750
σ1901.993
min1552.000
max7311.000
mean12.480
σ0.688
min11.595
max13.269
op=table_records(), no indexes
mean41.932
σ0.001
min41.929
max41.933
mean7311.000
σ0.000
min7311.000
max7311.000
mean15.059
σ0.840
min13.122
max15.755
op=table_records(), repeat
mean41.928
σ0.002
min41.927
max41.931
mean4154.750
σ1901.993
min1552.000
max7311.000
mean12.903
σ1.727
min11.087
max15.608
op=vertical_lookup_list() on indexed, after table_records()
mean27.653
σ0.136
min27.603
max27.990
mean4154.750
σ1901.993
min1552.000
max7311.000
mean8.861
σ0.318
min8.389
max9.332
op=vertical_lookup_list() on indexed, after table_records(), repeat
mean26.400
σ0.002
min26.399
max26.403
mean4154.750
σ1901.993
min1552.000
max7311.000
mean6.830
σ0.419
min6.045
max7.251
op=vertical_lookup_row_list() on 2 indexed
mean25.666
σ0.002
min25.665
max25.668
mean4154.750
σ1901.993
min1552.000
max7311.000
mean5.965
σ0.090
min5.792
max6.078
op=vertical_lookup_row_list() on 3 (1 unindexed)
mean25.968
σ0.002
min25.967
max25.972
mean4154.750
σ1901.993
min1552.000
max7311.000
mean5.817
σ0.116
min5.599
max5.949

CSV - loading a lazy table

Factorallocated MiBpeak allocated MiBtime (ms)
op=load_product(), no indexes
mean2524.606
σ0.000
min2524.606
max2524.607
mean7311.000
σ0.000
min7311.000
max7311.000
mean1053.417
σ5.449
min1046.931
max1060.489
op=load_product(), with indexes
mean8744.721
σ0.469
min8744.554
max8745.881
mean3576.500
σ1797.482
min1051.000
max5802.000
mean4808.499
σ1656.283
min3539.972
max7249.636

CSV - unindexed operations

Factorallocated MiBpeak allocated MiBtime (ms)
op=column_set() on unindexed, dense
mean62.078
σ0.002
min62.076
max62.080
mean4154.750
σ1901.993
min1552.000
max7311.000
mean84.169
σ11.798
min71.600
max100.495
op=vertical_lookup_list() on unindexed missing Int
mean40.944
σ0.001
min40.944
max40.945
mean7311.000
σ0.000
min7311.000
max7311.000
mean106.828
σ8.004
min89.486
max113.511
op=vertical_lookup_row_list() on unindexed small unique Int
mean66.686
σ0.000
min66.685
max66.687
mean7311.000
σ0.000
min7311.000
max7311.000
mean160.030
σ11.583
min132.967
max168.377

CSV - warmup

Factorallocated MiBpeak allocated MiBtime (ms)
op=table_records()
mean11656.836
σ4.324
min11655.305
max11667.538
mean4154.750
σ1901.993
min1552.000
max7311.000
mean6139.089
σ1101.668
min4982.496
max8161.534
op=vertical_lookup_list() on indexed
mean11560.065
σ0.001
min11560.064
max11560.066
mean7311.000
σ0.000
min7311.000
max7311.000
mean6079.750
σ1778.018
min4403.057
max9049.522

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
mean380.183
σ19.598
min352.297
max398.198
op=pointedIndexFromKvs
rows=400000
mean357.322
σ0.001
min357.321
max357.325
mean561.000
σ0.000
min561.000
max561.000
mean745.764
σ51.178
min633.918
max796.563

Marine Hull: transactPolicy

Factorallocated MiBpeak allocated MiBtime
datapoints=1
iterations=20
mean1008.500
σ0.759
min1008.024
max1011.640
mean1043.850
σ310.928
min572.000
max1502.000
mean1.534
σ0.061
min1.456
max1.703

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.407
σ0.505
min0.150
max1.308
name=error_case.art
mean2.339
σ0.012
min2.333
max2.361
mean402.000
σ0.000
min402.000
max402.000
mean0.482
σ0.313
min0.335
max1.041
name=heavy_item.art
mean1.522
σ0.002
min1.521
max1.525
mean402.000
σ0.000
min402.000
max402.000
mean0.227
σ0.024
min0.204
max0.261
name=nested_use.art
mean2.357
σ0.002
min2.356
max2.360
mean402.000
σ0.000
min402.000
max402.000
mean0.331
σ0.018
min0.320
max0.363

Parser: Real World

Factorallocated MiBpeak allocated MiBtime (sec)
name=aon_gpf25_7k_loc.art
mean964.741
σ0.011
min964.736
max964.760
mean436.600
σ6.066
min431.000
max443.000
mean0.565
σ0.034
min0.517
max0.609
name=cdr_enhanced_4k_loc.art
mean885.814
σ0.002
min885.812
max885.816
mean443.000
σ0.000
min443.000
max443.000
mean0.519
σ0.027
min0.471
max0.535

Parser: Record Parsing

Factorallocated MiBpeak allocated MiBtime (ms)
name=record_render_large_success.art
mean7.708
σ0.002
min7.707
max7.711
mean443.000
σ0.000
min443.000
max443.000
mean2.661
σ0.099
min2.465
max2.998
name=record_render_large_syntax_err.art
mean7.656
σ0.002
min7.655
max7.659
mean443.000
σ0.000
min443.000
max443.000
mean2.635
σ0.098
min2.459
max2.958
name=record_render_success.art
mean2.289
σ0.002
min2.288
max2.292
mean443.000
σ0.000
min443.000
max443.000
mean0.307
σ0.009
min0.292
max0.364
name=record_render_syntax_err.art
mean2.165
σ0.002
min2.164
max2.168
mean443.000
σ0.000
min443.000
max443.000
mean0.290
σ0.007
min0.278
max0.333

SoV import

Factorallocated MiBpeak allocated MiBtime_s
iters=10
rows=1000
mean298.083
σ1.046
min297.685
max301.055
mean442.600
σ16.126
min418.000
max466.000
mean0.603
σ0.022
min0.547
max0.633

Timed compile per phase

Factorallocated MiBpeak allocated MiBtime (ms)
phase=buildDeclTree
mean222.008
σ0.000
min222.008
max222.008
mean1737.500
σ10.351
min1725.000
max1745.000
mean203.806
σ2.386
min200.355
max207.205
phase=macro expansion
mean6.130
σ0.000
min6.130
max6.130
mean1737.500
σ10.351
min1725.000
max1745.000
mean10.744
σ2.295
min6.175
max12.780
phase=parser
mean1042.103
σ0.001
min1042.102
max1042.103
mean1737.500
σ10.351
min1725.000
max1745.000
mean662.829
σ138.549
min386.716
max827.487
phase=processProdDef
mean6169.657
σ0.000
min6169.656
max6169.658
mean1740.000
σ9.258
min1725.000
max1745.000
mean5671.592
σ1468.496
min3667.415
max7631.096
phase=renaming
mean21.667
σ0.000
min21.667
max21.667
mean1737.500
σ10.351
min1725.000
max1745.000
mean42.233
σ7.222
min30.362
max51.512
phase=type checker
mean958.461
σ0.066
min958.363
max958.551
mean1737.500
σ10.351
min1725.000
max1745.000
mean803.369
σ96.761
min668.371
max914.934

Workflow: transactPolicy

Factorallocated MiBpeak allocated MiBtime
iters=5
new-facts=1
prior-facts=1
mean293.688
σ0.038
min293.633
max293.724
mean444.000
σ0.000
min444.000
max444.000
mean0.408
σ0.008
min0.401
max0.418
iters=5
new-facts=1
prior-facts=6402
mean1303.782
σ0.088
min1303.645
max1303.871
mean1095.800
σ188.524
min836.000
max1322.000
mean2.104
σ0.274
min1.819
max2.448
iters=5
new-facts=6402
prior-facts=1
mean1546.810
σ4.027
min1544.818
max1554.008
mean618.200
σ80.160
min497.000
max712.000
mean2.246
σ0.116
min2.125
max2.422
iters=5
new-facts=6402
prior-facts=6402
mean1865.784
σ0.073
min1865.710
max1865.894
mean1731.000
σ184.141
min1466.000
max1896.000
mean3.131
σ0.377
min2.866
max3.797

newProductH/cdr_auton/broker

Factortime_s
iterations=5
mean1.630
σ0.062
min1.565
max1.726

policy addition benchmark

Factorallocated MiBdb queriespeak allocated MiBtime
policies=2
mean447.981
σ579.239
min158.361
max1316.839
mean96.250
σ8.500
min92.000
max109.000
mean444.000
σ0.000
min444.000
max444.000
mean0.532
σ0.533
min0.263
max1.331
policies=20
mean1583.916
σ0.365
min1583.662
max1584.456
mean920.000
σ0.000
min920.000
max920.000
mean446.250
σ1.500
min444.000
max447.000
mean2.657
σ0.060
min2.618
max2.747
policies=200
mean15847.064
σ0.120
min15846.896
max15847.171
mean9200.000
σ0.000
min9200.000
max9200.000
mean495.000
σ3.651
min491.000
max499.000
mean26.755
σ0.186
min26.603
max26.985