9b37ea77bdc64409011a355699e91e163edee68f

Aggregation: measureAggregations

Factor

allocated MiB

peak allocated MiB

time_s

cache=n

dps=1

iters=10

policies=100

*mean*	54.057
σ	0.368
min	53.914
max	55.105

*mean*	418.000
σ	0.000
min	418.000
max	418.000

*mean*	0.141
σ	0.003
min	0.138
max	0.146

cache=y

dps=1

iters=10

policies=100

*mean*	43.395
σ	0.008
min	43.385
max	43.409

*mean*	418.000
σ	0.000
min	418.000
max	418.000

*mean*	0.123
σ	0.004
min	0.120
max	0.128

CSV - column_set() on indexed

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=10

operation_display=column_set() on indexed

rows=200000

*mean*	36.614
σ	0.000
min	36.614
max	36.615

*mean*	8887.000
σ	0.000
min	8887.000
max	8887.000

*mean*	13.041
σ	0.414
min	12.484
max	13.646

iterations=10

operation_display=column_set() on indexed, repeat

rows=200000

*mean*	36.614
σ	0.000
min	36.614
max	36.614

*mean*	8887.000
σ	0.000
min	8887.000
max	8887.000

*mean*	12.630
σ	0.558
min	11.817
max	13.250

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

*mean*	62.074
σ	0.000
min	62.074
max	62.075

*mean*	5111.700
σ	2610.220
min	1356.000
max	8533.000

*mean*	105.202
σ	12.332
min	82.420
max	119.873

iterations=10

operation_display=column_set() on unindexed, sparse, repeat

rows=200000

*mean*	70.664
σ	0.002
min	70.662
max	70.668

*mean*	8887.000
σ	0.000
min	8887.000
max	8887.000

*mean*	201.607
σ	202.266
min	135.531
max	777.237

CSV - column_set(), warmup

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=10

operation_display=column_set() on unindexed, dense

rows=200000

*mean*	15109.632
σ	3.862
min	15108.410
max	15120.624

*mean*	5111.700
σ	2610.220
min	1356.000
max	8533.000

*mean*	9947.788
σ	2278.230
min	6660.158
max	12548.469

iterations=10

operation_display=column_set() on unindexed, sparse

rows=200000

*mean*	14060.732
σ	0.002
min	14060.731
max	14060.736

*mean*	8887.000
σ	0.000
min	8887.000
max	8887.000

*mean*	8432.210
σ	2113.917
min	5430.379
max	11452.268

CSV - loading a lazy table

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=10

operation_display=load_product() with indexes

rows=200000

*mean*	8744.535
σ	0.000
min	8744.534
max	8744.535

*mean*	8887.000
σ	0.000
min	8887.000
max	8887.000

*mean*	4508.807
σ	1149.775
min	3501.342
max	6004.661

iterations=10

operation_display=load_product(), no indexes

rows=200000

*mean*	2524.581
σ	0.002
min	2524.579
max	2524.583

*mean*	8887.000
σ	0.000
min	8887.000
max	8887.000

*mean*	1455.235
σ	982.668
min	1024.309
max	4019.295

iterations=10

operation_display=load_product(), with indexes

rows=200000

*mean*	8744.546
σ	0.035
min	8744.534
max	8744.645

*mean*	4712.700
σ	2572.096
min	1077.000
max	8533.000

*mean*	4775.949
σ	1217.652
min	3503.051
max	6902.864

iterations=10

operation_display=load_product()with indexes

rows=200000

*mean*	8744.532
σ	0.002
min	8744.530
max	8744.535

*mean*	8568.400
σ	111.945
min	8533.000
max	8887.000

*mean*	4766.504
σ	1450.613
min	3503.778
max	7240.200

CSV - table_records()

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=10

operation_display=table_records(), no indexes

rows=200000

*mean*	41.902
σ	0.002
min	41.900
max	41.904

*mean*	8887.000
σ	0.000
min	8887.000
max	8887.000

