5238e338bc0452eeef1c1112caa65f4b894ce49c

Home / Branches / sergei/exp-1738-handle-long-text-values-in-st-columns / 5238e338bc0452eeef1c1112caa65f4b894ce49c

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.718
σ0.367
min54.571
max55.761
mean416.000
σ0.000
min416.000
max416.000
mean0.139
σ0.005
min0.134
max0.150
cache=y
dps=1
iters=10
policies=100
mean43.777
σ0.008
min43.762
max43.787
mean416.000
σ0.000
min416.000
max416.000
mean0.124
σ0.004
min0.120
max0.131

CSV - indexed operations

Factorallocated MiBpeak allocated MiBtime (ms)
op=column_set() on indexed
mean36.604
σ0.000
min36.604
max36.605
mean4425.125
σ2227.522
min1483.000
max7406.000
mean12.293
σ0.270
min12.097
max12.785
op=column_set() on indexed, repeat
mean36.605
σ0.000
min36.604
max36.605
mean4605.750
σ2258.816
min1483.000
max7406.000
mean156.545
σ407.325
min11.557
max1164.623
op=table_records(), no indexes
mean41.939
σ0.002
min41.938
max41.942
mean7406.000
σ0.000
min7406.000
max7406.000
mean11.054
σ0.278
min10.811
max11.658
op=table_records(), repeat
mean41.925
σ0.001
min41.924
max41.928
mean4196.625
σ1955.168
min1483.000
max7406.000
mean11.467
σ1.800
min10.638
max15.903
op=vertical_lookup_list() on indexed, after table_records()
mean27.633
σ0.137
min27.584
max27.971
mean4196.625
σ1955.168
min1483.000
max7406.000
mean9.008
σ1.261
min8.069
max12.083
op=vertical_lookup_list() on indexed, after table_records(), repeat
mean26.384
σ0.000
min26.384
max26.384
mean4196.625
σ1955.168
min1483.000
max7406.000
mean7.030
σ0.905
min6.476
max9.252
op=vertical_lookup_row_list() on 2 indexed
mean25.662
σ0.004
min25.661
max25.673
mean4605.750
σ2258.816
min1483.000
max7406.000
mean6.389
σ1.129
min5.770
max9.149
op=vertical_lookup_row_list() on 3 (1 unindexed)
mean25.961
σ0.000
min25.961
max25.962
mean4605.750
σ2258.816
min1483.000
max7406.000
mean6.243
σ1.089
min5.678
max8.916

CSV - loading a lazy table

Factorallocated MiBpeak allocated MiBtime (ms)
op=load_product(), no indexes
mean1021.608
σ0.002
min1021.606
max1021.611
mean7406.000
σ0.000
min7406.000
max7406.000
mean345.782
σ2.612
min341.861
max349.762
op=load_product(), with indexes
mean3495.854
σ0.454
min3495.694
max3496.977
mean3770.000
σ2311.017
min720.000
max7406.000
mean1706.374
σ592.813
min1387.929
max2941.555

CSV - unindexed operations

Factorallocated MiBpeak allocated MiBtime (ms)
op=column_set() on unindexed, dense, minor warmup
mean107.841
σ0.000
min107.840
max107.841
mean4196.625
σ1955.168
min1483.000
max7406.000
mean136.318
σ15.392
min128.847
max174.289
op=column_set() on unindexed, dense, repeat
mean62.068
σ0.001
min62.065
max62.069
mean4425.125
σ2227.522
min1483.000
max7406.000
mean94.192
σ147.976
min40.763
max460.405
op=vertical_lookup_list() repeated on unindexed missing Int
mean40.926
σ0.002
min40.925
max40.929
mean7406.000
σ0.000
min7406.000
max7406.000
mean123.868
σ287.400
min21.629
max835.142
op=vertical_lookup_row_list() on unindexed small unique Int
mean71.294
σ0.002
min71.292
max71.296
mean7406.000
σ0.000
min7406.000
max7406.000
mean60.199
σ10.105
min55.221
max84.825

CSV - warmup

Factorallocated MiBpeak allocated MiBtime (ms)
op=table_records()
mean4646.842
σ0.013
min4646.837
max4646.875
mean4196.625
σ1955.168
min1483.000
max7406.000
mean3271.337
σ721.403
min2538.714
max4468.528
op=vertical_lookup_list() on indexed
mean1973.829
σ0.002
min1973.827
max1973.831
mean7406.000
σ0.000
min7406.000
max7406.000
mean1014.738
σ174.846
min931.700
max1433.495
op=vertical_lookup_list() on unindexed missing Int, minor warmup
mean905.083
σ0.002
min905.080
max905.086
mean7406.000
σ0.000
min7406.000
max7406.000
mean397.092
σ3.020
min392.944
max400.925

CSV internal benchmark: pointedIndexFromKvs

Factorallocated MiBpeak allocated MiBtime (ms)
op=pointedIndexFromKvs
rows=200000
mean148.144
σ0.001
min148.144
max148.148
mean476.125
σ1.553
min474.000
max479.000
mean387.928
σ27.447
min346.520
max431.036
op=pointedIndexFromKvs
rows=400000
mean308.493
σ0.001
min308.493
max308.497
mean564.375
σ1.768
min560.000
max565.000
mean731.840
σ57.227
min643.875
max826.185

Marine Hull: transactPolicy

Factorallocated MiBpeak allocated MiBtime
datapoints=1
iterations=20
mean964.530
σ1.821
min963.823
max972.232
mean1040.350
σ314.983
min561.000
max1500.000
mean1.282
σ0.112
min1.174
max1.508

Parser: Comma Sep

