0e0722872b1436ea139c6e31e79d34d8871d96f0

Aggregation: measureAggregations

Factor

allocated MiB

peak allocated MiB

time_s

cache=n

dps=1

iters=10

policies=100

*mean*	54.522
σ	0.369
min	54.385
max	55.572

*mean*	420.000
σ	0.000
min	420.000
max	420.000

*mean*	0.141
σ	0.005
min	0.135
max	0.148

cache=y

dps=1

iters=10

policies=100

*mean*	43.765
σ	0.008
min	43.757
max	43.779

*mean*	420.000
σ	0.000
min	420.000
max	420.000

*mean*	0.120
σ	0.004
min	0.116
max	0.126

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*	4171.000
σ	1897.612
min	1554.000
max	7202.000

*mean*	12.796
σ	0.324
min	12.459
max	13.338

iterations=8

operation_display=column_set() on indexed, repeat

rows=200000

*mean*	36.617
σ	0.002
min	36.616
max	36.620

*mean*	4290.750
σ	1977.161
min	1554.000
max	7202.000

*mean*	54.909
σ	120.293
min	11.869
max	352.617

iterations=8

operation_display=table_records(), no indexes

rows=200000

*mean*	41.930
σ	0.002
min	41.928
max	41.932

*mean*	7202.000
σ	0.000
min	7202.000
max	7202.000

*mean*	14.925
σ	1.251
min	12.025
max	15.906

iterations=8

operation_display=table_records(), no indexes, repeat

rows=200000

*mean*	41.930
σ	0.003
min	41.928
max	41.935

*mean*	7202.000
σ	0.000
min	7202.000
max	7202.000

*mean*	13.400
σ	1.210
min	11.556
max	14.595

iterations=8

operation_display=table_records(), repeat

rows=200000

*mean*	41.929
σ	0.002
min	41.927
max	41.932

*mean*	4171.000
σ	1897.612
min	1554.000
max	7202.000

*mean*	13.918
σ	1.584
min	11.238
max	15.610

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*	4171.000
σ	1897.612
min	1554.000
max	7202.000

*mean*	9.139
σ	0.247
min	8.907
max	9.647

iterations=8

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

rows=200000

*mean*	26.401
σ	0.002
min	26.399
max	26.403

*mean*	4171.000
σ	1897.612
min	1554.000
max	7202.000

*mean*	6.792
σ	0.256
min	6.435
max	7.106

iterations=8

operation_display=vertical_lookup_row_list() on 2 indexed

rows=200000

*mean*	25.666
σ	0.002
min	25.664
max	25.670

*mean*	4290.750
σ	1977.161
min	1554.000
max	7202.000

*mean*	5.986
σ	0.132
min	5.812
max	6.172

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*	4290.750
σ	1977.161
min	1554.000
max	7202.000

*mean*	5.690
σ	0.161
min	5.541
max	6.062

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*	4290.750
σ	1977.161
min	1554.000
max	7202.000

*mean*	5.693
σ	0.212
min	5.263
max	5.924

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*	4290.750
σ	1977.161
min	1554.000
max	7202.000

*mean*	5.502
σ	0.199
min	5.109
max	5.689

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

*mean*	1179.957
σ	394.873
min	1033.250
max	2157.171

iterations=8

operation_display=load_product(), with indexes

rows=200000

*mean*	8744.561
σ	0.040
min	8744.544
max	8744.661

*mean*	3598.125
σ	1817.232
min	1077.000
max	5836.000

*mean*	4392.037
σ	1283.226
min	3509.189
max	7116.660

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*	4171.000
σ	1897.612
min	1554.000
max	7202.000

*mean*	80.332
σ	10.343
min	71.816
max	100.223

iterations=8

operation_display=column_set() on unindexed, dense, repeat

rows=200000

*mean*	62.077
σ	0.002
min	62.076
max	62.080

*mean*	4171.000
σ	1897.612
min	1554.000
max	7202.000

*mean*	80.831
σ	9.929
min	71.766
max	99.499

iterations=8

