746b4a73ed3ce4a903cf4f6bf41dfbaf7d45c41f

Home / Branches / gosha/exp-1708-fix-facility-level-grouping-and-summing-in-the-supertable / 746b4a73ed3ce4a903cf4f6bf41dfbaf7d45c41f

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.715
σ0.366
min54.581
max55.757
mean419.000
σ0.000
min419.000
max419.000
mean0.139
σ0.005
min0.133
max0.149
cache=y
dps=1
iters=10
policies=100
mean43.777
σ0.008
min43.769
max43.791
mean419.000
σ0.000
min419.000
max419.000
mean0.122
σ0.004
min0.117
max0.131

CSV - indexed operations

Factorallocated MiBpeak allocated MiBtime (ms)
op=column_set() on indexed
mean36.604
σ0.000
min36.604
max36.605
mean4423.250
σ2226.591
min1484.000
max7405.000
mean13.185
σ3.521
min11.736
max21.890
op=column_set() on indexed, repeat
mean36.605
σ0.000
min36.604
max36.605
mean4604.625
σ2257.706
min1484.000
max7405.000
mean122.168
σ306.101
min12.604
max879.694
op=table_records(), no indexes
mean41.939
σ0.002
min41.938
max41.942
mean7405.000
σ0.000
min7405.000
max7405.000
mean11.011
σ0.156
min10.870
max11.326
op=table_records(), repeat
mean41.924
σ0.000
min41.924
max41.925
mean4194.625
σ1953.890
min1484.000
max7405.000
mean11.555
σ1.665
min10.692
max15.640
op=vertical_lookup_list() on indexed, after table_records()
mean27.633
σ0.136
min27.584
max27.971
mean4194.625
σ1953.890
min1484.000
max7405.000
mean9.153
σ1.225
min8.419
max12.076
op=vertical_lookup_list() on indexed, after table_records(), repeat
mean26.384
σ0.000
min26.384
max26.384
mean4194.625
σ1953.890
min1484.000
max7405.000
mean7.094
σ1.016
min6.561
max9.593
op=vertical_lookup_row_list() on 2 indexed
mean25.662
σ0.004
min25.661
max25.673
mean4604.625
σ2257.706
min1484.000
max7405.000
mean6.686
σ1.293
min5.866
max9.164
op=vertical_lookup_row_list() on 3 (1 unindexed)
mean25.961
σ0.001
min25.961
max25.962
mean4604.625
σ2257.706
min1484.000
max7405.000
mean6.430
σ1.251
min5.780
max9.325

CSV - loading a lazy table

Factorallocated MiBpeak allocated MiBtime (ms)
op=load_product(), no indexes
mean1021.608
σ0.002
min1021.606
max1021.611
mean7405.000
σ0.000
min7405.000
max7405.000
mean350.740
σ5.569
min346.110
max363.379
op=load_product(), with indexes
mean3495.855
σ0.454
min3495.694
max3496.978
mean3769.000
σ2309.691
min720.000
max7405.000
mean1774.776
σ624.181
min1404.636
max2790.531

CSV - unindexed operations

Factorallocated MiBpeak allocated MiBtime (ms)
op=column_set() on unindexed, dense, minor warmup
mean107.841
σ0.000
min107.840
max107.841
mean4194.625
σ1953.890
min1484.000
max7405.000
mean135.782
σ16.846
min125.574
max175.735
op=column_set() on unindexed, dense, repeat
mean62.068
σ0.001
min62.065
max62.069
mean4423.250
σ2226.591
min1484.000
max7405.000
mean154.243
σ315.834
min40.802
max935.884
op=vertical_lookup_list() repeated on unindexed missing Int
mean40.926
σ0.002
min40.925
max40.929
mean7405.000
σ0.000
min7405.000
max7405.000
mean86.514
σ182.960
min21.598
max539.315
op=vertical_lookup_row_list() on unindexed small unique Int
mean71.294
σ0.002
min71.292
max71.296
mean7405.000
σ0.000
min7405.000
max7405.000
mean58.952
σ9.371
min55.355
max82.135

CSV - warmup

Factorallocated MiBpeak allocated MiBtime (ms)
op=table_records()
mean4646.842
σ0.013
min4646.837
max4646.875
mean4194.625
σ1953.890
min1484.000
max7405.000
mean3183.626
σ651.927
min2516.221
max4084.253
op=vertical_lookup_list() on indexed
mean1973.829
σ0.002
min1973.827
max1973.831
mean7405.000
σ0.000
min7405.000
max7405.000
mean990.085
σ99.766
min935.134
max1209.817
op=vertical_lookup_list() on unindexed missing Int, minor warmup
mean905.083
σ0.002
min905.080
max905.086
mean7405.000
σ0.000
min7405.000
max7405.000
mean395.108
σ4.498
min384.433
max399.583

CSV internal benchmark: pointedIndexFromKvs

Factorallocated MiBpeak allocated MiBtime (ms)
op=pointedIndexFromKvs
rows=200000
mean148.144
σ0.001
min148.144
max148.148
mean475.750
σ0.463
min475.000
max476.000
mean360.737
σ28.872
min312.338
max397.176
op=pointedIndexFromKvs
rows=400000
mean308.493
σ0.001
min308.493
max308.497
mean563.000
σ0.000
min563.000
max563.000
mean717.300
σ60.229
min614.365
max811.328

Marine Hull: transactPolicy

