a56f9fab92706197eddc8686e9ab05989495e6a9

Home / Branches / austinplatt/db-playground / a56f9fab92706197eddc8686e9ab05989495e6a9

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
mean4.863
σ0.000
min4.863
max4.863

AST compact size (processProdDef)

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

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
mean57.818
σ0.362
min57.676
max58.848
mean419.000
σ0.000
min419.000
max419.000
mean0.148
σ0.005
min0.144
max0.155
cache=y
dps=1
iters=10
policies=100
mean46.898
σ0.007
min46.888
max46.907
mean419.000
σ0.000
min419.000
max419.000
mean0.129
σ0.005
min0.123
max0.138

CSV - indexed operations

Factorallocated MiBpeak allocated MiBtime (ms)
op=column_set() on indexed
mean36.605
σ0.000
min36.605
max36.605
mean4428.500
σ2226.680
min1484.000
max7409.000
mean12.236
σ0.403
min11.998
max13.189
op=column_set() on indexed, repeat
mean36.605
σ0.000
min36.605
max36.606
mean4608.500
σ2257.736
min1484.000
max7409.000
mean120.439
σ304.985
min11.437
max875.237
op=table_records(), no indexes
mean41.940
σ0.002
min41.938
max41.943
mean7409.000
σ0.000
min7409.000
max7409.000
mean11.427
σ1.114
min10.708
max14.159
op=table_records(), repeat
mean41.925
σ0.001
min41.924
max41.928
mean4199.500
σ1953.855
min1484.000
max7409.000
mean11.581
σ1.897
min10.697
max16.252
op=vertical_lookup_list() on indexed, after table_records()
mean27.634
σ0.137
min27.585
max27.972
mean4199.500
σ1953.855
min1484.000
max7409.000
mean8.917
σ1.285
min8.175
max12.036
op=vertical_lookup_list() on indexed, after table_records(), repeat
mean26.385
σ0.000
min26.385
max26.385
mean4199.500
σ1953.855
min1484.000
max7409.000
mean6.711
σ1.057
min6.167
max9.311
op=vertical_lookup_row_list() on 2 indexed
mean25.663
σ0.004
min25.662
max25.674
mean4608.500
σ2257.736
min1484.000
max7409.000
mean6.138
σ0.678
min5.672
max7.761
op=vertical_lookup_row_list() on 3 (1 unindexed)
mean25.962
σ0.001
min25.962
max25.964
mean4608.500
σ2257.736
min1484.000
max7409.000
mean5.995
σ0.633
min5.411
max7.431

CSV - loading a lazy table

Factorallocated MiBpeak allocated MiBtime (ms)
op=load_product(), no indexes
mean1021.599
σ0.002
min1021.597
max1021.602
mean7409.000
σ0.000
min7409.000
max7409.000
mean347.001
σ1.882
min345.011
max350.273
op=load_product(), with indexes
mean3495.846
σ0.455
min3495.685
max3496.971
mean3772.375
σ2310.423
min720.000
max7409.000
mean1722.487
σ617.040
min1384.082
max2979.834

CSV - unindexed operations

Factorallocated MiBpeak allocated MiBtime (ms)
op=column_set() on unindexed, dense, minor warmup
mean107.841
σ0.000
min107.841
max107.842
mean4199.500
σ1953.855
min1484.000
max7409.000
mean135.265
σ17.845
min123.207
max176.939
op=column_set() on unindexed, dense, repeat
mean62.069
σ0.001
min62.065
max62.070
mean4428.500
σ2226.680
min1484.000
max7409.000
mean100.949
σ164.901
min40.610
max509.037
op=vertical_lookup_list() repeated on unindexed missing Int
mean40.927
σ0.002
min40.926
max40.930
mean7409.000
σ0.000
min7409.000
max7409.000
mean110.240
σ247.258
min21.453
max722.137
op=vertical_lookup_row_list() on unindexed small unique Int
mean71.294
σ0.002
min71.293
max71.297
mean7409.000
σ0.000
min7409.000
max7409.000
mean60.354
σ9.159
min54.833
max80.758

CSV - warmup

Factorallocated MiBpeak allocated MiBtime (ms)
op=table_records()
mean4646.842
σ0.013
min4646.837
max4646.875
mean4199.500
σ1953.855
min1484.000
max7409.000
mean3232.455
σ733.480
min2512.715
max4495.880
op=vertical_lookup_list() on indexed
mean1973.830
σ0.002
min1973.829
max1973.833
mean7409.000
σ0.000
min7409.000
max7409.000
mean1020.610
σ203.499
min926.466
max1511.460
op=vertical_lookup_list() on unindexed missing Int, minor warmup
mean905.084
σ0.002
min905.082
max905.087
mean7409.000
σ0.000
min7409.000
max7409.000
mean401.413
σ42.377
min373.059
max505.218

CSV internal benchmark: pointedIndexFromKvs

Factorallocated MiBpeak allocated MiBtime (ms)
op=pointedIndexFromKvs
rows=200000
mean148.144
σ0.001
min148.144
max148.148
mean475.250
σ0.707
min475.000
max477.000
mean362.066
σ44.443
min309.991
max425.633
op=pointedIndexFromKvs
rows=400000
mean308.493
σ0.001
min308.493
max308.497
mean559.250
σ0.707
min559.000
max561.000
mean734.480
σ49.777
min647.534
max818.617

Marine Hull: transactPolicy

