bc2e9b3fd89167c2cd85993c4b56a86642d07b0c

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

Aggregation: measureAggregations

Factorallocated MiBpeak allocated MiBtime_s
cache=n
dps=1
iters=10
policies=100
mean54.581
σ0.342
min54.449
max55.554
mean418.000
σ0.000
min418.000
max418.000
mean0.140
σ0.005
min0.132
max0.150
cache=y
dps=1
iters=10
policies=100
mean43.704
σ0.007
min43.695
max43.715
mean418.000
σ0.000
min418.000
max418.000
mean0.121
σ0.005
min0.116
max0.130

CSV - indexed operations

Factorallocated MiBpeak allocated MiBtime (ms)
op=column_set() on indexed
mean36.618
σ0.002
min36.615
max36.620
mean4156.750
σ1906.689
min1557.000
max7326.000
mean13.090
σ0.234
min12.596
max13.338
op=column_set() on indexed, repeat
mean36.617
σ0.002
min36.616
max36.619
mean4156.750
σ1906.689
min1557.000
max7326.000
mean12.927
σ0.739
min12.176
max13.938
op=table_records(), no indexes
mean41.932
σ0.001
min41.929
max41.933
mean7326.000
σ0.000
min7326.000
max7326.000
mean15.409
σ0.767
min13.715
max15.955
op=table_records(), repeat
mean41.928
σ0.002
min41.927
max41.932
mean4156.750
σ1906.689
min1557.000
max7326.000
mean13.485
σ1.975
min11.169
max16.012
op=vertical_lookup_list() on indexed, after table_records()
mean27.653
σ0.136
min27.603
max27.990
mean4156.750
σ1906.689
min1557.000
max7326.000
mean9.004
σ0.268
min8.639
max9.377
op=vertical_lookup_list() on indexed, after table_records(), repeat
mean26.400
σ0.002
min26.399
max26.403
mean4156.750
σ1906.689
min1557.000
max7326.000
mean6.742
σ0.237
min6.423
max7.146
op=vertical_lookup_row_list() on 2 indexed
mean25.666
σ0.002
min25.665
max25.668
mean4156.750
σ1906.689
min1557.000
max7326.000
mean6.013
σ0.126
min5.845
max6.249
op=vertical_lookup_row_list() on 3 (1 unindexed)
mean25.968
σ0.002
min25.967
max25.972
mean4156.750
σ1906.689
min1557.000
max7326.000
mean5.874
σ0.117
min5.740
max6.101

CSV - loading a lazy table

Factorallocated MiBpeak allocated MiBtime (ms)
op=load_product(), no indexes
mean2524.606
σ0.000
min2524.606
max2524.606
mean7326.000
σ0.000
min7326.000
max7326.000
mean1053.344
σ4.867
min1047.689
max1061.347
op=load_product(), with indexes
mean8744.722
σ0.469
min8744.553
max8745.883
mean3577.750
σ1802.684
min1044.000
max5815.000
mean4929.427
σ1644.339
min3543.996
max7608.725

CSV - unindexed operations

Factorallocated MiBpeak allocated MiBtime (ms)
op=column_set() on unindexed, dense
mean62.078
σ0.002
min62.076
max62.081
mean4156.750
σ1906.689
min1557.000
max7326.000
mean83.600
σ12.096
min71.329
max103.779
op=vertical_lookup_list() on unindexed missing Int
mean40.944
σ0.001
min40.944
max40.945
mean7326.000
σ0.000
min7326.000
max7326.000
mean106.250
σ5.795
min95.309
max112.801
op=vertical_lookup_row_list() on unindexed small unique Int
mean66.686
σ0.000
min66.685
max66.687
mean7326.000
σ0.000
min7326.000
max7326.000
mean162.405
σ9.115
min141.307
max167.989

CSV - warmup

Factorallocated MiBpeak allocated MiBtime (ms)
op=table_records()
mean11656.836
σ4.324
min11655.305
max11667.538
mean4156.750
σ1906.689
min1557.000
max7326.000
mean6704.001
σ1272.507
min4938.628
max8000.360
op=vertical_lookup_list() on indexed
mean11560.065
σ0.001
min11560.064
max11560.066
mean7326.000
σ0.000
min7326.000
max7326.000
mean5848.682
σ1951.791
min4345.659
max9151.155

CSV internal benchmark: pointedIndexFromKvs

Factorallocated MiBpeak allocated MiBtime (ms)
op=pointedIndexFromKvs
rows=200000
mean172.559
σ0.001
min172.558
max172.562
mean476.000
σ0.000
min476.000
max476.000
mean382.823
σ18.833
min352.567
max397.782
op=pointedIndexFromKvs
rows=400000
mean357.322
σ0.001
min357.321
max357.325
mean562.000
σ0.000
min562.000
max562.000
mean697.869
σ69.430
min638.847
max790.620

Marine Hull: transactPolicy

