cd3562a0a687d02d7ad65df4929762c0ce6b36fa

CSV - column_set() on indexed

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=10

operation_display=column_set() on indexed

rows=200000

scenario_id=mixed_indexes/benchmark4

step_id=column_set.indexed.4

*mean*	36.783
σ	0.002
min	36.781
max	36.785

*mean*	9581.000
σ	0.000
min	9581.000
max	9581.000

*mean*	70.903
σ	183.279
min	12.644
max	592.523

iterations=10

operation_display=column_set() on indexed, repeat

rows=200000

scenario_id=mixed_indexes/benchmark4

step_id=column_set.indexed.repeat.4

*mean*	36.783
σ	0.002
min	36.781
max	36.787

*mean*	9581.000
σ	0.000
min	9581.000
max	9581.000

*mean*	25.482
σ	35.997
min	12.281
max	127.689

CSV - column_set() on unindexed

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=10

operation_display=column_set() on unindexed, dense, repeat

rows=200000

scenario_id=mixed_indexes/benchmark1

step_id=column_set.unindexed.dense.repeat.1

*mean*	62.241
σ	0.000
min	62.241
max	62.242

*mean*	5216.300
σ	2577.853
min	1266.000
max	8616.000

*mean*	100.925
σ	13.955
min	82.389
max	113.674

iterations=10

operation_display=column_set() on unindexed, sparse, repeat

rows=200000

scenario_id=no_indexes/benchmark3

step_id=column_set.unindexed.sparse.repeat.3

*mean*	70.832
σ	0.002
min	70.830
max	70.834

*mean*	9581.000
σ	0.000
min	9581.000
max	9581.000

*mean*	135.294
σ	5.663
min	120.830
max	139.559

CSV - column_set(), warmup

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=10

operation_display=column_set() on unindexed, dense

rows=200000

scenario_id=mixed_indexes/benchmark1

step_id=column_set.unindexed.dense.1

*mean*	15109.841
σ	3.993
min	15108.577
max	15121.206

*mean*	5216.300
σ	2577.853
min	1266.000
max	8616.000

*mean*	9971.609
σ	2043.469
min	6655.627
max	11823.489

iterations=10

operation_display=column_set() on unindexed, sparse

rows=200000

scenario_id=no_indexes/benchmark3

step_id=column_set.unindexed.sparse.3

*mean*	14060.902
σ	0.004
min	14060.898
max	14060.911

*mean*	9581.000
σ	0.000
min	9581.000
max	9581.000

*mean*	7121.631
σ	1814.878
min	5427.528
max	9589.509

CSV - loading a lazy table

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=10

operation_display=load_product()

rows=200000

scenario_id=mixed_indexes/benchmark1

step_id=load_product.1

*mean*	8744.666
σ	0.417
min	8744.530
max	8745.854

*mean*	4842.400
σ	2512.200
min	1044.000
max	8616.000

*mean*	4510.076
σ	1212.398
min	3512.254
max	6964.618

iterations=10

operation_display=load_product()

rows=200000

scenario_id=mixed_indexes/benchmark2

step_id=load_product.2

*mean*	8744.534
σ	0.003
min	8744.530
max	8744.539

*mean*	8616.000
σ	0.000
min	8616.000
max	8616.000

*mean*	4407.648
σ	1443.688
min	3520.821
max	7016.321

iterations=10

operation_display=load_product()

rows=200000

scenario_id=mixed_indexes/benchmark4

step_id=load_product.4.mixed_indexes

*mean*	8744.535
σ	0.003
min	8744.531
max	8744.539

*mean*	9581.000
σ	0.000
min	9581.000
max	9581.000

*mean*	4980.640
σ	1490.708
min	3536.123
max	7422.543

iterations=10

operation_display=load_product(), no indexes

rows=200000

scenario_id=no_indexes/benchmark3

step_id=load_product.3.no_indexes

*mean*	2524.583
σ	0.004
min	2524.579
max	2524.591

*mean*	9581.000
σ	0.000
min	9581.000
max	9581.000

*mean*	1421.962
σ	826.080
min	1032.429
max	3339.567

CSV - table_records()

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=10

operation_display=table_records()

rows=200000

scenario_id=no_indexes/benchmark3

step_id=table_records.3

*mean*	42.069
σ	0.002
min	42.067
max	42.071

