9419edcc1122a1bdbb290cb652e5b824029fc9ab

Aggregation: measureAggregations

Factor

allocated MiB

peak allocated MiB

time_s

cache=n

dps=1

iters=10

policies=100

*mean*	54.521
σ	0.370
min	54.381
max	55.574

*mean*	417.000
σ	0.000
min	417.000
max	417.000

*mean*	0.139
σ	0.009
min	0.131
max	0.161

cache=y

dps=1

iters=10

policies=100

*mean*	43.766
σ	0.007
min	43.754
max	43.781

*mean*	417.000
σ	0.000
min	417.000
max	417.000

*mean*	0.121
σ	0.005
min	0.115
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.617
σ	0.002
min	36.615
max	36.620

*mean*	4287.875
σ	1980.916
min	1552.000
max	7207.000

*mean*	75.941
σ	180.967
min	11.647
max	523.811

iterations=8

operation_display=column_set() on indexed, repeat

rows=200000

*mean*	36.618
σ	0.002
min	36.616
max	36.620

*mean*	4287.875
σ	1980.916
min	1552.000
max	7207.000

*mean*	13.058
σ	2.779
min	11.130
max	19.773

iterations=8

operation_display=table_records(), no indexes

rows=200000

*mean*	41.930
σ	0.002
min	41.928
max	41.932

*mean*	7207.000
σ	0.000
min	7207.000
max	7207.000

*mean*	14.413
σ	0.807
min	12.710
max	15.058

iterations=8

operation_display=table_records(), no indexes, repeat

rows=200000

*mean*	41.929
σ	0.002
min	41.928
max	41.932

*mean*	7207.000
σ	0.000
min	7207.000
max	7207.000

*mean*	12.860
σ	1.167
min	10.582
max	13.967

iterations=8

operation_display=table_records(), repeat

rows=200000

*mean*	41.929
σ	0.002
min	41.927
max	41.931

*mean*	4171.875
σ	1903.503
min	1552.000
max	7207.000

*mean*	12.833
σ	1.735
min	10.243
max	14.773

iterations=8

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

rows=200000

*mean*	27.605
σ	0.002
min	27.603
max	27.607

*mean*	4171.875
σ	1903.503
min	1552.000
max	7207.000

*mean*	8.544
σ	0.486
min	7.786
max	9.109

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*	4171.875
σ	1903.503
min	1552.000
max	7207.000

*mean*	6.341
σ	0.275
min	5.918
max	6.669

iterations=8

operation_display=vertical_lookup_row_list() on 2 indexed

rows=200000

*mean*	25.666
σ	0.002
min	25.665
max	25.668

*mean*	4287.875
σ	1980.916
min	1552.000
max	7207.000

*mean*	5.623
σ	0.442
min	5.299
max	6.666

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*	4287.875
σ	1980.916
min	1552.000
max	7207.000

*mean*	5.322
σ	0.480
min	5.090
max	6.503

iterations=8

operation_display=vertical_lookup_row_list() on 3 (1 unindexed)

rows=200000

*mean*	25.969
σ	0.003
min	25.967
max	25.975

*mean*	4287.875
σ	1980.916
min	1552.000
max	7207.000

*mean*	5.389
σ	0.483
min	5.066
max	6.560

iterations=8

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

rows=200000

*mean*	25.968
σ	0.002
min	25.967
max	25.971

*mean*	4287.875
σ	1980.916
min	1552.000
max	7207.000

*mean*	5.241
σ	0.452
min	4.831
max	6.315

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*	7207.000
σ	0.000
min	7207.000
max	7207.000

*mean*	1338.177
σ	475.290
min	1020.323
max	2213.927

iterations=8

operation_display=load_product(), with indexes

rows=200000

*mean*	8744.560
σ	0.040
min	8744.545
max	8744.659

*mean*	3593.500
σ	1821.084
min	1070.000
max	5828.000

*mean*	4816.324
σ	1658.368
min	3475.161
max	7121.003

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.001
min	62.076
max	62.080

*mean*	4171.875
σ	1903.503
min	1552.000
max	7207.000

*mean*	76.614
σ	6.965
min	70.411
max	91.899

iterations=8

operation_display=column_set() on unindexed, dense, repeat

