e60993f95c140cbbc8b53f722feae430c3c9c36d

Home / Branches / alexfmpe/qa-32-useracl-merge-queries / e60993f95c140cbbc8b53f722feae430c3c9c36d

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 Decls)

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

AST compact size (processProdDef)

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

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.781
σ0.368
min54.646
max55.828
mean417.000
σ0.000
min417.000
max417.000
mean0.147
σ0.010
min0.137
max0.166
cache=y
dps=1
iters=10
policies=100
mean43.770
σ0.008
min43.758
max43.780
mean417.000
σ0.000
min417.000
max417.000
mean0.126
σ0.007
min0.118
max0.140

CSV - indexed operations

Factorallocated MiBpeak allocated MiBtime (ms)
op=column_set() on indexed
mean36.617
σ0.000
min36.617
max36.618
mean4499.500
σ2215.588
min1472.000
max7306.000
mean12.301
σ0.378
min11.925
max12.914
op=column_set() on indexed, repeat
mean36.617
σ0.000
min36.617
max36.618
mean4499.500
σ2215.588
min1472.000
max7306.000
mean11.938
σ0.667
min11.492
max13.511
op=table_records(), no indexes
mean41.948
σ0.002
min41.946
max41.951
mean7306.000
σ0.000
min7306.000
max7306.000
mean11.466
σ0.993
min10.932
max13.893
op=table_records(), repeat
mean41.933
σ0.000
min41.933
max41.934
mean4499.500
σ2215.588
min1472.000
max7306.000
mean10.967
σ0.143
min10.691
max11.133
op=vertical_lookup_list() on indexed, after table_records()
mean27.655
σ0.137
min27.606
max27.993
mean4499.500
σ2215.588
min1472.000
max7306.000
mean8.477
σ0.347
min8.014
max8.827
op=vertical_lookup_list() on indexed, after table_records(), repeat
mean26.406
σ0.000
min26.406
max26.406
mean4499.500
σ2215.588
min1472.000
max7306.000
mean6.672
σ0.280
min6.171
max6.958
op=vertical_lookup_row_list() on 2 indexed
mean25.681
σ0.003
min25.680
max25.688
mean4499.500
σ2215.588
min1472.000
max7306.000
mean5.924
σ0.078
min5.813
max6.020
op=vertical_lookup_row_list() on 3 (1 unindexed)
mean25.984
σ0.000
min25.984
max25.985
mean4499.500
σ2215.588
min1472.000
max7306.000
mean5.823
σ0.072
min5.741
max5.980

CSV - loading a lazy table

Factorallocated MiBpeak allocated MiBtime (ms)
op=load_product(), no indexes
mean1021.627
σ0.002
min1021.625
max1021.629
mean7306.000
σ0.000
min7306.000
max7306.000
mean346.837
σ1.639
min344.993
max349.258
op=load_product(), with indexes
mean3495.878
σ0.468
min3495.713
max3497.036
mean3676.625
σ2246.596
min723.000
max7306.000
mean1521.286
σ387.040
min1377.096
max2479.059

CSV - unindexed operations

Factorallocated MiBpeak allocated MiBtime (ms)
op=column_set() on unindexed, dense, minor warmup
mean107.854
σ0.000
min107.853
max107.854
mean4499.500
σ2215.588
min1472.000
max7306.000
mean132.071
σ9.147
min124.112
max147.089
op=column_set() on unindexed, dense, repeat
mean62.081
σ0.000
min62.081
max62.082
mean4499.500
σ2215.588
min1472.000
max7306.000
mean43.092
σ1.372
min41.497
max45.538
op=vertical_lookup_list() repeated on unindexed missing Int
mean40.948
σ0.002
min40.947
max40.950
mean7306.000
σ0.000
min7306.000
max7306.000
mean43.183
σ58.600
min21.764
max188.170
op=vertical_lookup_row_list() on unindexed small unique Int
mean71.308
σ0.002
min71.307
max71.310
mean7306.000
σ0.000
min7306.000
max7306.000
mean61.352
σ13.043
min56.000
max93.614

CSV - warmup

Factorallocated MiBpeak allocated MiBtime (ms)
op=table_records()
mean4646.851
σ0.013
min4646.845
max4646.883
mean4499.500
σ2215.588
min1472.000
max7306.000
mean3491.166
σ687.376
min2522.615
max4418.073
op=vertical_lookup_list() on indexed
mean1973.851
σ0.002
min1973.849
max1973.854
mean7306.000
σ0.000
min7306.000
max7306.000
mean1052.067
σ243.790
min920.856
max1590.755
op=vertical_lookup_list() on unindexed missing Int, minor warmup
mean905.105
σ0.002
min905.102
max905.108
mean7306.000
σ0.000
min7306.000
max7306.000
mean406.319
σ38.436
min390.238
max501.396

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
mean393.641
σ19.664
min372.713
max435.127
op=pointedIndexFromKvs
rows=400000
mean308.493
σ0.001
min308.493
max308.497
mean558.000
σ1.069
min557.000
max559.000
mean774.060
σ49.135
min677.356
max836.699

Marine Hull: transactPolicy

