9c45923ec449d27845d7e9f9fe2d4f0ed5a848f6

Aggregation: measureAggregations

Factor

allocated MiB

peak allocated MiB

time_s

cache=n

dps=1

iters=10

policies=100

*mean*	54.617
σ	0.349
min	54.486
max	55.611

*mean*	417.000
σ	0.000
min	417.000
max	417.000

*mean*	0.140
σ	0.003
min	0.134
max	0.144

cache=y

dps=1

iters=10

policies=100

*mean*	43.786
σ	0.006
min	43.780
max	43.799

*mean*	417.000
σ	0.000
min	417.000
max	417.000

*mean*	0.123
σ	0.004
min	0.117
max	0.130

CSV - indexed operations

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=8

operation_display=column_set() on indexed

rows=200000

*mean*	36.618
σ	0.002
min	36.615
max	36.620

*mean*	4285.000
σ	1979.421
min	1553.000
max	7209.000

*mean*	55.007
σ	119.524
min	12.431
max	350.812

iterations=8

operation_display=column_set() on indexed, repeat

rows=200000

*mean*	36.617
σ	0.002
min	36.616
max	36.620

*mean*	4285.000
σ	1979.421
min	1553.000
max	7209.000

*mean*	12.690
σ	0.601
min	11.813
max	13.411

iterations=8

operation_display=table_records(), no indexes

rows=200000

*mean*	41.929
σ	0.002
min	41.928
max	41.933

*mean*	7209.000
σ	0.000
min	7209.000
max	7209.000

*mean*	14.881
σ	0.966
min	13.255
max	15.996

iterations=8

operation_display=table_records(), no indexes, repeat

rows=200000

*mean*	41.930
σ	0.002
min	41.928
max	41.932

*mean*	7209.000
σ	0.000
min	7209.000
max	7209.000

*mean*	13.654
σ	1.222
min	12.059
max	15.338

iterations=8

operation_display=table_records(), repeat

rows=200000

*mean*	41.929
σ	0.002
min	41.927
max	41.931

*mean*	4169.125
σ	1902.358
min	1553.000
max	7209.000

*mean*	12.922
σ	1.252
min	11.009
max	14.607

iterations=8

operation_display=vertical_lookup_list() on indexed, after table_records()

rows=200000

*mean*	27.604
σ	0.002
min	27.603
max	27.607

*mean*	4169.125
σ	1902.358
min	1553.000
max	7209.000

*mean*	9.159
σ	0.377
min	8.553
max	9.553

iterations=8

operation_display=vertical_lookup_list() on indexed, after table_records(), repeat

rows=200000

*mean*	26.400
σ	0.001
min	26.399
max	26.403

*mean*	4169.125
σ	1902.358
min	1553.000
max	7209.000

*mean*	7.155
σ	0.141
min	6.934
max	7.287

iterations=8

operation_display=vertical_lookup_row_list() on 2 indexed

rows=200000

*mean*	25.667
σ	0.002
min	25.664
max	25.670

*mean*	4285.000
σ	1979.421
min	1553.000
max	7209.000

*mean*	6.038
σ	0.133
min	5.839
max	6.173

iterations=8

operation_display=vertical_lookup_row_list() on 2 indexed, repeat

rows=200000

*mean*	25.661
σ	0.002
min	25.659
max	25.663

*mean*	4285.000
σ	1979.421
min	1553.000
max	7209.000

*mean*	5.603
σ	0.161
min	5.339
max	5.891

iterations=8

operation_display=vertical_lookup_row_list() on 3 (1 unindexed)

rows=200000

*mean*	25.969
σ	0.002
min	25.967
max	25.971

*mean*	4285.000
σ	1979.421
min	1553.000
max	7209.000

*mean*	5.679
σ	0.159
min	5.431
max	5.898

iterations=8

operation_display=vertical_lookup_row_list() on 3 (1 unindexed), repeat

rows=200000

*mean*	25.968
σ	0.001
min	25.967
max	25.971

*mean*	4285.000
σ	1979.421
min	1553.000
max	7209.000

*mean*	5.537
σ	0.129
min	5.264
max	5.648

CSV - loading a lazy table

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=8

operation_display=load_product(), no indexes

rows=200000

*mean*	2524.596
σ	0.002
min	2524.594
max	2524.598

*mean*	7209.000
σ	0.000
min	7209.000
max	7209.000

*mean*	1405.757
σ	593.272
min	1045.302
max	2678.692

iterations=8

operation_display=load_product(), with indexes

rows=200000

*mean*	8744.561
σ	0.042
min	8744.545
max	8744.664

*mean*	3590.125
σ	1817.478
min	1072.000
max	5820.000

*mean*	4462.726
σ	1353.970
min	3517.883
max	7184.198

CSV - unindexed operations

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=8