operation_display=vertical_lookup_list() on unindexed missing Int

rows=200000

*mean*	40.945
σ	0.002
min	40.944
max	40.947

*mean*	7202.000
σ	0.000
min	7202.000
max	7202.000

*mean*	102.197
σ	10.753
min	79.871
max	108.769

iterations=8

operation_display=vertical_lookup_list() on unindexed missing Int, repeat

rows=200000

*mean*	40.945
σ	0.002
min	40.943
max	40.948

*mean*	7202.000
σ	0.000
min	7202.000
max	7202.000

*mean*	102.112
σ	10.799
min	79.670
max	108.646

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

*mean*	7202.000
σ	0.000
min	7202.000
max	7202.000

*mean*	104.570
σ	10.094
min	82.529
max	111.812

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

*mean*	7202.000
σ	0.000
min	7202.000
max	7202.000

*mean*	102.228
σ	10.822
min	79.947
max	109.083

iterations=8

operation_display=vertical_lookup_row_list() on unindexed small unique Int

rows=200000

*mean*	66.686
σ	0.001
min	66.686
max	66.689

*mean*	7202.000
σ	0.000
min	7202.000
max	7202.000

*mean*	215.757
σ	165.123
min	127.081
max	622.653

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

*mean*	7202.000
σ	0.000
min	7202.000
max	7202.000

*mean*	151.380
σ	23.955
min	104.077
max	169.866

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*	4171.000
σ	1897.612
min	1554.000
max	7202.000

*mean*	6628.984
σ	1274.286
min	4901.670
max	8418.269

iterations=8

operation_display=vertical_lookup_list() on indexed

rows=200000

*mean*	11560.065
σ	0.001
min	11560.064
max	11560.068

*mean*	7202.000
σ	0.000
min	7202.000
max	7202.000

*mean*	5909.805
σ	1360.346
min	4380.215
max	7623.141

CSV internal benchmark: pointedIndexFromKvs

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=8

operation_display=pointedIndexFromKvs

rows=200000

*mean*	172.669
σ	0.007
min	172.653
max	172.675

*mean*	491.250
σ	0.707
min	491.000
max	493.000

*mean*	403.462
σ	17.211
min	366.921
max	421.201

iterations=8

operation_display=pointedIndexFromKvs

rows=400000

*mean*	357.458
σ	0.159
min	357.321
max	357.670

*mean*	576.000
σ	0.000
min	576.000
max	576.000

*mean*	785.563
σ	28.036
min	730.953
max	821.950

Marine Hull: transactPolicy

Factor

allocated MiB

peak allocated MiB

time

datapoints=1

iterations=20

*mean*	1008.082
σ	0.760
min	1007.608
max	1011.223

*mean*	7202.000
σ	0.000
min	7202.000
max	7202.000

*mean*	1.529
σ	0.127
min	1.415
max	1.880

Parser: Comma Sep

Factor

allocated MiB

peak allocated MiB

time (ms)

name=ambiguous_item.art

*mean*	0.884
σ	0.003
min	0.881
max	0.887

*mean*	7202.000
σ	0.000
min	7202.000
max	7202.000

*mean*	0.437
σ	0.132
min	0.340
max	0.651

name=error_case.art

*mean*	2.333
σ	0.003
min	2.332
max	2.337

*mean*	7202.000
σ	0.000
min	7202.000
max	7202.000

*mean*	0.888
σ	0.095
min	0.824
max	1.053

name=heavy_item.art

*mean*	1.521
σ	0.002
min	1.520
max	1.524

*mean*	7202.000
σ	0.000
min	7202.000
max	7202.000

*mean*	0.546
σ	0.046
min	0.504
max	0.624

name=nested_use.art

*mean*	2.355
σ	0.002
min	2.355
max	2.358

*mean*	7202.000
σ	0.000
min	7202.000
max	7202.000

*mean*	0.864
σ	0.036
min	0.830
max	0.920

Parser: Real World

Factor

allocated MiB

peak allocated MiB

time (sec)

name=aon_gpf25_7k_loc.art

