61c254d3c8caaceddd4038b51f13912099781c10

CSV benchmark: catalog/aon_aef_broker/dpx_locations_us/large_csv_loaded

Factor

allocated MiB

peak allocated MiB

time_s

iterations=5

operation_display=column_set() on area_code (indexed)

rows=15894

scenario_id=catalog/aon_aef_broker/dpx_locations_us/large_csv_loaded

step_id=column_set.area_code

*mean*	228.196
σ	0.016
min	228.178
max	228.219

*mean*	41.516
σ	0.196
min	41.243
max	41.724

*mean*	0.119
σ	0.001
min	0.118
max	0.122

iterations=5

operation_display=column_set() on area_code (indexed), repeat

rows=15894

scenario_id=catalog/aon_aef_broker/dpx_locations_us/large_csv_loaded

step_id=column_set.area_code.repeat

*mean*	1.643
σ	2.250
min	0.000
max	4.109

*mean*	0.226
σ	0.310
min	0.000
max	0.575

*mean*	0.001
σ	0.001
min	0.001
max	0.002

iterations=5

operation_display=column_set() on dpx_subarea_name (no index)

rows=15894

scenario_id=catalog/aon_aef_broker/dpx_locations_us/large_csv_loaded

step_id=column_set.dpx_subarea_name

*mean*	6.335
σ	1.806
min	5.464
max	9.563

*mean*	1.069
σ	0.042
min	1.025
max	1.116

*mean*	0.008
σ	0.001
min	0.007
max	0.009

iterations=5

operation_display=column_set() on dpx_subarea_name (no index), repeat

rows=15894

scenario_id=catalog/aon_aef_broker/dpx_locations_us/large_csv_loaded

step_id=column_set.dpx_subarea_name.repeat

*mean*	8.085
σ	1.777
min	4.906
max	8.879

*mean*	0.293
σ	0.443
min	0.085
max	1.086

*mean*	0.008
σ	0.000
min	0.007
max	0.008

iterations=5

operation_display=load_product()

rows=15894

scenario_id=catalog/aon_aef_broker/dpx_locations_us/large_csv_loaded

step_id=load_product

*mean*	181.233
σ	2.956
min	177.688
max	184.303

*mean*	23.820
σ	0.514
min	23.241
max	24.327

*mean*	0.084
σ	0.001
min	0.082
max	0.086

iterations=5

operation_display=vertical_lookup_list() on area_code (indexed)

rows=15894

scenario_id=catalog/aon_aef_broker/dpx_locations_us/large_csv_loaded

step_id=vertical_lookup_list.area_code

*mean*	3.121
σ	2.860
min	0.000
max	5.601

*mean*	0.212
σ	0.261
min	0.000
max	0.534

*mean*	0.001
σ	0.001
min	0.001
max	0.002

iterations=5

operation_display=vertical_lookup_list() on area_code (indexed), repeat

rows=15894

scenario_id=catalog/aon_aef_broker/dpx_locations_us/large_csv_loaded

step_id=vertical_lookup_list.area_code.repeat

*mean*	2.238
σ	3.065
min	0.000
max	5.597

*mean*	0.154
σ	0.281
min	0.000
max	0.648

*mean*	0.001
σ	0.001
min	0.000
max	0.002

iterations=5

operation_display=vertical_lookup_list() on dpx_subarea_code (no index)

rows=15894

scenario_id=catalog/aon_aef_broker/dpx_locations_us/large_csv_loaded

step_id=vertical_lookup_list.dpx_subarea_code

*mean*	4.617
σ	0.293
min	4.101
max	4.788

*mean*	0.474
σ	0.260
min	0.286
max	0.932

*mean*	0.005
σ	0.000
min	0.005
max	0.005

iterations=5

operation_display=vertical_lookup_list() on dpx_subarea_code (no index), repeat

rows=15894

scenario_id=catalog/aon_aef_broker/dpx_locations_us/large_csv_loaded

step_id=vertical_lookup_list.dpx_subarea_code.repeat

*mean*	0.000
σ	0.000
min	0.000
max	0.000

*mean*	0.000
σ	0.000
min	0.000
max	0.000

*mean*	0.003
σ	0.000
min	0.003
max	0.003

iterations=5

operation_display=vertical_lookup_row_list() on area + subarea code (both indexed)

rows=15894

scenario_id=catalog/aon_aef_broker/dpx_locations_us/large_csv_loaded

step_id=vertical_lookup_row_list.area.subarea

*mean*	0.000
σ	0.000
min	0.000
max	0.000

*mean*	0.000
σ	0.000
min	0.000
max	0.000

