Compare commits

Aggregation: measureAggregations

Factor

allocated MiB

peak allocated MiB

time_s

cache=n

dps=1

iters=10

policies=100

*mean*	54.617-54.616=0.001
σ	0.352-0.351=0.001
min	54.483-54.482=0.001
max	55.618-55.615=0.003

*mean*	417.000-416.000=1.000
σ	0.000
min	417.000-416.000=1.000
max	417.000-416.000=1.000

*mean*	0.140-0.138=0.002
σ	0.004-0.004=-0.000
min	0.136-0.132=0.004
max	0.146-0.145=0.001

cache=y

dps=1

iters=10

policies=100

*mean*	43.786-43.785=0.000
σ	0.006-0.006=0.000
min	43.776-43.775=0.002
max	43.799-43.798=0.001

*mean*	417.000-416.000=1.000
σ	0.000
min	417.000-416.000=1.000
max	417.000-416.000=1.000

*mean*	0.123-0.121=0.003
σ	0.004-0.006=-0.001
min	0.119-0.115=0.004
max	0.131-0.129=0.001

CSV - indexed operations

Factor

allocated MiB

peak allocated MiB

time (ms)

op=column_set() on indexed

*mean*	36.618-36.618=0.000
σ	0.002-0.002=0.000
min	36.615
max	36.620-36.620=0.000

*mean*	4111.750-4263.750=-152.000
σ	1561.686-1878.098=-316.413
min	2029.000-1981.000=48.000
max	6047.000-7542.000=-1495.000

*mean*	11.993-12.945=-0.952
σ	0.307-1.706=-1.399
min	11.556-11.819=-0.263
max	12.468-17.082=-4.613

op=column_set() on indexed, repeat

*mean*	36.617-36.617=0.000
σ	0.002-0.002=0.000
min	36.616-36.616=0.000
max	36.620-36.620=0.000

*mean*	4111.750-4263.750=-152.000
σ	1561.686-1878.098=-316.413
min	2029.000-1981.000=48.000
max	6047.000-7542.000=-1495.000

*mean*	12.514-13.175=-0.661
σ	0.296-1.224=-0.928
min	12.113-12.488=-0.375
max	13.024-16.179=-3.155

op=table_records(), no indexes

*mean*	41.929-41.928=0.000
σ	0.001-0.001=0.001
min	41.928
max	41.932-41.929=0.003

*mean*	6047.000-7542.000=-1495.000
σ	0.000
min	6047.000-7542.000=-1495.000
max	6047.000-7542.000=-1495.000

*mean*	13.001-13.876=-0.875
σ	1.145-0.952=0.193
min	10.876-12.815=-1.939
max	14.411-15.206=-0.796

op=table_records(), repeat

*mean*	41.929-41.928=0.000
σ	0.002-0.002=0.000
min	41.927-41.927=0.000
max	41.932-41.931=0.001

*mean*	4111.750-4263.750=-152.000
σ	1561.686-1878.098=-316.413
min	2029.000-1981.000=48.000
max	6047.000-7542.000=-1495.000

*mean*	12.346-12.528=-0.182
σ	1.767-2.249=-0.482
min	10.512-10.433=0.080
max	14.618-15.731=-1.113

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

*mean*	27.605-27.605=-0.000
σ	0.002-0.002=-0.000
min	27.603
max	27.607-27.607=-0.000

*mean*	4111.750-4263.750=-152.000
σ	1561.686-1878.098=-316.413
min	2029.000-1981.000=48.000
max	6047.000-7542.000=-1495.000

*mean*	8.347-8.752=-0.405
σ	0.374-1.319=-0.945
min	7.700-7.825=-0.124
max	8.891-11.935=-3.044

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

*mean*	26.400-26.401=-0.000
σ	0.002-0.002=-0.000
min	26.399
max	26.403-26.403=-0.000

*mean*	4111.750-4263.750=-152.000
σ	1561.686-1878.098=-316.413
min	2029.000-1981.000=48.000
max	6047.000-7542.000=-1495.000

*mean*	6.222-6.696=-0.474
σ	0.198-1.112=-0.914
min	5.905-5.821=0.084
max	6.469-9.322=-2.853

op=vertical_lookup_row_list() on 2 indexed

*mean*	25.666-25.666=-0.001
σ	0.002-0.002=-0.000
min	25.664-25.664=0.000
max	25.669-25.670=-0.000

*mean*	4111.750-4263.750=-152.000
σ	1561.686-1878.098=-316.413
min	2029.000-1981.000=48.000
max	6047.000-7542.000=-1495.000

