8e5c0c33227f8e3ebd410ca0e6ef52b5d3594c8c

Home / Branches / alexfmpe/qa-32-useracl-merge-queries / 8e5c0c33227f8e3ebd410ca0e6ef52b5d3594c8c

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.082
σ0.000
min5.082
max5.082

AST compact size (parser)

Factorcompact size MiB
phase=parser
mean4.988
σ0.000
min4.988
max4.988

AST compact size (processProdDef Decls)

Factorcompact size MiB
phase=processProdDef Decls
mean5.395
σ0.000
min5.395
max5.395

AST compact size (processProdDef)

Factorcompact size MiB
phase=processProdDef
mean446.633
σ0.000
min446.633
max446.633

AST compact size (renaming)

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

AST compact size (type checker)

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

Aggregation: measureAggregations

Factorallocated MiBpeak allocated MiBtime_s
cache=n
dps=1
iters=10
policies=100
mean54.726
σ0.355
min54.593
max55.736
mean418.000
σ0.000
min418.000
max418.000
mean0.141
σ0.004
min0.137
max0.149
cache=y
dps=1
iters=10
policies=100
mean43.771
σ0.006
min43.764
max43.781
mean418.000
σ0.000
min418.000
max418.000
mean0.120
σ0.005
min0.115
max0.131

CSV - indexed operations

Factorallocated MiBpeak allocated MiBtime (ms)
op=column_set() on indexed
mean36.604
σ0.000
min36.604
max36.605
mean4588.000
σ2249.204
min1486.000
max7379.000
mean133.090
σ342.195
min11.869
max979.979
op=column_set() on indexed, repeat
mean36.604
σ0.000
min36.604
max36.605
mean4588.000
σ2249.204
min1486.000
max7379.000
mean14.008
σ4.306
min11.366
max24.554
op=table_records(), no indexes
mean41.940
σ0.002
min41.938
max41.942
mean7379.000
σ0.000
min7379.000
max7379.000
mean10.963
σ0.238
min10.506
max11.242
op=table_records(), repeat
mean41.925
σ0.000
min41.924
max41.925
mean4179.250
σ1946.263
min1486.000
max7379.000
mean11.707
σ1.829
min10.922
max16.228
op=vertical_lookup_list() on indexed, after table_records()
mean27.632
σ0.137
min27.584
max27.971
mean4179.250
σ1946.263
min1486.000
max7379.000
mean9.032
σ1.362
min8.125
max12.341
op=vertical_lookup_list() on indexed, after table_records(), repeat
mean26.384
σ0.000
min26.384
max26.384
mean4179.250
σ1946.263
min1486.000
max7379.000
mean6.634
σ1.071
min5.766
max9.145
op=vertical_lookup_row_list() on 2 indexed
mean25.662
σ0.004
min25.661
max25.673
mean4588.000
σ2249.204
min1486.000
max7379.000
mean6.363
σ1.017
min5.800
max8.855
op=vertical_lookup_row_list() on 3 (1 unindexed)
mean25.961
σ0.001
min25.961
max25.962
mean4588.000
σ2249.204
min1486.000
max7379.000
mean6.110
σ1.085
min5.480
max8.777

CSV - loading a lazy table

Factorallocated MiBpeak allocated MiBtime (ms)
op=load_product(), no indexes
mean1021.608
σ0.002
min1021.606
max1021.611
mean7379.000
σ0.000
min7379.000
max7379.000
mean372.398
σ79.442
min340.970
max568.947
op=load_product(), with indexes
mean3495.854
σ0.453
min3495.694
max3496.977
mean3755.500
σ2300.542
min719.000
max7379.000
mean1750.182
σ677.330
min1380.168
max2939.787

CSV - unindexed operations