*mean*	0.000
σ	0.000
min	0.000
max	0.001

iterations=5

operation_display=vertical_lookup_row_list() on area + subarea code (both indexed), repeat

rows=15894

scenario_id=catalog/aon_aef_broker/dpx_locations_us/large_csv_loaded

step_id=vertical_lookup_row_list.area.subarea.repeat

*mean*	0.000
σ	0.000
min	0.000
max	0.000

*mean*	0.000
σ	0.000
min	0.000
max	0.000

*mean*	0.000
σ	0.000
min	0.000
max	0.000

CSV benchmark: ci/scenario_aon

Factor

allocated MiB

peak allocated MiB

time_s

iterations=5

operation_display=column_set() on area_code (indexed)

rows=15894

scenario_id=ci/scenario_aon

step_id=column_set.area_code

*mean*	228.984
σ	1.774
min	228.182
max	232.157

*mean*	26.654
σ	15.162
min	6.618
max	42.000

*mean*	0.271
σ	0.091
min	0.166
max	0.388

iterations=5

operation_display=column_set() on dpx_subarea_name (no index)

rows=15894

scenario_id=ci/scenario_aon

step_id=column_set.dpx_subarea_name

*mean*	5.702
σ	1.780
min	4.893
max	8.886

*mean*	1.156
σ	0.085
min	1.068
max	1.263

*mean*	0.011
σ	0.003
min	0.007
max	0.014

iterations=5

operation_display=load_product()

rows=15894

scenario_id=ci/scenario_aon

step_id=load_product

*mean*	178.979
σ	1.921
min	177.671
max	182.382

*mean*	26.794
σ	10.097
min	14.864
max	40.000

*mean*	0.172
σ	0.060
min	0.084
max	0.244

iterations=5

operation_display=vertical_lookup_row_list() on area + subarea code (both indexed)

rows=15894

scenario_id=ci/scenario_aon

step_id=vertical_lookup_row_list.area.subarea

*mean*	2.457
σ	2.243
min	0.000
max	4.096

*mean*	0.557
σ	0.508
min	0.000
max	0.938

*mean*	0.001
σ	0.001
min	0.001
max	0.002

CSV benchmark: ci/scenario_synthetic

Factor

allocated MiB

peak allocated MiB

time_s

iterations=5

operation_display=load_product()

rows=200000

scenario_id=ci/scenario_synthetic

step_id=load_product

*mean*	8715.932
σ	0.918
min	8715.490
max	8717.573

*mean*	470.244
σ	85.152
min	383.000
max	576.000

*mean*	5.395
σ	1.399
min	3.623
max	6.984

iterations=5

operation_display=table_records()

rows=200000

scenario_id=ci/scenario_synthetic

step_id=table_records

*mean*	15164.966
σ	5.013
min	15162.695
max	15173.934

*mean*	424.800
σ	248.925
min	94.000
max	736.000

*mean*	11.331
σ	0.720
min	10.680
max	12.397

iterations=5

operation_display=table_records(), repeat

rows=200000

scenario_id=ci/scenario_synthetic

step_id=table_records.repeat

*mean*	27.807
σ	0.002
min	27.806
max	27.810

*mean*	0.102
σ	0.000
min	0.102
max	0.103

*mean*	0.010
σ	0.002
min	0.008
max	0.013

iterations=5

operation_display=vertical_lookup_list() on indexed

rows=200000

scenario_id=ci/scenario_synthetic

step_id=vertical_lookup_list.indexed

*mean*	12.820
σ	0.002
min	12.817
max	12.822

*mean*	10.791
σ	0.000
min	10.790
max	10.791

*mean*	0.005
σ	0.001
min	0.005
max	0.007

iterations=5

operation_display=vertical_lookup_list() on indexed, repeat

rows=200000

scenario_id=ci/scenario_synthetic

step_id=vertical_lookup_list.indexed.repeat

*mean*	12.800
σ	0.002
min	12.797
max	12.802

*mean*	0.242
σ	0.000
min	0.242
max	0.242

*mean*	0.005
σ	0.001
min	0.004
max	0.006

CSV benchmark: synthetic/mixed_indexes/benchmark_one

Factor

allocated MiB

peak allocated MiB

time_s

iterations=5

operation_display=load_product()

rows=200000

scenario_id=synthetic/mixed_indexes/benchmark_one

step_id=load_product

*mean*	8715.329
σ	0.454
min	8715.096
max	8716.139

*mean*	360.484
σ	169.171
min	213.598
max	543.643

*mean*	4.577
σ	1.444
min	3.434
max	6.704

iterations=5

operation_display=table_records()

rows=200000