*mean*	5.261-5.595=-0.334
σ	0.130-0.390=-0.260
min	5.076-5.361=-0.285
max	5.467-6.545=-1.078

op=vertical_lookup_row_list() on 3 (1 unindexed)

*mean*	25.968-25.968=0.000
σ	0.002-0.002=0.000
min	25.967-25.967=-0.000
max	25.971

*mean*	4111.750-4263.750=-152.000
σ	1561.686-1878.098=-316.413
min	2029.000-1981.000=48.000
max	6047.000-7542.000=-1495.000

*mean*	5.089-5.459=-0.370
σ	0.205-0.527=-0.321
min	4.790-5.098=-0.309
max	5.438-6.669=-1.231

CSV - loading a lazy table

Factor

allocated MiB

peak allocated MiB

time (ms)

op=load_product(), no indexes

*mean*	2524.593-2524.593=0.000
σ	0.000-0.000=0.000
min	2524.593
max	2524.594-2524.593=0.001

*mean*	6047.000-7542.000=-1495.000
σ	0.000
min	6047.000-7542.000=-1495.000
max	6047.000-7542.000=-1495.000

*mean*	1424.158-1054.076=370.081
σ	636.682-5.777=630.905
min	1031.011-1045.453=-14.442
max	2775.619-1061.960=1713.659

op=load_product(), with indexes

*mean*	8744.559-8744.558=0.001
σ	0.033-0.033=-0.001
min	8744.544-8744.544=-0.000
max	8744.639-8744.640=-0.001

*mean*	3837.500-3784.250=53.250
σ	1633.742-1607.727=26.015
min	2029.000-1981.000=48.000
max	6047.000-5939.000=108.000

*mean*	4191.663-4513.098=-321.435
σ	1248.783-1247.689=1.094
min	3504.455-3556.834=-52.380
max	7089.260-6640.123=449.137

CSV - unindexed operations

Factor

allocated MiB

peak allocated MiB

time (ms)

op=column_set() on unindexed, dense

*mean*	62.078-62.077=0.001
σ	0.003-0.002=0.001
min	62.076-62.075=0.000
max	62.084-62.080=0.004

*mean*	4111.750-4263.750=-152.000
σ	1561.686-1878.098=-316.413
min	2029.000-1981.000=48.000
max	6047.000-7542.000=-1495.000

*mean*	78.938-86.599=-7.661
σ	8.910-13.351=-4.441
min	70.238-71.412=-1.175
max	90.073-106.523=-16.450

op=vertical_lookup_list() on unindexed missing Int

*mean*	40.944-40.944=-0.000
σ	0.001-0.001=-0.000
min	40.944
max	40.945

*mean*	6047.000-7542.000=-1495.000
σ	0.000
min	6047.000-7542.000=-1495.000
max	6047.000-7542.000=-1495.000

*mean*	98.425-238.403=-139.978
σ	10.502-393.391=-382.889
min	83.089-85.584=-2.495
max	110.173-1211.786=-1101.614

op=vertical_lookup_row_list() on unindexed small unique Int

*mean*	66.686-66.686=0.000
σ	0.000-0.000=0.000
min	66.685
max	66.686

*mean*	6047.000-7542.000=-1495.000
σ	0.000
min	6047.000-7542.000=-1495.000
max	6047.000-7542.000=-1495.000

*mean*	225.422-152.901=72.521
σ	235.403-13.643=221.759
min	119.686-137.923=-18.237
max	806.864-169.440=637.424

CSV - warmup

Factor

allocated MiB

peak allocated MiB

time (ms)

op=table_records()

*mean*	11656.833-11656.833=-0.000
σ	4.318-4.317=0.002
min	11655.305-11655.305=-0.000
max	11667.521-11667.517=0.004

*mean*	4111.750-4263.750=-152.000
σ	1561.686-1878.098=-316.413
min	2029.000-1981.000=48.000
max	6047.000-7542.000=-1495.000

*mean*	5917.013-6442.952=-525.938
σ	1194.834-1213.327=-18.493
min	4867.045-4990.274=-123.229
max	8216.295-8209.479=6.816

op=vertical_lookup_list() on indexed

*mean*	11560.068-11560.069=-0.001
σ	0.001-0.002=-0.001
min	11560.066
max	11560.069-11560.072=-0.003

*mean*	6047.000-7542.000=-1495.000
σ	0.000
min	6047.000-7542.000=-1495.000
max	6047.000-7542.000=-1495.000

*mean*	6368.396-5392.109=976.287
σ	1161.424-1295.656=-134.233
min	4379.456-4376.246=3.210
max	7928.250-7313.346=614.904

CSV internal benchmark: pointedIndexFromKvs

Factor

allocated MiB