Factorallocated MiBpeak allocated MiBtime (ms)
name=ambiguous_item.art
mean0.913
σ0.020
min0.903
max0.949
mean403.000
σ0.000
min403.000
max403.000
mean0.323
σ0.330
min0.142
max0.906
name=error_case.art
mean2.346
σ0.012
min2.340
max2.368
mean403.000
σ0.000
min403.000
max403.000
mean0.570
σ0.348
min0.311
max1.049
name=heavy_item.art
mean1.523
σ0.002
min1.522
max1.526
mean403.000
σ0.000
min403.000
max403.000
mean0.215
σ0.026
min0.196
max0.260
name=nested_use.art
mean2.364
σ0.002
min2.363
max2.367
mean403.000
σ0.000
min403.000
max403.000
mean0.330
σ0.022
min0.310
max0.367

Parser: Real World

Factorallocated MiBpeak allocated MiBtime (sec)
name=aon_gpf25_7k_loc.art
mean964.839
σ0.009
min964.834
max964.855
mean431.800
σ1.789
min431.000
max435.000
mean0.486
σ0.059
min0.410
max0.539
name=cdr_enhanced_4k_loc.art
mean885.913
σ0.002
min885.912
max885.915
mean444.000
σ0.000
min444.000
max444.000
mean0.453
σ0.044
min0.420
max0.519

Parser: Record Parsing

Factorallocated MiBpeak allocated MiBtime (ms)
name=record_render_large_success.art
mean7.718
σ0.002
min7.717
max7.721
mean444.000
σ0.000
min444.000
max444.000
mean2.659
σ0.104
min2.460
max3.169
name=record_render_large_syntax_err.art
mean7.667
σ0.002
min7.666
max7.670
mean444.000
σ0.000
min444.000
max444.000
mean2.684
σ0.098
min2.510
max2.952
name=record_render_success.art
mean2.290
σ0.002
min2.289
max2.293
mean444.000
σ0.000
min444.000
max444.000
mean0.309
σ0.044
min0.287
max0.654
name=record_render_syntax_err.art
mean2.165
σ0.002
min2.164
max2.168
mean444.000
σ0.000
min444.000
max444.000
mean0.285
σ0.007
min0.273
max0.329

Revision Creation

Factorallocated MiBpeak allocated MiBtime_s
number of threads=8
revision count=1000
mean12.025
σ10.948
min0.574
max82.444
mean454.393
σ16.087
min409.000
max470.000
mean0.027
σ0.027
min0.001
max0.194

SoV import

Factorallocated MiBpeak allocated MiBtime_s
iters=10
rows=1000
mean278.676
σ1.019
min278.193
max281.564
mean447.900
σ19.508
min417.000
max481.000
mean0.583
σ0.015
min0.554
max0.607

Timed compile per phase

Factorallocated MiBpeak allocated MiBtime (ms)
phase=buildDeclTree
mean169.257
σ0.000
min169.257
max169.257
mean851.000
σ0.000
min851.000
max851.000
mean238.696
σ6.011
min228.883
max245.624
phase=macro expansion
mean5.900
σ0.000
min5.900
max5.900
mean850.500
σ1.414
min847.000
max851.000
mean6.335
σ1.200
min5.855
max9.303
phase=parser
mean1041.965
σ0.000
min1041.964
max1041.965
mean850.500
σ1.414
min847.000
max851.000
mean478.727
σ108.244
min375.414
max588.053
phase=processProdDef
mean2243.717
σ0.000
min2243.717
max2243.717
mean851.000
σ0.000
min851.000
max851.000
mean2790.729
σ273.317
min2310.143
max3186.231
phase=renaming
mean21.436
σ0.000
min21.436
max21.436
mean850.500
σ1.414
min847.000
max851.000
mean29.527
σ8.999
min20.199
max42.407
phase=type checker
mean958.596
σ0.047
min958.573
max958.698
mean850.500
σ1.414
min847.000
max851.000
mean637.473
σ28.117
min608.890
max681.015

Workflow: transactPolicy

Factorallocated MiBpeak allocated MiBtime
iters=5
new-facts=1
prior-facts=1
mean282.359
σ0.034
min282.313
max282.395
mean441.000
σ2.739
min439.000
max444.000
mean0.389
σ0.015
min0.375
max0.411
iters=5
new-facts=1
prior-facts=6402
mean1267.609
σ0.112
min1267.454
max1267.771
mean1088.000
σ183.966
min869.000
max1324.000
mean1.999
σ0.179
min1.801
max2.184
iters=5
new-facts=6402
prior-facts=1
mean1506.518
σ2.953
min1504.994
max1511.790
mean629.200
σ81.315
min505.000
max719.000
mean2.143
σ0.142
min2.053
max2.386
iters=5
new-facts=6402
prior-facts=6402
mean1829.578
σ0.029
min1829.534
max1829.605
mean1738.000
σ199.079
min1466.000
max1926.000
mean2.886
σ0.043
min2.826
max2.947

newProductH/cdr_auton/broker

Factortime_s
iterations=5
mean1.745
σ0.066
min1.633
max1.794

policy addition benchmark

Factorallocated MiBdb queriespeak allocated MiBtime
policies=2
mean393.851
σ509.574
min139.060
max1158.213
mean99.750
σ7.500
min96.000
max111.000
mean441.000
σ0.000
min441.000
max441.000
mean0.492
σ0.506
min0.230
max1.250
policies=20
mean1390.728
σ0.167
min1390.611
max1390.975
mean960.000
σ0.000
min960.000
max960.000
mean445.750
σ9.500
min441.000
max460.000
mean2.321
σ0.021
min2.299
max2.349
policies=200
mean13915.803
σ0.116
min13915.653
max13915.915
mean9600.000
σ0.000
min9600.000
max9600.000
mean494.250
σ4.573
min489.000
max499.000
mean23.328
σ0.101
min23.206
max23.438