scenario_id=synthetic/mixed_indexes/benchmark_one

step_id=table_records

*mean*	15162.731
σ	0.032
min	15162.696
max	15162.755

*mean*	483.582
σ	799.077
min	24.914
max	1901.408

*mean*	9.825
σ	2.093
min	6.700
max	12.182

iterations=5

operation_display=table_records(), repeat

rows=200000

scenario_id=synthetic/mixed_indexes/benchmark_one

step_id=table_records.repeat

*mean*	27.806
σ	0.000
min	27.806
max	27.806

*mean*	0.102
σ	0.000
min	0.102
max	0.102

*mean*	0.009
σ	0.002
min	0.008
max	0.013

iterations=5

operation_display=vertical_lookup_list() on indexed

rows=200000

scenario_id=synthetic/mixed_indexes/benchmark_one

step_id=vertical_lookup_list.indexed

*mean*	12.820
σ	0.002
min	12.817
max	12.821

*mean*	10.790
σ	0.000
min	10.790
max	10.790

*mean*	0.005
σ	0.000
min	0.004
max	0.005

iterations=5

operation_display=vertical_lookup_list() on indexed, repeat

rows=200000

scenario_id=synthetic/mixed_indexes/benchmark_one

step_id=vertical_lookup_list.indexed.repeat

*mean*	12.799
σ	0.002
min	12.797
max	12.801

*mean*	0.242
σ	0.000
min	0.242
max	0.242

*mean*	0.004
σ	0.000
min	0.004
max	0.004

iterations=5

operation_display=vertical_lookup_row_list() on 2 indexed

rows=200000

scenario_id=synthetic/mixed_indexes/benchmark_one

step_id=vertical_lookup_row_list.two_indexed

*mean*	12.170
σ	0.003
min	12.167
max	12.173

*mean*	0.038
σ	0.000
min	0.038
max	0.039

*mean*	0.003
σ	0.000
min	0.003
max	0.003

iterations=5

operation_display=vertical_lookup_row_list() on 2 indexed, repeat

rows=200000

scenario_id=synthetic/mixed_indexes/benchmark_one

step_id=vertical_lookup_row_list.two_indexed.repeat

*mean*	11.773
σ	0.002
min	11.771
max	11.775

*mean*	0.039
σ	0.000
min	0.039
max	0.039

*mean*	0.003
σ	0.000
min	0.003
max	0.003

iterations=5

operation_display=vertical_lookup_row_list() on 3 (1 unindexed)

rows=200000

scenario_id=synthetic/mixed_indexes/benchmark_one

step_id=vertical_lookup_row_list.three_one_unindexed

*mean*	12.139
σ	0.008
min	12.134
max	12.152

*mean*	0.047
σ	0.002
min	0.046
max	0.050

*mean*	0.003
σ	0.000
min	0.003
max	0.003

iterations=5

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

rows=200000

scenario_id=synthetic/mixed_indexes/benchmark_one

step_id=vertical_lookup_row_list.three_one_unindexed.repeat

*mean*	12.138
σ	0.004
min	12.135
max	12.144

*mean*	0.041
σ	0.002
min	0.040
max	0.044

*mean*	0.003
σ	0.000
min	0.003
max	0.003

CSV benchmark: synthetic/mixed_indexes/benchmark_three

Factor

allocated MiB

peak allocated MiB

time_s

iterations=5

operation_display=column_set() on indexed

rows=200000

scenario_id=synthetic/mixed_indexes/benchmark_three

step_id=column_set.indexed

*mean*	39.756
σ	0.002
min	39.754
max	39.758

*mean*	46.723
σ	99.675
min	2.147
max	225.026

*mean*	0.046
σ	0.035
min	0.024
max	0.105

iterations=5

operation_display=column_set() on indexed, repeat

rows=200000

scenario_id=synthetic/mixed_indexes/benchmark_three

step_id=column_set.indexed.repeat

*mean*	42.759
σ	0.002
min	42.757
max	42.761

*mean*	13.151
σ	0.001
min	13.150
max	13.152

*mean*	0.031
σ	0.013
min	0.024
max	0.055

iterations=5

operation_display=load_product()

rows=200000

scenario_id=synthetic/mixed_indexes/benchmark_three

step_id=load_product

*mean*	8718.261
σ	0.600
min	8717.198
max	8718.651

*mean*	370.674
σ	224.401
min	31.059
max	554.631

*mean*	5.106
σ	1.497
min	3.458
max	6.919

iterations=5

operation_display=vertical_lookup_list() on indexed

rows=200000

scenario_id=synthetic/mixed_indexes/benchmark_three

