0481445eb6536279669585c04916ab40e4688bb1

Aggregation: measureAggregations

Factor

allocated MiB

peak allocated MiB

time_s

cache=n

dps=1

iters=10

policies=100

*mean*	54.617
σ	0.349
min	54.484
max	55.609

*mean*	416.000
σ	0.000
min	416.000
max	416.000

*mean*	0.142
σ	0.005
min	0.138
max	0.150

cache=y

dps=1

iters=10

policies=100

*mean*	43.786
σ	0.008
min	43.777
max	43.800

*mean*	416.000
σ	0.000
min	416.000
max	416.000

*mean*	0.126
σ	0.008
min	0.117
max	0.142

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

*mean*	4285.875
σ	1976.705
min	1550.000
max	7212.000

*mean*	113.790
σ	285.538
min	12.554
max	820.461

iterations=8

operation_display=column_set() on indexed, repeat

rows=200000

*mean*	36.617
σ	0.002
min	36.616
max	36.619

*mean*	4285.875
σ	1976.705
min	1550.000
max	7212.000

*mean*	14.300
σ	2.981
min	13.140
max	21.670

iterations=8

operation_display=table_records(), no indexes

rows=200000

*mean*	41.929
σ	0.002
min	41.928
max	41.932

*mean*	7212.000
σ	0.000
min	7212.000
max	7212.000

*mean*	15.060
σ	0.769
min	13.570
max	16.012

iterations=8

operation_display=table_records(), no indexes, repeat

rows=200000

*mean*	41.929
σ	0.002
min	41.928
max	41.931

*mean*	7212.000
σ	0.000
min	7212.000
max	7212.000

*mean*	13.657
σ	1.004
min	12.141
max	14.783

iterations=8

operation_display=table_records(), repeat

rows=200000

*mean*	41.929
σ	0.002
min	41.927
max	41.932

*mean*	4168.375
σ	1899.104
min	1550.000
max	7212.000

*mean*	13.399
σ	1.714
min	10.880
max	15.300

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*	4168.375
σ	1899.104
min	1550.000
max	7212.000

*mean*	9.004
σ	0.326
min	8.439
max	9.462

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*	4168.375
σ	1899.104
min	1550.000
max	7212.000

*mean*	7.075
σ	0.187
min	6.763
max	7.280

iterations=8

operation_display=vertical_lookup_row_list() on 2 indexed

rows=200000

*mean*	25.666
σ	0.002
min	25.665
max	25.669

*mean*	4285.875
σ	1976.705
min	1550.000
max	7212.000

*mean*	6.189
σ	0.631
min	5.789
max	7.729

iterations=8

operation_display=vertical_lookup_row_list() on 2 indexed, repeat

rows=200000

*mean*	25.661
σ	0.002
min	25.659
max	25.664

*mean*	4285.875
σ	1976.705
min	1550.000
max	7212.000

*mean*	5.817
σ	0.535
min	5.581
max	7.137

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*	4285.875
σ	1976.705
min	1550.000
max	7212.000

*mean*	5.966
σ	0.619
min	5.623
max	7.401

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*	4285.875
σ	1976.705
min	1550.000
max	7212.000

*mean*	5.787
σ	0.610
min	5.495
max	7.291

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

*mean*	7212.000
σ	0.000
min	7212.000
max	7212.000

*mean*	1458.992
σ	663.878
min	1049.386
max	2812.640

iterations=8

operation_display=load_product(), with indexes

rows=200000

*mean*	8744.561
σ	0.042
min	8744.545
max	8744.664

*mean*	3592.250
σ	1811.735
min	1075.000
max	5817.000

*mean*	4814.251
σ	1668.681
min	3567.869
max	7571.635

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*	4168.375
σ	1899.104
min	1550.000
max	7212.000

*mean*	79.295
σ	7.452
min	71.650
max	93.905

iterations=8

operation_display=column_set() on unindexed, dense, repeat

