00b884f42b2aa4e434d1e74bfe0802c715ec8d8d

Home / Branches / cursor/permission-label-noted-parentheses-7ef3 / 00b884f42b2aa4e434d1e74bfe0802c715ec8d8d

Aggregation: measureAggregations

Factorallocated MiBpeak allocated MiBtime_s
cache=n
dps=1
iters=10
policies=100
mean54.617
σ0.351
min54.482
max55.614
mean416.000
σ0.000
min416.000
max416.000
mean0.140
σ0.005
min0.132
max0.149
cache=y
dps=1
iters=10
policies=100
mean43.786
σ0.006
min43.777
max43.795
mean416.000
σ0.000
min416.000
max416.000
mean0.122
σ0.004
min0.116
max0.128

CSV - indexed operations

Factorallocated MiBpeak allocated MiBtime (ms)
iterations=8
operation_display=column_set() on indexed
rows=200000
mean36.618
σ0.002
min36.615
max36.620
mean4285.750
σ1980.551
min1549.000
max7208.000
mean92.255
σ224.980
min12.436
max649.051
iterations=8
operation_display=column_set() on indexed, repeat
rows=200000
mean36.617
σ0.002
min36.616
max36.620
mean4285.750
σ1980.551
min1549.000
max7208.000
mean13.108
σ0.549
min11.947
max13.880
iterations=8
operation_display=table_records(), no indexes
rows=200000
mean41.929
σ0.002
min41.928
max41.932
mean7208.000
σ0.000
min7208.000
max7208.000
mean15.111
σ0.998
min12.932
max15.947
iterations=8
operation_display=table_records(), no indexes, repeat
rows=200000
mean41.930
σ0.002
min41.928
max41.932
mean7208.000
σ0.000
min7208.000
max7208.000
mean13.712
σ1.082
min11.972
max14.861
iterations=8
operation_display=table_records(), repeat
rows=200000
mean41.929
σ0.002
min41.927
max41.932
mean4168.750
σ1902.750
min1549.000
max7208.000
mean13.709
σ1.570
min11.596
max15.358
iterations=8
operation_display=vertical_lookup_list() on indexed, after table_records()
rows=200000
mean27.604
σ0.002
min27.603
max27.607
mean4168.750
σ1902.750
min1549.000
max7208.000
mean8.941
σ0.480
min8.228
max9.804
iterations=8
operation_display=vertical_lookup_list() on indexed, after table_records(), repeat
rows=200000
mean26.400
σ0.001
min26.399
max26.403
mean4168.750
σ1902.750
min1549.000
max7208.000
mean6.884
σ0.285
min6.459
max7.317
iterations=8
operation_display=vertical_lookup_row_list() on 2 indexed
rows=200000
mean25.667
σ0.002
min25.664
max25.670
mean4285.750
σ1980.551
min1549.000
max7208.000
mean6.016
σ0.151
min5.754
max6.191
iterations=8
operation_display=vertical_lookup_row_list() on 2 indexed, repeat
rows=200000
mean25.661
σ0.002
min25.659
max25.663
mean4285.750
σ1980.551
min1549.000
max7208.000
mean5.638
σ0.152
min5.396
max5.819
iterations=8
operation_display=vertical_lookup_row_list() on 3 (1 unindexed)
rows=200000
mean25.969
σ0.002
min25.967
max25.971
mean4285.750
σ1980.551
min1549.000
max7208.000
mean5.698
σ0.118
min5.501
max5.845
iterations=8
operation_display=vertical_lookup_row_list() on 3 (1 unindexed), repeat
rows=200000
mean25.968
σ0.001
min25.967
max25.971
mean4285.750
σ1980.551
min1549.000
max7208.000
mean5.806
σ0.622
min5.479
max7.328

CSV - loading a lazy table

Factorallocated MiBpeak allocated MiBtime (ms)
iterations=8
operation_display=load_product(), no indexes
rows=200000
mean2524.596
σ0.002
min2524.594
max2524.598
mean7208.000
σ0.000
min7208.000
max7208.000
mean1431.015
σ626.793
min1037.451
max2764.586
iterations=8
operation_display=load_product(), with indexes
rows=200000
mean8744.560
σ0.042
min8744.545
max8744.664
mean3591.625
σ1818.608
min1071.000
max5825.000
mean4685.333
σ1463.520
min3492.149
max7512.673