*mean*	9581.000
σ	0.000
min	9581.000
max	9581.000

*mean*	14.090
σ	1.746
min	11.381
max	15.883

iterations=10

operation_display=table_records(), repeat

rows=200000

scenario_id=mixed_indexes/benchmark2

step_id=table_records.repeat.2

*mean*	42.067
σ	0.002
min	42.066
max	42.070

*mean*	8712.500
σ	305.160
min	8616.000
max	9581.000

*mean*	13.013
σ	1.925
min	10.932
max	16.666

iterations=10

operation_display=table_records(), repeat

rows=200000

scenario_id=no_indexes/benchmark3

step_id=table_records.repeat.3

*mean*	42.069
σ	0.003
min	42.067
max	42.075

*mean*	9581.000
σ	0.000
min	9581.000
max	9581.000

*mean*	13.156
σ	1.785
min	10.536
max	15.064

CSV - table_records(), warmup

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=10

operation_display=table_records()

rows=200000

scenario_id=mixed_indexes/benchmark2

step_id=table_records.2

*mean*	15088.408
σ	0.003
min	15088.403
max	15088.413

*mean*	8712.500
σ	305.160
min	8616.000
max	9581.000

*mean*	9448.676
σ	2249.393
min	6597.185
max	12443.933

CSV - vertical_lookup_list() on indexed

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=10

operation_display=vertical_lookup_list() on indexed, repeat

rows=200000

scenario_id=mixed_indexes/benchmark1

step_id=vertical_lookup_list.indexed.repeat.1

*mean*	26.567
σ	0.002
min	26.565
max	26.569

*mean*	5216.300
σ	2577.853
min	1266.000
max	8616.000

*mean*	7.307
σ	0.283
min	6.948
max	7.760

iterations=10

operation_display=vertical_lookup_list() on indexed, repeat

rows=200000

scenario_id=mixed_indexes/benchmark2

step_id=vertical_lookup_list.indexed.repeat.2

*mean*	26.567
σ	0.002
min	26.564
max	26.569

*mean*	8712.500
σ	305.160
min	8616.000
max	9581.000

*mean*	7.373
σ	1.195
min	6.736
max	10.706

iterations=10

operation_display=vertical_lookup_list() on indexed, repeat

rows=200000

scenario_id=mixed_indexes/benchmark4

step_id=vertical_lookup_list.indexed.repeat.4

*mean*	26.567
σ	0.002
min	26.565
max	26.569

*mean*	9581.000
σ	0.000
min	9581.000
max	9581.000

*mean*	8.093
σ	0.357
min	7.538
max	8.472

CSV - vertical_lookup_list() on unindexed

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=10

operation_display=vertical_lookup_list() on unindexed missing Int

rows=200000

scenario_id=no_indexes/benchmark3

step_id=vertical_lookup_list.unindexed.missing_int.3

*mean*	41.111
σ	0.002
min	41.110
max	41.114

*mean*	9581.000
σ	0.000
min	9581.000
max	9581.000

*mean*	95.035
σ	16.970
min	61.333
max	109.487

iterations=10

operation_display=vertical_lookup_list() on unindexed missing Int, repeat

rows=200000

scenario_id=no_indexes/benchmark3

step_id=vertical_lookup_list.unindexed.missing_int.repeat.3

*mean*	41.112
σ	0.002
min	41.109
max	41.114

*mean*	9581.000
σ	0.000
min	9581.000
max	9581.000

*mean*	93.678
σ	18.651
min	61.066
max	109.253

iterations=10

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

rows=200000

scenario_id=no_indexes/benchmark3

step_id=vertical_lookup_list.unindexed.tail_unique_int.repeat.3

*mean*	41.117
σ	0.002
min	41.115
max	41.120

*mean*	9581.000
σ	0.000
min	9581.000
max	9581.000

*mean*	198.685
σ	319.688
min	67.481
max	1107.572

CSV - vertical_lookup_list(), mini warmup

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=10

operation_display=vertical_lookup_list() on indexed

rows=200000

scenario_id=mixed_indexes/benchmark1

step_id=vertical_lookup_list.indexed.1

*mean*	27.771
σ	0.003
min	27.769
max	27.778

*mean*	5216.300
σ	2577.853
min	1266.000
max	8616.000

*mean*	9.728
σ	0.721
min	8.767
max	10.389

