7db072e8e0769331e5bfb2f613594a6901e9df75

Aggregation: measureAggregations

Factor

allocated MiB

peak allocated MiB

time_s

cache=n

dps=1

iters=10

policies=100

*mean*	53.709
σ	0.366
min	53.566
max	54.750

*mean*	415.000
σ	0.000
min	415.000
max	415.000

*mean*	0.150
σ	0.012
min	0.135
max	0.166

cache=y

dps=1

iters=10

policies=100

*mean*	43.060
σ	0.005
min	43.049
max	43.067

*mean*	415.000
σ	0.000
min	415.000
max	415.000

*mean*	0.125
σ	0.009
min	0.118
max	0.145

CSV - indexed operations

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=8

operation_display=column_set() on indexed

rows=200000

*mean*	36.617
σ	0.002
min	36.615
max	36.619

*mean*	4161.500
σ	1888.123
min	1550.000
max	7167.000

*mean*	12.809
σ	0.417
min	12.287
max	13.537

iterations=8

operation_display=column_set() on indexed, repeat

rows=200000

*mean*	36.617
σ	0.002
min	36.616
max	36.620

*mean*	4278.500
σ	1966.112
min	1550.000
max	7167.000

*mean*	13.684
σ	2.281
min	11.739
max	19.090

iterations=8

operation_display=table_records(), no indexes

rows=200000

*mean*	41.930
σ	0.002
min	41.928
max	41.932

*mean*	7167.000
σ	0.000
min	7167.000
max	7167.000

*mean*	14.910
σ	0.745
min	13.489
max	15.470

iterations=8

operation_display=table_records(), no indexes, repeat

rows=200000

*mean*	41.929
σ	0.002
min	41.928
max	41.932

*mean*	7167.000
σ	0.000
min	7167.000
max	7167.000

*mean*	13.918
σ	1.007
min	12.797
max	15.595

iterations=8

operation_display=table_records(), repeat

rows=200000

*mean*	41.929
σ	0.002
min	41.927
max	41.932

*mean*	4161.500
σ	1888.123
min	1550.000
max	7167.000

*mean*	13.932
σ	1.594
min	11.438
max	15.359

iterations=8

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

rows=200000

*mean*	27.605
σ	0.003
min	27.603
max	27.611

*mean*	4161.500
σ	1888.123
min	1550.000
max	7167.000

*mean*	9.108
σ	0.352
min	8.400
max	9.513

iterations=8

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

rows=200000

*mean*	26.400
σ	0.002
min	26.399
max	26.403

*mean*	4161.500
σ	1888.123
min	1550.000
max	7167.000

*mean*	6.645
σ	0.264
min	6.383
max	7.207

iterations=8

operation_display=vertical_lookup_row_list() on 2 indexed

rows=200000

*mean*	25.666
σ	0.002
min	25.664
max	25.668

*mean*	4278.500
σ	1966.112
min	1550.000
max	7167.000

*mean*	6.183
σ	0.577
min	5.804
max	7.544

iterations=8

operation_display=vertical_lookup_row_list() on 2 indexed, repeat

rows=200000

*mean*	25.661
σ	0.002
min	25.659
max	25.663

*mean*	4278.500
σ	1966.112
min	1550.000
max	7167.000

*mean*	5.692
σ	0.626
min	5.066
max	7.160

iterations=8

operation_display=vertical_lookup_row_list() on 3 (1 unindexed)

rows=200000

*mean*	25.969
σ	0.002
min	25.967
max	25.971

*mean*	4278.500
σ	1966.112
min	1550.000
max	7167.000

*mean*	5.814
σ	0.571
min	5.232
max	7.162

iterations=8

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

rows=200000

*mean*	25.968
σ	0.002
min	25.967
max	25.971

*mean*	4278.500
σ	1966.112
min	1550.000
max	7167.000

*mean*	5.634
σ	0.521
min	5.043
max	6.834

CSV - loading a lazy table

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=8

operation_display=load_product(), no indexes

rows=200000

*mean*	2524.596
σ	0.002
min	2524.594
max	2524.598

*mean*	7167.000
σ	0.000
min	7167.000
max	7167.000

*mean*	1436.232
σ	608.544
min	1038.070
max	2394.257

iterations=8

operation_display=load_product(), with indexes

rows=200000

*mean*	8744.561
σ	0.041
min	8744.545
max	8744.661

*mean*	3590.000
σ	1810.087
min	1075.000
max	5812.000

*mean*	4487.943
σ	1355.223
min	3514.253
max	7042.548

CSV - unindexed operations

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=8

operation_display=column_set() on unindexed, dense

rows=200000

*mean*	62.077
σ	0.002
min	62.076
max	62.080

