43069c9369f12150e07e276e1089dd630c63fd17

Aggregation: measureAggregations

Factor

allocated MiB

peak allocated MiB

time_s

cache=n

dps=1

iters=10

policies=100

*mean*	54.616
σ	0.350
min	54.483
max	55.612

*mean*	414.000
σ	0.000
min	414.000
max	414.000

*mean*	0.140
σ	0.005
min	0.136
max	0.149

cache=y

dps=1

iters=10

policies=100

*mean*	43.786
σ	0.005
min	43.779
max	43.797

*mean*	414.000
σ	0.000
min	414.000
max	414.000

*mean*	0.122
σ	0.004
min	0.117
max	0.129

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.875
σ	1977.393
min	1548.000
max	7213.000

*mean*	109.310
σ	272.405
min	12.656
max	783.478

iterations=8

operation_display=column_set() on indexed, repeat

rows=200000

*mean*	36.618
σ	0.002
min	36.616
max	36.620

*mean*	4286.875
σ	1977.393
min	1548.000
max	7213.000

*mean*	13.252
σ	1.316
min	12.023
max	16.108

iterations=8

operation_display=table_records(), no indexes

rows=200000

*mean*	41.930
σ	0.002
min	41.928
max	41.933

*mean*	7213.000
σ	0.000
min	7213.000
max	7213.000

*mean*	14.937
σ	0.915
min	13.189
max	15.883

iterations=8

operation_display=table_records(), no indexes, repeat

rows=200000

*mean*	41.929
σ	0.002
min	41.928
max	41.932

*mean*	7213.000
σ	0.000
min	7213.000
max	7213.000

*mean*	13.871
σ	0.885
min	12.684
max	15.017

iterations=8

operation_display=table_records(), repeat

rows=200000

*mean*	41.929
σ	0.002
min	41.927
max	41.932

*mean*	4169.500
σ	1899.802
min	1548.000
max	7213.000

*mean*	13.777
σ	1.684
min	11.109
max	15.402

iterations=8

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

rows=200000

*mean*	27.605
σ	0.002
min	27.603
max	27.607

*mean*	4169.500
σ	1899.802
min	1548.000
max	7213.000

*mean*	9.140
σ	0.439
min	8.274
max	9.599

iterations=8

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

rows=200000

*mean*	26.400
σ	0.001
min	26.399
max	26.403

*mean*	4169.500
σ	1899.802
min	1548.000
max	7213.000

*mean*	6.819
σ	0.421
min	6.184
max	7.246

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.875
σ	1977.393
min	1548.000
max	7213.000

*mean*	6.112
σ	0.068
min	5.974
max	6.213

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.875
σ	1977.393
min	1548.000
max	7213.000

*mean*	5.691
σ	0.078
min	5.585
max	5.839

iterations=8

operation_display=vertical_lookup_row_list() on 3 (1 unindexed)

rows=200000

*mean*	25.969
σ	0.003
min	25.967
max	25.975

*mean*	4286.875
σ	1977.393
min	1548.000
max	7213.000

*mean*	5.758
σ	0.072
min	5.666
max	5.872

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*	4286.875
σ	1977.393
min	1548.000
max	7213.000

*mean*	5.631
σ	0.123
min	5.477
max	5.860

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

*mean*	7213.000
σ	0.000
min	7213.000
max	7213.000

*mean*	1447.308
σ	645.977
min	1040.699
max	2785.952

iterations=8

operation_display=load_product(), with indexes

rows=200000

*mean*	8744.560
σ	0.041
min	8744.545
max	8744.661

*mean*	3592.000
σ	1813.391
min	1074.000
max	5819.000

*mean*	4916.934
σ	1595.220
min	3517.840
max	7497.891

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.001
min	62.076
max	62.080

*mean*	4169.500
σ	1899.802
min	1548.000
max	7213.000

*mean*	78.339
σ	5.647
min	70.637
max	86.092

iterations=8

operation_display=column_set() on unindexed, dense, repeat