CSV - unindexed operations

Factorallocated MiBpeak allocated MiBtime (ms)
iterations=8
operation_display=column_set() on unindexed, dense
rows=200000
mean62.077
σ0.002
min62.076
max62.081
mean4168.750
σ1902.750
min1549.000
max7208.000
mean78.370
σ8.562
min70.362
max96.949
iterations=8
operation_display=column_set() on unindexed, dense, repeat
rows=200000
mean62.078
σ0.003
min62.076
max62.084
mean4168.750
σ1902.750
min1549.000
max7208.000
mean79.191
σ8.794
min71.026
max97.583
iterations=8
operation_display=vertical_lookup_list() on unindexed missing Int
rows=200000
mean40.944
σ0.001
min40.944
max40.947
mean7208.000
σ0.000
min7208.000
max7208.000
mean102.805
σ10.239
min81.076
max108.708
iterations=8
operation_display=vertical_lookup_list() on unindexed missing Int, repeat
rows=200000
mean40.946
σ0.002
min40.944
max40.948
mean7208.000
σ0.000
min7208.000
max7208.000
mean102.673
σ10.136
min81.396
max108.512
iterations=8
operation_display=vertical_lookup_list() on unindexed unique Int near end
rows=200000
mean40.950
σ0.002
min40.949
max40.953
mean7208.000
σ0.000
min7208.000
max7208.000
mean105.024
σ9.738
min87.157
max114.429
iterations=8
operation_display=vertical_lookup_list() on unindexed unique Int near end, repeat
rows=200000
mean40.951
σ0.002
min40.949
max40.954
mean7208.000
σ0.000
min7208.000
max7208.000
mean102.789
σ10.340
min81.204
max108.639
iterations=8
operation_display=vertical_lookup_row_list() on unindexed small unique Int
rows=200000
mean66.686
σ0.001
min66.685
max66.689
mean7208.000
σ0.000
min7208.000
max7208.000
mean238.108
σ227.062
min128.568
max798.931
iterations=8
operation_display=vertical_lookup_row_list() on unindexed small unique Int, repeat
rows=200000
mean66.687
σ0.002
min66.685
max66.690
mean7208.000
σ0.000
min7208.000
max7208.000
mean155.399
σ15.954
min129.321
max168.085

CSV - warmup

Factorallocated MiBpeak allocated MiBtime (ms)
iterations=8
operation_display=table_records()
rows=200000
mean11656.833
σ4.318
min11655.305
max11667.519
mean4168.750
σ1902.750
min1549.000
max7208.000
mean6318.661
σ1344.930
min4874.443
max7898.340
iterations=8
operation_display=vertical_lookup_list() on indexed
rows=200000
mean11560.065
σ0.001
min11560.064
max11560.068
mean7208.000
σ0.000
min7208.000
max7208.000
mean5758.789
σ1457.974
min4388.232
max7749.906

CSV internal benchmark: pointedIndexFromKvs

Factorallocated MiBpeak allocated MiBtime (ms)
iterations=8
operation_display=pointedIndexFromKvs
rows=200000
mean172.662
σ0.011
min172.641
max172.674
mean486.000
σ0.000
min486.000
max486.000
mean386.317
σ22.430
min354.951
max412.603
iterations=8
operation_display=pointedIndexFromKvs
rows=400000
mean357.475
σ0.152
min357.321
max357.643
mean563.000
σ0.000
min563.000
max563.000
mean778.106
σ46.300
min665.486
max805.093

Marine Hull: transactPolicy

Factorallocated MiBpeak allocated MiBtime
datapoints=1
iterations=20
mean1008.083
σ0.762
min1007.608
max1011.230
mean7208.000
σ0.000
min7208.000
max7208.000
mean1.501
σ0.111
min1.395
max1.811

Parser: Comma Sep

