7fd41433714d73c927202e3749d0849fb066f666

Home / Branches / danieldiaz/bro-2220-create-backend-endpoints-for-team-subscriptions / 7fd41433714d73c927202e3749d0849fb066f666

Aggregation: measureAggregations

Factorallocated MiBpeak allocated MiBtime_s
cache=n
dps=1
iters=10
policies=100
mean54.623
σ0.340
min54.495
max55.591
mean418.000
σ0.000
min418.000
max418.000
mean0.142
σ0.004
min0.137
max0.149
cache=y
dps=1
iters=10
policies=100
mean43.785
σ0.006
min43.777
max43.794
mean418.000
σ0.000
min418.000
max418.000
mean0.122
σ0.005
min0.117
max0.132

CSV - indexed operations

Factorallocated MiBpeak allocated MiBtime (ms)
op=column_set() on indexed
mean36.618
σ0.002
min36.616
max36.620
mean4145.875
σ1889.269
min1554.000
max7268.000
mean12.870
σ0.191
min12.634
max13.196
op=column_set() on indexed, repeat
mean36.617
σ0.002
min36.615
max36.620
mean4145.875
σ1889.269
min1554.000
max7268.000
mean12.430
σ0.613
min11.813
max13.501
op=table_records(), no indexes
mean41.932
σ0.001
min41.928
max41.933
mean7268.000
σ0.000
min7268.000
max7268.000
mean15.273
σ0.504
min14.302
max15.921
op=table_records(), repeat
mean41.928
σ0.002
min41.927
max41.931
mean4145.875
σ1889.269
min1554.000
max7268.000
mean13.608
σ1.772
min11.247
max15.621
op=vertical_lookup_list() on indexed, after table_records()
mean27.653
σ0.136
min27.603
max27.990
mean4145.875
σ1889.269
min1554.000
max7268.000
mean8.896
σ0.198
min8.581
max9.134
op=vertical_lookup_list() on indexed, after table_records(), repeat
mean26.400
σ0.002
min26.399
max26.403
mean4145.875
σ1889.269
min1554.000
max7268.000
mean6.648
σ0.410
min5.928
max7.070
op=vertical_lookup_row_list() on 2 indexed
mean25.666
σ0.002
min25.665
max25.668
mean4145.875
σ1889.269
min1554.000
max7268.000
mean6.044
σ0.083
min5.909
max6.153
op=vertical_lookup_row_list() on 3 (1 unindexed)
mean25.968
σ0.002
min25.967
max25.972
mean4145.875
σ1889.269
min1554.000
max7268.000
mean5.887
σ0.210
min5.642
max6.310

CSV - loading a lazy table

Factorallocated MiBpeak allocated MiBtime (ms)
op=load_product(), no indexes
mean2524.606
σ0.000
min2524.606
max2524.607
mean7268.000
σ0.000
min7268.000
max7268.000
mean1547.280
σ973.791
min1035.827
max3821.806
op=load_product(), with indexes
mean8744.722
σ0.469
min8744.554
max8745.883
mean3567.875
σ1787.806
min1047.000
max5771.000
mean4447.607
σ1376.796
min3529.228
max7490.367

CSV - unindexed operations

Factorallocated MiBpeak allocated MiBtime (ms)
op=column_set() on unindexed, dense
mean62.078
σ0.002
min62.076
max62.081
mean4145.875
σ1889.269
min1554.000
max7268.000
mean84.601
σ12.646
min70.552
max101.803
op=vertical_lookup_list() on unindexed missing Int
mean40.944
σ0.001
min40.944
max40.945
mean7268.000
σ0.000
min7268.000
max7268.000
mean109.281
σ2.807
min104.585
max112.838
op=vertical_lookup_row_list() on unindexed small unique Int
mean66.686
σ0.000
min66.685
max66.687
mean7268.000
σ0.000
min7268.000
max7268.000
mean165.017
σ5.314
min152.445
max169.363

CSV - warmup

Factorallocated MiBpeak allocated MiBtime (ms)
op=table_records()
mean11656.836
σ4.324
min11655.305
max11667.538
mean4145.875
σ1889.269
min1554.000
max7268.000
mean6291.624
σ939.983
min4927.432
max8232.513
op=vertical_lookup_list() on indexed
mean11560.065
σ0.001
min11560.064
max11560.066
mean7268.000
σ0.000
min7268.000
max7268.000
mean5963.573
σ1650.119
min4386.005
max8122.365

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
mean380.141
σ19.734
min345.504
max395.279
op=pointedIndexFromKvs
rows=400000
mean357.322
σ0.001
min357.321
max357.325
mean560.250
σ0.463
min560.000
max561.000
mean741.732
σ66.598
min624.426
max802.320

Marine Hull: transactPolicy

Factorallocated MiBpeak allocated MiBtime
datapoints=1
iterations=20
mean1008.376
σ0.760
min1007.900
max1011.516
mean1045.500
σ298.907
min565.000
max1447.000
mean1.550
σ0.075
min1.479
max1.757

Parser: Comma Sep