operation_display=column_set() on unindexed, dense

rows=200000

*mean*	62.077
σ	0.002
min	62.076
max	62.080

*mean*	4169.125
σ	1902.358
min	1553.000
max	7209.000

*mean*	77.678
σ	7.225
min	70.835
max	92.166

iterations=8

operation_display=column_set() on unindexed, dense, repeat

rows=200000

*mean*	62.077
σ	0.002
min	62.076
max	62.080

*mean*	4169.125
σ	1902.358
min	1553.000
max	7209.000

*mean*	78.128
σ	7.221
min	71.938
max	92.287

iterations=8

operation_display=vertical_lookup_list() on unindexed missing Int

rows=200000

*mean*	40.944
σ	0.001
min	40.944
max	40.947

*mean*	7209.000
σ	0.000
min	7209.000
max	7209.000

*mean*	103.525
σ	8.762
min	85.815
max	109.308

iterations=8

operation_display=vertical_lookup_list() on unindexed missing Int, repeat

rows=200000

*mean*	40.946
σ	0.002
min	40.944
max	40.948

*mean*	7209.000
σ	0.000
min	7209.000
max	7209.000

*mean*	103.448
σ	9.156
min	85.010
max	109.488

iterations=8

operation_display=vertical_lookup_list() on unindexed unique Int near end

rows=200000

*mean*	40.950
σ	0.002
min	40.949
max	40.953

*mean*	7209.000
σ	0.000
min	7209.000
max	7209.000

*mean*	106.219
σ	7.683
min	92.158
max	112.975

iterations=8

operation_display=vertical_lookup_list() on unindexed unique Int near end, repeat

rows=200000

*mean*	40.951
σ	0.002
min	40.949
max	40.954

*mean*	7209.000
σ	0.000
min	7209.000
max	7209.000

*mean*	103.538
σ	9.118
min	85.382
max	109.281

iterations=8

operation_display=vertical_lookup_row_list() on unindexed small unique Int

rows=200000

*mean*	66.686
σ	0.001
min	66.685
max	66.689

*mean*	7209.000
σ	0.000
min	7209.000
max	7209.000

*mean*	255.085
σ	271.988
min	133.732
max	927.502

iterations=8

operation_display=vertical_lookup_row_list() on unindexed small unique Int, repeat

rows=200000

*mean*	66.687
σ	0.002
min	66.685
max	66.690

*mean*	7209.000
σ	0.000
min	7209.000
max	7209.000

*mean*	156.827
σ	14.589
min	134.504
max	170.749

CSV - warmup

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=8

operation_display=table_records()

rows=200000

*mean*	11656.833
σ	4.318
min	11655.305
max	11667.520

*mean*	4169.125
σ	1902.358
min	1553.000
max	7209.000

*mean*	6444.393
σ	1118.247
min	4906.995
max	8144.733

iterations=8

operation_display=vertical_lookup_list() on indexed

rows=200000

*mean*	11560.065
σ	0.001
min	11560.064
max	11560.068

*mean*	7209.000
σ	0.000
min	7209.000
max	7209.000

*mean*	5706.302
σ	1532.383
min	4353.928
max	7786.906

CSV internal benchmark: pointedIndexFromKvs

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=8

operation_display=pointedIndexFromKvs

rows=200000

*mean*	172.661
σ	0.008
min	172.649
max	172.670

*mean*	488.000
σ	0.000
min	488.000
max	488.000

*mean*	385.059
σ	23.697
min	351.766
max	413.646

iterations=8

operation_display=pointedIndexFromKvs

rows=400000

*mean*	357.468
σ	0.144
min	357.321
max	357.638

*mean*	564.000
σ	0.000
min	564.000
max	564.000

*mean*	780.582
σ	35.408
min	717.084
max	819.259

Marine Hull: transactPolicy

Factor

allocated MiB

peak allocated MiB

time

datapoints=1

iterations=20

*mean*	1008.084
σ	0.761
min	1007.608
max	1011.233

*mean*	7209.000
σ	0.000
min	7209.000
max	7209.000

*mean*	1.564
σ	0.165
min	1.408
max	2.065

Parser: Comma Sep

Factor

allocated MiB

peak allocated MiB

time (ms)

name=ambiguous_item.art

*mean*	0.883
σ	0.002
min	0.881
max	0.886

*mean*	7209.000
σ	0.000
min	7209.000
max	7209.000

*mean*	0.428
σ	0.088
min	0.355
max	0.564

name=error_case.art

*mean*	2.333
σ	0.003
min	2.332
max	2.337

*mean*	7209.000
σ	0.000
min	7209.000
max	7209.000

*mean*	0.930
σ	0.186
min	0.826
max	1.260

name=heavy_item.art

*mean*	1.521
σ	0.002
min	1.520
max	1.524