rows=200000

*mean*	62.077
σ	0.002
min	62.076
max	62.080

*mean*	4171.875
σ	1903.503
min	1552.000
max	7207.000

*mean*	77.088
σ	6.929
min	71.072
max	92.287

iterations=8

operation_display=vertical_lookup_list() on unindexed missing Int

rows=200000

*mean*	40.945
σ	0.002
min	40.943
max	40.949

*mean*	7207.000
σ	0.000
min	7207.000
max	7207.000

*mean*	102.750
σ	7.377
min	87.910
max	107.487

iterations=8

operation_display=vertical_lookup_list() on unindexed missing Int, repeat

rows=200000

*mean*	40.945
σ	0.002
min	40.944
max	40.947

*mean*	7207.000
σ	0.000
min	7207.000
max	7207.000

*mean*	102.694
σ	7.331
min	87.864
max	107.392

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.954

*mean*	7207.000
σ	0.000
min	7207.000
max	7207.000

*mean*	104.494
σ	7.430
min	90.892
max	111.328

iterations=8

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

rows=200000

*mean*	40.950
σ	0.002
min	40.949
max	40.953

*mean*	7207.000
σ	0.000
min	7207.000
max	7207.000

*mean*	103.197
σ	7.442
min	88.001
max	107.675

iterations=8

operation_display=vertical_lookup_row_list() on unindexed small unique Int

rows=200000

*mean*	66.687
σ	0.002
min	66.686
max	66.690

*mean*	7207.000
σ	0.000
min	7207.000
max	7207.000

*mean*	267.143
σ	304.769
min	139.502
max	1020.999

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*	7207.000
σ	0.000
min	7207.000
max	7207.000

*mean*	156.954
σ	13.570
min	135.417
max	168.427

CSV - warmup

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=8

operation_display=table_records()

rows=200000

*mean*	11656.833
σ	4.319
min	11655.305
max	11667.523

*mean*	4171.875
σ	1903.503
min	1552.000
max	7207.000

*mean*	6108.529
σ	1090.814
min	4880.198
max	8073.645

iterations=8

operation_display=vertical_lookup_list() on indexed

rows=200000

*mean*	11560.066
σ	0.003
min	11560.064
max	11560.072

*mean*	7207.000
σ	0.000
min	7207.000
max	7207.000

*mean*	5498.059
σ	1249.118
min	4358.533
max	7774.911

CSV internal benchmark: pointedIndexFromKvs

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=8

operation_display=pointedIndexFromKvs

rows=200000

*mean*	172.664
σ	0.009
min	172.652
max	172.675

*mean*	488.000
σ	0.000
min	488.000
max	488.000

*mean*	394.702
σ	34.390
min	328.509
max	426.613

iterations=8

operation_display=pointedIndexFromKvs

rows=400000

*mean*	357.469
σ	0.162
min	357.321
max	357.661

*mean*	564.000
σ	0.000
min	564.000
max	564.000

*mean*	779.965
σ	55.962
min	654.899
max	822.141

Marine Hull: transactPolicy

Factor

allocated MiB

peak allocated MiB

time

datapoints=1

iterations=20

*mean*	1008.077
σ	0.762
min	1007.609
max	1011.229

*mean*	7207.000
σ	0.000
min	7207.000
max	7207.000

*mean*	1.557
σ	0.150
min	1.409
max	1.923

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*	7207.000
σ	0.000
min	7207.000
max	7207.000

*mean*	0.309
σ	0.113
min	0.233
max	0.508

name=error_case.art

*mean*	2.333
σ	0.003
min	2.332
max	2.337

*mean*	7207.000
σ	0.000
min	7207.000
max	7207.000

*mean*	0.643
σ	0.089
min	0.585
max	0.799

name=heavy_item.art

*mean*	1.521
σ	0.002
min	1.520
max	1.524

*mean*	7207.000
σ	0.000
min	7207.000
max	7207.000

*mean*	0.389
σ	0.032
min	0.361
max	0.443

name=nested_use.art

*mean*	2.355
σ	0.002
min	2.355
max	2.358

*mean*	7207.000
σ	0.000
min	7207.000
max	7207.000

*mean*	0.789
σ	0.078
min	0.652
max	0.841