Factorallocated MiBpeak allocated MiBtime (ms)
name=ambiguous_item.art
mean0.883
σ0.002
min0.881
max0.886
mean7208.000
σ0.000
min7208.000
max7208.000
mean0.310
σ0.121
min0.238
max0.524
name=error_case.art
mean2.334
σ0.002
min2.332
max2.337
mean7208.000
σ0.000
min7208.000
max7208.000
mean0.644
σ0.070
min0.597
max0.768
name=heavy_item.art
mean1.521
σ0.002
min1.520
max1.524
mean7208.000
σ0.000
min7208.000
max7208.000
mean0.384
σ0.034
min0.360
max0.443
name=nested_use.art
mean2.356
σ0.002
min2.355
max2.358
mean7208.000
σ0.000
min7208.000
max7208.000
mean0.629
σ0.039
min0.586
max0.677

Parser: Real World

Factorallocated MiBpeak allocated MiBtime (sec)
name=aon_gpf25_7k_loc.art
mean963.553
σ0.025
min963.523
max963.592
mean7208.000
σ0.000
min7208.000
max7208.000
mean0.815
σ0.055
min0.734
max0.856
name=cdr_enhanced_4k_loc.art
mean884.856
σ0.008
min884.847
max884.866
mean7208.000
σ0.000
min7208.000
max7208.000
mean0.715
σ0.031
min0.681
max0.744

Parser: Record Parsing

Factorallocated MiBpeak allocated MiBtime (ms)
name=record_render_large_success.art
mean7.706
σ0.002
min7.705
max7.709
mean7208.000
σ0.000
min7208.000
max7208.000
mean4.200
σ0.085
min4.061
max4.623
name=record_render_large_syntax_err.art
mean7.655
σ0.002
min7.654
max7.658
mean7208.000
σ0.000
min7208.000
max7208.000
mean4.207
σ0.068
min4.021
max4.504
name=record_render_success.art
mean2.288
σ0.002
min2.287
max2.291
mean7208.000
σ0.000
min7208.000
max7208.000
mean0.758
σ0.020
min0.725
max0.863
name=record_render_syntax_err.art
mean2.163
σ0.002
min2.163
max2.166
mean7208.000
σ0.000
min7208.000
max7208.000
mean0.717
σ0.019
min0.607
max0.777

SoV import

Factorallocated MiBpeak allocated MiBtime_s
iters=10
rows=1000
mean297.416
σ0.255
min297.189
max298.092
mean7208.000
σ0.000
min7208.000
max7208.000
mean0.567
σ0.033
min0.507
max0.593

Workflow: transactPolicy

Factorallocated MiBpeak allocated MiBtime
iters=5
new-facts=1
prior-facts=1
mean289.734
σ0.032
min289.687
max289.776
mean7208.000
σ0.000
min7208.000
max7208.000
mean0.395
σ0.011
min0.387
max0.411
iters=5
new-facts=1
prior-facts=6402
mean1299.648
σ0.103
min1299.522
max1299.768
mean7208.000
σ0.000
min7208.000
max7208.000
mean1.910
σ0.077
min1.813
max1.995
iters=5
new-facts=6402
prior-facts=1
mean1542.655
σ4.027
min1540.605
max1549.852
mean7208.000
σ0.000
min7208.000
max7208.000
mean2.380
σ0.269
min2.062
max2.703
iters=5
new-facts=6402
prior-facts=6402
mean1861.616
σ0.070
min1861.515
max1861.683
mean7208.000
σ0.000
min7208.000
max7208.000
mean3.008
σ0.123
min2.895
max3.151

newProductH/cdr_auton/broker

Factortime_s
iterations=5
mean1.364
σ0.377
min0.941
max1.840

policy addition benchmark

Factorallocated MiBdb queriespeak allocated MiBtime
policies=2
mean446.149
σ577.064
min157.615
max1311.746
mean96.250
σ8.500
min92.000
max109.000
mean7208.000
σ0.000
min7208.000
max7208.000
mean0.538
σ0.541
min0.266
max1.351
policies=20
mean1576.427
σ0.347
min1576.190
max1576.942
mean920.000
σ0.000
min920.000
max920.000
mean7208.000
σ0.000
min7208.000
max7208.000
mean2.627
σ0.012
min2.614
max2.641
policies=200
mean15772.247
σ0.070
min15772.199
max15772.349
mean9200.000
σ0.000
min9200.000
max9200.000
mean7208.000
σ0.000
min7208.000
max7208.000
mean26.409
σ0.175
min26.212
max26.594