iterations=10

operation_display=vertical_lookup_list() on indexed

rows=200000

scenario_id=mixed_indexes/benchmark2

step_id=vertical_lookup_list.indexed.2

*mean*	27.771
σ	0.003
min	27.769
max	27.777

*mean*	8712.500
σ	305.160
min	8616.000
max	9581.000

*mean*	9.419
σ	1.424
min	8.304
max	13.220

iterations=10

operation_display=vertical_lookup_list() on unindexed unique Int near end

rows=200000

scenario_id=no_indexes/benchmark3

step_id=vertical_lookup_list.unindexed.tail_unique_int.3

*mean*	41.117
σ	0.002
min	41.114
max	41.121

*mean*	9581.000
σ	0.000
min	9581.000
max	9581.000

*mean*	171.299
σ	220.135
min	76.214
max	797.104

CSV - vertical_lookup_list(), warmup

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=10

operation_display=vertical_lookup_list() on indexed

rows=200000

scenario_id=mixed_indexes/benchmark4

step_id=vertical_lookup_list.indexed.4

*mean*	15074.109
σ	0.002
min	15074.106
max	15074.113

*mean*	9581.000
σ	0.000
min	9581.000
max	9581.000

*mean*	10588.427
σ	2133.900
min	6587.985
max	12425.190

CSV - vertical_lookup_row_list() on indexed

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=10

operation_display=vertical_lookup_row_list() on 2 indexed

rows=200000

scenario_id=mixed_indexes/benchmark2

step_id=vertical_lookup_row_list.two_indexed.2

*mean*	25.683
σ	0.002
min	25.680
max	25.686

*mean*	8712.500
σ	305.160
min	8616.000
max	9581.000

*mean*	5.606
σ	0.960
min	5.141
max	8.320

iterations=10

operation_display=vertical_lookup_row_list() on 2 indexed, repeat

rows=200000

scenario_id=mixed_indexes/benchmark2

step_id=vertical_lookup_row_list.two_indexed.repeat.2

*mean*	25.683
σ	0.002
min	25.680
max	25.685

*mean*	8712.500
σ	305.160
min	8616.000
max	9581.000

*mean*	5.556
σ	1.024
min	4.867
max	8.439

iterations=10

operation_display=vertical_lookup_row_list() on 3 (1 unindexed)

rows=200000

scenario_id=mixed_indexes/benchmark2

step_id=vertical_lookup_row_list.three_one_unindexed.2

*mean*	25.875
σ	0.002
min	25.872
max	25.880

*mean*	8712.500
σ	305.160
min	8616.000
max	9581.000

*mean*	5.593
σ	1.028
min	4.980
max	8.487

iterations=10

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

rows=200000

scenario_id=mixed_indexes/benchmark2

step_id=vertical_lookup_row_list.three_one_unindexed.repeat.2

*mean*	25.873
σ	0.002
min	25.872
max	25.876

*mean*	8712.500
σ	305.160
min	8616.000
max	9581.000

*mean*	5.554
σ	0.977
min	5.080
max	8.321

CSV - vertical_lookup_row_list() on unindexed

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=10

operation_display=vertical_lookup_row_list() on unindexed small unique Int

rows=200000

scenario_id=no_indexes/benchmark3

step_id=vertical_lookup_row_list.unindexed.small_unique_int.3

*mean*	66.839
σ	0.002
min	66.837
max	66.841

*mean*	9581.000
σ	0.000
min	9581.000
max	9581.000

*mean*	143.002
σ	26.762
min	98.886
max	166.718

iterations=10

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

rows=200000

scenario_id=no_indexes/benchmark3

step_id=vertical_lookup_row_list.unindexed.small_unique_int.repeat.3

*mean*	66.838
σ	0.002
min	66.837
max	66.841

*mean*	9581.000
σ	0.000
min	9581.000
max	9581.000

*mean*	143.694
σ	26.604
min	100.071
max	167.301

CSV internal benchmark: pointedIndexFromKvs

Factor

allocated MiB

peak allocated MiB

time (ms)

benchmark=pointed_index_from_kvs

iterations=10

rows=400000

*mean*	357.322
σ	0.002
min	357.321
max	357.325

*mean*	557.000
σ	8.055
min	545.000
max	562.000

*mean*	726.727
σ	79.059
min	595.643
max	841.402