228b32f8e538fe60297658c53398ded653fe9ed0

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.764
σ	0.002
min	36.762
max	36.766

*mean*	9949.000
σ	0.000
min	9949.000
max	9949.000

*mean*	54.881
σ	132.128
min	12.060
max	430.920

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.765
σ	0.002
min	36.762
max	36.766

*mean*	9949.000
σ	0.000
min	9949.000
max	9949.000

*mean*	33.531
σ	61.121
min	12.003
max	207.267

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=benchmark1

step_id=column_set.unindexed.dense.repeat.1

*mean*	62.224
σ	0.002
min	62.222
max	62.226

*mean*	5371.000
σ	2677.022
min	1395.000
max	9283.000

*mean*	105.573
σ	10.121
min	90.998
max	117.402

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.812
σ	0.002
min	70.811
max	70.815

*mean*	9949.000
σ	0.000
min	9949.000
max	9949.000

*mean*	135.261
σ	12.035
min	111.055
max	143.377

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=benchmark1

step_id=column_set.unindexed.dense.1

*mean*	62.224
σ	0.002
min	62.222
max	62.226

*mean*	5371.000
σ	2677.022
min	1395.000
max	9283.000

*mean*	105.634
σ	9.279
min	93.283
max	117.289

iterations=10

operation_display=column_set() on unindexed, sparse

rows=200000

scenario_id=no_indexes/benchmark3

step_id=column_set.unindexed.sparse.3

*mean*	70.815
σ	0.004
min	70.811
max	70.824

*mean*	9949.000
σ	0.000
min	9949.000
max	9949.000

*mean*	309.137
σ	355.363
min	137.951
max	1050.265

CSV - loading a lazy table

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=10

operation_display=load_product()

rows=200000

scenario_id=benchmark1

step_id=load_product.1

*mean*	8744.530
σ	0.003
min	8744.527
max	8744.535

*mean*	5168.000
σ	2813.148
min	1049.000
max	9283.000

*mean*	5744.129
σ	1379.349
min	3803.511
max	7217.456

iterations=10

operation_display=load_product()

rows=200000

scenario_id=mixed_indexes/benchmark2

step_id=load_product.2

*mean*	8744.531
σ	0.003
min	8744.527
max	8744.535

*mean*	9283.000
σ	0.000
min	9283.000
max	9283.000

*mean*	5523.217
σ	1539.210
min	3565.054
max	7533.189

iterations=10

operation_display=load_product()

rows=200000

scenario_id=mixed_indexes/benchmark4

step_id=load_product.4.mixed_indexes

*mean*	8744.529
σ	0.002
min	8744.527
max	8744.534

*mean*	9949.000
σ	0.000
min	9949.000
max	9949.000

*mean*	5223.472
σ	1537.008
min	3574.564
max	7632.628

iterations=10

operation_display=load_product(), no indexes

rows=200000

scenario_id=no_indexes/benchmark3

step_id=load_product.3.no_indexes

*mean*	2524.579
σ	0.004
min	2524.576
max	2524.589

*mean*	9949.000
σ	0.000
min	9949.000
max	9949.000

*mean*	1318.402
σ	607.088
min	1036.874
max	2811.670

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.050
σ	0.002
min	42.048
max	42.052

*mean*	9949.000
σ	0.000
min	9949.000
max	9949.000

*mean*	11.892
σ	1.350
min	10.456
max	14.413

iterations=10

operation_display=table_records(), repeat

rows=200000

scenario_id=mixed_indexes/benchmark2

step_id=table_records.repeat.2

*mean*	42.048
σ	0.002
min	42.047
max	42.051

*mean*	9349.600
σ	210.608
min	9283.000
max	9949.000

*mean*	12.504
σ	1.386
min	10.631
max	14.599

iterations=10

operation_display=table_records(), repeat

rows=200000

scenario_id=no_indexes/benchmark3

step_id=table_records.repeat.3

*mean*	42.049
σ	0.002
min	42.047
max	42.052

*mean*	9949.000
σ	0.000
min	9949.000
max	9949.000

