dfc81bdb51f3da57031b03b5af11330c171df71e

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

*mean*	13.240
σ	0.326
min	12.550
max	13.672

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.003
min	36.781
max	36.788

*mean*	9574.000
σ	0.000
min	9574.000
max	9574.000

*mean*	92.028
σ	205.651
min	12.215
max	663.999

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*	5218.400
σ	2577.148
min	1268.000
max	8619.000

*mean*	102.447
σ	14.949
min	74.469
max	120.625

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

*mean*	137.802
σ	6.449
min	122.263
max	145.754

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

*mean*	5218.400
σ	2577.148
min	1268.000
max	8619.000

*mean*	9497.259
σ	1930.396
min	6742.339
max	11727.827

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.903
σ	0.004
min	14060.899
max	14060.912

*mean*	9574.000
σ	0.000
min	9574.000
max	9574.000

*mean*	6634.859
σ	1660.548
min	5478.495
max	10260.077

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.667
σ	0.417
min	8744.531
max	8745.854

*mean*	4844.000
σ	2511.652
min	1043.000
max	8619.000

*mean*	4531.465
σ	1320.007
min	3503.270
max	6734.436

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

*mean*	4213.319
σ	1143.837
min	3500.468
max	6226.504

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

*mean*	9574.000
σ	0.000
min	9574.000
max	9574.000

*mean*	4870.190
σ	1442.789
min	3507.968
max	7128.090

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

*mean*	1423.374
σ	833.068
min	1021.510
max	3366.740

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.066
max	42.071

*mean*	9574.000
σ	0.000
min	9574.000
max	9574.000

*mean*	14.085
σ	1.758
min	11.118
max	16.261

iterations=10

operation_display=table_records(), repeat

rows=200000

scenario_id=mixed_indexes/benchmark2

step_id=table_records.repeat.2

*mean*	42.068
σ	0.002
min	42.066
max	42.071

*mean*	8714.500
σ	301.998
min	8619.000
max	9574.000

*mean*	13.233
σ	1.564
min	11.740
max	16.543

iterations=10

operation_display=table_records(), repeat

rows=200000

scenario_id=no_indexes/benchmark3

step_id=table_records.repeat.3

*mean*	42.069
σ	0.002
min	42.066
max	42.071

*mean*	9574.000
σ	0.000
min	9574.000
max	9574.000

*mean*	12.669
σ	1.525
min	10.752
max	15.342

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*	8714.500
σ	301.998
min	8619.000
max	9574.000

*mean*	9394.319
σ	1998.389
min	6604.096
max	11476.951

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*	5218.400
σ	2577.148
min	1268.000
max	8619.000

*mean*	7.387
σ	0.401
min	6.613
max	7.817

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.565
max	26.569

*mean*	8714.500
σ	301.998
min	8619.000
max	9574.000

*mean*	6.896
σ	0.889
min	6.094
max	8.985

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.003
min	26.565
max	26.572

*mean*	9574.000
σ	0.000
min	9574.000
max	9574.000

*mean*	8.292
σ	0.298
min	7.732
max	8.575

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

*mean*	95.035
σ	17.050
min	64.817
max	108.296

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

*mean*	94.218
σ	18.074
min	64.363
max	109.670

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

*mean*	194.064
σ	303.501
min	72.054
max	1056.997

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*	5218.400
σ	2577.148
min	1268.000
max	8619.000

*mean*	9.759
σ	0.718
min	8.714
max	10.499

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.002
min	27.769
max	27.773

*mean*	8714.500
σ	301.998
min	8619.000
max	9574.000

*mean*	9.157
σ	0.802
min	8.443
max	11.052

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

*mean*	9574.000
σ	0.000
min	9574.000
max	9574.000

*mean*	167.321
σ	207.315
min	76.031
max	756.651

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

*mean*	10263.945
σ	2139.286
min	6553.331
max	12353.869

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.801
σ	0.003
min	25.798
max	25.806

*mean*	8714.500
σ	301.998
min	8619.000
max	9574.000

*mean*	5.431
σ	0.612
min	5.053
max	7.100

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.795
σ	0.002
min	25.793
max	25.797

*mean*	8714.500
σ	301.998
min	8619.000
max	9574.000

*mean*	5.392
σ	0.622
min	4.951
max	7.095

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*	26.101
σ	0.003
min	26.097
max	26.106

*mean*	8714.500
σ	301.998
min	8619.000
max	9574.000

*mean*	5.460
σ	0.586
min	5.028
max	7.054

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*	26.099
σ	0.002
min	26.097
max	26.101

*mean*	8714.500
σ	301.998
min	8619.000
max	9574.000

*mean*	5.380
σ	0.580
min	4.902
max	6.957

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

*mean*	144.012
σ	24.091
min	105.871
max	165.032

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.839
σ	0.002
min	66.837
max	66.841

*mean*	9574.000
σ	0.000
min	9574.000
max	9574.000

*mean*	144.580
σ	23.999
min	107.133
max	167.556

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*	555.000
σ	4.830
min	548.000
max	558.000

*mean*	769.093
σ	57.009
min	632.951
max	827.347