Factorallocated MiBpeak allocated MiBtime (ms)
name=ambiguous_item.art
mean0.891
σ0.020
min0.881
max0.928
mean403.000
σ0.000
min403.000
max403.000
mean0.295
σ0.285
min0.136
max0.799
name=error_case.art
mean2.338
σ0.012
min2.332
max2.359
mean403.000
σ0.000
min403.000
max403.000
mean0.477
σ0.319
min0.324
max1.046
name=heavy_item.art
mean1.522
σ0.002
min1.520
max1.524
mean403.000
σ0.000
min403.000
max403.000
mean0.217
σ0.025
min0.201
max0.260
name=nested_use.art
mean2.355
σ0.002
min2.355
max2.358
mean403.000
σ0.000
min403.000
max403.000
mean0.330
σ0.014
min0.317
max0.355

Parser: Real World

Factorallocated MiBpeak allocated MiBtime (sec)
name=aon_gpf25_7k_loc.art
mean963.908
σ0.011
min963.902
max963.926
mean431.400
σ0.894
min431.000
max433.000
mean0.551
σ0.070
min0.473
max0.607
name=cdr_enhanced_4k_loc.art
mean884.884
σ0.002
min884.883
max884.886
mean435.000
σ0.000
min435.000
max435.000
mean0.489
σ0.027
min0.462
max0.522

Parser: Record Parsing

Factorallocated MiBpeak allocated MiBtime (ms)
name=record_render_large_success.art
mean7.706
σ0.002
min7.705
max7.709
mean435.000
σ0.000
min435.000
max435.000
mean1.943
σ0.074
min1.839
max2.308
name=record_render_large_syntax_err.art
mean7.655
σ0.002
min7.654
max7.658
mean435.000
σ0.000
min435.000
max435.000
mean2.361
σ0.345
min1.877
max2.955
name=record_render_success.art
mean2.288
σ0.002
min2.287
max2.291
mean435.000
σ0.000
min435.000
max435.000
mean0.314
σ0.050
min0.294
max0.796
name=record_render_syntax_err.art
mean2.163
σ0.002
min2.163
max2.166
mean435.000
σ0.000
min435.000
max435.000
mean0.294
σ0.017
min0.277
max0.447

SoV import

Factorallocated MiBpeak allocated MiBtime_s
iters=10
rows=1000
mean298.146
σ0.995
min297.699
max300.971
mean441.800
σ14.250
min418.000
max462.000
mean0.609
σ0.015
min0.587
max0.631

Timed compile per phase

Factorallocated MiBpeak allocated MiBtime (ms)
phase=buildDeclTree
mean222.008
σ0.000
min222.008
max222.008
mean1722.625
σ57.279
min1581.000
max1745.000
mean212.184
σ2.644
min208.583
max216.353
phase=macro expansion
mean6.130
σ0.000
min6.130
max6.130
mean1722.625
σ57.279
min1581.000
max1745.000
mean10.923
σ1.950
min7.299
max12.709
phase=parser
mean1041.161
σ0.000
min1041.161
max1041.161
mean1722.625
σ57.279
min1581.000
max1745.000
mean628.452
σ106.083
min422.130
max726.644
phase=processProdDef
mean6169.660
σ0.000
min6169.659
max6169.660
mean1743.125
σ2.588
min1740.000
max1745.000
mean5115.434
σ1110.128
min3785.905
max7175.449
phase=renaming
mean21.670
σ0.000
min21.670
max21.670
mean1722.625
σ57.279
min1581.000
max1745.000
mean41.480
σ7.748
min26.512
max48.199
phase=type checker
mean958.537
σ0.066
min958.439
max958.626
mean1722.625
σ57.279
min1581.000
max1745.000
mean740.341
σ96.888
min642.316
max890.002

Workflow: transactPolicy

Factorallocated MiBpeak allocated MiBtime
iters=5
new-facts=1
prior-facts=1
mean292.780
σ0.045
min292.715
max292.823
mean445.000
σ0.000
min445.000
max445.000
mean0.414
σ0.016
min0.398
max0.432
iters=5
new-facts=1
prior-facts=6402
mean1302.864
σ0.077
min1302.736
max1302.934
mean1088.400
σ171.302
min890.000
max1320.000
mean2.044
σ0.219
min1.804
max2.233
iters=5
new-facts=6402
prior-facts=1
mean1545.944
σ4.071
min1543.952
max1553.221
mean624.800
σ89.032
min503.000
max726.000
mean2.412
σ0.321
min2.143
max2.906
iters=5
new-facts=6402
prior-facts=6402
mean1864.869
σ0.069
min1864.797
max1864.980
mean1728.400
σ175.239
min1481.000
max1889.000
mean3.068
σ0.286
min2.873
max3.575

newProductH/cdr_auton/broker

Factortime_s
iterations=5
mean1.766
σ0.087
min1.668
max1.869

policy addition benchmark

Factorallocated MiBdb queriespeak allocated MiBtime
policies=2
mean449.845
σ579.102
min160.291
max1318.498
mean102.250
σ8.500
min98.000
max115.000
mean442.000
σ0.000
min442.000
max442.000
mean0.541
σ0.543
min0.267
max1.355
policies=20
mean1603.244
σ0.395
min1602.984
max1603.831
mean980.000
σ0.000
min980.000
max980.000
mean446.500
σ5.196
min442.000
max451.000
mean2.682
σ0.017
min2.664
max2.703
policies=200
mean16040.820
σ0.210
min16040.624
max16041.116
mean9800.000
σ0.000
min9800.000
max9800.000
mean500.750
σ6.344
min492.000
max507.000
mean27.040
σ0.140
min26.878
max27.207