fcc40bd1907042d8fc0cf4a7cba49df4299b5b29

Aggregation: measureAggregations

Factor

allocated MiB

peak allocated MiB

time_s

cache=n

dps=1

iters=10

policies=100

*mean*	53.704
σ	0.369
min	53.563
max	54.754

*mean*	418.000
σ	0.000
min	418.000
max	418.000

*mean*	0.138
σ	0.005
min	0.129
max	0.146

cache=y

dps=1

iters=10

policies=100

*mean*	43.060
σ	0.006
min	43.051
max	43.070

*mean*	418.000
σ	0.000
min	418.000
max	418.000

*mean*	0.122
σ	0.004
min	0.119
max	0.127

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*	4286.375
σ	1978.815
min	1555.000
max	7211.000

*mean*	94.621
σ	231.462
min	12.419
max	667.461

iterations=8

operation_display=column_set() on indexed, repeat

rows=200000

*mean*	36.617
σ	0.002
min	36.616
max	36.620

*mean*	4286.375
σ	1978.815
min	1555.000
max	7211.000

*mean*	14.012
σ	2.926
min	11.774
max	21.083

iterations=8

operation_display=table_records(), no indexes

rows=200000

*mean*	41.930
σ	0.002
min	41.928
max	41.932

*mean*	7211.000
σ	0.000
min	7211.000
max	7211.000

*mean*	15.016
σ	0.860
min	13.328
max	15.945

iterations=8

operation_display=table_records(), no indexes, repeat

rows=200000

*mean*	41.929
σ	0.002
min	41.928
max	41.932

*mean*	7211.000
σ	0.000
min	7211.000
max	7211.000

*mean*	14.101
σ	1.223
min	12.461
max	15.635

iterations=8

operation_display=table_records(), repeat

rows=200000

*mean*	41.929
σ	0.002
min	41.927
max	41.932

*mean*	4169.500
σ	1901.251
min	1555.000
max	7211.000

*mean*	13.921
σ	1.757
min	11.043
max	15.507

iterations=8

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

rows=200000

*mean*	27.604
σ	0.002
min	27.603
max	27.607

*mean*	4169.500
σ	1901.251
min	1555.000
max	7211.000

*mean*	9.176
σ	0.367
min	8.664
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*	4169.500
σ	1901.251
min	1555.000
max	7211.000

*mean*	6.549
σ	0.147
min	6.385
max	6.816

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*	4286.375
σ	1978.815
min	1555.000
max	7211.000

*mean*	6.201
σ	0.526
min	5.794
max	7.470

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*	4286.375
σ	1978.815
min	1555.000
max	7211.000

*mean*	5.883
σ	0.611
min	5.586
max	7.387

iterations=8

operation_display=vertical_lookup_row_list() on 3 (1 unindexed)

rows=200000

*mean*	25.969
σ	0.002
min	25.967
max	25.972

*mean*	4286.375
σ	1978.815
min	1555.000
max	7211.000

*mean*	5.912
σ	0.423
min	5.627
max	6.922

iterations=8

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

rows=200000

*mean*	25.968
σ	0.001
min	25.967
max	25.971

*mean*	4286.375
σ	1978.815
min	1555.000
max	7211.000

*mean*	5.734
σ	0.480
min	5.288
max	6.867

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.595
σ	0.002
min	2524.594
max	2524.598

*mean*	7211.000
σ	0.000
min	7211.000
max	7211.000

*mean*	1414.669
σ	624.676
min	1026.477
max	2750.152

iterations=8

operation_display=load_product(), with indexes

rows=200000

*mean*	8744.561
σ	0.041
min	8744.545
max	8744.661

*mean*	3591.625
σ	1816.647
min	1073.000
max	5822.000

*mean*	5027.413
σ	1718.397
min	3468.783
max	7416.671

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*	4169.500
σ	1901.251
min	1555.000
max	7211.000

*mean*	76.523
σ	5.221
min	70.726
max	87.393

iterations=8

operation_display=column_set() on unindexed, dense, repeat

rows=200000

*mean*	62.078
σ	0.002
min	62.076
max	62.080

