b04e40c998a566816bfae1ec2ac2f9486580c0a1

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

Aggregation: measureAggregations

Factorallocated MiBpeak allocated MiBtime_s
cache=n
dps=1
iters=10
policies=100
mean54.679
σ0.358
min54.537
max55.697
mean418.000
σ0.000
min418.000
max418.000
mean0.148
σ0.014
min0.124
max0.170
cache=y
dps=1
iters=10
policies=100
mean43.704
σ0.005
min43.697
max43.710
mean418.000
σ0.000
min418.000
max418.000
mean0.121
σ0.005
min0.116
max0.129

CSV - indexed operations

Factorallocated MiBpeak allocated MiBtime (ms)
op=column_set() on indexed
mean36.618
σ0.002
min36.616
max36.620
mean4154.500
σ1901.774
min1557.000
max7309.000
mean12.240
σ0.266
min11.885
max12.736
op=column_set() on indexed, repeat
mean36.617
σ0.002
min36.616
max36.620
mean4154.500
σ1901.774
min1557.000
max7309.000
mean11.785
σ0.539
min11.319
max12.578
op=table_records(), no indexes
mean41.932
σ0.001
min41.929
max41.933
mean7309.000
σ0.000
min7309.000
max7309.000
mean14.498
σ0.676
min12.994
max15.022
op=table_records(), repeat
mean41.929
σ0.002
min41.928
max41.932
mean4154.500
σ1901.774
min1557.000
max7309.000
mean12.648
σ1.843
min10.319
max14.702
op=vertical_lookup_list() on indexed, after table_records()
mean27.654
σ0.136
min27.604
max27.991
mean4154.500
σ1901.774
min1557.000
max7309.000
mean8.307
σ0.308
min7.825
max8.792
op=vertical_lookup_list() on indexed, after table_records(), repeat
mean26.401
σ0.002
min26.400
max26.404
mean4154.500
σ1901.774
min1557.000
max7309.000
mean6.401
σ0.145
min6.107
max6.575
op=vertical_lookup_row_list() on 2 indexed
mean25.668
σ0.003
min25.665
max25.674
mean4154.500
σ1901.774
min1557.000
max7309.000
mean5.478
σ0.120
min5.334
max5.692
op=vertical_lookup_row_list() on 3 (1 unindexed)
mean25.970
σ0.002
min25.968
max25.974
mean4154.500
σ1901.774
min1557.000
max7309.000
mean5.322
σ0.183
min4.989
max5.583

CSV - loading a lazy table

Factorallocated MiBpeak allocated MiBtime (ms)
op=load_product(), no indexes
mean2524.606
σ0.000
min2524.606
max2524.607
mean7309.000
σ0.000
min7309.000
max7309.000
mean1265.483
σ553.369
min1030.501
max2621.747
op=load_product(), with indexes
mean8744.722
σ0.469
min8744.553
max8745.883
mean3573.375
σ1796.727
min1045.000
max5794.000
mean5041.324
σ1673.589
min3515.720
max7373.739

CSV - unindexed operations

Factorallocated MiBpeak allocated MiBtime (ms)
op=column_set() on unindexed, dense
mean62.078
σ0.002
min62.076
max62.080
mean4154.500
σ1901.774
min1557.000
max7309.000
mean82.496
σ12.777
min69.522
max99.788
op=vertical_lookup_list() on unindexed missing Int
mean40.945
σ0.001
min40.945
max40.946
mean7309.000
σ0.000
min7309.000
max7309.000
mean105.665
σ4.598
min95.917
max109.939
op=vertical_lookup_row_list() on unindexed small unique Int
mean66.686
σ0.000
min66.686
max66.687
mean7309.000
σ0.000
min7309.000
max7309.000
mean162.835
σ6.901
min147.087
max167.973

CSV - warmup

Factorallocated MiBpeak allocated MiBtime (ms)
op=table_records()
mean11656.900
σ4.304
min11655.306
max11667.552
mean4154.500
σ1901.774
min1557.000
max7309.000
mean6589.199
σ1278.497
min4934.753
max8224.903
op=vertical_lookup_list() on indexed
mean11560.066
σ0.001
min11560.065
max11560.067
mean7309.000
σ0.000
min7309.000
max7309.000
mean5324.942
σ1293.766
min4338.970
max7707.814

CSV internal benchmark: pointedIndexFromKvs

Factorallocated MiBpeak allocated MiBtime (ms)
op=pointedIndexFromKvs
rows=200000
mean172.559
σ0.001
min172.558
max172.562
mean477.000
σ0.000
min477.000
max477.000
mean387.340
σ15.745
min348.645
max396.101
op=pointedIndexFromKvs
rows=400000
mean357.322
σ0.001
min357.321
max357.325
mean562.000
σ0.000
min562.000
max562.000
mean760.641
σ52.971
min672.628
max801.781

Marine Hull: transactPolicy

