c9d46f47fed4aaf8fe075c1bcd8541c9143f39e8

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

Aggregation: measureAggregations

Factorallocated MiBpeak allocated MiBtime_s
cache=n
dps=1
iters=10
policies=100
mean54.676
σ0.357
min54.543
max55.690
mean422.000
σ0.000
min422.000
max422.000
mean0.140
σ0.005
min0.134
max0.148
cache=y
dps=1
iters=10
policies=100
mean43.705
σ0.004
min43.698
max43.711
mean422.000
σ0.000
min422.000
max422.000
mean0.123
σ0.004
min0.121
max0.132

CSV - indexed operations

Factorallocated MiBpeak allocated MiBtime (ms)
op=column_set() on indexed
mean36.618
σ0.002
min36.616
max36.620
mean4151.875
σ1900.254
min1554.000
max7301.000
mean12.587
σ0.321
min12.070
max12.948
op=column_set() on indexed, repeat
mean36.617
σ0.002
min36.616
max36.620
mean4151.875
σ1900.254
min1554.000
max7301.000
mean12.129
σ0.713
min11.287
max13.099
op=table_records(), no indexes
mean41.932
σ0.001
min41.929
max41.933
mean7301.000
σ0.000
min7301.000
max7301.000
mean15.172
σ0.566
min13.866
max15.653
op=table_records(), repeat
mean41.929
σ0.002
min41.927
max41.932
mean4151.875
σ1900.254
min1554.000
max7301.000
mean13.221
σ1.818
min10.814
max15.727
op=vertical_lookup_list() on indexed, after table_records()
mean27.654
σ0.136
min27.604
max27.991
mean4151.875
σ1900.254
min1554.000
max7301.000
mean9.018
σ0.290
min8.591
max9.619
op=vertical_lookup_list() on indexed, after table_records(), repeat
mean26.401
σ0.002
min26.400
max26.404
mean4151.875
σ1900.254
min1554.000
max7301.000
mean6.638
σ0.331
min6.207
max7.065
op=vertical_lookup_row_list() on 2 indexed
mean25.668
σ0.003
min25.666
max25.674
mean4151.875
σ1900.254
min1554.000
max7301.000
mean5.920
σ0.102
min5.735
max6.032
op=vertical_lookup_row_list() on 3 (1 unindexed)
mean25.970
σ0.002
min25.968
max25.974
mean4151.875
σ1900.254
min1554.000
max7301.000
mean5.690
σ0.212
min5.342
max6.012

CSV - loading a lazy table

Factorallocated MiBpeak allocated MiBtime (ms)
op=load_product(), no indexes
mean2524.606
σ0.000
min2524.606
max2524.606
mean7301.000
σ0.000
min7301.000
max7301.000
mean1390.923
σ633.305
min1036.516
max2857.434
op=load_product(), with indexes
mean8744.722
σ0.469
min8744.553
max8745.882
mean3572.250
σ1797.062
min1042.000
max5795.000
mean4782.640
σ1512.196
min3535.941
max7382.257

CSV - unindexed operations

Factorallocated MiBpeak allocated MiBtime (ms)
op=column_set() on unindexed, dense
mean62.078
σ0.002
min62.076
max62.081
mean4151.875
σ1900.254
min1554.000
max7301.000
mean82.885
σ12.684
min67.887
max102.880
op=vertical_lookup_list() on unindexed missing Int
mean40.945
σ0.001
min40.945
max40.946
mean7301.000
σ0.000
min7301.000
max7301.000
mean107.013
σ2.374
min103.602
max109.792
op=vertical_lookup_row_list() on unindexed small unique Int
mean66.686
σ0.000
min66.686
max66.687
mean7301.000
σ0.000
min7301.000
max7301.000
mean163.969
σ5.649
min150.596
max167.475

CSV - warmup

Factorallocated MiBpeak allocated MiBtime (ms)
op=table_records()
mean11656.900
σ4.304
min11655.306
max11667.552
mean4151.875
σ1900.254
min1554.000
max7301.000
mean6600.556
σ1289.593
min4916.425
max8105.100
op=vertical_lookup_list() on indexed
mean11560.066
σ0.001
min11560.065
max11560.067
mean7301.000
σ0.000
min7301.000
max7301.000
mean5291.249
σ1245.122
min4361.533
max7700.796

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
mean373.935
σ14.952
min341.937
max387.358
op=pointedIndexFromKvs
rows=400000
mean357.322
σ0.001
min357.321
max357.325
mean560.000
σ0.000
min560.000
max560.000
mean753.105
σ23.125
min707.068
max785.826

Marine Hull: transactPolicy

Factorallocated MiBpeak allocated MiBtime
datapoints=1
iterations=20
mean1024.327
σ0.759
min1023.851
max1027.464
mean1037.400
σ303.161
min554.000
max1461.000
mean1.582
σ0.096
min1.505
max1.858

Parser: Comma Sep

