7f06ffcb88cfd3082efd7ceeca50a94b89e30651

Home / Branches / marcelkalveram/exp-1635-add-support-for-node-types-of-select-all / 7f06ffcb88cfd3082efd7ceeca50a94b89e30651

Aggregation: measureAggregations

Factorallocated MiBpeak allocated MiBtime_s
cache=n
dps=1
iters=10
policies=100
mean54.677
σ0.358
min54.546
max55.695
mean417.000
σ0.000
min417.000
max417.000
mean0.139
σ0.006
min0.131
max0.149
cache=y
dps=1
iters=10
policies=100
mean43.704
σ0.006
min43.694
max43.713
mean417.000
σ0.000
min417.000
max417.000
mean0.124
σ0.005
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
mean3874.625
σ1847.483
min1280.000
max6161.000
mean12.557
σ0.289
min12.251
max13.167
op=column_set() on indexed, repeat
mean36.618
σ0.002
min36.616
max36.620
mean3874.625
σ1847.483
min1280.000
max6161.000
mean12.374
σ0.764
min11.519
max13.403
op=table_records(), no indexes
mean41.930
σ0.002
min41.928
max41.932
mean6161.000
σ0.000
min6161.000
max6161.000
mean14.700
σ0.191
min14.282
max14.904
op=table_records(), repeat
mean41.928
σ0.000
min41.928
max41.929
mean3874.625
σ1847.483
min1280.000
max6161.000
mean12.271
σ1.914
min10.370
max14.834
op=vertical_lookup_list() on indexed, after table_records()
mean27.654
σ0.136
min27.604
max27.991
mean3874.625
σ1847.483
min1280.000
max6161.000
mean8.429
σ0.252
min8.065
max8.741
op=vertical_lookup_list() on indexed, after table_records(), repeat
mean26.401
σ0.002
min26.400
max26.404
mean3874.625
σ1847.483
min1280.000
max6161.000
mean6.541
σ0.269
min6.048
max6.955
op=vertical_lookup_row_list() on 2 indexed
mean25.669
σ0.003
min25.665
max25.674
mean3874.625
σ1847.483
min1280.000
max6161.000
mean5.435
σ0.168
min5.234
max5.697
op=vertical_lookup_row_list() on 3 (1 unindexed)
mean25.970
σ0.002
min25.968
max25.974
mean3874.625
σ1847.483
min1280.000
max6161.000
mean5.325
σ0.061
min5.257
max5.409

CSV - loading a lazy table

Factorallocated MiBpeak allocated MiBtime (ms)
op=load_product(), no indexes
mean2524.604
σ0.002
min2524.602
max2524.606
mean6161.000
σ0.000
min6161.000
max6161.000
mean1469.522
σ810.479
min1034.449
max3138.753
op=load_product(), with indexes
mean7878.102
σ0.469
min7877.935
max7879.264
mean3233.500
σ1838.753
min809.000
max6161.000
mean3738.673
σ1199.744
min3108.262
max6261.993

CSV - unindexed operations

Factorallocated MiBpeak allocated MiBtime (ms)
op=column_set() on unindexed, dense
mean62.078
σ0.002
min62.076
max62.081
mean3874.625
σ1847.483
min1280.000
max6161.000
mean84.142
σ11.619
min71.340
max96.822
op=vertical_lookup_list() on unindexed missing Int
mean40.946
σ0.002
min40.945
max40.949
mean6161.000
σ0.000
min6161.000
max6161.000
mean64.093
σ4.045
min60.277
max69.246
op=vertical_lookup_row_list() on unindexed small unique Int
mean66.687
σ0.002
min66.686
max66.690
mean6161.000
σ0.000
min6161.000
max6161.000
mean99.877
σ1.104
min98.395
max102.088

CSV - warmup

Factorallocated MiBpeak allocated MiBtime (ms)
op=table_records()
mean11849.156
σ4.304
min11847.561
max11859.806
mean3874.625
σ1847.483
min1280.000
max6161.000
mean6086.596
σ1324.313
min5057.951
max8314.837
op=vertical_lookup_list() on indexed
mean10791.093
σ0.002
min10791.092
max10791.096
mean6161.000
σ0.000
min6161.000
max6161.000
mean5222.618
σ1592.040
min4076.788
max7403.332

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.573
σ31.054
min299.363
max393.458
op=pointedIndexFromKvs
rows=400000
mean357.322
σ0.001
min357.321
max357.325
mean561.000
σ0.000
min561.000
max561.000
mean762.468
σ44.338
min657.658
max801.841

Marine Hull: transactPolicy

Factorallocated MiBpeak allocated MiBtime
datapoints=1
iterations=20
mean1024.327
σ0.758
min1023.855
max1027.465
mean1050.050
σ312.634
min592.000
max1513.000
mean1.574
σ0.087
min1.495
max1.778

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.424
σ0.552
min0.157
max1.410
name=error_case.art
mean2.339
σ0.012
min2.333
max2.361
mean402.000
σ0.000
min402.000
max402.000
mean0.480
σ0.317
min0.328
max1.045
name=heavy_item.art
mean1.522
σ0.002
min1.521
max1.525
mean402.000
σ0.000
min402.000
max402.000
mean0.227
σ0.020
min0.213
max0.261
name=nested_use.art
mean2.357
σ0.002
min2.356
max2.360
mean402.000
σ0.000
min402.000
max402.000
mean0.342
σ0.021
min0.328
max0.378