Factorallocated MiBpeak allocated MiBtime
datapoints=1
iterations=20
mean963.617
σ1.817
min962.913
max971.301
mean1048.500
σ312.491
min591.000
max1508.000
mean1.309
σ0.172
min1.167
max1.754

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.393
σ0.489
min0.146
max1.264
name=error_case.art
mean2.340
σ0.012
min2.334
max2.362
mean402.000
σ0.000
min402.000
max402.000
mean0.474
σ0.319
min0.320
max1.044
name=heavy_item.art
mean1.523
σ0.002
min1.521
max1.525
mean402.000
σ0.000
min402.000
max402.000
mean0.217
σ0.018
min0.205
max0.248
name=nested_use.art
mean2.358
σ0.002
min2.357
max2.361
mean402.000
σ0.000
min402.000
max402.000
mean0.325
σ0.021
min0.310
max0.362

Parser: Real World

Factorallocated MiBpeak allocated MiBtime (sec)
name=aon_gpf25_7k_loc.art
mean964.971
σ0.011
min964.965
max964.989
mean436.000
σ2.236
min432.000
max437.000
mean0.558
σ0.052
min0.492
max0.617
name=cdr_enhanced_4k_loc.art
mean885.898
σ0.002
min885.897
max885.901
mean440.000
σ0.000
min440.000
max440.000
mean0.473
σ0.023
min0.461
max0.513

Parser: Record Parsing

Factorallocated MiBpeak allocated MiBtime (ms)
name=record_render_large_success.art
mean7.710
σ0.002
min7.709
max7.713
mean440.000
σ0.000
min440.000
max440.000
mean2.580
σ0.104
min2.404
max3.174
name=record_render_large_syntax_err.art
mean7.658
σ0.002
min7.657
max7.661
mean440.000
σ0.000
min440.000
max440.000
mean2.630
σ0.110
min2.463
max2.919
name=record_render_success.art
mean2.290
σ0.002
min2.289
max2.293
mean440.000
σ0.000
min440.000
max440.000
mean0.305
σ0.008
min0.289
max0.354
name=record_render_syntax_err.art
mean2.165
σ0.002
min2.164
max2.168
mean440.000
σ0.000
min440.000
max440.000
mean0.292
σ0.011
min0.275
max0.373

Revision Creation

Factorallocated MiBpeak allocated MiBtime_s
number of threads=8
revision count=1000
mean11.897
σ11.239
min0.577
max95.806
mean463.989
σ20.104
min410.000
max480.000
mean0.027
σ0.028
min0.001
max0.228

SoV import

Factorallocated MiBpeak allocated MiBtime_s
iters=10
rows=1000
mean278.456
σ1.052
min277.992
max281.437
mean444.200
σ17.184
min419.000
max470.000
mean0.584
σ0.011
min0.562
max0.602

Timed compile per phase

Factorallocated MiBpeak allocated MiBtime (ms)
phase=buildDeclTree
mean173.738
σ0.000
min173.738
max173.738
mean845.000
σ0.000
min845.000
max845.000
mean215.430
σ33.792
min153.323
max255.873
phase=macro expansion
mean6.130
σ0.000
min6.130
max6.130
mean844.250
σ2.121
min839.000
max845.000
mean9.792
σ0.431
min9.395
max10.808
phase=parser
mean1042.435
σ0.000
min1042.434
max1042.435
mean844.250
σ2.121
min839.000
max845.000
mean595.827
σ11.439
min569.946
max606.195
phase=processProdDef
mean2243.975
σ0.000
min2243.975
max2243.975
mean845.000
σ0.000
min845.000
max845.000
mean2998.492
σ561.973
min1961.054
max3537.927
phase=renaming
mean21.675
σ0.000
min21.675
max21.675
mean844.250
σ2.121
min839.000
max845.000
mean40.658
σ0.601
min39.388
max41.266
phase=type checker
mean989.752
σ0.066
min989.654
max989.841
mean844.250
σ2.121
min839.000
max845.000
mean707.376
σ37.253
min674.659
max784.323

Workflow: transactPolicy

Factorallocated MiBpeak allocated MiBtime
iters=5
new-facts=1
prior-facts=1
mean282.030
σ0.034
min281.980
max282.061
mean443.000
σ0.000
min443.000
max443.000
mean0.379
σ0.008
min0.375
max0.394
iters=5
new-facts=1
prior-facts=6402
mean1266.763
σ0.102
min1266.654
max1266.931
mean1113.800
σ185.439
min895.000
max1370.000
mean1.992
σ0.084
min1.895
max2.073
iters=5
new-facts=6402
prior-facts=1
mean1505.732
σ2.922
min1504.242
max1510.949
mean623.600
σ87.751
min493.000
max726.000
mean2.267
σ0.189
min2.103
max2.565
iters=5
new-facts=6402
prior-facts=6402
mean1828.762
σ0.086
min1828.653
max1828.883
mean1750.600
σ208.062
min1486.000
max1950.000
mean3.147
σ0.254
min2.814
max3.457

newProductH/cdr_auton/broker

Factortime_s
iterations=5
mean1.764
σ0.117
min1.565
max1.862

policy addition benchmark

Factorallocated MiBdb queriespeak allocated MiBtime
policies=2
mean397.020
σ518.049
min137.993
max1174.095
mean95.500
σ7.000
min92.000
max106.000
mean443.000
σ0.000
min443.000
max443.000
mean0.504
σ0.533
min0.236
max1.303
policies=20
mean1380.088
σ0.160
min1379.979
max1380.325
mean920.000
σ0.000
min920.000
max920.000
mean447.000
σ8.000
min443.000
max459.000
mean2.318
σ0.014
min2.298
max2.330
policies=200
mean13809.191
σ0.125
min13809.054
max13809.356
mean9200.000
σ0.000
min9200.000
max9200.000
mean499.500
σ4.203
min494.000
max504.000
mean23.445
σ0.121
min23.322
max23.554