Factorallocated MiBpeak allocated MiBtime (ms)
op=column_set() on unindexed, dense, minor warmup
mean107.841
σ0.000
min107.841
max107.841
mean4407.250
σ2218.282
min1486.000
max7379.000
mean197.342
σ173.787
min123.185
max624.610
op=column_set() on unindexed, dense, repeat
mean62.068
σ0.001
min62.065
max62.069
mean4407.250
σ2218.282
min1486.000
max7379.000
mean43.401
σ1.571
min41.216
max45.602
op=vertical_lookup_list() repeated on unindexed missing Int
mean40.926
σ0.002
min40.925
max40.928
mean7379.000
σ0.000
min7379.000
max7379.000
mean21.955
σ0.657
min21.453
max23.476
op=vertical_lookup_row_list() on unindexed small unique Int
mean71.294
σ0.002
min71.292
max71.296
mean7379.000
σ0.000
min7379.000
max7379.000
mean202.896
σ416.113
min55.084
max1232.721

CSV - warmup

Factorallocated MiBpeak allocated MiBtime (ms)
op=table_records()
mean4646.842
σ0.014
min4646.837
max4646.876
mean4179.250
σ1946.263
min1486.000
max7379.000
mean3297.257
σ892.185
min2470.079
max5099.736
op=vertical_lookup_list() on indexed
mean1973.829
σ0.002
min1973.827
max1973.832
mean7379.000
σ0.000
min7379.000
max7379.000
mean1055.553
σ291.585
min902.222
max1751.739
op=vertical_lookup_list() on unindexed missing Int, minor warmup
mean905.083
σ0.002
min905.080
max905.086
mean7379.000
σ0.000
min7379.000
max7379.000
mean384.735
σ5.699
min372.702
max392.049

CSV internal benchmark: pointedIndexFromKvs

Factorallocated MiBpeak allocated MiBtime (ms)
op=pointedIndexFromKvs
rows=200000
mean148.144
σ0.001
min148.144
max148.148
mean477.000
σ0.000
min477.000
max477.000
mean380.361
σ21.999
min357.806
max423.180
op=pointedIndexFromKvs
rows=400000
mean308.493
σ0.001
min308.493
max308.497
mean562.000
σ0.000
min562.000
max562.000
mean733.368
σ51.985
min641.024
max794.338

Marine Hull: transactPolicy

Factorallocated MiBpeak allocated MiBtime
datapoints=1
iterations=20
mean964.179
σ1.819
min963.472
max971.869
mean1045.800
σ319.589
min537.000
max1513.000
mean1.307
σ0.172
min1.182
max1.920

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.299
σ0.296
min0.144
max0.824
name=error_case.art
mean2.346
σ0.012
min2.340
max2.368
mean402.000
σ0.000
min402.000
max402.000
mean0.478
σ0.336
min0.316
max1.079
name=heavy_item.art
mean1.523
σ0.002
min1.522
max1.526
mean402.000
σ0.000
min402.000
max402.000
mean0.218
σ0.021
min0.199
max0.253
name=nested_use.art
mean2.364
σ0.002
min2.363
max2.367
mean402.000
σ0.000
min402.000
max402.000
mean0.328
σ0.014
min0.312
max0.350

Parser: Real World

Factorallocated MiBpeak allocated MiBtime (sec)
name=aon_gpf25_7k_loc.art
mean964.838
σ0.009
min964.833
max964.855
mean431.600
σ1.342
min431.000
max434.000
mean0.514
σ0.063
min0.439
max0.608
name=cdr_enhanced_4k_loc.art
mean885.913
σ0.002
min885.912
max885.915
mean442.000
σ0.000
min442.000
max442.000
mean0.459
σ0.048
min0.375
max0.495

Parser: Record Parsing

Factorallocated MiBpeak allocated MiBtime (ms)
name=record_render_large_success.art
mean7.718
σ0.002
min7.717
max7.721
mean442.000
σ0.000
min442.000
max442.000
mean1.849
σ0.088
min1.692
max2.184
name=record_render_large_syntax_err.art
mean7.667
σ0.002
min7.666
max7.670
mean442.000
σ0.000
min442.000
max442.000
mean2.578
σ0.208
min1.743
max2.926
name=record_render_success.art
mean2.290
σ0.002
min2.289
max2.293
mean442.000
σ0.000
min442.000
max442.000
mean0.318
σ0.026
min0.291
max0.497
name=record_render_syntax_err.art
mean2.165
σ0.002
min2.164
max2.168
mean442.000
σ0.000
min442.000
max442.000
mean0.303
σ0.041
min0.277
max0.557