peak allocated MiB

time (ms)

op=pointedIndexFromKvs

rows=200000

*mean*	172.588-172.583=0.005
σ	0.030-0.028=0.003
min	172.560-172.558=0.002
max	172.630-172.629=0.001

*mean*	2029.000-1981.000=48.000
σ	0.000
min	2029.000-1981.000=48.000
max	2029.000-1981.000=48.000

*mean*	371.119-367.632=3.486
σ	69.006-21.758=47.248
min	262.853-339.436=-76.583
max	501.187-404.592=96.596

op=pointedIndexFromKvs

rows=400000

*mean*	357.367-357.361=0.006
σ	0.046-0.038=0.007
min	357.321
max	357.426-357.408=0.018

*mean*	2029.000-1981.000=48.000
σ	0.000
min	2029.000-1981.000=48.000
max	2029.000-1981.000=48.000

*mean*	770.310-753.520=16.790
σ	20.418-55.334=-34.916
min	748.528-635.866=112.662
max	799.623-818.278=-18.655

Marine Hull: transactPolicy

Factor

allocated MiB

peak allocated MiB

time

datapoints=1

iterations=20

*mean*	1008.187-1008.181=0.005
σ	0.875-0.927=-0.052
min	1007.689-1007.724=-0.036
max	1011.811-1012.040=-0.229

*mean*	1038.600-1041.400=-2.800
σ	303.828-304.882=-1.054
min	547.000-557.000=-10.000
max	1464.000-1468.000=-4.000

*mean*	1.521-1.557=-0.036
σ	0.067-0.112=-0.044
min	1.447-1.463=-0.016
max	1.709-1.813=-0.104

Parser: Comma Sep

Factor

allocated MiB

peak allocated MiB

time (ms)

name=ambiguous_item.art

*mean*	0.883-0.884=-0.001
σ	0.002-0.002=-0.000
min	0.881
max	0.886-0.886=-0.001

*mean*	1464.000-1468.000=-4.000
σ	0.000
min	1464.000-1468.000=-4.000
max	1464.000-1468.000=-4.000

*mean*	0.419-0.446=-0.028
σ	0.133-0.131=0.003
min	0.342-0.343=-0.000
max	0.656-0.656=-0.001

name=error_case.art

*mean*	2.334-2.333=0.000
σ	0.002-0.003=-0.000
min	2.332
max	2.337

*mean*	1464.000-1468.000=-4.000
σ	0.000
min	1464.000-1468.000=-4.000
max	1464.000-1468.000=-4.000

*mean*	0.879-0.892=-0.013
σ	0.076-0.096=-0.021
min	0.827-0.834=-0.008
max	1.012-1.064=-0.052

name=heavy_item.art

*mean*	1.521
σ	0.002
min	1.520
max	1.524

*mean*	1464.000-1468.000=-4.000
σ	0.000
min	1464.000-1468.000=-4.000
max	1464.000-1468.000=-4.000

*mean*	0.537-0.542=-0.005
σ	0.047-0.045=0.002
min	0.497-0.506=-0.009
max	0.609-0.619=-0.010

name=nested_use.art

*mean*	2.355
σ	0.002
min	2.355
max	2.358

*mean*	1464.000-1468.000=-4.000
σ	0.000
min	1464.000-1468.000=-4.000
max	1464.000-1468.000=-4.000

*mean*	0.834-0.843=-0.009
σ	0.041-0.042=-0.001
min	0.796-0.801=-0.005
max	0.901-0.912=-0.011

Parser: Real World

Factor

allocated MiB

peak allocated MiB

time (sec)

name=aon_gpf25_7k_loc.art

*mean*	963.541-963.542=-0.001
σ	0.028-0.027=0.000
min	963.523
max	963.589-963.590=-0.001

*mean*	1464.000-1468.000=-4.000
σ	0.000
min	1464.000-1468.000=-4.000
max	1464.000-1468.000=-4.000

*mean*	0.808-0.847=-0.039
σ	0.040-0.032=0.008
min	0.754-0.790=-0.036
max	0.859-0.872=-0.012

name=cdr_enhanced_4k_loc.art

*mean*	884.854-884.851=0.002
σ	0.005-0.005=0.001
min	884.847
max	884.861-884.859=0.002

*mean*	1464.000-1468.000=-4.000
σ	0.000
min	1464.000-1468.000=-4.000
max	1464.000-1468.000=-4.000

*mean*	0.732-0.705=0.027
σ	0.029-0.036=-0.007
min	0.680-0.644=0.035
max	0.749-0.740=0.009

Parser: Record Parsing

Factor

allocated MiB

peak allocated MiB

