Compare commits

Aggregation: measureAggregations

Factor

allocated MiB

peak allocated MiB

time_s

cache=n

dps=1

iters=10

policies=100

*mean*	54.576-54.619=-0.043
σ	0.348-0.350=-0.002
min	54.441-54.485=-0.044
max	55.566-55.616=-0.049

*mean*	418.400-417.000=1.400
σ	0.966-0.000=0.966
min	417.000
max	419.000-417.000=2.000

*mean*	0.140-0.150=-0.010
σ	0.004-0.009=-0.005
min	0.137-0.139=-0.002
max	0.150-0.165=-0.015

cache=y

dps=1

iters=10

policies=100

*mean*	43.706-43.786=-0.080
σ	0.006-0.008=-0.002
min	43.699-43.778=-0.079
max	43.717-43.803=-0.086

*mean*	419.000-417.000=2.000
σ	0.000
min	419.000-417.000=2.000
max	419.000-417.000=2.000

*mean*	0.123-0.126=-0.002
σ	0.004-0.008=-0.003
min	0.120-0.117=0.003
max	0.132-0.141=-0.010

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-36.616=-0.000
max	36.620-36.620=-0.000

*mean*	4149.500-4255.875=-106.375
σ	1893.423-1893.064=0.359
min	1554.000-1890.000=-336.000
max	7278.000-7541.000=-263.000

*mean*	12.966-12.296=0.670
σ	0.142-0.317=-0.174
min	12.652-11.802=0.850
max	13.116-12.733=0.383

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.619=0.000

*mean*	4149.500-4255.875=-106.375
σ	1893.423-1893.064=0.359
min	1554.000-1890.000=-336.000
max	7278.000-7541.000=-263.000

*mean*	13.199-12.680=0.519
σ	0.174-0.362=-0.189
min	12.927-11.922=1.005
max	13.438-13.152=0.286

op=table_records(), no indexes

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

*mean*	7278.000-7541.000=-263.000
σ	0.000
min	7278.000-7541.000=-263.000
max	7278.000-7541.000=-263.000

*mean*	15.387-13.603=1.784
σ	0.303-0.862=-0.559
min	14.668-12.630=2.038
max	15.603-14.611=0.992

op=table_records(), repeat

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

*mean*	4149.500-4255.875=-106.375
σ	1893.423-1893.064=0.359
min	1554.000-1890.000=-336.000
max	7278.000-7541.000=-263.000

*mean*	12.654-11.989=0.665
σ	1.829-1.793=0.036
min	10.821-10.504=0.317
max	15.522-14.587=0.935

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

*mean*	27.653-27.605=0.048
σ	0.136-0.002=0.135
min	27.603-27.603=0.000
max	27.990-27.607=0.383

*mean*	4149.500-4255.875=-106.375
σ	1893.423-1893.064=0.359
min	1554.000-1890.000=-336.000
max	7278.000-7541.000=-263.000

*mean*	9.036-8.253=0.784
σ	0.319-0.440=-0.121
min	8.583-7.629=0.953
max	9.433-9.001=0.432

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-26.399=0.000
max	26.403-26.403=-0.000

*mean*	4149.500-4255.875=-106.375
σ	1893.423-1893.064=0.359
min	1554.000-1890.000=-336.000
max	7278.000-7541.000=-263.000

*mean*	6.956-5.954=1.002
σ	0.531-0.311=0.220
min	6.108-5.344=0.764
max	7.606-6.368=1.238

op=vertical_lookup_row_list() on 2 indexed

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

*mean*	4149.500-4255.875=-106.375
σ	1893.423-1893.064=0.359
min	1554.000-1890.000=-336.000
max	7278.000-7541.000=-263.000

*mean*	6.019-5.310=0.709
σ	0.166-0.134=0.033
min	5.774-5.158=0.616
max	6.214-5.510=0.704

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.972-25.971=0.001

*mean*	4149.500-4255.875=-106.375
σ	1893.423-1893.064=0.359
min	1554.000-1890.000=-336.000
max	7278.000-7541.000=-263.000

*mean*	5.867-5.011=0.856
σ	0.173-0.151=0.022
min	5.684-4.765=0.919
max	6.250-5.192=1.059

CSV - loading a lazy table

Factor