*mean*	4169.500
σ	1901.251
min	1555.000
max	7211.000

*mean*	77.306
σ	5.158
min	71.115
max	87.981

iterations=8

operation_display=vertical_lookup_list() on unindexed missing Int

rows=200000

*mean*	40.945
σ	0.003
min	40.943
max	40.951

*mean*	7211.000
σ	0.000
min	7211.000
max	7211.000

*mean*	104.875
σ	7.488
min	90.829
max	109.570

iterations=8

operation_display=vertical_lookup_list() on unindexed missing Int, repeat

rows=200000

*mean*	40.945
σ	0.002
min	40.943
max	40.947

*mean*	7211.000
σ	0.000
min	7211.000
max	7211.000

*mean*	104.879
σ	7.471
min	90.965
max	109.500

iterations=8

operation_display=vertical_lookup_list() on unindexed unique Int near end

rows=200000

*mean*	40.951
σ	0.002
min	40.949
max	40.954

*mean*	7211.000
σ	0.000
min	7211.000
max	7211.000

*mean*	107.531
σ	7.477
min	94.168
max	115.748

iterations=8

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

rows=200000

*mean*	40.950
σ	0.002
min	40.948
max	40.953

*mean*	7211.000
σ	0.000
min	7211.000
max	7211.000

*mean*	104.966
σ	7.426
min	90.992
max	109.625

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

*mean*	7211.000
σ	0.000
min	7211.000
max	7211.000

*mean*	241.596
σ	228.259
min	142.482
max	805.947

iterations=8

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

rows=200000

*mean*	66.686
σ	0.002
min	66.685
max	66.689

*mean*	7211.000
σ	0.000
min	7211.000
max	7211.000

*mean*	156.691
σ	14.851
min	130.041
max	168.378

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

*mean*	4169.500
σ	1901.251
min	1555.000
max	7211.000

*mean*	6596.605
σ	1272.633
min	4839.302
max	8198.319

iterations=8

operation_display=vertical_lookup_list() on indexed

rows=200000

*mean*	11560.066
σ	0.002
min	11560.064
max	11560.068

*mean*	7211.000
σ	0.000
min	7211.000
max	7211.000

*mean*	5926.061
σ	1432.206
min	4354.609
max	7662.061

CSV internal benchmark: pointedIndexFromKvs

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=8

operation_display=pointedIndexFromKvs

rows=200000

*mean*	172.662
σ	0.013
min	172.644
max	172.682

*mean*	488.500
σ	0.756
min	488.000
max	490.000

*mean*	373.519
σ	53.411
min	274.168
max	421.327

iterations=8

operation_display=pointedIndexFromKvs

rows=400000

*mean*	357.472
σ	0.161
min	357.321
max	357.639

*mean*	566.000
σ	0.000
min	566.000
max	566.000

*mean*	786.322
σ	29.050
min	734.135
max	809.216

Marine Hull: transactPolicy

Factor

allocated MiB

peak allocated MiB

time

datapoints=1

iterations=20

*mean*	1005.001
σ	0.751
min	1004.531
max	1008.105

*mean*	7211.000
σ	0.000
min	7211.000
max	7211.000

*mean*	1.577
σ	0.111
min	1.426
max	1.834

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

*mean*	0.306
σ	0.092
min	0.256
max	0.470

name=error_case.art

*mean*	2.333
σ	0.003
min	2.332
max	2.337

*mean*	7211.000
σ	0.000
min	7211.000
max	7211.000

*mean*	0.867
σ	0.098
min	0.779
max	1.028

name=heavy_item.art

*mean*	1.521
σ	0.002
min	1.520
max	1.524

*mean*	7211.000
σ	0.000
min	7211.000
max	7211.000

*mean*	0.532
σ	0.052
min	0.498
max	0.620

name=nested_use.art

*mean*	2.355
σ	0.002
min	2.355
max	2.358

*mean*	7211.000
σ	0.000
min	7211.000
max	7211.000

*mean*	0.840
σ	0.044
min	0.810
max	0.916

Parser: Real World

Factor

allocated MiB