Factorallocated MiBpeak allocated MiBtime
datapoints=1
iterations=20
mean977.273
σ2.439
min976.423
max987.608
mean1048.400
σ295.530
min576.000
max1466.000
mean1.287
σ0.113
min1.211
max1.629

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.405
σ0.461
min0.143
max1.224
name=error_case.art
mean2.346
σ0.012
min2.340
max2.368
mean401.000
σ0.000
min401.000
max401.000
mean0.737
σ0.315
min0.580
max1.301
name=heavy_item.art
mean1.523
σ0.002
min1.522
max1.526
mean401.000
σ0.000
min401.000
max401.000
mean0.224
σ0.027
min0.204
max0.270
name=nested_use.art
mean2.364
σ0.002
min2.363
max2.367
mean401.000
σ0.000
min401.000
max401.000
mean0.340
σ0.018
min0.321
max0.370

Parser: Real World

Factorallocated MiBpeak allocated MiBtime (sec)
name=aon_gpf25_7k_loc.art
mean964.978
σ0.009
min964.973
max964.995
mean430.000
σ0.000
min430.000
max430.000
mean0.555
σ0.042
min0.500
max0.607
name=cdr_enhanced_4k_loc.art
mean886.000
σ0.002
min885.999
max886.003
mean430.000
σ0.000
min430.000
max430.000
mean0.442
σ0.029
min0.409
max0.478

Parser: Record Parsing

Factorallocated MiBpeak allocated MiBtime (ms)
name=record_render_large_success.art
mean7.719
σ0.002
min7.718
max7.722
mean430.000
σ0.000
min430.000
max430.000
mean1.979
σ0.069
min1.842
max2.259
name=record_render_large_syntax_err.art
mean7.667
σ0.002
min7.666
max7.670
mean430.000
σ0.000
min430.000
max430.000
mean1.955
σ0.065
min1.830
max2.170
name=record_render_success.art
mean2.290
σ0.002
min2.290
max2.294
mean430.000
σ0.000
min430.000
max430.000
mean0.306
σ0.012
min0.290
max0.384
name=record_render_syntax_err.art
mean2.166
σ0.002
min2.165
max2.169
mean430.000
σ0.000
min430.000
max430.000
mean0.291
σ0.007
min0.274
max0.320

Revision Creation

Factorallocated MiBpeak allocated MiBtime_s
number of threads=8
revision count=1000
mean11.798
σ11.853
min0.574
max88.724
mean462.482
σ21.174
min406.000
max481.000
mean0.027
σ0.029
min0.001
max0.231

SoV import

Factorallocated MiBpeak allocated MiBtime_s
iters=10
rows=1000
mean294.189
σ1.037
min293.703
max297.129
mean440.500
σ16.467
min414.000
max459.000
mean0.585
σ0.025
min0.533
max0.609

Timed compile per phase

Factorallocated MiBpeak allocated MiBtime (ms)
phase=buildDeclTree
mean106.546
σ0.000
min106.546
max106.546
mean848.000
σ0.000
min848.000
max848.000
mean149.356
σ9.875
min136.239
max161.667
phase=macro expansion
mean5.894
σ0.000
min5.894
max5.894
mean848.000
σ0.000
min848.000
max848.000
mean8.723
σ0.693
min7.027
max9.095
phase=parser
mean1042.131
σ0.000
min1042.131
max1042.132
mean848.000
σ0.000
min848.000
max848.000
mean590.113
σ58.570
min445.521
max615.574
phase=processProdDef
mean2241.193
σ0.000
min2241.193
max2241.193
mean848.000
σ0.000
min848.000
max848.000
mean3053.242
σ195.576
min2816.467
max3299.384
phase=renaming
mean21.430
σ0.000
min21.430
max21.430
mean848.000
σ0.000
min848.000
max848.000
mean45.435
σ2.649
min39.132
max47.318
phase=type checker
mean958.466
σ0.047
min958.443
max958.568
mean848.000
σ0.000
min848.000
max848.000
mean666.763
σ13.427
min644.187
max682.606

Workflow: transactPolicy

Factorallocated MiBpeak allocated MiBtime
iters=5
new-facts=1
prior-facts=1
mean328.221
σ0.041
min328.163
max328.265
mean441.600
σ5.128
min434.000
max446.000
mean0.436
σ0.010
min0.426
max0.452
iters=5
new-facts=1
prior-facts=6402
mean1313.428
σ0.139
min1313.304
max1313.660
mean1091.600
σ176.754
min883.000
max1311.000
mean1.970
σ0.127
min1.836
max2.139
iters=5
new-facts=6402
prior-facts=1
mean1552.416
σ3.051
min1550.899
max1557.868
mean640.400
σ70.390
min543.000
max731.000
mean2.237
σ0.119
min2.115
max2.384
iters=5
new-facts=6402
prior-facts=6402
mean1875.435
σ0.061
min1875.363
max1875.519
mean1723.200
σ208.295
min1449.000
max1922.000
mean2.982
σ0.137
min2.834
max3.174

newProductH/cdr_auton/broker

Factortime_s
iterations=5
mean1.625
σ0.043
min1.581
max1.687

policy addition benchmark

Factorallocated MiBdb queriespeak allocated MiBtime
policies=2
mean420.296
σ509.314
min165.636
max1184.267
mean103.750
σ7.500
min100.000
max115.000
mean434.000
σ0.000
min434.000
max434.000
mean0.533
σ0.513
min0.273
max1.303
policies=20
mean1656.581
σ0.394
min1656.346
max1657.169
mean1000.000
σ0.000
min1000.000
max1000.000
mean453.250
σ12.945
min438.000
max464.000
mean2.675
σ0.012
min2.658
max2.687
policies=200
mean16573.869
σ0.079
min16573.817
max16573.987
mean10000.000
σ0.000
min10000.000
max10000.000
mean500.750
σ5.560
min494.000
max507.000
mean27.001
σ0.108
min26.882
max27.100