4ec9c9bee0608ae189f14a2bdb25651d32cd476e

Home / Branches / supertable-sum-in-collapsed-groups / 4ec9c9bee0608ae189f14a2bdb25651d32cd476e

AST compact size (buildDeclTree)

Factorcompact size MiB
phase=buildDeclTree
mean0.203
σ0.000
min0.203
max0.203

AST compact size (macro expansion)

Factorcompact size MiB
phase=macro expansion
mean5.301
σ0.000
min5.301
max5.301

AST compact size (parser)

Factorcompact size MiB
phase=parser
mean5.176
σ0.000
min5.176
max5.176

AST compact size (processProdDef)

Factorcompact size MiB
phase=processProdDef
mean558.695
σ0.000
min558.695
max558.695

AST compact size (renaming)

Factorcompact size MiB
phase=renaming
mean5.488
σ0.000
min5.488
max5.488

AST compact size (type checker)

Factorcompact size MiB
phase=type checker
mean6.645
σ0.000
min6.645
max6.645

Aggregation: measureAggregations

Factorallocated MiBpeak allocated MiBtime_s
cache=n
dps=1
iters=10
policies=100
mean54.882
σ0.359
min54.740
max55.903
mean417.000
σ0.000
min417.000
max417.000
mean0.142
σ0.005
min0.139
max0.152
cache=y
dps=1
iters=10
policies=100
mean43.850
σ0.007
min43.840
max43.865
mean417.000
σ0.000
min417.000
max417.000
mean0.125
σ0.004
min0.122
max0.132

CSV - indexed operations

Factorallocated MiBpeak allocated MiBtime (ms)
op=column_set() on indexed
mean36.618
σ0.002
min36.616
max36.620
mean4042.375
σ2010.309
min1217.000
max7153.000
mean13.382
σ1.628
min12.429
max17.351
op=column_set() on indexed, repeat
mean36.618
σ0.002
min36.616
max36.620
mean4042.375
σ2010.309
min1217.000
max7153.000
mean13.638
σ1.955
min11.763
max18.314
op=table_records(), no indexes
mean41.930
σ0.002
min41.928
max41.933
mean7153.000
σ0.000
min7153.000
max7153.000
mean15.159
σ0.271
min14.767
max15.656
op=table_records(), repeat
mean41.930
σ0.002
min41.927
max41.932
mean4042.375
σ2010.309
min1217.000
max7153.000
mean14.700
σ1.587
min11.334
max16.222
op=vertical_lookup_list() on indexed, after table_records()
mean27.654
σ0.136
min27.604
max27.991
mean4042.375
σ2010.309
min1217.000
max7153.000
mean9.966
σ1.776
min8.353
max12.917
op=vertical_lookup_list() on indexed, after table_records(), repeat
mean26.401
σ0.002
min26.400
max26.404
mean4042.375
σ2010.309
min1217.000
max7153.000
mean7.658
σ1.444
min6.480
max10.127
op=vertical_lookup_row_list() on 2 indexed
mean25.668
σ0.004
min25.665
max25.678
mean4042.375
σ2010.309
min1217.000
max7153.000
mean6.233
σ0.672
min5.800
max7.843
op=vertical_lookup_row_list() on 3 (1 unindexed)
mean25.970
σ0.003
min25.969
max25.976
mean4042.375
σ2010.309
min1217.000
max7153.000
mean5.945
σ0.461
min5.611
max7.046

CSV - loading a lazy table

Factorallocated MiBpeak allocated MiBtime (ms)
op=load_product(), no indexes
mean1021.613
σ0.002
min1021.612
max1021.616
mean7153.000
σ0.000
min7153.000
max7153.000
mean348.901
σ3.825
min342.209
max354.531
op=load_product(), with indexes
mean7917.792
σ0.469
min7917.625
max7918.954
mean3273.250
σ1824.158
min809.000
max5621.000
mean3670.056
σ1069.101
min3071.807
max6144.941

CSV - unindexed operations

Factorallocated MiBpeak allocated MiBtime (ms)
op=column_set() on unindexed, dense
mean62.077
σ0.002
min62.076
max62.080
mean4042.375
σ2010.309
min1217.000
max7153.000
mean88.213
σ20.043
min70.630
max122.392
op=vertical_lookup_list() on unindexed missing Int
mean40.946
σ0.002
min40.944
max40.950
mean7153.000
σ0.000
min7153.000
max7153.000
mean62.629
σ2.850
min60.412
max68.880
op=vertical_lookup_row_list() on unindexed small unique Int
mean66.688
σ0.002
min66.686
max66.691
mean7153.000
σ0.000
min7153.000
max7153.000
mean99.655
σ1.201
min97.795
max100.994

CSV - warmup

Factorallocated MiBpeak allocated MiBtime (ms)
op=table_records()
mean14217.171
σ4.304
min14215.576
max14227.820
mean4042.375
σ2010.309
min1217.000
max7153.000
mean8267.680
σ1810.074
min5992.505
max10820.713
op=vertical_lookup_list() on indexed
mean13159.109
σ0.002
min13159.105
max13159.111
mean7153.000
σ0.000
min7153.000
max7153.000
mean5868.214
σ1701.834
min5003.587
max9707.238

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
mean389.081
σ4.121
min382.465
max394.506
op=pointedIndexFromKvs
rows=400000
mean357.322
σ0.001
min357.321
max357.325
mean560.000
σ0.000
min560.000
max560.000
mean708.690
σ68.017
min621.846
max760.601

Marine Hull: transactPolicy