peak allocated MiB

time (sec)

name=aon_gpf25_7k_loc.art

*mean*	963.548
σ	0.023
min	963.529
max	963.579

*mean*	7211.000
σ	0.000
min	7211.000
max	7211.000

*mean*	0.780
σ	0.069
min	0.689
max	0.850

name=cdr_enhanced_4k_loc.art

*mean*	884.854
σ	0.005
min	884.847
max	884.860

*mean*	7211.000
σ	0.000
min	7211.000
max	7211.000

*mean*	0.730
σ	0.004
min	0.725
max	0.735

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

*mean*	4.291
σ	0.077
min	4.148
max	4.545

name=record_render_large_syntax_err.art

*mean*	7.655
σ	0.002
min	7.654
max	7.658

*mean*	7211.000
σ	0.000
min	7211.000
max	7211.000

*mean*	4.265
σ	0.085
min	4.111
max	4.637

name=record_render_success.art

*mean*	2.288
σ	0.002
min	2.287
max	2.291

*mean*	7211.000
σ	0.000
min	7211.000
max	7211.000

*mean*	0.757
σ	0.019
min	0.721
max	0.883

name=record_render_syntax_err.art

*mean*	2.163
σ	0.002
min	2.163
max	2.166

*mean*	7211.000
σ	0.000
min	7211.000
max	7211.000

*mean*	0.570
σ	0.092
min	0.491
max	0.812

SoV import

Factor

allocated MiB

peak allocated MiB

time_s

iters=10

rows=1000

*mean*	294.282
σ	0.203
min	294.168
max	294.854

*mean*	7211.000
σ	0.000
min	7211.000
max	7211.000

*mean*	0.537
σ	0.032
min	0.495
max	0.575

Workflow: transactPolicy

Factor

allocated MiB

peak allocated MiB

time

iters=5

new-facts=1

prior-facts=1

*mean*	281.464
σ	0.039
min	281.405
max	281.508

*mean*	7211.000
σ	0.000
min	7211.000
max	7211.000

*mean*	0.387
σ	0.007
min	0.378
max	0.395

iters=5

new-facts=1

prior-facts=6402

*mean*	1291.505
σ	0.113
min	1291.353
max	1291.630

*mean*	7211.000
σ	0.000
min	7211.000
max	7211.000

*mean*	2.034
σ	0.078
min	1.973
max	2.171

iters=5

new-facts=6402

prior-facts=1

*mean*	1534.345
σ	3.979
min	1532.254
max	1541.452

*mean*	7211.000
σ	0.000
min	7211.000
max	7211.000

*mean*	2.294
σ	0.297
min	2.084
max	2.756

iters=5

new-facts=6402

prior-facts=6402

*mean*	1853.328
σ	0.058
min	1853.241
max	1853.377

*mean*	7211.000
σ	0.000
min	7211.000
max	7211.000

*mean*	2.953
σ	0.138
min	2.846
max	3.130

newProductH/cdr_auton/broker

Factor

time_s

iterations=5

*mean*	1.624
σ	0.264
min	1.326
max	1.955

policy addition benchmark

Factor

allocated MiB

db queries

peak allocated MiB

time

policies=2

*mean*	442.428
σ	577.064
min	153.893
max	1308.024

*mean*	96.250
σ	8.500
min	92.000
max	109.000

*mean*	7211.000
σ	0.000
min	7211.000
max	7211.000

*mean*	0.536
σ	0.544
min	0.263
max	1.352

policies=20

*mean*	1539.220
σ	0.333
min	1538.994
max	1539.713

*mean*	920.000
σ	0.000
min	920.000
max	920.000

*mean*	7211.000
σ	0.000
min	7211.000
max	7211.000

*mean*	2.611
σ	0.026
min	2.592
max	2.648

policies=200

*mean*	15400.434
σ	0.105
min	15400.284
max	15400.531

*mean*	9200.000
σ	0.000
min	9200.000
max	9200.000

*mean*	7211.000
σ	0.000
min	7211.000
max	7211.000

*mean*	26.162
σ	0.190
min	25.990
max	26.430