*mean*	4161.500
σ	1888.123
min	1550.000
max	7167.000

*mean*	80.406
σ	8.934
min	71.421
max	98.261

iterations=8

operation_display=column_set() on unindexed, dense, repeat

rows=200000

*mean*	62.077
σ	0.002
min	62.076
max	62.080

*mean*	4161.500
σ	1888.123
min	1550.000
max	7167.000

*mean*	80.976
σ	9.012
min	71.377
max	98.694

iterations=8

operation_display=vertical_lookup_list() on unindexed missing Int

rows=200000

*mean*	40.944
σ	0.001
min	40.944
max	40.947

*mean*	7167.000
σ	0.000
min	7167.000
max	7167.000

*mean*	103.393
σ	6.094
min	93.037
max	107.477

iterations=8

operation_display=vertical_lookup_list() on unindexed missing Int, repeat

rows=200000

*mean*	40.946
σ	0.002
min	40.943
max	40.947

*mean*	7167.000
σ	0.000
min	7167.000
max	7167.000

*mean*	103.418
σ	6.019
min	93.039
max	107.187

iterations=8

operation_display=vertical_lookup_list() on unindexed unique Int near end

rows=200000

*mean*	40.950
σ	0.002
min	40.949
max	40.953

*mean*	7167.000
σ	0.000
min	7167.000
max	7167.000

*mean*	106.072
σ	5.901
min	94.925
max	111.693

iterations=8

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

rows=200000

*mean*	40.951
σ	0.002
min	40.948
max	40.953

*mean*	7167.000
σ	0.000
min	7167.000
max	7167.000

*mean*	103.718
σ	5.921
min	93.036
max	107.704

iterations=8

operation_display=vertical_lookup_row_list() on unindexed small unique Int

rows=200000

*mean*	66.687
σ	0.002
min	66.685
max	66.690

*mean*	7167.000
σ	0.000
min	7167.000
max	7167.000

*mean*	216.719
σ	162.574
min	145.948
max	618.567

iterations=8

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

rows=200000

*mean*	66.686
σ	0.001
min	66.685
max	66.689

*mean*	7167.000
σ	0.000
min	7167.000
max	7167.000

*mean*	155.345
σ	14.803
min	124.363
max	165.997

CSV - warmup

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=8

operation_display=table_records()

rows=200000

*mean*	11656.833
σ	4.318
min	11655.305
max	11667.519

*mean*	4161.500
σ	1888.123
min	1550.000
max	7167.000

*mean*	6096.729
σ	1350.214
min	4892.002
max	8252.587

iterations=8

operation_display=vertical_lookup_list() on indexed

rows=200000

*mean*	11560.065
σ	0.001
min	11560.064
max	11560.068

*mean*	7167.000
σ	0.000
min	7167.000
max	7167.000

*mean*	5924.906
σ	1649.720
min	4378.827
max	7778.394

CSV internal benchmark: pointedIndexFromKvs

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=8

operation_display=pointedIndexFromKvs

rows=200000

*mean*	172.670
σ	0.010
min	172.657
max	172.681

*mean*	486.000
σ	0.000
min	486.000
max	486.000

*mean*	404.979
σ	18.072
min	366.035
max	418.981

iterations=8

operation_display=pointedIndexFromKvs

rows=400000

*mean*	357.472
σ	0.151
min	357.321
max	357.654

*mean*	562.000
σ	0.000
min	562.000
max	562.000

*mean*	765.864
σ	74.802
min	641.821
max	815.571

Marine Hull: transactPolicy

Factor

allocated MiB

peak allocated MiB

time

datapoints=1

iterations=20

*mean*	1005.002
σ	0.751
min	1004.530
max	1008.105

*mean*	7167.000
σ	0.000
min	7167.000
max	7167.000

*mean*	1.596
σ	0.102
min	1.455
max	1.821

Parser: Comma Sep

Factor

allocated MiB

peak allocated MiB

time (ms)

name=ambiguous_item.art

*mean*	0.883
σ	0.002
min	0.881
max	0.886

*mean*	7167.000
σ	0.000
min	7167.000
max	7167.000

*mean*	0.205
σ	0.116
min	0.142
max	0.412

name=error_case.art

*mean*	2.333
σ	0.003
min	2.332
max	2.337

*mean*	7167.000
σ	0.000
min	7167.000
max	7167.000

*mean*	0.412
σ	0.143
min	0.342
max	0.667

name=heavy_item.art

*mean*	1.521
σ	0.002
min	1.520
max	1.524

*mean*	7167.000
σ	0.000
min	7167.000
max	7167.000

*mean*	0.435
σ	0.176
min	0.225
max	0.608