Factorallocated MiBpeak allocated MiBtime
datapoints=1
iterations=20
mean1024.329
σ0.759
min1023.855
max1027.465
mean1046.150
σ295.980
min563.000
max1438.000
mean1.558
σ0.051
min1.495
max1.649

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.393
σ0.507
min0.140
max1.298
name=error_case.art
mean2.339
σ0.012
min2.333
max2.361
mean402.000
σ0.000
min402.000
max402.000
mean0.530
σ0.309
min0.318
max1.044
name=heavy_item.art
mean1.522
σ0.002
min1.521
max1.525
mean402.000
σ0.000
min402.000
max402.000
mean0.224
σ0.026
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.335
σ0.019
min0.318
max0.367

Parser: Real World

Factorallocated MiBpeak allocated MiBtime (sec)
name=aon_gpf25_7k_loc.art
mean964.840
σ0.011
min964.835
max964.859
mean436.000
σ2.236
min432.000
max437.000
mean0.576
σ0.047
min0.498
max0.615
name=cdr_enhanced_4k_loc.art
mean885.820
σ0.002
min885.819
max885.823
mean442.000
σ0.000
min442.000
max442.000
mean0.490
σ0.033
min0.444
max0.519

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.570
σ0.079
min2.420
max2.841
name=record_render_large_syntax_err.art
mean7.657
σ0.002
min7.656
max7.660
mean442.000
σ0.000
min442.000
max442.000
mean2.562
σ0.088
min2.419
max2.875
name=record_render_success.art
mean2.289
σ0.002
min2.289
max2.293
mean442.000
σ0.000
min442.000
max442.000
mean0.306
σ0.011
min0.289
max0.378
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.026
min0.279
max0.540

SoV import

Factorallocated MiBpeak allocated MiBtime_s
iters=10
rows=1000
mean298.989
σ1.098
min298.498
max302.087
mean442.800
σ14.227
min427.000
max468.000
mean0.595
σ0.027
min0.528
max0.617

Timed compile per phase

Factorallocated MiBpeak allocated MiBtime (ms)
phase=buildDeclTree
mean239.532
σ0.000
min239.532
max239.532
mean1755.500
σ13.363
min1743.000
max1768.000
mean216.930
σ1.140
min215.156
max218.696
phase=macro expansion
mean6.130
σ0.000
min6.130
max6.130
mean1755.500
σ13.363
min1743.000
max1768.000
mean11.256
σ1.982
min7.482
max13.015
phase=parser
mean1042.361
σ0.000
min1042.361
max1042.362
mean1755.500
σ13.363
min1743.000
max1768.000
mean654.807
σ128.993
min415.815
max843.076
phase=processProdDef
mean6169.660
σ0.001
min6169.660
max6169.661
mean1758.625
σ12.939
min1743.000
max1768.000
mean4859.814
σ1532.536
min2960.466
max7766.196
phase=renaming
mean21.675
σ0.000
min21.675
max21.675
mean1755.500
σ13.363
min1743.000
max1768.000
mean42.010
σ8.935
min25.789
max53.911
phase=type checker
mean990.442
σ0.066
min990.344
max990.532
mean1755.500
σ13.363
min1743.000
max1768.000
mean774.407
σ90.321
min647.237
max907.979

Workflow: transactPolicy

Factorallocated MiBpeak allocated MiBtime
iters=5
new-facts=1
prior-facts=1
mean293.925
σ0.044
min293.862
max293.966
mean445.200
σ1.643
min444.000
max447.000
mean0.398
σ0.001
min0.397
max0.399
iters=5
new-facts=1
prior-facts=6402
mean1320.275
σ0.066
min1320.169
max1320.327
mean1069.400
σ168.034
min844.000
max1277.000
mean2.116
σ0.286
min1.793
max2.478
iters=5
new-facts=6402
prior-facts=1
mean1559.735
σ4.070
min1557.700
max1567.009
mean620.200
σ82.363
min496.000
max717.000
mean2.280
σ0.181
min2.168
max2.599
iters=5
new-facts=6402
prior-facts=6402
mean1882.267
σ0.057
min1882.198
max1882.355
mean1701.600
σ245.957
min1408.000
max2032.000
mean2.878
σ0.133
min2.713
max3.012

newProductH/cdr_auton/broker

Factortime_s
iterations=5
mean1.765
σ0.108
min1.621
max1.878

policy addition benchmark

Factorallocated MiBdb queriespeak allocated MiBtime
policies=2
mean453.536
σ585.529
min160.767
max1331.829
mean102.250
σ8.500
min98.000
max115.000
mean443.000
σ0.000
min443.000
max443.000
mean0.529
σ0.518
min0.267
max1.306
policies=20
mean1608.040
σ0.414
min1607.755
max1608.652
mean980.000
σ0.000
min980.000
max980.000
mean449.250
σ9.878
min443.000
max464.000
mean2.697
σ0.022
min2.669
max2.721
policies=200
mean16088.609
σ0.109
min16088.517
max16088.757
mean9800.000
σ0.000
min9800.000
max9800.000
mean496.000
σ4.163
min491.000
max501.000
mean27.342
σ0.125
min27.157
max27.423