eb0ac31ede583c6d2eb25dff9483e6526160d3e3

Home / Branches / jaak/derive-fields-experiment / eb0ac31ede583c6d2eb25dff9483e6526160d3e3

Aggregation: measureAggregations

Factorallocated MiBpeak allocated MiBtime_s
cache=n
dps=1
iters=10
policies=100
mean54.617
σ0.349
min54.483
max55.610
mean418.000
σ0.000
min418.000
max418.000
mean0.139
σ0.006
min0.132
max0.148
cache=y
dps=1
iters=10
policies=100
mean43.785
σ0.006
min43.778
max43.800
mean418.000
σ0.000
min418.000
max418.000
mean0.124
σ0.004
min0.121
max0.131

CSV - indexed operations

Factorallocated MiBpeak allocated MiBtime (ms)
op=column_set() on indexed
mean36.618
σ0.002
min36.616
max36.620
mean4111.750
σ1551.319
min2070.000
max6041.000
mean12.218
σ0.410
min11.721
max12.967
op=column_set() on indexed, repeat
mean36.617
σ0.002
min36.615
max36.620
mean4111.750
σ1551.319
min2070.000
max6041.000
mean12.389
σ0.763
min11.188
max13.253
op=table_records(), no indexes
mean41.928
σ0.000
min41.928
max41.929
mean6041.000
σ0.000
min6041.000
max6041.000
mean13.147
σ1.085
min11.042
max14.571
op=table_records(), repeat
mean41.928
σ0.002
min41.927
max41.931
mean4111.750
σ1551.319
min2070.000
max6041.000
mean12.208
σ1.823
min10.385
max14.472
op=vertical_lookup_list() on indexed, after table_records()
mean27.605
σ0.002
min27.603
max27.607
mean4111.750
σ1551.319
min2070.000
max6041.000
mean8.186
σ0.269
min7.798
max8.508
op=vertical_lookup_list() on indexed, after table_records(), repeat
mean26.400
σ0.002
min26.399
max26.403
mean4111.750
σ1551.319
min2070.000
max6041.000
mean6.147
σ0.400
min5.225
max6.517
op=vertical_lookup_row_list() on 2 indexed
mean25.666
σ0.002
min25.664
max25.670
mean4111.750
σ1551.319
min2070.000
max6041.000
mean5.359
σ0.102
min5.229
max5.499
op=vertical_lookup_row_list() on 3 (1 unindexed)
mean25.969
σ0.002
min25.967
max25.971
mean4111.750
σ1551.319
min2070.000
max6041.000
mean5.222
σ0.092
min5.120
max5.388

CSV - loading a lazy table

Factorallocated MiBpeak allocated MiBtime (ms)
op=load_product(), no indexes
mean2524.594
σ0.000
min2524.593
max2524.594
mean6041.000
σ0.000
min6041.000
max6041.000
mean1543.337
σ791.347
min1042.528
max2960.084
op=load_product(), with indexes
mean8744.558
σ0.032
min8744.544
max8744.638
mean3841.625
σ1619.733
min2070.000
max6041.000
mean4837.651
σ1485.872
min3527.661
max7379.806

CSV - unindexed operations

Factorallocated MiBpeak allocated MiBtime (ms)
op=column_set() on unindexed, dense
mean62.078
σ0.002
min62.076
max62.080
mean4111.750
σ1551.319
min2070.000
max6041.000
mean80.502
σ9.210
min70.775
max94.809
op=vertical_lookup_list() on unindexed missing Int
mean40.944
σ0.001
min40.944
max40.945
mean6041.000
σ0.000
min6041.000
max6041.000
mean95.148
σ11.494
min76.420
max107.149
op=vertical_lookup_row_list() on unindexed small unique Int
mean66.686
σ0.000
min66.685
max66.686
mean6041.000
σ0.000
min6041.000
max6041.000
mean220.637
σ225.032
min112.587
max776.129

CSV - warmup

Factorallocated MiBpeak allocated MiBtime (ms)
op=table_records()
mean11656.833
σ4.318
min11655.305
max11667.521
mean4111.750
σ1551.319
min2070.000
max6041.000
mean6476.374
σ1438.813
min4910.146
max8308.418
op=vertical_lookup_list() on indexed
mean11560.068
σ0.001
min11560.066
max11560.069
mean6041.000
σ0.000
min6041.000
max6041.000
mean6678.735
σ1292.470
min4410.859
max8018.304

CSV internal benchmark: pointedIndexFromKvs

Factorallocated MiBpeak allocated MiBtime (ms)
op=pointedIndexFromKvs
rows=200000
mean172.588
σ0.028
min172.561
max172.628
mean2070.000
σ0.000
min2070.000
max2070.000
mean356.647
σ49.375
min320.459
max464.626
op=pointedIndexFromKvs
rows=400000
mean357.372
σ0.044
min357.321
max357.424
mean2070.000
σ0.000
min2070.000
max2070.000
mean732.743
σ59.888
min617.061
max799.486

Marine Hull: transactPolicy

Factorallocated MiBpeak allocated MiBtime
datapoints=1
iterations=20
mean1008.182
σ0.898
min1007.691
max1011.917
mean1040.300
σ304.697
min548.000
max1469.000
mean1.545
σ0.077
min1.466
max1.772

Parser: Comma Sep