*mean*	11.779
σ	1.371
min	10.237
max	13.975

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*	42.047
σ	0.001
min	42.047
max	42.051

*mean*	9349.600
σ	210.608
min	9283.000
max	9949.000

*mean*	13.905
σ	1.586
min	11.106
max	15.530

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=benchmark1

step_id=vertical_lookup_list.indexed.repeat.1

*mean*	26.548
σ	0.002
min	26.545
max	26.549

*mean*	5371.000
σ	2677.022
min	1395.000
max	9283.000

*mean*	6.518
σ	0.473
min	5.813
max	7.309

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.549
σ	0.001
min	26.545
max	26.549

*mean*	9349.600
σ	210.608
min	9283.000
max	9949.000

*mean*	6.575
σ	0.367
min	5.980
max	7.131

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.548
σ	0.002
min	26.545
max	26.549

*mean*	9949.000
σ	0.000
min	9949.000
max	9949.000

*mean*	6.682
σ	0.482
min	5.994
max	7.196

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.092
σ	0.002
min	41.090
max	41.094

*mean*	9949.000
σ	0.000
min	9949.000
max	9949.000

*mean*	91.817
σ	17.575
min	63.188
max	108.325

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.093
σ	0.004
min	41.090
max	41.103

*mean*	9949.000
σ	0.000
min	9949.000
max	9949.000

*mean*	188.682
σ	243.693
min	62.446
max	823.407

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.098
σ	0.002
min	41.095
max	41.099

*mean*	9949.000
σ	0.000
min	9949.000
max	9949.000

*mean*	94.662
σ	17.402
min	63.921
max	108.801

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=benchmark1

step_id=vertical_lookup_list.indexed.1

*mean*	26.548
σ	0.002
min	26.545
max	26.549

*mean*	5371.000
σ	2677.022
min	1395.000
max	9283.000

*mean*	6.938
σ	0.567
min	5.799
max	7.527

iterations=10

operation_display=vertical_lookup_list() on indexed

rows=200000

scenario_id=mixed_indexes/benchmark2

step_id=vertical_lookup_list.indexed.2

*mean*	26.546
σ	0.002
min	26.545
max	26.549

*mean*	9349.600
σ	210.608
min	9283.000
max	9949.000

*mean*	7.104
σ	0.369
min	6.547
max	7.623

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.097
σ	0.002
min	41.095
max	41.099

*mean*	9949.000
σ	0.000
min	9949.000
max	9949.000

*mean*	94.613
σ	17.016
min	64.175
max	108.765

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*	26.547
σ	0.002
min	26.545
max	26.549

*mean*	9949.000
σ	0.000
min	9949.000
max	9949.000

*mean*	7.968
σ	0.336
min	7.518
max	8.565

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.664
σ	0.001
min	25.662
max	25.666

*mean*	9349.600
σ	210.608
min	9283.000
max	9949.000

*mean*	5.075
σ	0.183
min	4.855
max	5.362

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.664
σ	0.002
min	25.661
max	25.666

*mean*	9349.600
σ	210.608
min	9283.000
max	9949.000

*mean*	5.117
σ	0.206
min	4.846
max	5.519

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.853
σ	0.001
min	25.852
max	25.857

*mean*	9349.600
σ	210.608
min	9283.000
max	9949.000

*mean*	5.089
σ	0.184
min	4.799
max	5.325

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.853
σ	0.001
min	25.852
max	25.856

*mean*	9349.600
σ	210.608
min	9283.000
max	9949.000

*mean*	5.110
σ	0.154
min	4.884
max	5.278

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.819
σ	0.002
min	66.818
max	66.821

*mean*	9949.000
σ	0.000
min	9949.000
max	9949.000

*mean*	127.741
σ	25.255
min	103.204
max	166.974

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.820
σ	0.002
min	66.818
max	66.821

*mean*	9949.000
σ	0.000
min	9949.000
max	9949.000

*mean*	128.119
σ	25.254
min	102.896
max	166.504

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.600
σ	4.427
min	545.000
max	559.000

*mean*	769.423
σ	35.470
min	684.577
max	800.418