allocated MiB

peak allocated MiB

time (ms)

op=load_product(), no indexes

*mean*	2524.606-2524.594=0.012
σ	0.000-0.000=0.000
min	2524.606-2524.594=0.012
max	2524.607-2524.594=0.013

*mean*	7278.000-7541.000=-263.000
σ	0.000
min	7278.000-7541.000=-263.000
max	7278.000-7541.000=-263.000

*mean*	1504.057-1052.984=451.072
σ	859.463-4.608=854.855
min	1045.717-1046.053=-0.335
max	3538.066-1058.670=2479.396

op=load_product(), with indexes

*mean*	8744.721-8744.559=0.162
σ	0.469-0.033=0.436
min	8744.553-8744.545=0.008
max	8745.883-8744.640=1.243

*mean*	3571.625-3766.750=-195.125
σ	1794.296-1638.423=155.873
min	1043.000-1890.000=-847.000
max	5787.000-5946.000=-159.000

*mean*	4945.174-4620.953=324.221
σ	1565.579-1460.399=105.180
min	3539.800-3552.378=-12.578
max	7419.736-7288.588=131.148

CSV - unindexed operations

Factor

allocated MiB

peak allocated MiB

time (ms)

op=column_set() on unindexed, dense

*mean*	62.078-62.077=0.000
σ	0.002-0.002=0.000
min	62.076-62.076=-0.000
max	62.081-62.080=0.001

*mean*	4149.500-4255.875=-106.375
σ	1893.423-1893.064=0.359
min	1554.000-1890.000=-336.000
max	7278.000-7541.000=-263.000

*mean*	85.810-85.635=0.175
σ	13.314-7.072=6.243
min	71.534-76.535=-5.002
max	101.968-96.826=5.142

op=vertical_lookup_list() on unindexed missing Int

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

*mean*	7278.000-7541.000=-263.000
σ	0.000
min	7278.000-7541.000=-263.000
max	7278.000-7541.000=-263.000

*mean*	107.692-99.339=8.353
σ	2.364-8.342=-5.978
min	103.543-85.134=18.409
max	109.618-107.961=1.657

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-66.685=-0.000
max	66.687-66.686=0.000

*mean*	7278.000-7541.000=-263.000
σ	0.000
min	7278.000-7541.000=-263.000
max	7278.000-7541.000=-263.000

*mean*	163.889-150.198=13.692
σ	5.794-16.980=-11.186
min	151.239-117.530=33.709
max	169.638-167.771=1.867

CSV - warmup

Factor

allocated MiB

peak allocated MiB

time (ms)

op=table_records()

*mean*	11656.836-11656.833=0.004
σ	4.324-4.317=0.007
min	11655.305-11655.305=0.000
max	11667.537-11667.517=0.021

*mean*	4149.500-4255.875=-106.375
σ	1893.423-1893.064=0.359
min	1554.000-1890.000=-336.000
max	7278.000-7541.000=-263.000

*mean*	6600.890-6331.926=268.964
σ	1312.335-1313.152=-0.817
min	4933.361-4950.041=-16.680
max	8068.833-8423.325=-354.492

op=vertical_lookup_list() on indexed

*mean*	11560.065-11560.068=-0.004
σ	0.001-0.001=-0.000
min	11560.064-11560.066=-0.002
max	11560.066-11560.069=-0.003

*mean*	7278.000-7541.000=-263.000
σ	0.000
min	7278.000-7541.000=-263.000
max	7278.000-7541.000=-263.000

*mean*	5336.465-5386.988=-50.523
σ	1294.143-1302.881=-8.739
min	4392.548-4416.464=-23.916
max	7962.496-7399.778=562.718

CSV internal benchmark: pointedIndexFromKvs

Factor

allocated MiB

peak allocated MiB

time (ms)

op=pointedIndexFromKvs

rows=200000

*mean*	172.559-172.591=-0.032
σ	0.001-0.025=-0.023
min	172.558
max	172.562-172.623=-0.061

*mean*	477.000-1890.000=-1413.000
σ	0.000
min	477.000-1890.000=-1413.000
max	477.000-1890.000=-1413.000

*mean*	385.931-375.499=10.432
σ	14.941-21.136=-6.196
min	349.086-354.409=-5.323
max	393.734-403.924=-10.191