*mean*	963.549
σ	0.038
min	963.523
max	963.616

*mean*	7202.000
σ	0.000
min	7202.000
max	7202.000

*mean*	0.759
σ	0.071
min	0.665
max	0.842

name=cdr_enhanced_4k_loc.art

*mean*	884.854
σ	0.009
min	884.847
max	884.868

*mean*	7202.000
σ	0.000
min	7202.000
max	7202.000

*mean*	0.592
σ	0.073
min	0.504
max	0.650

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

*mean*	7202.000
σ	0.000
min	7202.000
max	7202.000

*mean*	3.549
σ	0.081
min	3.422
max	3.855

name=record_render_large_syntax_err.art

*mean*	7.655
σ	0.002
min	7.654
max	7.658

*mean*	7202.000
σ	0.000
min	7202.000
max	7202.000

*mean*	3.505
σ	0.067
min	3.387
max	3.724

name=record_render_success.art

*mean*	2.288
σ	0.002
min	2.287
max	2.291

*mean*	7202.000
σ	0.000
min	7202.000
max	7202.000

*mean*	0.547
σ	0.021
min	0.513
max	0.696

name=record_render_syntax_err.art

*mean*	2.163
σ	0.002
min	2.163
max	2.166

*mean*	7202.000
σ	0.000
min	7202.000
max	7202.000

*mean*	0.523
σ	0.024
min	0.492
max	0.720

SoV import

Factor

allocated MiB

peak allocated MiB

time_s

iters=10

rows=1000

*mean*	297.455
σ	0.219
min	297.324
max	298.060

*mean*	7202.000
σ	0.000
min	7202.000
max	7202.000

*mean*	0.573
σ	0.030
min	0.510
max	0.610

Workflow: transactPolicy

Factor

allocated MiB

peak allocated MiB

time

iters=5

new-facts=1

prior-facts=1

*mean*	289.745
σ	0.026
min	289.719
max	289.789

*mean*	7202.000
σ	0.000
min	7202.000
max	7202.000

*mean*	0.387
σ	0.001
min	0.386
max	0.390

iters=5

new-facts=1

prior-facts=6402

*mean*	1299.682
σ	0.132
min	1299.492
max	1299.846

*mean*	7202.000
σ	0.000
min	7202.000
max	7202.000

*mean*	1.892
σ	0.111
min	1.805
max	2.025

iters=5

new-facts=6402

prior-facts=1

*mean*	1542.724
σ	4.006
min	1540.692
max	1549.881

*mean*	7202.000
σ	0.000
min	7202.000
max	7202.000

*mean*	2.494
σ	0.267
min	2.150
max	2.754

iters=5

new-facts=6402

prior-facts=6402

*mean*	1861.622
σ	0.071
min	1861.535
max	1861.720

*mean*	7202.000
σ	0.000
min	7202.000
max	7202.000

*mean*	3.124
σ	0.358
min	2.847
max	3.678

newProductH/cdr_auton/broker

Factor

time_s

iterations=5

*mean*	1.630
σ	0.269
min	1.312
max	1.924

policy addition benchmark

Factor

allocated MiB

db queries

peak allocated MiB

time

policies=2

*mean*	446.149
σ	577.066
min	157.613
max	1311.748

*mean*	96.250
σ	8.500
min	92.000
max	109.000

*mean*	7202.000
σ	0.000
min	7202.000
max	7202.000

*mean*	0.515
σ	0.487
min	0.269
max	1.245

policies=20

*mean*	1576.390
σ	0.332
min	1576.162
max	1576.882

*mean*	920.000
σ	0.000
min	920.000
max	920.000

*mean*	7202.000
σ	0.000
min	7202.000
max	7202.000

*mean*	2.612
σ	0.019
min	2.595
max	2.631

policies=200

*mean*	15772.054
σ	0.091
min	15771.982
max	15772.184

*mean*	9200.000
σ	0.000
min	9200.000
max	9200.000

*mean*	7202.000
σ	0.000
min	7202.000
max	7202.000

*mean*	26.564
σ	0.120
min	26.459
max	26.679