*mean*	14.663
σ	1.234
min	11.274
max	15.476

iterations=10

operation_display=table_records(), no indexes, repeat

rows=200000

*mean*	41.900
σ	0.002
min	41.900
max	41.903

*mean*	8887.000
σ	0.000
min	8887.000
max	8887.000

*mean*	13.678
σ	1.386
min	10.765
max	15.490

iterations=10

operation_display=table_records(), repeat

rows=200000

*mean*	41.901
σ	0.002
min	41.899
max	41.904

*mean*	8568.400
σ	111.945
min	8533.000
max	8887.000

*mean*	14.316
σ	1.559
min	11.153
max	15.727

CSV - table_records(), warmup

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=10

operation_display=table_records()

rows=200000

*mean*	15088.238
σ	0.002
min	15088.236
max	15088.242

*mean*	8568.400
σ	111.945
min	8533.000
max	8887.000

*mean*	9874.848
σ	2196.310
min	6499.327
max	12671.283

CSV - vertical_lookup_list() on indexed

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=10

operation_display=vertical_lookup_list() on indexed, after column_set(), repeat

rows=200000

*mean*	26.398
σ	0.001
min	26.397
max	26.401

*mean*	5111.700
σ	2610.220
min	1356.000
max	8533.000

*mean*	7.018
σ	0.587
min	6.257
max	7.744

iterations=10

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

rows=200000

*mean*	26.398
σ	0.002
min	26.397
max	26.401

*mean*	8568.400
σ	111.945
min	8533.000
max	8887.000

*mean*	6.700
σ	0.453
min	5.803
max	7.372

iterations=10

operation_display=vertical_lookup_list() on indexed, repeat

rows=200000

*mean*	26.398
σ	0.000
min	26.398
max	26.398

*mean*	8887.000
σ	0.000
min	8887.000
max	8887.000

*mean*	8.214
σ	0.387
min	7.620
max	8.732

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

*mean*	40.944
σ	0.003
min	40.942
max	40.949

*mean*	8887.000
σ	0.000
min	8887.000
max	8887.000

*mean*	97.451
σ	11.624
min	75.908
max	107.512

iterations=10

operation_display=vertical_lookup_list() on unindexed missing Int, repeat

rows=200000

*mean*	40.943
σ	0.002
min	40.942
max	40.946

*mean*	8887.000
σ	0.000
min	8887.000
max	8887.000

*mean*	96.683
σ	12.760
min	70.713
max	107.623

iterations=10

operation_display=vertical_lookup_list() on unindexed unique Int near end

rows=200000

*mean*	40.949
σ	0.002
min	40.947
max	40.952

*mean*	8887.000
σ	0.000
min	8887.000
max	8887.000

*mean*	99.850
σ	8.029
min	80.545
max	107.427

iterations=10

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

rows=200000

*mean*	40.948
σ	0.001
min	40.947
max	40.951

*mean*	8887.000
σ	0.000
min	8887.000
max	8887.000

*mean*	128.542
σ	91.142
min	76.398
max	386.685

CSV - vertical_lookup_list(), mini warmup

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=10

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

rows=200000

*mean*	27.602
σ	0.001
min	27.602
max	27.603

*mean*	5111.700
σ	2610.220
min	1356.000
max	8533.000

*mean*	9.870
σ	0.691
min	8.827
max	10.616

iterations=10

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

rows=200000

*mean*	27.602
σ	0.002
min	27.602
max	27.605

*mean*	8568.400
σ	111.945
min	8533.000
max	8887.000

*mean*	9.641
σ	0.611
min	8.272
max	10.239

CSV - vertical_lookup_list(), warmup

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=10

operation_display=vertical_lookup_list() on indexed

rows=200000

*mean*	15073.940
σ	0.000
min	15073.939
max	15073.940

*mean*	8887.000
σ	0.000
min	8887.000
max	8887.000

*mean*	9658.605
σ	2392.196
min	6483.387
max	12229.084

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

*mean*	25.633
σ	0.002
min	25.631
max	25.637