op=pointedIndexFromKvs

rows=400000

*mean*	357.322-357.359=-0.038
σ	0.001-0.037=-0.036
min	357.321
max	357.325-357.403=-0.078

*mean*	559.250-1890.000=-1330.750
σ	0.463-0.000=0.463
min	559.000-1890.000=-1331.000
max	560.000-1890.000=-1330.000

*mean*	757.482-745.434=12.049
σ	66.925-85.242=-18.317
min	602.860-626.354=-23.494
max	831.371-870.686=-39.315

Marine Hull: transactPolicy

Factor

allocated MiB

peak allocated MiB

time

datapoints=1

iterations=20

*mean*	1008.515-1008.201=0.314
σ	0.818-0.971=-0.153
min	1008.026-1007.714=0.312
max	1011.908-1012.250=-0.342

*mean*	1051.100-1040.600=10.500
σ	316.305-296.374=19.931
min	564.000-552.000=12.000
max	1524.000-1440.000=84.000

*mean*	1.538-1.563=-0.024
σ	0.077-0.086=-0.009
min	1.354-1.474=-0.120
max	1.700-1.772=-0.073

Parser: Comma Sep

Factor

allocated MiB

peak allocated MiB

time (ms)

name=ambiguous_item.art

*mean*	0.913-0.883=0.030
σ	0.020-0.002=0.018
min	0.903-0.881=0.021
max	0.949-0.886=0.063

*mean*	402.000-1440.000=-1038.000
σ	0.000
min	402.000-1440.000=-1038.000
max	402.000-1440.000=-1038.000

*mean*	0.401-0.420=-0.020
σ	0.518-0.124=0.394
min	0.138-0.354=-0.216
max	1.326-0.641=0.685

name=error_case.art

*mean*	2.339-2.333=0.006
σ	0.012-0.003=0.010
min	2.333-2.332=0.001
max	2.361-2.337=0.024

*mean*	402.000-1440.000=-1038.000
σ	0.000
min	402.000-1440.000=-1038.000
max	402.000-1440.000=-1038.000

*mean*	0.661-0.898=-0.238
σ	0.308-0.088=0.220
min	0.337-0.827=-0.490
max	1.039-1.048=-0.009

name=heavy_item.art

*mean*	1.522-1.521=0.001
σ	0.002-0.002=0.000
min	1.521-1.520=0.001
max	1.525-1.524=0.001

*mean*	402.000-1440.000=-1038.000
σ	0.000
min	402.000-1440.000=-1038.000
max	402.000-1440.000=-1038.000

*mean*	0.219-0.557=-0.338
σ	0.023-0.046=-0.023
min	0.196-0.518=-0.322
max	0.258-0.636=-0.378

name=nested_use.art

*mean*	2.357-2.355=0.001
σ	0.002
min	2.356-2.355=0.001
max	2.360-2.358=0.001

*mean*	402.000-1440.000=-1038.000
σ	0.000
min	402.000-1440.000=-1038.000
max	402.000-1440.000=-1038.000

*mean*	0.336-0.860=-0.524
σ	0.016-0.037=-0.021
min	0.323-0.837=-0.514
max	0.362-0.926=-0.563

Parser: Real World

Factor

allocated MiB

peak allocated MiB

time (sec)

name=aon_gpf25_7k_loc.art

*mean*	964.741-963.548=1.193
σ	0.011-0.035=-0.025
min	964.736-963.523=1.213
max	964.760-963.608=1.151

*mean*	436.600-1440.000=-1003.400
σ	6.066-0.000=6.066
min	431.000-1440.000=-1009.000
max	443.000-1440.000=-997.000

*mean*	0.536-0.809=-0.273
σ	0.052-0.036=0.017
min	0.476-0.782=-0.306
max	0.615-0.866=-0.251

name=cdr_enhanced_4k_loc.art

*mean*	885.814-884.854=0.960
σ	0.002-0.009=-0.007
min	885.812-884.847=0.965
max	885.816-884.867=0.949

*mean*	443.000-1440.000=-997.000
σ	0.000
min	443.000-1440.000=-997.000
max	443.000-1440.000=-997.000