rows=200000

*mean*	62.078
σ	0.002
min	62.076
max	62.080

*mean*	4168.375
σ	1899.104
min	1550.000
max	7212.000

*mean*	80.075
σ	7.725
min	72.134
max	95.622

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

*mean*	103.582
σ	8.333
min	85.469
max	109.115

iterations=8

operation_display=vertical_lookup_list() on unindexed missing Int, repeat

rows=200000

*mean*	40.946
σ	0.002
min	40.944
max	40.947

*mean*	7212.000
σ	0.000
min	7212.000
max	7212.000

*mean*	103.718
σ	8.477
min	85.266
max	108.916

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

*mean*	105.781
σ	6.873
min	93.015
max	110.824

iterations=8

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

rows=200000

*mean*	40.951
σ	0.002
min	40.949
max	40.953

*mean*	7212.000
σ	0.000
min	7212.000
max	7212.000

*mean*	103.807
σ	8.402
min	85.633
max	109.823

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

*mean*	231.135
σ	203.623
min	135.063
max	734.310

iterations=8

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

rows=200000

*mean*	66.687
σ	0.002
min	66.685
max	66.690

*mean*	7212.000
σ	0.000
min	7212.000
max	7212.000

*mean*	155.441
σ	16.660
min	124.970
max	168.211

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*	4168.375
σ	1899.104
min	1550.000
max	7212.000

*mean*	6651.614
σ	853.013
min	4937.562
max	7602.777

iterations=8

operation_display=vertical_lookup_list() on indexed

rows=200000

*mean*	11560.065
σ	0.001
min	11560.064
max	11560.068

*mean*	7212.000
σ	0.000
min	7212.000
max	7212.000

*mean*	5538.445
σ	1167.580
min	4437.619
max	7429.122

CSV internal benchmark: pointedIndexFromKvs

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=8

operation_display=pointedIndexFromKvs

rows=200000

*mean*	172.663
σ	0.008
min	172.654
max	172.679

*mean*	489.000
σ	0.000
min	489.000
max	489.000

*mean*	401.848
σ	32.747
min	327.121
max	423.040

iterations=8

operation_display=pointedIndexFromKvs

rows=400000

*mean*	357.444
σ	0.147
min	357.321
max	357.658

*mean*	573.000
σ	0.000
min	573.000
max	573.000

*mean*	796.354
σ	30.708
min	730.712
max	833.467

Marine Hull: transactPolicy

Factor

allocated MiB

peak allocated MiB

time

datapoints=1

iterations=20

*mean*	1008.081
σ	0.760
min	1007.607
max	1011.223

*mean*	7212.000
σ	0.000
min	7212.000
max	7212.000

*mean*	1.534
σ	0.164
min	1.377
max	1.951

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

*mean*	0.418
σ	0.134
min	0.334
max	0.655

name=error_case.art

*mean*	2.333
σ	0.003
min	2.332
max	2.337

*mean*	7212.000
σ	0.000
min	7212.000
max	7212.000

*mean*	0.874
σ	0.088
min	0.825
max	1.031

name=heavy_item.art

*mean*	1.521
σ	0.002
min	1.520
max	1.524

*mean*	7212.000
σ	0.000
min	7212.000
max	7212.000

*mean*	0.538
σ	0.048
min	0.498
max	0.618

name=nested_use.art

*mean*	2.357
σ	0.003
min	2.355
max	2.361

*mean*	7212.000
σ	0.000
min	7212.000
max	7212.000

*mean*	0.845
σ	0.038
min	0.821
max	0.911

Parser: Real World

Factor

allocated MiB

peak allocated MiB

time (sec)

name=aon_gpf25_7k_loc.art

*mean*	963.549
σ	0.025
min	963.527
max	963.577

*mean*	7212.000
σ	0.000
min	7212.000
max	7212.000

*mean*	0.791
σ	0.072
min	0.668
max	0.855