Parser: Real World

Factorallocated MiBpeak allocated MiBtime (sec)
name=aon_gpf25_7k_loc.art
mean964.840
σ0.011
min964.835
max964.859
mean431.400
σ0.894
min431.000
max433.000
mean0.535
σ0.064
min0.445
max0.597
name=cdr_enhanced_4k_loc.art
mean885.820
σ0.002
min885.819
max885.823
mean439.000
σ0.000
min439.000
max439.000
mean0.450
σ0.053
min0.385
max0.508

Parser: Record Parsing

Factorallocated MiBpeak allocated MiBtime (ms)
name=record_render_large_success.art
mean7.709
σ0.002
min7.708
max7.712
mean439.000
σ0.000
min439.000
max439.000
mean2.632
σ0.092
min2.490
max3.000
name=record_render_large_syntax_err.art
mean7.657
σ0.002
min7.656
max7.660
mean439.000
σ0.000
min439.000
max439.000
mean2.595
σ0.078
min2.471
max2.845
name=record_render_success.art
mean2.289
σ0.002
min2.289
max2.293
mean439.000
σ0.000
min439.000
max439.000
mean0.311
σ0.008
min0.296
max0.358
name=record_render_syntax_err.art
mean2.165
σ0.002
min2.164
max2.168
mean439.000
σ0.000
min439.000
max439.000
mean0.296
σ0.006
min0.286
max0.332

SoV import

Factorallocated MiBpeak allocated MiBtime_s
iters=10
rows=1000
mean298.590
σ1.005
min298.226
max301.448
mean446.600
σ17.658
min418.000
max473.000
mean0.606
σ0.013
min0.577
max0.620

Timed compile per phase

Factorallocated MiBpeak allocated MiBtime (ms)
phase=buildDeclTree
mean239.532
σ0.000
min239.532
max239.532
mean1028.000
σ0.000
min1028.000
max1028.000
mean224.748
σ4.071
min217.797
max230.988
phase=macro expansion
mean6.130
σ0.000
min6.130
max6.130
mean1028.000
σ0.000
min1028.000
max1028.000
mean11.626
σ2.020
min7.426
max12.749
phase=parser
mean1042.362
σ0.000
min1042.361
max1042.362
mean1028.000
σ0.000
min1028.000
max1028.000
mean686.573
σ107.053
min422.666
max733.555
phase=processProdDef
mean4753.371
σ0.000
min4753.370
max4753.371
mean1028.000
σ0.000
min1028.000
max1028.000
mean4462.763
σ318.669
min3936.556
max4941.444
phase=renaming
mean21.671
σ0.000
min21.671
max21.671
mean1028.000
σ0.000
min1028.000
max1028.000
mean46.232
σ3.080
min40.521
max48.598
phase=type checker
mean990.442
σ0.066
min990.344
max990.532
mean1028.000
σ0.000
min1028.000
max1028.000
mean856.809
σ72.019
min697.104
max913.381

Workflow: transactPolicy

Factorallocated MiBpeak allocated MiBtime
iters=5
new-facts=1
prior-facts=1
mean293.919
σ0.038
min293.865
max293.958
mean446.000
σ0.000
min446.000
max446.000
mean0.408
σ0.009
min0.401
max0.421
iters=5
new-facts=1
prior-facts=6402
mean1320.263
σ0.042
min1320.215
max1320.328
mean1108.200
σ170.563
min895.000
max1331.000
mean2.130
σ0.131
min1.911
max2.263
iters=5
new-facts=6402
prior-facts=1
mean1559.486
σ3.420
min1557.814
max1565.598
mean624.400
σ90.754
min509.000
max728.000
mean2.443
σ0.343
min2.127
max2.909
iters=5
new-facts=6402
prior-facts=6402
mean1882.292
σ0.081
min1882.200
max1882.389
mean1749.600
σ210.777
min1479.000
max1951.000
mean3.217
σ0.395
min2.824
max3.692

newProductH/cdr_auton/broker

Factortime_s
iterations=5
mean1.775
σ0.073
min1.651
max1.840

policy addition benchmark

Factorallocated MiBdb queriespeak allocated MiBtime
policies=2
mean452.965
σ584.388
min160.768
max1329.547
mean102.250
σ8.500
min98.000
max115.000
mean443.000
σ0.000
min443.000
max443.000
mean0.548
σ0.553
min0.266
max1.378
policies=20
mean1608.042
σ0.413
min1607.758
max1608.652
mean980.000
σ0.000
min980.000
max980.000
mean446.750
σ2.500
min443.000
max448.000
mean2.692
σ0.019
min2.675
max2.719
policies=200
mean16088.510
σ0.130
min16088.378
max16088.650
mean9800.000
σ0.000
min9800.000
max9800.000
mean498.500
σ6.245
min491.000
max505.000
mean27.381
σ0.159
min27.254
max27.588