*mean*	8568.400
σ	111.945
min	8533.000
max	8887.000

*mean*	5.149
σ	0.189
min	4.945
max	5.540

iterations=10

operation_display=vertical_lookup_row_list() on 2 indexed, repeat

rows=200000

*mean*	25.628
σ	0.002
min	25.626
max	25.630

*mean*	8568.400
σ	111.945
min	8533.000
max	8887.000

*mean*	5.039
σ	0.185
min	4.874
max	5.368

iterations=10

operation_display=vertical_lookup_row_list() on 3 (1 unindexed)

rows=200000

*mean*	25.932
σ	0.002
min	25.930
max	25.935

*mean*	8568.400
σ	111.945
min	8533.000
max	8887.000

*mean*	5.158
σ	0.217
min	4.923
max	5.504

iterations=10

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

rows=200000

*mean*	25.931
σ	0.002
min	25.930
max	25.934

*mean*	8568.400
σ	111.945
min	8533.000
max	8887.000

*mean*	5.096
σ	0.166
min	4.840
max	5.350

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

*mean*	66.671
σ	0.001
min	66.670
max	66.673

*mean*	8887.000
σ	0.000
min	8887.000
max	8887.000

*mean*	150.728
σ	17.399
min	113.634
max	165.000

iterations=10

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

rows=200000

*mean*	66.670
σ	0.002
min	66.670
max	66.673

*mean*	8887.000
σ	0.000
min	8887.000
max	8887.000

*mean*	150.718
σ	17.331
min	114.385
max	165.539

CSV internal benchmark: pointedIndexFromKvs

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=10

operation_display=pointedIndexFromKvs

rows=200000

*mean*	172.663
σ	0.007
min	172.650
max	172.674

*mean*	491.000
σ	0.000
min	491.000
max	491.000

*mean*	391.865
σ	26.246
min	344.574
max	420.228

iterations=10

operation_display=pointedIndexFromKvs

rows=400000

*mean*	357.404
σ	0.135
min	357.321
max	357.643

*mean*	569.000
σ	0.000
min	569.000
max	569.000

*mean*	777.539
σ	58.339
min	652.487
max	867.770

Marine Hull: transactPolicy

Factor

allocated MiB

peak allocated MiB

time

datapoints=1

iterations=20

*mean*	1006.876
σ	0.751
min	1006.403
max	1009.977

*mean*	8887.000
σ	0.000
min	8887.000
max	8887.000

*mean*	1.569
σ	0.140
min	1.463
max	1.995

Parser: Comma Sep

Factor

allocated MiB

peak allocated MiB

time (ms)

name=ambiguous_item.art

*mean*	0.883
σ	0.003
min	0.882
max	0.887

*mean*	8887.000
σ	0.000
min	8887.000
max	8887.000

*mean*	0.308
σ	0.124
min	0.246
max	0.529

name=error_case.art

*mean*	2.339
σ	0.003
min	2.337
max	2.342

*mean*	8887.000
σ	0.000
min	8887.000
max	8887.000

*mean*	0.831
σ	0.130
min	0.642
max	0.993

name=heavy_item.art

*mean*	1.524
σ	0.002
min	1.522
max	1.526

*mean*	8887.000
σ	0.000
min	8887.000
max	8887.000

*mean*	0.536
σ	0.045
min	0.497
max	0.607

name=nested_use.art

*mean*	2.361
σ	0.002
min	2.360
max	2.364

*mean*	8887.000
σ	0.000
min	8887.000
max	8887.000

*mean*	0.847
σ	0.042
min	0.813
max	0.917

Parser: Real World

Factor

allocated MiB

peak allocated MiB

time (sec)

name=aon_gpf25_7k_loc.art

*mean*	964.829
σ	0.027
min	964.802
max	964.864

*mean*	8887.000
σ	0.000
min	8887.000
max	8887.000

*mean*	0.828
σ	0.023
min	0.788
max	0.841

name=cdr_enhanced_4k_loc.art