time (ms)

name=record_render_large_success.art

*mean*	7.706-7.706=0.000
σ	0.002-0.002=0.000
min	7.705
max	7.712-7.711=0.001

*mean*	1464.000-1468.000=-4.000
σ	0.000
min	1464.000-1468.000=-4.000
max	1464.000-1468.000=-4.000

*mean*	4.328-4.279=0.048
σ	0.096-0.078=0.018
min	4.160-4.137=0.023
max	4.578-4.550=0.028

name=record_render_large_syntax_err.art

*mean*	7.655
σ	0.002
min	7.654
max	7.658

*mean*	1464.000-1468.000=-4.000
σ	0.000
min	1464.000-1468.000=-4.000
max	1464.000-1468.000=-4.000

*mean*	4.281-4.259=0.022
σ	0.124-0.073=0.051
min	4.091-4.121=-0.029
max	5.135-4.513=0.622

name=record_render_success.art

*mean*	2.288
σ	0.002
min	2.287
max	2.291

*mean*	1464.000-1468.000=-4.000
σ	0.000
min	1464.000-1468.000=-4.000
max	1464.000-1468.000=-4.000

*mean*	0.757-0.757=0.000
σ	0.019-0.019=-0.000
min	0.725-0.726=-0.001
max	0.867-0.878=-0.011

name=record_render_syntax_err.art

*mean*	2.163
σ	0.002
min	2.163
max	2.166

*mean*	1464.000-1468.000=-4.000
σ	0.000
min	1464.000-1468.000=-4.000
max	1464.000-1468.000=-4.000

*mean*	0.718-0.700=0.018
σ	0.013-0.023=-0.010
min	0.692-0.633=0.059
max	0.761-0.812=-0.050

SoV import

Factor

allocated MiB

peak allocated MiB

time_s

iters=10

rows=1000

*mean*	297.419-297.595=-0.176
σ	0.259-0.228=0.031
min	297.228-297.356=-0.128
max	298.130-298.193=-0.064

*mean*	2029.000-1981.000=48.000
σ	0.000
min	2029.000-1981.000=48.000
max	2029.000-1981.000=48.000

*mean*	0.555-0.545=0.010
σ	0.032-0.037=-0.004
min	0.503-0.504=-0.002
max	0.587-0.593=-0.006

Timed compile per phase

Factor

allocated MiB

peak allocated MiB

time (ms)

phase=buildDeclTree

*mean*	219.065
σ	0.000
min	219.065
max	219.065

*mean*	1745.000-1567.125=177.875
σ	0.000-113.831=-113.831
min	1745.000-1468.000=277.000
max	1745.000-1698.000=47.000

*mean*	197.168-195.550=1.618
σ	2.133-2.514=-0.381
min	193.214-192.721=0.493
max	199.949-199.869=0.079

phase=macro expansion

*mean*	1.295
σ	0.000
min	1.295
max	1.295

*mean*	1745.000-1567.125=177.875
σ	0.000-113.831=-113.831
min	1745.000-1468.000=277.000
max	1745.000-1698.000=47.000

*mean*	0.984-1.018=-0.034
σ	0.231-0.223=0.009
min	0.634-0.636=-0.003
max	1.200-1.203=-0.002

phase=parser

*mean*	1023.358-1023.359=-0.000
σ	0.000-0.000=0.000
min	1023.358-1023.358=-0.000
max	1023.359

*mean*	1745.000-1567.125=177.875
σ	0.000-113.831=-113.831
min	1745.000-1468.000=277.000
max	1745.000-1698.000=47.000

*mean*	590.843-594.641=-3.797
σ	111.450-116.007=-4.557
min	351.993-357.628=-5.636
max	679.165-685.719=-6.553

phase=processProdDef

*mean*	6169.658-6169.658=0.000
σ	0.001-0.001=0.000
min	6169.657
max	6169.659

*mean*	1745.000-1604.125=140.875
σ	0.000-124.605=-124.605
min	1745.000-1468.000=277.000
max	1745.000-1764.000=-19.000

*mean*	5788.237-5869.183=-80.946
σ	1249.935-1314.704=-64.768
min	4269.816-3579.848=689.968
max	7448.934-7190.534=258.400

phase=renaming

*mean*	24.522
σ	0.000
min	24.522
max	24.522

*mean*	1745.000-1567.125=177.875
σ	0.000-113.831=-113.831
min	1745.000-1468.000=277.000
max	1745.000-1698.000=47.000

*mean*	40.623-40.157=0.466
σ	7.521-7.901=-0.380
min	23.862-24.115=-0.252
max	46.339-46.268=0.071

phase=type checker