name=cdr_enhanced_4k_loc.art

*mean*	884.853
σ	0.005
min	884.847
max	884.859

*mean*	7212.000
σ	0.000
min	7212.000
max	7212.000

*mean*	0.713
σ	0.040
min	0.647
max	0.749

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

*mean*	7212.000
σ	0.000
min	7212.000
max	7212.000

*mean*	4.260
σ	0.076
min	4.130
max	4.504

name=record_render_large_syntax_err.art

*mean*	7.655
σ	0.002
min	7.654
max	7.658

*mean*	7212.000
σ	0.000
min	7212.000
max	7212.000

*mean*	4.261
σ	0.070
min	4.137
max	4.538

name=record_render_success.art

*mean*	2.288
σ	0.002
min	2.287
max	2.291

*mean*	7212.000
σ	0.000
min	7212.000
max	7212.000

*mean*	0.746
σ	0.020
min	0.718
max	0.877

name=record_render_syntax_err.art

*mean*	2.163
σ	0.002
min	2.163
max	2.166

*mean*	7212.000
σ	0.000
min	7212.000
max	7212.000

*mean*	0.712
σ	0.026
min	0.505
max	0.776

SoV import

Factor

allocated MiB

peak allocated MiB

time_s

iters=10

rows=1000

*mean*	297.236
σ	0.246
min	297.075
max	297.912

*mean*	7212.000
σ	0.000
min	7212.000
max	7212.000

*mean*	0.558
σ	0.027
min	0.522
max	0.593

Workflow: transactPolicy

Factor

allocated MiB

peak allocated MiB

time

iters=5

new-facts=1

prior-facts=1

*mean*	289.731
σ	0.037
min	289.688
max	289.788

*mean*	7212.000
σ	0.000
min	7212.000
max	7212.000

*mean*	0.396
σ	0.011
min	0.388
max	0.413

iters=5

new-facts=1

prior-facts=6402

*mean*	1299.647
σ	0.087
min	1299.548
max	1299.753

*mean*	7212.000
σ	0.000
min	7212.000
max	7212.000

*mean*	1.949
σ	0.089
min	1.805
max	2.020

iters=5

new-facts=6402

prior-facts=1

*mean*	1542.622
σ	4.061
min	1540.608
max	1549.879

*mean*	7212.000
σ	0.000
min	7212.000
max	7212.000

*mean*	2.250
σ	0.170
min	2.063
max	2.478

iters=5

new-facts=6402

prior-facts=6402

*mean*	1861.615
σ	0.061
min	1861.522
max	1861.671

*mean*	7212.000
σ	0.000
min	7212.000
max	7212.000

*mean*	2.987
σ	0.206
min	2.687
max	3.159

newProductH/cdr_auton/broker

Factor

time_s

iterations=5

*mean*	1.658
σ	0.190
min	1.490
max	1.909

policy addition benchmark

Factor

allocated MiB

db queries

peak allocated MiB

time

policies=2

*mean*	446.148
σ	577.064
min	157.614
max	1311.744

*mean*	96.250
σ	8.500
min	92.000
max	109.000

*mean*	7212.000
σ	0.000
min	7212.000
max	7212.000

*mean*	0.543
σ	0.551
min	0.267
max	1.370

policies=20

*mean*	1576.408
σ	0.342
min	1576.179
max	1576.915

*mean*	920.000
σ	0.000
min	920.000
max	920.000

*mean*	7212.000
σ	0.000
min	7212.000
max	7212.000

*mean*	2.619
σ	0.017
min	2.595
max	2.633

policies=200

*mean*	15772.324
σ	0.094
min	15772.228
max	15772.437

*mean*	9200.000
σ	0.000
min	9200.000
max	9200.000

*mean*	7212.000
σ	0.000
min	7212.000
max	7212.000

*mean*	26.490
σ	0.081
min	26.397
max	26.577