Factorallocated MiBpeak allocated MiBtime
datapoints=1
iterations=20
mean1008.500
σ0.759
min1008.028
max1011.638
mean1044.800
σ308.959
min595.000
max1501.000
mean1.545
σ0.072
min1.471
max1.763

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.387
σ0.487
min0.141
max1.255
name=error_case.art
mean2.339
σ0.012
min2.333
max2.361
mean402.000
σ0.000
min402.000
max402.000
mean0.478
σ0.328
min0.320
max1.065
name=heavy_item.art
mean1.522
σ0.002
min1.521
max1.525
mean402.000
σ0.000
min402.000
max402.000
mean0.222
σ0.020
min0.204
max0.257
name=nested_use.art
mean2.357
σ0.002
min2.356
max2.360
mean402.000
σ0.000
min402.000
max402.000
mean0.334
σ0.017
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.000
σ2.236
min432.000
max437.000
mean0.548
σ0.056
min0.485
max0.615
name=cdr_enhanced_4k_loc.art
mean885.814
σ0.002
min885.812
max885.816
mean443.000
σ0.000
min443.000
max443.000
mean0.464
σ0.047
min0.383
max0.496

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.335
σ0.331
min1.829
max2.896
name=record_render_large_syntax_err.art
mean7.656
σ0.002
min7.655
max7.659
mean443.000
σ0.000
min443.000
max443.000
mean2.625
σ0.095
min2.446
max2.933
name=record_render_success.art
mean2.289
σ0.002
min2.288
max2.292
mean443.000
σ0.000
min443.000
max443.000
mean0.303
σ0.010
min0.285
max0.367
name=record_render_syntax_err.art
mean2.165
σ0.002
min2.164
max2.168
mean443.000
σ0.000
min443.000
max443.000
mean0.287
σ0.013
min0.273
max0.374

SoV import

Factorallocated MiBpeak allocated MiBtime_s
iters=10
rows=1000
mean298.248
σ0.992
min297.804
max301.054
mean444.000
σ14.757
min422.000
max465.000
mean0.609
σ0.018
min0.583
max0.636

Timed compile per phase

Factorallocated MiBpeak allocated MiBtime (ms)
phase=buildDeclTree
mean222.008
σ0.000
min222.008
max222.008
mean1680.000
σ0.000
min1680.000
max1680.000
mean209.545
σ2.580
min204.835
max212.779
phase=macro expansion
mean6.130
σ0.000
min6.130
max6.130
mean1680.000
σ0.000
min1680.000
max1680.000
mean8.968
σ1.987
min6.227
max12.594
phase=parser
mean1042.098
σ0.000
min1042.097
max1042.098
mean1680.000
σ0.000
min1680.000
max1680.000
mean621.146
σ86.785
min483.874
max721.758
phase=processProdDef
mean6169.660
σ0.000
min6169.660
max6169.660
mean1680.000
σ0.000
min1680.000
max1680.000
mean6742.690
σ790.416
min5482.716
max7411.009
phase=renaming
mean21.671
σ0.000
min21.671
max21.671
mean1680.000
σ0.000
min1680.000
max1680.000
mean44.542
σ6.078
min33.917
max50.886
phase=type checker
mean958.457
σ0.066
min958.360
max958.547
mean1680.000
σ0.000
min1680.000
max1680.000
mean751.231
σ49.930
min657.976
max796.252

Workflow: transactPolicy

Factorallocated MiBpeak allocated MiBtime
iters=5
new-facts=1
prior-facts=1
mean293.686
σ0.039
min293.632
max293.727
mean445.000
σ0.000
min445.000
max445.000
mean0.401
σ0.011
min0.396
max0.421
iters=5
new-facts=1
prior-facts=6402
mean1303.726
σ0.067
min1303.642
max1303.789
mean1062.600
σ168.589
min840.000
max1273.000
mean1.889
σ0.095
min1.814
max2.038
iters=5
new-facts=6402
prior-facts=1
mean1546.817
σ4.016
min1544.813
max1553.995
mean611.800
σ73.152
min497.000
max690.000
mean2.238
σ0.122
min2.134
max2.442
iters=5
new-facts=6402
prior-facts=6402
mean1865.806
σ0.060
min1865.749
max1865.896
mean1710.000
σ249.716
min1418.000
max2064.000
mean2.957
σ0.104
min2.884
max3.121

newProductH/cdr_auton/broker

Factortime_s
iterations=5
mean1.742
σ0.167
min1.511
max1.918

policy addition benchmark

Factorallocated MiBdb queriespeak allocated MiBtime
policies=2
mean450.089
σ579.265
min160.453
max1318.986
mean102.250
σ8.500
min98.000
max115.000
mean443.000
σ0.000
min443.000
max443.000
mean0.540
σ0.540
min0.269
max1.350
policies=20
mean1604.906
σ0.404
min1604.626
max1605.504
mean980.000
σ0.000
min980.000
max980.000
mean446.000
σ2.000
min443.000
max447.000
mean2.680
σ0.010
min2.667
max2.690
policies=200
mean16057.228
σ0.085
min16057.124
max16057.320
mean9800.000
σ0.000
min9800.000
max9800.000
mean493.500
σ3.697
min489.000
max497.000
mean27.114
σ0.135
min26.979
max27.262