*mean*	0.512-0.737=-0.224
σ	0.032-0.022=0.010
min	0.455-0.698=-0.243
max	0.529-0.750=-0.221

Parser: Record Parsing

Factor

allocated MiB

peak allocated MiB

time (ms)

name=record_render_large_success.art

*mean*	7.708-7.706=0.001
σ	0.002-0.002=0.000
min	7.707-7.705=0.001
max	7.711-7.709=0.001

*mean*	443.000-1440.000=-997.000
σ	0.000
min	443.000-1440.000=-997.000
max	443.000-1440.000=-997.000

*mean*	1.961-4.321=-2.359
σ	0.075-0.116=-0.041
min	1.845-4.152=-2.307
max	2.292-5.137=-2.846

name=record_render_large_syntax_err.art

*mean*	7.656-7.655=0.001
σ	0.002-0.002=-0.000
min	7.655-7.654=0.001
max	7.659-7.658=0.001

*mean*	443.000-1440.000=-997.000
σ	0.000
min	443.000-1440.000=-997.000
max	443.000-1440.000=-997.000

*mean*	1.969-4.301=-2.332
σ	0.090-0.085=0.005
min	1.841-4.164=-2.323
max	2.274-4.626=-2.352

name=record_render_success.art

*mean*	2.289-2.288=0.001
σ	0.002
min	2.288-2.287=0.001
max	2.292-2.291=0.001

*mean*	443.000-1440.000=-997.000
σ	0.000
min	443.000-1440.000=-997.000
max	443.000-1440.000=-997.000

*mean*	0.302-0.766=-0.463
σ	0.008-0.016=-0.007
min	0.287-0.735=-0.448
max	0.348-0.863=-0.516

name=record_render_syntax_err.art

*mean*	2.165-2.163=0.001
σ	0.002
min	2.164-2.163=0.001
max	2.168-2.166=0.001

*mean*	443.000-1440.000=-997.000
σ	0.000
min	443.000-1440.000=-997.000
max	443.000-1440.000=-997.000

*mean*	0.291-0.733=-0.442
σ	0.008-0.019=-0.011
min	0.274-0.636=-0.362
max	0.335-0.791=-0.456

SoV import

Factor

allocated MiB

peak allocated MiB

time_s

iters=10

rows=1000

*mean*	298.272-297.722=0.550
σ	1.025-0.213=0.812
min	297.839-297.589=0.250
max	301.179-298.303=2.875

*mean*	442.900-1890.000=-1447.100
σ	18.912-0.000=18.912
min	416.000-1890.000=-1474.000
max	467.000-1890.000=-1423.000

*mean*	0.607-0.619=-0.012
σ	0.016-0.017=-0.001
min	0.584-0.600=-0.015
max	0.641-0.650=-0.009

Timed compile per phase

Factor

allocated MiB

peak allocated MiB

time (ms)

phase=buildDeclTree

*mean*	222.008
σ	0.000
min	222.008
max	222.008

*mean*	1742.500
σ	0.926
min	1741.000
max	1743.000

*mean*	204.051
σ	1.437
min	201.846
max	206.239

phase=macro expansion

*mean*	6.130
σ	0.000
min	6.130
max	6.130

*mean*	1742.500
σ	0.926
min	1741.000
max	1743.000

*mean*	10.998
σ	1.382
min	9.187
max	12.573

phase=parser

*mean*	1042.099
σ	0.000
min	1042.098
max	1042.099

*mean*	1742.500
σ	0.926
min	1741.000
max	1743.000

*mean*	633.648
σ	75.618
min	567.916
max	724.612

phase=processProdDef

*mean*	6169.656
σ	0.001
min	6169.655
max	6169.657

*mean*	1742.750
σ	0.707
min	1741.000
max	1743.000

*mean*	5198.344
σ	1229.820
min	3618.709
max	7206.905

phase=renaming

*mean*	21.667
σ	0.000
min	21.667
max	21.667

*mean*	1742.500
σ	0.926
min	1741.000
max	1743.000

*mean*	40.776
σ	5.986
min	34.539
max	47.723

phase=type checker

*mean*	958.457
σ	0.066
min	958.360
max	958.547

*mean*	1742.500
σ	0.926
min	1741.000
max	1743.000

*mean*	801.736
σ	96.971
min	662.715
max	884.002