rows=200000

*mean*	62.077
σ	0.002
min	62.075
max	62.080

*mean*	4169.500
σ	1899.802
min	1548.000
max	7213.000

*mean*	79.729
σ	5.546
min	72.403
max	87.161

iterations=8

operation_display=vertical_lookup_list() on unindexed missing Int

rows=200000

*mean*	40.945
σ	0.002
min	40.944
max	40.949

*mean*	7213.000
σ	0.000
min	7213.000
max	7213.000

*mean*	103.968
σ	7.120
min	91.784
max	108.433

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

*mean*	103.810
σ	6.932
min	91.982
max	108.195

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

*mean*	7213.000
σ	0.000
min	7213.000
max	7213.000

*mean*	107.003
σ	5.190
min	98.693
max	112.909

iterations=8

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

rows=200000

*mean*	40.950
σ	0.002
min	40.949
max	40.953

*mean*	7213.000
σ	0.000
min	7213.000
max	7213.000

*mean*	104.083
σ	7.079
min	92.293
max	108.608

iterations=8

operation_display=vertical_lookup_row_list() on unindexed small unique Int

rows=200000

*mean*	66.687
σ	0.002
min	66.686
max	66.690

*mean*	7213.000
σ	0.000
min	7213.000
max	7213.000

*mean*	238.095
σ	219.831
min	144.758
max	781.596

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

*mean*	156.406
σ	16.484
min	122.881
max	169.619

CSV - warmup

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=8

operation_display=table_records()

rows=200000

*mean*	11656.833
σ	4.319
min	11655.305
max	11667.523

*mean*	4169.500
σ	1899.802
min	1548.000
max	7213.000

*mean*	7008.720
σ	1235.374
min	4864.494
max	8152.535

iterations=8

operation_display=vertical_lookup_list() on indexed

rows=200000

*mean*	11560.066
σ	0.003
min	11560.064
max	11560.072

*mean*	7213.000
σ	0.000
min	7213.000
max	7213.000

*mean*	6073.840
σ	1482.323
min	4356.818
max	7644.570

CSV internal benchmark: pointedIndexFromKvs

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=8

operation_display=pointedIndexFromKvs

rows=200000

*mean*	172.657
σ	0.013
min	172.640
max	172.675

*mean*	486.000
σ	0.000
min	486.000
max	486.000

*mean*	372.198
σ	44.639
min	272.178
max	414.244

iterations=8

operation_display=pointedIndexFromKvs

rows=400000

*mean*	357.462
σ	0.151
min	357.321
max	357.614

*mean*	565.000
σ	0.000
min	565.000
max	565.000

*mean*	800.739
σ	20.934
min	760.008
max	820.966

Marine Hull: transactPolicy

Factor

allocated MiB

peak allocated MiB

time

datapoints=1

iterations=20

*mean*	1008.078
σ	0.762
min	1007.611
max	1011.229

*mean*	7213.000
σ	0.000
min	7213.000
max	7213.000

*mean*	1.566
σ	0.128
min	1.364
max	1.925

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

*mean*	0.322
σ	0.122
min	0.254
max	0.539

name=error_case.art

*mean*	2.333
σ	0.003
min	2.332
max	2.337

*mean*	7213.000
σ	0.000
min	7213.000
max	7213.000

*mean*	0.646
σ	0.085
min	0.596
max	0.797

name=heavy_item.art

*mean*	1.521
σ	0.002
min	1.520
max	1.524

*mean*	7213.000
σ	0.000
min	7213.000
max	7213.000

*mean*	0.385
σ	0.041
min	0.352
max	0.456

name=nested_use.art

*mean*	2.355
σ	0.002
min	2.355
max	2.358

*mean*	7213.000
σ	0.000
min	7213.000
max	7213.000

*mean*	0.612
σ	0.027
min	0.587
max	0.654

Parser: Real World

Factor

allocated MiB

peak allocated MiB

time (sec)

name=aon_gpf25_7k_loc.art