Factorallocated MiBpeak allocated MiBtime (ms)
name=ambiguous_item.art
mean0.883
σ0.002
min0.881
max0.886
mean1469.000
σ0.000
min1469.000
max1469.000
mean0.416
σ0.121
min0.342
max0.628
name=error_case.art
mean2.333
σ0.003
min2.332
max2.337
mean1469.000
σ0.000
min1469.000
max1469.000
mean0.881
σ0.080
min0.827
max1.022
name=heavy_item.art
mean1.521
σ0.002
min1.520
max1.524
mean1469.000
σ0.000
min1469.000
max1469.000
mean0.550
σ0.050
min0.514
max0.637
name=nested_use.art
mean2.355
σ0.002
min2.355
max2.358
mean1469.000
σ0.000
min1469.000
max1469.000
mean0.854
σ0.043
min0.821
max0.928

Parser: Real World

Factorallocated MiBpeak allocated MiBtime (sec)
name=aon_gpf25_7k_loc.art
mean963.922
σ0.025
min963.902
max963.964
mean1469.000
σ0.000
min1469.000
max1469.000
mean0.812
σ0.056
min0.719
max0.857
name=cdr_enhanced_4k_loc.art
mean884.889
σ0.006
min884.883
max884.897
mean1469.000
σ0.000
min1469.000
max1469.000
mean0.691
σ0.051
min0.628
max0.747

Parser: Record Parsing

Factorallocated MiBpeak allocated MiBtime (ms)
name=record_render_large_success.art
mean7.706
σ0.002
min7.705
max7.709
mean1469.000
σ0.000
min1469.000
max1469.000
mean4.333
σ0.088
min4.201
max4.590
name=record_render_large_syntax_err.art
mean7.655
σ0.002
min7.654
max7.658
mean1469.000
σ0.000
min1469.000
max1469.000
mean4.020
σ0.358
min3.458
max4.581
name=record_render_success.art
mean2.288
σ0.002
min2.287
max2.291
mean1469.000
σ0.000
min1469.000
max1469.000
mean0.756
σ0.021
min0.722
max0.861
name=record_render_syntax_err.art
mean2.163
σ0.002
min2.163
max2.166
mean1469.000
σ0.000
min1469.000
max1469.000
mean0.709
σ0.026
min0.663
max0.805

SoV import

Factorallocated MiBpeak allocated MiBtime_s
iters=10
rows=1000
mean297.491
σ0.223
min297.363
max298.116
mean2070.000
σ0.000
min2070.000
max2070.000
mean0.570
σ0.025
min0.515
max0.587

Timed compile per phase

Factorallocated MiBpeak allocated MiBtime (ms)
phase=buildDeclTree
mean221.996
σ0.000
min221.996
max221.996
mean1598.625
σ27.224
min1589.000
max1666.000
mean208.895
σ1.743
min206.677
max212.147
phase=macro expansion
mean6.127
σ0.000
min6.127
max6.127
mean1598.625
σ27.224
min1589.000
max1666.000
mean11.711
σ2.185
min9.279
max15.545
phase=parser
mean1041.157
σ0.000
min1041.157
max1041.157
mean1598.625
σ27.224
min1589.000
max1666.000
mean693.135
σ80.873
min589.416
max835.906
phase=processProdDef
mean6169.661
σ0.001
min6169.660
max6169.662
mean1626.750
σ80.315
min1589.000
max1814.000
mean6751.616
σ1531.686
min3065.076
max8035.271
phase=renaming
mean21.666
σ0.000
min21.666
max21.666
mean1598.625
σ27.224
min1589.000
max1666.000
mean45.583
σ5.717
min38.824
max55.746
phase=type checker
mean958.665
σ0.055
min958.579
max958.736
mean1598.625
σ27.224
min1589.000
max1666.000
mean779.188
σ72.073
min660.811
max870.626

Workflow: transactPolicy

Factorallocated MiBpeak allocated MiBtime
iters=5
new-facts=1
prior-facts=1
mean289.764
σ0.038
min289.720
max289.803
mean1814.000
σ0.000
min1814.000
max1814.000
mean0.401
σ0.008
min0.397
max0.415
iters=5
new-facts=1
prior-facts=6402
mean1299.588
σ0.068
min1299.510
max1299.687
mean1814.000
σ0.000
min1814.000
max1814.000
mean1.932
σ0.132
min1.815
max2.139
iters=5
new-facts=6402
prior-facts=1
mean1542.654
σ4.021
min1540.673
max1549.841
mean1814.000
σ0.000
min1814.000
max1814.000
mean2.287
σ0.124
min2.113
max2.450
iters=5
new-facts=6402
prior-facts=6402
mean1861.644
σ0.051
min1861.578
max1861.693
mean1876.600
σ110.895
min1814.000
max2070.000
mean2.944
σ0.090
min2.851
max3.053

newProductH/cdr_auton/broker

Factortime_s
iterations=5
mean1.747
σ0.129
min1.553
max1.839

policy addition benchmark

Factorallocated MiBdb queriespeak allocated MiBtime
policies=2
mean446.208
σ577.185
min157.613
max1311.985
mean96.250
σ8.500
min92.000
max109.000
mean1814.000
σ0.000
min1814.000
max1814.000
mean0.472
σ0.388
min0.275
max1.054
policies=20
mean1576.435
σ0.396
min1576.179
max1577.026
mean920.000
σ0.000
min920.000
max920.000
mean1814.000
σ0.000
min1814.000
max1814.000
mean2.719
σ0.014
min2.701
max2.730
policies=200
mean15772.173
σ0.116
min15772.063
max15772.313
mean9200.000
σ0.000
min9200.000
max9200.000
mean1814.000
σ0.000
min1814.000
max1814.000
mean27.324
σ0.512
min26.556
max27.584