Factorallocated MiBpeak allocated MiBtime (ms)
name=ambiguous_item.art
mean0.913
σ0.020
min0.903
max0.949
mean401.000
σ0.000
min401.000
max401.000
mean0.341
σ0.296
min0.149
max0.860
name=error_case.art
mean2.339
σ0.012
min2.333
max2.361
mean401.000
σ0.000
min401.000
max401.000
mean0.422
σ0.197
min0.320
max0.774
name=heavy_item.art
mean1.522
σ0.002
min1.521
max1.525
mean401.000
σ0.000
min401.000
max401.000
mean0.221
σ0.028
min0.205
max0.271
name=nested_use.art
mean2.357
σ0.002
min2.356
max2.360
mean401.000
σ0.000
min401.000
max401.000
mean0.334
σ0.018
min0.317
max0.364

Parser: Real World

Factorallocated MiBpeak allocated MiBtime (sec)
name=aon_gpf25_7k_loc.art
mean964.840
σ0.011
min964.835
max964.859
mean432.600
σ3.130
min430.000
max436.000
mean0.578
σ0.044
min0.526
max0.616
name=cdr_enhanced_4k_loc.art
mean885.820
σ0.002
min885.819
max885.823
mean436.000
σ0.000
min436.000
max436.000
mean0.486
σ0.055
min0.389
max0.520

Parser: Record Parsing

Factorallocated MiBpeak allocated MiBtime (ms)
name=record_render_large_success.art
mean7.709
σ0.002
min7.708
max7.712
mean436.000
σ0.000
min436.000
max436.000
mean2.595
σ0.079
min2.467
max2.891
name=record_render_large_syntax_err.art
mean7.657
σ0.002
min7.656
max7.660
mean436.000
σ0.000
min436.000
max436.000
mean2.573
σ0.055
min2.462
max2.743
name=record_render_success.art
mean2.289
σ0.002
min2.289
max2.293
mean436.000
σ0.000
min436.000
max436.000
mean0.309
σ0.013
min0.290
max0.363
name=record_render_syntax_err.art
mean2.165
σ0.002
min2.164
max2.168
mean436.000
σ0.000
min436.000
max436.000
mean0.293
σ0.009
min0.278
max0.339

SoV import

Factorallocated MiBpeak allocated MiBtime_s
iters=10
rows=1000
mean298.707
σ1.036
min298.299
max301.649
mean445.100
σ18.520
min418.000
max471.000
mean0.617
σ0.013
min0.587
max0.636

Timed compile per phase

Factorallocated MiBpeak allocated MiBtime (ms)
phase=buildDeclTree
mean239.536
σ0.000
min239.536
max239.536
mean1733.625
σ20.860
min1682.000
max1741.000
mean217.660
σ1.935
min215.160
max220.869
phase=macro expansion
mean6.133
σ0.000
min6.133
max6.133
mean1733.625
σ20.860
min1682.000
max1741.000
mean11.547
σ1.482
min9.398
max12.687
phase=parser
mean1042.363
σ0.000
min1042.363
max1042.363
mean1733.625
σ20.860
min1682.000
max1741.000
mean667.807
σ73.768
min559.844
max724.734
phase=processProdDef
mean6169.657
σ0.001
min6169.657
max6169.658
mean1741.000
σ0.000
min1741.000
max1741.000
mean5298.032
σ811.073
min4316.417
max6665.889
phase=renaming
mean21.671
σ0.000
min21.671
max21.671
mean1733.625
σ20.860
min1682.000
max1741.000
mean44.026
σ5.158
min34.656
max48.136
phase=type checker
mean990.442
σ0.066
min990.344
max990.532
mean1733.625
σ20.860
min1682.000
max1741.000
mean762.117
σ70.733
min676.459
max897.936

Workflow: transactPolicy

Factorallocated MiBpeak allocated MiBtime
iters=5
new-facts=1
prior-facts=1
mean293.926
σ0.046
min293.861
max293.972
mean443.800
σ1.095
min443.000
max445.000
mean0.413
σ0.008
min0.404
max0.423
iters=5
new-facts=1
prior-facts=6402
mean1320.230
σ0.066
min1320.171
max1320.320
mean1112.200
σ187.716
min892.000
max1374.000
mean2.056
σ0.130
min1.947
max2.225
iters=5
new-facts=6402
prior-facts=1
mean1559.739
σ4.097
min1557.707
max1567.062
mean625.400
σ88.053
min495.000
max730.000
mean2.294
σ0.217
min2.127
max2.665
iters=5
new-facts=6402
prior-facts=6402
mean1882.275
σ0.066
min1882.186
max1882.345
mean1756.800
σ208.938
min1505.000
max1963.000
mean3.194
σ0.204
min2.966
max3.483

newProductH/cdr_auton/broker

Factortime_s
iterations=5
mean1.842
σ0.104
min1.663
max1.923

policy addition benchmark

Factorallocated MiBdb queriespeak allocated MiBtime
policies=2
mean453.536
σ585.529
min160.771
max1331.829
mean102.250
σ8.500
min98.000
max115.000
mean443.000
σ0.000
min443.000
max443.000
mean0.551
σ0.549
min0.274
max1.374
policies=20
mean1608.041
σ0.432
min1607.753
max1608.681
mean980.000
σ0.000
min980.000
max980.000
mean449.000
σ10.677
min443.000
max465.000
mean2.724
σ0.020
min2.694
max2.738
policies=200
mean16088.517
σ0.136
min16088.315
max16088.612
mean9800.000
σ0.000
min9800.000
max9800.000
mean499.250
σ5.679
min493.000
max505.000
mean27.420
σ0.148
min27.292
max27.597