*mean*	885.511
σ	0.006
min	885.504
max	885.519

*mean*	8887.000
σ	0.000
min	8887.000
max	8887.000

*mean*	0.720
σ	0.020
min	0.685
max	0.734

Parser: Record Parsing

Factor

allocated MiB

peak allocated MiB

time (ms)

name=record_render_large_success.art

*mean*	7.716
σ	0.002
min	7.715
max	7.721

*mean*	8887.000
σ	0.000
min	8887.000
max	8887.000

*mean*	4.211
σ	0.084
min	4.042
max	4.543

name=record_render_large_syntax_err.art

*mean*	7.665
σ	0.002
min	7.664
max	7.668

*mean*	8887.000
σ	0.000
min	8887.000
max	8887.000

*mean*	4.203
σ	0.084
min	4.060
max	4.513

name=record_render_success.art

*mean*	2.291
σ	0.002
min	2.290
max	2.294

*mean*	8887.000
σ	0.000
min	8887.000
max	8887.000

*mean*	0.729
σ	0.021
min	0.675
max	0.842

name=record_render_syntax_err.art

*mean*	2.166
σ	0.002
min	2.165
max	2.169

*mean*	8887.000
σ	0.000
min	8887.000
max	8887.000

*mean*	0.703
σ	0.014
min	0.675
max	0.785

SoV import

Factor

allocated MiB

peak allocated MiB

time_s

iters=10

rows=1000

*mean*	295.519
σ	0.232
min	295.276
max	296.094

*mean*	8887.000
σ	0.000
min	8887.000
max	8887.000

*mean*	0.566
σ	0.066
min	0.498
max	0.712

Workflow: transactPolicy

Factor

allocated MiB

peak allocated MiB

time

iters=5

new-facts=1

prior-facts=1

*mean*	285.368
σ	0.025
min	285.335
max	285.402

*mean*	8887.000
σ	0.000
min	8887.000
max	8887.000

*mean*	0.394
σ	0.007
min	0.390
max	0.407

iters=5

new-facts=1

prior-facts=6402

*mean*	1295.797
σ	0.076
min	1295.693
max	1295.908

*mean*	8887.000
σ	0.000
min	8887.000
max	8887.000

*mean*	2.090
σ	0.180
min	1.821
max	2.266

iters=5

new-facts=6402

prior-facts=1

*mean*	1539.981
σ	6.890
min	1536.729
max	1552.304

*mean*	8887.000
σ	0.000
min	8887.000
max	8887.000

*mean*	2.318
σ	0.176
min	2.117
max	2.578

iters=5

new-facts=6402

prior-facts=6402

*mean*	1857.648
σ	0.070
min	1857.558
max	1857.723

*mean*	8887.000
σ	0.000
min	8887.000
max	8887.000

*mean*	3.024
σ	0.110
min	2.854
max	3.143

newProductH/cdr_auton/broker

Factor

time_s

iterations=5

*mean*	1.614
σ	0.235
min	1.234
max	1.841

policy addition benchmark

Factor

allocated MiB

db queries

peak allocated MiB

time

policies=2

*mean*	445.738
σ	580.932
min	155.269
max	1317.136

*mean*	96.250
σ	8.500
min	92.000
max	109.000

*mean*	8887.000
σ	0.000
min	8887.000
max	8887.000

*mean*	0.562
σ	0.583
min	0.266
max	1.436

policies=20

*mean*	1552.986
σ	0.335
min	1552.759
max	1553.482

*mean*	920.000
σ	0.000
min	920.000
max	920.000

*mean*	8887.000
σ	0.000
min	8887.000
max	8887.000

*mean*	2.611
σ	0.028
min	2.592
max	2.653

policies=200

*mean*	15538.012
σ	0.167
min	15537.847
max	15538.243

*mean*	9200.000
σ	0.000
min	9200.000
max	9200.000

*mean*	8887.000
σ	0.000
min	8887.000
max	8887.000

*mean*	26.320
σ	0.158
min	26.123
max	26.451