Parser: Real World

Factor

allocated MiB

peak allocated MiB

time (sec)

name=aon_gpf25_7k_loc.art

*mean*	963.552
σ	0.027
min	963.535
max	963.599

*mean*	7207.000
σ	0.000
min	7207.000
max	7207.000

*mean*	0.815
σ	0.041
min	0.759
max	0.849

name=cdr_enhanced_4k_loc.art

*mean*	884.853
σ	0.008
min	884.847
max	884.866

*mean*	7207.000
σ	0.000
min	7207.000
max	7207.000

*mean*	0.705
σ	0.057
min	0.604
max	0.744

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*	7207.000
σ	0.000
min	7207.000
max	7207.000

*mean*	4.262
σ	0.076
min	4.114
max	4.534

name=record_render_large_syntax_err.art

*mean*	7.655
σ	0.002
min	7.654
max	7.658

*mean*	7207.000
σ	0.000
min	7207.000
max	7207.000

*mean*	4.233
σ	0.066
min	4.096
max	4.465

name=record_render_success.art

*mean*	2.288
σ	0.002
min	2.287
max	2.291

*mean*	7207.000
σ	0.000
min	7207.000
max	7207.000

*mean*	0.757
σ	0.017
min	0.726
max	0.871

name=record_render_syntax_err.art

*mean*	2.163
σ	0.002
min	2.163
max	2.166

*mean*	7207.000
σ	0.000
min	7207.000
max	7207.000

*mean*	0.715
σ	0.015
min	0.686
max	0.778

SoV import

Factor

allocated MiB

peak allocated MiB

time_s

iters=10

rows=1000

*mean*	297.413
σ	0.226
min	297.202
max	297.991

*mean*	7207.000
σ	0.000
min	7207.000
max	7207.000

*mean*	0.546
σ	0.020
min	0.513
max	0.573

Workflow: transactPolicy

Factor

allocated MiB

peak allocated MiB

time

iters=5

new-facts=1

prior-facts=1

*mean*	289.717
σ	0.031
min	289.674
max	289.758

*mean*	7207.000
σ	0.000
min	7207.000
max	7207.000

*mean*	0.386
σ	0.000
min	0.386
max	0.387

iters=5

new-facts=1

prior-facts=6402

*mean*	1299.650
σ	0.122
min	1299.505
max	1299.778

*mean*	7207.000
σ	0.000
min	7207.000
max	7207.000

*mean*	1.833
σ	0.039
min	1.793
max	1.878

iters=5

new-facts=6402

prior-facts=1

*mean*	1542.628
σ	3.983
min	1540.595
max	1549.745

*mean*	7207.000
σ	0.000
min	7207.000
max	7207.000

*mean*	2.277
σ	0.160
min	2.090
max	2.459

iters=5

new-facts=6402

prior-facts=6402

*mean*	1861.611
σ	0.067
min	1861.524
max	1861.689

*mean*	7207.000
σ	0.000
min	7207.000
max	7207.000

*mean*	2.987
σ	0.323
min	2.832
max	3.565

newProductH/cdr_auton/broker

Factor

time_s

iterations=5

*mean*	1.496
σ	0.277
min	1.259
max	1.887

policy addition benchmark

Factor

allocated MiB

db queries

peak allocated MiB

time

policies=2

*mean*	446.147
σ	577.064
min	157.614
max	1311.743

*mean*	96.250
σ	8.500
min	92.000
max	109.000

*mean*	7207.000
σ	0.000
min	7207.000
max	7207.000

*mean*	0.548
σ	0.560
min	0.266
max	1.389

policies=20

*mean*	1576.400
σ	0.346
min	1576.164
max	1576.913

*mean*	920.000
σ	0.000
min	920.000
max	920.000

*mean*	7207.000
σ	0.000
min	7207.000
max	7207.000

*mean*	2.623
σ	0.010
min	2.613
max	2.635

policies=200

*mean*	15771.937
σ	0.162
min	15771.789
max	15772.149

*mean*	9200.000
σ	0.000
min	9200.000
max	9200.000

*mean*	7207.000
σ	0.000
min	7207.000
max	7207.000

*mean*	26.478
σ	0.173
min	26.322
max	26.679