Workflow: transactPolicy

Factor

allocated MiB

peak allocated MiB

time

iters=5

new-facts=1

prior-facts=1

*mean*	293.957-290.043=3.913
σ	0.038-0.038=-0.000
min	293.902-289.990=3.912
max	293.994-290.084=3.910

*mean*	447.000-1440.000=-993.000
σ	0.000
min	447.000-1440.000=-993.000
max	447.000-1440.000=-993.000

*mean*	0.395-0.395=0.000
σ	0.003-0.013=-0.010
min	0.393-0.388=0.005
max	0.400-0.418=-0.017

iters=5

new-facts=1

prior-facts=6402

*mean*	1304.033-1299.950=4.083
σ	0.073-0.107=-0.033
min	1303.911-1299.808=4.103
max	1304.109-1300.092=4.017

*mean*	1107.600-1440.000=-332.400
σ	171.208-0.000=171.208
min	895.000-1440.000=-545.000
max	1332.000-1440.000=-108.000

*mean*	2.067-2.391=-0.324
σ	0.156-0.249=-0.093
min	1.893-2.199=-0.306
max	2.247-2.758=-0.511

iters=5

new-facts=6402

prior-facts=1

*mean*	1547.118-1542.936=4.182
σ	4.026-3.987=0.039
min	1545.182-1540.995=4.187
max	1554.316-1550.064=4.252

*mean*	625.400-1440.000=-814.600
σ	88.401-0.000=88.401
min	510.000-1440.000=-930.000
max	730.000-1440.000=-710.000

*mean*	2.417-2.352=0.066
σ	0.326-0.131=0.195
min	2.109-2.151=-0.041
max	2.812-2.476=0.336

iters=5

new-facts=6402

prior-facts=6402

*mean*	1866.062-1861.894=4.168
σ	0.097-0.060=0.037
min	1865.942-1861.812=4.130
max	1866.169-1861.967=4.202

*mean*	1761.800-1735.400=26.400
σ	216.764-167.446=49.318
min	1479.000-1493.000=-14.000
max	1969.000-1890.000=79.000

*mean*	3.203-3.108=0.095
σ	0.364-0.249=0.116
min	2.691-2.856=-0.165
max	3.540-3.472=0.068

newProductH/cdr_auton/broker

Factor

time_s

iterations=5

*mean*	1.814-1.666=0.149
σ	0.122-0.181=-0.060
min	1.633-1.462=0.170
max	1.957-1.867=0.090

policy addition benchmark

Factor

allocated MiB

db queries

peak allocated MiB

time

policies=2

*mean*	448.578-446.745=1.833
σ	579.374-577.197=2.177
min	158.889-158.145=0.744
max	1317.640-1312.540=5.099

*mean*	96.250
σ	8.500
min	92.000
max	109.000

*mean*	444.000-1440.000=-996.000
σ	0.000
min	444.000-1440.000=-996.000
max	444.000-1440.000=-996.000

*mean*	0.539-0.548=-0.009
σ	0.547-0.568=-0.021
min	0.263-0.260=0.002
max	1.359-1.400=-0.041

policies=20

*mean*	1589.226-1581.735=7.491
σ	0.363-0.358=0.005
min	1588.974-1581.492=7.482
max	1589.763-1582.267=7.496

*mean*	920.000
σ	0.000
min	920.000
max	920.000

*mean*	448.000-1440.000=-992.000
σ	4.619-0.000=4.619
min	444.000-1440.000=-996.000
max	452.000-1440.000=-988.000

*mean*	2.636-2.637=-0.001
σ	0.015-0.017=-0.003
min	2.622-2.615=0.007
max	2.656-2.655=0.001

policies=200

*mean*	15900.357-15825.435=74.922
σ	0.136-0.094=0.042
min	15900.218-15825.295=74.924
max	15900.544-15825.490=75.054

*mean*	9200.000
σ	0.000
min	9200.000
max	9200.000

*mean*	496.500-1440.000=-943.500
σ	2.887-0.000=2.887
min	493.000-1440.000=-947.000
max	500.000-1440.000=-940.000

*mean*	26.771-26.607=0.165
σ	0.097-0.082=0.014
min	26.645-26.489=0.156
max	26.856-26.668=0.188