*mean*	963.552
σ	0.024
min	963.527
max	963.582

*mean*	7213.000
σ	0.000
min	7213.000
max	7213.000

*mean*	0.800
σ	0.046
min	0.751
max	0.848

name=cdr_enhanced_4k_loc.art

*mean*	884.853
σ	0.009
min	884.847
max	884.866

*mean*	7213.000
σ	0.000
min	7213.000
max	7213.000

*mean*	0.698
σ	0.062
min	0.601
max	0.743

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

*mean*	4.271
σ	0.089
min	4.104
max	4.706

name=record_render_large_syntax_err.art

*mean*	7.655
σ	0.002
min	7.654
max	7.658

*mean*	7213.000
σ	0.000
min	7213.000
max	7213.000

*mean*	4.248
σ	0.093
min	4.110
max	4.752

name=record_render_success.art

*mean*	2.288
σ	0.002
min	2.287
max	2.291

*mean*	7213.000
σ	0.000
min	7213.000
max	7213.000

*mean*	0.752
σ	0.019
min	0.700
max	0.862

name=record_render_syntax_err.art

*mean*	2.163
σ	0.002
min	2.163
max	2.166

*mean*	7213.000
σ	0.000
min	7213.000
max	7213.000

*mean*	0.712
σ	0.014
min	0.679
max	0.768

SoV import

Factor

allocated MiB

peak allocated MiB

time_s

iters=10

rows=1000

*mean*	297.467
σ	0.209
min	297.336
max	298.024

*mean*	7213.000
σ	0.000
min	7213.000
max	7213.000

*mean*	0.580
σ	0.036
min	0.536
max	0.656

Workflow: transactPolicy

Factor

allocated MiB

peak allocated MiB

time

iters=5

new-facts=1

prior-facts=1

*mean*	289.724
σ	0.039
min	289.676
max	289.782

*mean*	7213.000
σ	0.000
min	7213.000
max	7213.000

*mean*	0.396
σ	0.004
min	0.393
max	0.402

iters=5

new-facts=1

prior-facts=6402

*mean*	1299.646
σ	0.105
min	1299.518
max	1299.770

*mean*	7213.000
σ	0.000
min	7213.000
max	7213.000

*mean*	2.015
σ	0.199
min	1.809
max	2.230

iters=5

new-facts=6402

prior-facts=1

*mean*	1542.605
σ	4.052
min	1540.594
max	1549.846

*mean*	7213.000
σ	0.000
min	7213.000
max	7213.000

*mean*	2.249
σ	0.155
min	2.088
max	2.467

iters=5

new-facts=6402

prior-facts=6402

*mean*	1861.614
σ	0.060
min	1861.531
max	1861.670

*mean*	7213.000
σ	0.000
min	7213.000
max	7213.000

*mean*	3.085
σ	0.263
min	2.851
max	3.534

newProductH/cdr_auton/broker

Factor

time_s

iterations=5

*mean*	1.562
σ	0.215
min	1.265
max	1.842

policy addition benchmark

Factor

allocated MiB

db queries

peak allocated MiB

time

policies=2

*mean*	446.148
σ	577.064
min	157.613
max	1311.744

*mean*	96.250
σ	8.500
min	92.000
max	109.000

*mean*	7213.000
σ	0.000
min	7213.000
max	7213.000

*mean*	0.562
σ	0.583
min	0.269
max	1.436

policies=20

*mean*	1576.405
σ	0.337
min	1576.176
max	1576.904

*mean*	920.000
σ	0.000
min	920.000
max	920.000

*mean*	7213.000
σ	0.000
min	7213.000
max	7213.000

*mean*	2.611
σ	0.034
min	2.563
max	2.642

policies=200

*mean*	15772.243
σ	0.100
min	15772.119
max	15772.334

*mean*	9200.000
σ	0.000
min	9200.000
max	9200.000

*mean*	7213.000
σ	0.000
min	7213.000
max	7213.000

*mean*	26.359
σ	0.060
min	26.277
max	26.411