name=nested_use.art

*mean*	2.355
σ	0.002
min	2.355
max	2.358

*mean*	7167.000
σ	0.000
min	7167.000
max	7167.000

*mean*	0.865
σ	0.048
min	0.826
max	0.946

Parser: Real World

Factor

allocated MiB

peak allocated MiB

time (sec)

name=aon_gpf25_7k_loc.art

*mean*	963.552
σ	0.027
min	963.527
max	963.595

*mean*	7167.000
σ	0.000
min	7167.000
max	7167.000

*mean*	0.812
σ	0.048
min	0.742
max	0.857

name=cdr_enhanced_4k_loc.art

*mean*	884.854
σ	0.009
min	884.847
max	884.867

*mean*	7167.000
σ	0.000
min	7167.000
max	7167.000

*mean*	0.739
σ	0.007
min	0.730
max	0.746

Parser: Record Parsing

Factor

allocated MiB

peak allocated MiB

time (ms)

name=record_render_large_success.art

*mean*	7.706
σ	0.002
min	7.705
max	7.711

*mean*	7167.000
σ	0.000
min	7167.000
max	7167.000

*mean*	4.228
σ	0.090
min	3.811
max	4.507

name=record_render_large_syntax_err.art

*mean*	7.655
σ	0.002
min	7.654
max	7.658

*mean*	7167.000
σ	0.000
min	7167.000
max	7167.000

*mean*	4.222
σ	0.085
min	4.062
max	4.492

name=record_render_success.art

*mean*	2.288
σ	0.002
min	2.287
max	2.291

*mean*	7167.000
σ	0.000
min	7167.000
max	7167.000

*mean*	0.762
σ	0.023
min	0.725
max	0.887

name=record_render_syntax_err.art

*mean*	2.163
σ	0.002
min	2.163
max	2.166

*mean*	7167.000
σ	0.000
min	7167.000
max	7167.000

*mean*	0.718
σ	0.020
min	0.686
max	0.807

SoV import

Factor

allocated MiB

peak allocated MiB

time_s

iters=10

rows=1000

*mean*	294.398
σ	0.226
min	294.246
max	294.999

*mean*	7167.000
σ	0.000
min	7167.000
max	7167.000

*mean*	0.550
σ	0.037
min	0.506
max	0.601

Workflow: transactPolicy

Factor

allocated MiB

peak allocated MiB

time

iters=5

new-facts=1

prior-facts=1

*mean*	281.465
σ	0.038
min	281.405
max	281.502

*mean*	7167.000
σ	0.000
min	7167.000
max	7167.000

*mean*	0.393
σ	0.008
min	0.387
max	0.405

iters=5

new-facts=1

prior-facts=6402

*mean*	1291.491
σ	0.093
min	1291.371
max	1291.581

*mean*	7167.000
σ	0.000
min	7167.000
max	7167.000

*mean*	1.948
σ	0.099
min	1.832
max	2.106

iters=5

new-facts=6402

prior-facts=1

*mean*	1534.407
σ	3.963
min	1532.418
max	1541.491

*mean*	7167.000
σ	0.000
min	7167.000
max	7167.000

*mean*	2.392
σ	0.304
min	2.129
max	2.755

iters=5

new-facts=6402

prior-facts=6402

*mean*	1853.319
σ	0.051
min	1853.246
max	1853.369

*mean*	7167.000
σ	0.000
min	7167.000
max	7167.000

*mean*	3.018
σ	0.286
min	2.853
max	3.519

newProductH/cdr_auton/broker

Factor

time_s

iterations=5

*mean*	1.492
σ	0.264
min	1.172
max	1.812

policy addition benchmark

Factor

allocated MiB

db queries

peak allocated MiB

time

policies=2

*mean*	442.432
σ	577.063
min	153.896
max	1308.025

*mean*	96.250
σ	8.500
min	92.000
max	109.000

*mean*	7167.000
σ	0.000
min	7167.000
max	7167.000

*mean*	0.539
σ	0.549
min	0.262
max	1.363

policies=20

*mean*	1539.203
σ	0.314
min	1538.999
max	1539.669

*mean*	920.000
σ	0.000
min	920.000
max	920.000

*mean*	7167.000
σ	0.000
min	7167.000
max	7167.000

*mean*	2.583
σ	0.012
min	2.575
max	2.601

policies=200

*mean*	15400.275
σ	0.080
min	15400.221
max	15400.392

*mean*	9200.000
σ	0.000
min	9200.000
max	9200.000

*mean*	7167.000
σ	0.000
min	7167.000
max	7167.000

*mean*	26.099
σ	0.168
min	25.939
max	26.260