*mean*	974.792
σ	0.047
min	974.722
max	974.878

*mean*	1745.000-1567.125=177.875
σ	0.000-113.831=-113.831
min	1745.000-1468.000=277.000
max	1745.000-1698.000=47.000

*mean*	765.170-750.014=15.155
σ	100.430-29.675=70.755
min	688.284-704.820=-16.536
max	994.923-778.949=215.974

Workflow: transactPolicy

Factor

allocated MiB

peak allocated MiB

time

iters=5

new-facts=1

prior-facts=1

*mean*	289.765-289.771=-0.007
σ	0.034-0.033=0.001
min	289.718-289.728=-0.010
max	289.800-289.808=-0.008

*mean*	1745.000-1764.000=-19.000
σ	0.000
min	1745.000-1764.000=-19.000
max	1745.000-1764.000=-19.000

*mean*	0.389-0.399=-0.009
σ	0.005-0.010=-0.005
min	0.386-0.389=-0.003
max	0.398-0.410=-0.012

iters=5

new-facts=1

prior-facts=6402

*mean*	1299.618-1299.602=0.015
σ	0.096-0.100=-0.003
min	1299.512-1299.504=0.007
max	1299.775-1299.762=0.012

*mean*	1745.000-1764.000=-19.000
σ	0.000
min	1745.000-1764.000=-19.000
max	1745.000-1764.000=-19.000

*mean*	1.935-1.990=-0.055
σ	0.177-0.129=0.048
min	1.796-1.838=-0.043
max	2.157-2.196=-0.039

iters=5

new-facts=6402

prior-facts=1

*mean*	1542.638-1542.648=-0.010
σ	4.027-4.010=0.016
min	1540.621-1540.688=-0.067
max	1549.835-1549.816=0.019

*mean*	1745.000-1764.000=-19.000
σ	0.000
min	1745.000-1764.000=-19.000
max	1745.000-1764.000=-19.000

*mean*	2.303-2.260=0.043
σ	0.237-0.116=0.121
min	2.056-2.132=-0.076
max	2.649-2.383=0.266

iters=5

new-facts=6402

prior-facts=6402

*mean*	1861.637-1861.653=-0.016
σ	0.046-0.068=-0.023
min	1861.594-1861.577=0.017
max	1861.702-1861.729=-0.027

*mean*	1821.200-1856.200=-35.000
σ	123.524-114.458=9.066
min	1745.000-1764.000=-19.000
max	2029.000-1981.000=48.000

*mean*	2.905-3.276=-0.371
σ	0.069-0.382=-0.313
min	2.830-2.861=-0.031
max	2.981-3.794=-0.813

newProductH/cdr_auton/broker

Factor

time_s

iterations=5

*mean*	1.799-1.817=-0.017
σ	0.081-0.107=-0.026
min	1.659-1.673=-0.013
max	1.865-1.931=-0.066

policy addition benchmark

Factor

allocated MiB

db queries

peak allocated MiB

time

policies=2

*mean*	446.183-446.185=-0.001
σ	577.140-577.141=-0.001
min	157.610-157.613=-0.003
max	1311.893-1311.896=-0.003

*mean*	96.250
σ	8.500
min	92.000
max	109.000

*mean*	1745.000-1764.000=-19.000
σ	0.000
min	1745.000-1764.000=-19.000
max	1745.000-1764.000=-19.000

*mean*	0.469-0.428=0.041
σ	0.388-0.317=0.071
min	0.273-0.267=0.006
max	1.051-0.903=0.148

policies=20

*mean*	1576.421-1576.449=-0.028
σ	0.403-0.421=-0.018
min	1576.155-1576.173=-0.018
max	1577.021-1577.076=-0.055

*mean*	920.000
σ	0.000
min	920.000
max	920.000

*mean*	1745.000-1764.000=-19.000
σ	0.000
min	1745.000-1764.000=-19.000
max	1745.000-1764.000=-19.000

*mean*	2.703-2.740=-0.037
σ	0.007-0.084=-0.077
min	2.694-2.665=0.029
max	2.709-2.820=-0.110

policies=200

*mean*	15772.225-15772.280=-0.056
σ	0.246-0.145=0.101
min	15771.998-15772.149=-0.152
max	15772.551-15772.483=0.068

*mean*	9200.000
σ	0.000
min	9200.000
max	9200.000

*mean*	1745.000-1764.000=-19.000
σ	0.000
min	1745.000-1764.000=-19.000
max	1745.000-1764.000=-19.000

*mean*	26.791-26.545=0.246
σ	0.375-0.424=-0.050
min	26.299-26.213=0.086
max	27.167-27.147=0.020