step_id=vertical_lookup_list.indexed

*mean*	15147.523
σ	0.079
min	15147.397
max	15147.590

*mean*	428.980
σ	736.110
min	17.939
max	1739.593

*mean*	11.359
σ	0.985
min	10.060
max	12.221

iterations=5

operation_display=vertical_lookup_list() on indexed, repeat

rows=200000

scenario_id=synthetic/mixed_indexes/benchmark_three

step_id=vertical_lookup_list.indexed.repeat

*mean*	12.434
σ	0.001
min	12.434
max	12.437

*mean*	10.891
σ	0.000
min	10.891
max	10.891

*mean*	0.005
σ	0.001
min	0.004
max	0.006

CSV benchmark: synthetic/no_indexes/benchmark_two

Factor

allocated MiB

peak allocated MiB

time_s

iterations=5

operation_display=column_set() on unindexed

rows=200000

scenario_id=synthetic/no_indexes/benchmark_two

step_id=column_set.unindexed

*mean*	14104.794
σ	0.009
min	14104.789
max	14104.809

*mean*	386.268
σ	281.357
min	53.575
max	798.312

*mean*	8.290
σ	2.015
min	5.434
max	10.399

iterations=5

operation_display=column_set() on unindexed, repeat

rows=200000

scenario_id=synthetic/no_indexes/benchmark_two

step_id=column_set.unindexed.repeat

*mean*	73.245
σ	0.009
min	73.230
max	73.249

*mean*	18.619
σ	0.000
min	18.619
max	18.620

*mean*	0.142
σ	0.005
min	0.134
max	0.148

iterations=5

operation_display=load_product()

rows=200000

scenario_id=synthetic/no_indexes/benchmark_two

step_id=load_product

*mean*	2470.066
σ	0.136
min	2470.002
max	2470.311

*mean*	707.242
σ	1009.536
min	199.993
max	2505.808

*mean*	1.742
σ	0.825
min	1.028
max	2.926

iterations=5

operation_display=vertical_lookup_list() on unindexed missing Int

rows=200000

scenario_id=synthetic/no_indexes/benchmark_two

step_id=vertical_lookup_list.unindexed.missing_int

*mean*	27.345
σ	0.001
min	27.345
max	27.347

*mean*	12.920
σ	0.000
min	12.920
max	12.921

*mean*	0.087
σ	0.010
min	0.074
max	0.100

iterations=5

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

rows=200000

scenario_id=synthetic/no_indexes/benchmark_two

step_id=vertical_lookup_list.unindexed.missing_int.repeat

*mean*	27.343
σ	0.002
min	27.342
max	27.346

*mean*	12.921
σ	0.000
min	12.920
max	12.921

*mean*	0.087
σ	0.010
min	0.074
max	0.100

iterations=5

operation_display=vertical_lookup_list() on unindexed unique Int near end

rows=200000

scenario_id=synthetic/no_indexes/benchmark_two

step_id=vertical_lookup_list.unindexed.tail_unique_int

*mean*	27.565
σ	0.001
min	27.565
max	27.567

*mean*	15.311
σ	0.000
min	15.311
max	15.311

*mean*	0.087
σ	0.010
min	0.074
max	0.100

iterations=5

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

rows=200000

scenario_id=synthetic/no_indexes/benchmark_two

step_id=vertical_lookup_list.unindexed.tail_unique_int.repeat

*mean*	27.349
σ	0.001
min	27.349
max	27.351

*mean*	12.921
σ	0.000
min	12.920
max	12.921

*mean*	0.087
σ	0.010
min	0.074
max	0.100

iterations=5

operation_display=vertical_lookup_row_list() on unindexed small unique Int

rows=200000

scenario_id=synthetic/no_indexes/benchmark_two

step_id=vertical_lookup_row_list.unindexed.small_unique_int

*mean*	53.897
σ	0.000
min	53.896
max	53.897

*mean*	36.220
σ	0.000
min	36.220
max	36.221

*mean*	0.138
σ	0.014
min	0.122
max	0.158

iterations=5

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

rows=200000

scenario_id=synthetic/no_indexes/benchmark_two

step_id=vertical_lookup_row_list.unindexed.small_unique_int.repeat

*mean*	53.054
σ	0.000
min	53.053
max	53.054

*mean*	110.295
σ	167.133
min	35.551
max	409.272

*mean*	0.232
σ	0.199
min	0.125
max	0.587

Internal benchmark: pointedIndexFromKvs

Factor

time_s

benchmark=pointed_index_from_kvs

iterations=5

rows=400000

*mean*	0.405
σ	0.210
min	0.309
max	0.780