Factorallocated MiBpeak allocated MiBtime
datapoints=1
iterations=20
mean964.563
σ1.880
min963.842
max972.515
mean1059.450
σ319.719
min553.000
max1534.000
mean1.317
σ0.174
min1.182
max1.734

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.284
σ0.275
min0.131
max0.770
name=error_case.art
mean2.346
σ0.012
min2.340
max2.368
mean402.000
σ0.000
min402.000
max402.000
mean0.469
σ0.334
min0.303
max1.066
name=heavy_item.art
mean1.523
σ0.002
min1.522
max1.526
mean402.000
σ0.000
min402.000
max402.000
mean0.223
σ0.026
min0.204
max0.268
name=nested_use.art
mean2.364
σ0.002
min2.363
max2.367
mean402.000
σ0.000
min402.000
max402.000
mean0.331
σ0.019
min0.314
max0.360

Parser: Real World

Factorallocated MiBpeak allocated MiBtime (sec)
name=aon_gpf25_7k_loc.art
mean964.979
σ0.009
min964.974
max964.996
mean431.000
σ0.000
min431.000
max431.000
mean0.601
σ0.012
min0.585
max0.612
name=cdr_enhanced_4k_loc.art
mean886.001
σ0.002
min886.000
max886.004
mean431.000
σ0.000
min431.000
max431.000
mean0.487
σ0.029
min0.445
max0.524

Parser: Record Parsing

Factorallocated MiBpeak allocated MiBtime (ms)
name=record_render_large_success.art
mean7.719
σ0.002
min7.718
max7.722
mean431.000
σ0.000
min431.000
max431.000
mean2.674
σ0.124
min2.439
max3.139
name=record_render_large_syntax_err.art
mean7.667
σ0.002
min7.666
max7.670
mean431.000
σ0.000
min431.000
max431.000
mean2.250
σ0.352
min1.879
max3.011
name=record_render_success.art
mean2.290
σ0.002
min2.290
max2.294
mean431.000
σ0.000
min431.000
max431.000
mean0.307
σ0.008
min0.294
max0.350
name=record_render_syntax_err.art
mean2.166
σ0.002
min2.165
max2.169
mean431.000
σ0.000
min431.000
max431.000
mean0.298
σ0.037
min0.280
max0.651

Revision Creation

Factorallocated MiBpeak allocated MiBtime_s
number of threads=8
revision count=1000
mean11.389
σ11.554
min0.577
max91.887
mean461.260
σ18.755
min408.000
max479.000
mean0.026
σ0.028
min0.001
max0.220

SoV import

Factorallocated MiBpeak allocated MiBtime_s
iters=10
rows=1000
mean279.138
σ1.036
min278.751
max282.083
mean443.300
σ14.697
min425.000
max468.000
mean0.583
σ0.020
min0.546
max0.624

Timed compile per phase

Factorallocated MiBpeak allocated MiBtime (ms)
phase=buildDeclTree
mean169.257
σ0.000
min169.257
max169.257
mean848.000
σ0.000
min848.000
max848.000
mean216.337
σ20.876
min192.759
max246.195
phase=macro expansion
mean5.896
σ0.000
min5.896
max5.896
mean848.000
σ0.000
min848.000
max848.000
mean6.280
σ1.122
min5.765
max9.045
phase=parser
mean1042.138
σ0.000
min1042.137
max1042.138
mean848.000
σ0.000
min848.000
max848.000
mean434.834
σ106.623
min372.726
max615.136
phase=processProdDef
mean2243.714
σ0.000
min2243.714
max2243.714
mean848.000
σ0.000
min848.000
max848.000
mean2819.547
σ192.113
min2537.270
max3042.462
phase=renaming
mean21.436
σ0.000
min21.436
max21.436
mean848.000
σ0.000
min848.000
max848.000
mean35.698
σ4.997
min32.535
max47.778
phase=type checker
mean958.600
σ0.047
min958.577
max958.702
mean848.000
σ0.000
min848.000
max848.000
mean663.013
σ17.641
min635.864
max678.844

Workflow: transactPolicy

Factorallocated MiBpeak allocated MiBtime
iters=5
new-facts=1
prior-facts=1
mean282.856
σ0.038
min282.800
max282.892
mean440.800
σ3.834
min438.000
max445.000
mean0.379
σ0.003
min0.376
max0.384
iters=5
new-facts=1
prior-facts=6402
mean1268.131
σ0.076
min1268.051
max1268.237
mean1090.800
σ168.035
min891.000
max1320.000
mean2.220
σ0.168
min2.034
max2.450
iters=5
new-facts=6402
prior-facts=1
mean1507.030
σ2.942
min1505.498
max1512.281
mean625.200
σ86.436
min496.000
max726.000
mean2.186
σ0.079
min2.118
max2.303
iters=5
new-facts=6402
prior-facts=6402
mean1830.073
σ0.059
min1830.004
max1830.130
mean1720.600
σ189.639
min1453.000
max1892.000
mean2.990
σ0.315
min2.652
max3.501

newProductH/cdr_auton/broker

Factortime_s
iterations=5
mean1.744
σ0.100
min1.587
max1.838

policy addition benchmark

Factorallocated MiBdb queriespeak allocated MiBtime
policies=2
mean406.197
σ509.796
min151.294
max1170.891
mean101.750
σ7.500
min98.000
max113.000
mean439.000
σ0.000
min439.000
max439.000
mean0.511
σ0.510
min0.250
max1.276
policies=20
mean1513.150
σ0.273
min1512.971
max1513.555
mean980.000
σ0.000
min980.000
max980.000
mean443.000
σ4.619
min439.000
max447.000
mean2.500
σ0.012
min2.484
max2.510
policies=200
mean15140.026
σ0.118
min15139.878
max15140.163
mean9800.000
σ0.000
min9800.000
max9800.000
mean491.000
σ4.243
min487.000
max496.000
mean25.280
σ0.076
min25.178
max25.361