*mean*	7209.000
σ	0.000
min	7209.000
max	7209.000

*mean*	0.535
σ	0.037
min	0.502
max	0.599

name=nested_use.art

*mean*	2.355
σ	0.002
min	2.355
max	2.358

*mean*	7209.000
σ	0.000
min	7209.000
max	7209.000

*mean*	0.848
σ	0.034
min	0.819
max	0.901

Parser: Real World

Factor

allocated MiB

peak allocated MiB

time (sec)

name=aon_gpf25_7k_loc.art

*mean*	963.551
σ	0.030
min	963.523
max	963.602

*mean*	7209.000
σ	0.000
min	7209.000
max	7209.000

*mean*	0.800
σ	0.054
min	0.734
max	0.863

name=cdr_enhanced_4k_loc.art

*mean*	884.856
σ	0.006
min	884.851
max	884.863

*mean*	7209.000
σ	0.000
min	7209.000
max	7209.000

*mean*	0.687
σ	0.063
min	0.610
max	0.742

Parser: Record Parsing

Factor

allocated MiB

peak allocated MiB

time (ms)

name=record_render_large_success.art

*mean*	7.706
σ	0.002
min	7.705
max	7.709

*mean*	7209.000
σ	0.000
min	7209.000
max	7209.000

*mean*	4.308
σ	0.100
min	4.140
max	4.652

name=record_render_large_syntax_err.art

*mean*	7.655
σ	0.002
min	7.654
max	7.660

*mean*	7209.000
σ	0.000
min	7209.000
max	7209.000

*mean*	4.264
σ	0.080
min	4.141
max	4.584

name=record_render_success.art

*mean*	2.288
σ	0.002
min	2.287
max	2.291

*mean*	7209.000
σ	0.000
min	7209.000
max	7209.000

*mean*	0.756
σ	0.016
min	0.731
max	0.857

name=record_render_syntax_err.art

*mean*	2.163
σ	0.002
min	2.163
max	2.166

*mean*	7209.000
σ	0.000
min	7209.000
max	7209.000

*mean*	0.720
σ	0.014
min	0.688
max	0.775

SoV import

Factor

allocated MiB

peak allocated MiB

time_s

iters=10

rows=1000

*mean*	297.458
σ	0.193
min	297.332
max	297.985

*mean*	7209.000
σ	0.000
min	7209.000
max	7209.000

*mean*	0.590
σ	0.022
min	0.554
max	0.612

Workflow: transactPolicy

Factor

allocated MiB

peak allocated MiB

time

iters=5

new-facts=1

prior-facts=1

*mean*	289.728
σ	0.045
min	289.676
max	289.797

*mean*	7209.000
σ	0.000
min	7209.000
max	7209.000

*mean*	0.397
σ	0.011
min	0.389
max	0.409

iters=5

new-facts=1

prior-facts=6402

*mean*	1299.659
σ	0.082
min	1299.576
max	1299.772

*mean*	7209.000
σ	0.000
min	7209.000
max	7209.000

*mean*	1.982
σ	0.122
min	1.823
max	2.160

iters=5

new-facts=6402

prior-facts=1

*mean*	1542.628
σ	4.014
min	1540.606
max	1549.801

*mean*	7209.000
σ	0.000
min	7209.000
max	7209.000

*mean*	2.244
σ	0.142
min	2.128
max	2.447

iters=5

new-facts=6402

prior-facts=6402

*mean*	1861.606
σ	0.061
min	1861.519
max	1861.654

*mean*	7209.000
σ	0.000
min	7209.000
max	7209.000

*mean*	2.946
σ	0.095
min	2.863
max	3.057

newProductH/cdr_auton/broker

Factor

time_s

iterations=5

*mean*	1.356
σ	0.283
min	1.131
max	1.827

policy addition benchmark

Factor

allocated MiB

db queries

peak allocated MiB

time

policies=2

*mean*	446.149
σ	577.065
min	157.615
max	1311.746

*mean*	96.250
σ	8.500
min	92.000
max	109.000

*mean*	7209.000
σ	0.000
min	7209.000
max	7209.000

*mean*	0.557
σ	0.562
min	0.272
max	1.401

policies=20

*mean*	1576.426
σ	0.349
min	1576.187
max	1576.944

*mean*	920.000
σ	0.000
min	920.000
max	920.000

*mean*	7209.000
σ	0.000
min	7209.000
max	7209.000

*mean*	2.638
σ	0.026
min	2.615
max	2.666

policies=200

*mean*	15772.261
σ	0.058
min	15772.185
max	15772.311

*mean*	9200.000
σ	0.000
min	9200.000
max	9200.000

*mean*	7209.000
σ	0.000
min	7209.000
max	7209.000

*mean*	26.678
σ	0.116
min	26.509
max	26.763