Factorallocated MiBpeak allocated MiBtime
datapoints=1
iterations=20
mean1024.299
σ0.759
min1023.823
max1027.437
mean1039.150
σ299.123
min554.000
max1462.000
mean1.543
σ0.065
min1.464
max1.726

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.296
σ0.283
min0.144
max0.799
name=error_case.art
mean2.339
σ0.012
min2.333
max2.361
mean402.000
σ0.000
min402.000
max402.000
mean0.474
σ0.317
min0.316
max1.042
name=heavy_item.art
mean1.522
σ0.002
min1.521
max1.525
mean402.000
σ0.000
min402.000
max402.000
mean0.221
σ0.027
min0.201
max0.267
name=nested_use.art
mean2.357
σ0.002
min2.356
max2.360
mean402.000
σ0.000
min402.000
max402.000
mean0.328
σ0.014
min0.318
max0.352

Parser: Real World

Factorallocated MiBpeak allocated MiBtime (sec)
name=aon_gpf25_7k_loc.art
mean964.840
σ0.011
min964.835
max964.859
mean437.200
σ6.535
min431.000
max444.000
mean0.563
σ0.053
min0.467
max0.590
name=cdr_enhanced_4k_loc.art
mean885.820
σ0.002
min885.819
max885.823
mean444.000
σ0.000
min444.000
max444.000
mean0.487
σ0.051
min0.405
max0.524

Parser: Record Parsing

Factorallocated MiBpeak allocated MiBtime (ms)
name=record_render_large_success.art
mean7.709
σ0.002
min7.708
max7.712
mean444.000
σ0.000
min444.000
max444.000
mean1.975
σ0.088
min1.824
max2.257
name=record_render_large_syntax_err.art
mean7.657
σ0.002
min7.656
max7.660
mean444.000
σ0.000
min444.000
max444.000
mean2.282
σ0.359
min1.868
max3.024
name=record_render_success.art
mean2.289
σ0.002
min2.289
max2.293
mean444.000
σ0.000
min444.000
max444.000
mean0.305
σ0.009
min0.290
max0.364
name=record_render_syntax_err.art
mean2.165
σ0.002
min2.164
max2.168
mean444.000
σ0.000
min444.000
max444.000
mean0.290
σ0.007
min0.278
max0.333

SoV import

Factorallocated MiBpeak allocated MiBtime_s
iters=10
rows=1000
mean298.701
σ1.008
min298.345
max301.567
mean442.400
σ17.122
min417.000
max466.000
mean0.599
σ0.023
min0.554
max0.618

Timed compile per phase

Factorallocated MiBpeak allocated MiBtime (ms)
phase=buildDeclTree
mean236.681
σ0.000
min236.681
max236.681
mean841.625
σ12.694
min822.000
max850.000
mean203.628
σ3.375
min198.912
max210.601
phase=macro expansion
mean6.133
σ0.000
min6.133
max6.133
mean840.250
σ15.425
min811.000
max850.000
mean7.365
σ1.450
min6.258
max9.694
phase=parser
mean1042.362
σ0.000
min1042.362
max1042.362
mean839.875
σ16.252
min808.000
max850.000
mean428.210
σ53.060
min374.430
max505.212
phase=processProdDef
mean4850.764
σ0.000
min4850.764
max4850.764
mean843.000
σ12.961
min822.000
max850.000
mean4459.528
σ550.121
min3627.921
max5247.158
phase=renaming
mean21.671
σ0.000
min21.671
max21.671
mean841.625
σ12.694
min822.000
max850.000
mean26.468
σ8.847
min20.202
max40.604
phase=type checker
mean990.450
σ0.071
min990.344
max990.563
mean841.625
σ12.694
min822.000
max850.000
mean712.371
σ75.741
min641.676
max859.550

Workflow: transactPolicy

Factorallocated MiBpeak allocated MiBtime
iters=5
new-facts=1
prior-facts=1
mean293.820
σ0.037
min293.766
max293.858
mean446.000
σ0.000
min446.000
max446.000
mean0.396
σ0.006
min0.392
max0.406
iters=5
new-facts=1
prior-facts=6402
mean1320.216
σ0.028
min1320.174
max1320.246
mean1067.600
σ165.555
min844.000
max1270.000
mean2.243
σ0.055
min2.162
max2.305
iters=5
new-facts=6402
prior-facts=1
mean1560.612
σ6.240
min1557.616
max1571.771
mean618.800
σ82.769
min494.000
max717.000
mean2.324
σ0.227
min2.191
max2.728
iters=5
new-facts=6402
prior-facts=6402
mean1882.173
σ0.055
min1882.107
max1882.244
mean1701.200
σ257.825
min1398.000
max2057.000
mean2.974
σ0.108
min2.831
max3.109

newProductH/cdr_auton/broker

Factortime_s
iterations=5
mean1.712
σ0.242
min1.295
max1.916

policy addition benchmark

Factorallocated MiBdb queriespeak allocated MiBtime
policies=2
mean452.081
σ582.721
min160.718
max1326.164
mean102.250
σ8.500
min98.000
max115.000
mean441.000
σ0.000
min441.000
max441.000
mean0.530
σ0.505
min0.271
max1.287
policies=20
mean1607.522
σ0.407
min1607.245
max1608.125
mean980.000
σ0.000
min980.000
max980.000
mean448.500
σ8.660
min441.000
max456.000
mean2.692
σ0.010
min2.681
max2.702
policies=200
mean16083.475
σ0.115
min16083.399
max16083.644
mean9800.000
σ0.000
min9800.000
max9800.000
mean495.500
σ3.873
min491.000
max500.000
mean27.155
σ0.048
min27.110
max27.206