Revision Creation

Factorallocated MiBpeak allocated MiBtime_s
number of threads=8
revision count=1000
mean11.703
σ11.172
min0.714
max74.448
mean463.724
σ19.802
min412.000
max481.000
mean0.027
σ0.028
min0.001
max0.202

SoV import

Factorallocated MiBpeak allocated MiBtime_s
iters=10
rows=1000
mean278.435
σ1.055
min278.026
max281.437
mean443.900
σ14.372
min417.000
max467.000
mean0.575
σ0.018
min0.529
max0.593

Timed compile per phase

Factorallocated MiBpeak allocated MiBtime (ms)
phase=buildDeclTree
mean169.257
σ0.000
min169.257
max169.257
mean693.000
σ0.000
min693.000
max693.000
mean212.168
σ21.275
min192.753
max247.197
phase=macro expansion
mean5.899
σ0.000
min5.899
max5.899
mean693.000
σ0.000
min693.000
max693.000
mean8.188
σ1.063
min6.893
max9.055
phase=parser
mean1041.959
σ0.000
min1041.958
max1041.959
mean693.000
σ0.000
min693.000
max693.000
mean542.612
σ94.316
min410.106
max619.027
phase=processProdDef
mean2243.721
σ0.000
min2243.721
max2243.721
mean693.000
σ0.000
min693.000
max693.000
mean2838.167
σ373.847
min2146.383
max3229.067
phase=renaming
mean21.436
σ0.000
min21.436
max21.436
mean693.000
σ0.000
min693.000
max693.000
mean43.959
σ4.499
min37.189
max47.952
phase=type checker
mean958.596
σ0.047
min958.573
max958.698
mean693.000
σ0.000
min693.000
max693.000
mean655.628
σ16.394
min629.804
max671.350

Workflow: transactPolicy

Factorallocated MiBpeak allocated MiBtime
iters=5
new-facts=1
prior-facts=1
mean282.001
σ0.034
min281.951
max282.032
mean442.000
σ0.000
min442.000
max442.000
mean0.377
σ0.006
min0.374
max0.387
iters=5
new-facts=1
prior-facts=6402
mean1267.269
σ0.089
min1267.122
max1267.340
mean1069.200
σ161.747
min851.000
max1273.000
mean2.043
σ0.239
min1.808
max2.372
iters=5
new-facts=6402
prior-facts=1
mean1506.131
σ2.925
min1504.621
max1511.350
mean613.600
σ78.236
min493.000
max701.000
mean2.137
σ0.107
min2.051
max2.314
iters=5
new-facts=6402
prior-facts=6402
mean1829.221
σ0.045
min1829.149
max1829.268
mean1719.200
σ248.892
min1427.000
max2058.000
mean2.831
σ0.048
min2.799
max2.915

newProductH/cdr_auton/broker

Factortime_s
iterations=5
mean1.754
σ0.107
min1.591
max1.853

policy addition benchmark

Factorallocated MiBdb queriespeak allocated MiBtime
policies=2
mean393.170
σ509.568
min138.384
max1157.522
mean97.500
σ7.000
min94.000
max108.000
mean436.000
σ0.000
min436.000
max436.000
mean0.489
σ0.514
min0.229
max1.260
policies=20
mean1383.956
σ0.146
min1383.850
max1384.172
mean940.000
σ0.000
min940.000
max940.000
mean440.000
σ4.619
min436.000
max444.000
mean2.299
σ0.013
min2.285
max2.315
policies=200
mean13848.151
σ0.174
min13848.029
max13848.400
mean9400.000
σ0.000
min9400.000
max9400.000
mean493.750
σ2.872
min490.000
max497.000
mean23.193
σ0.133
min23.080
max23.351