Compare commits

Aggregation: measureAggregations

Factor

allocated MiB

peak allocated MiB

time_s

cache=n

dps=1

iters=10

policies=100

*mean*	54.577-54.578=-0.001
σ	0.347-0.350=-0.003
min	54.444-54.448=-0.004
max	55.564-55.574=-0.009

*mean*	416.700-417.000=-0.300
σ	0.483-0.000=0.483
min	416.000-417.000=-1.000
max	417.000

*mean*	0.141-0.142=-0.001
σ	0.005-0.006=-0.001
min	0.137-0.137=-0.001
max	0.151-0.153=-0.002

cache=y

dps=1

iters=10

policies=100

*mean*	43.706-43.706=0.001
σ	0.006-0.005=0.001
min	43.700-43.700=0.000
max	43.720-43.716=0.004

*mean*	417.000
σ	0.000
min	417.000
max	417.000

*mean*	0.124-0.122=0.002
σ	0.004-0.005=-0.001
min	0.120-0.116=0.004
max	0.132-0.131=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

*mean*	4156.250-4151.750=4.500
σ	1905.520-1898.206=7.315
min	1550.000-1556.000=-6.000
max	7327.000-7296.000=31.000

*mean*	12.994-12.392=0.602
σ	0.219-0.207=0.012
min	12.655-12.082=0.573
max	13.322-12.621=0.701

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*	4156.250-4151.750=4.500
σ	1905.520-1898.206=7.315
min	1550.000-1556.000=-6.000
max	7327.000-7296.000=31.000

*mean*	13.056-12.841=0.215
σ	0.615-0.237=0.378
min	12.248-12.383=-0.134
max	13.729-13.090=0.640

op=table_records(), no indexes

*mean*	41.932-41.932=-0.000
σ	0.001-0.001=-0.000
min	41.928
max	41.933-41.933=0.000

*mean*	7327.000-7296.000=31.000
σ	0.000
min	7327.000-7296.000=31.000
max	7327.000-7296.000=31.000

*mean*	14.863-14.686=0.177
σ	0.755-0.505=0.250
min	13.018-13.507=-0.488
max	15.268-15.161=0.107

op=table_records(), repeat

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

*mean*	4156.250-4151.750=4.500
σ	1905.520-1898.206=7.315
min	1550.000-1556.000=-6.000
max	7327.000-7296.000=31.000

*mean*	12.730-12.725=0.005
σ	1.877-1.603=0.274
min	10.877-10.548=0.329
max	15.387-14.573=0.815

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

*mean*	27.653-27.653=-0.000
σ	0.136-0.136=-0.000
min	27.603
max	27.990-27.990=-0.000

*mean*	4156.250-4151.750=4.500
σ	1905.520-1898.206=7.315
min	1550.000-1556.000=-6.000
max	7327.000-7296.000=31.000

*mean*	9.131-8.439=0.692
σ	0.439-0.219=0.220
min	8.602-8.058=0.544
max	9.816-8.719=1.098

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

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

*mean*	4156.250-4151.750=4.500
σ	1905.520-1898.206=7.315
min	1550.000-1556.000=-6.000
max	7327.000-7296.000=31.000

*mean*	6.983-6.299=0.684
σ	0.405-0.201=0.203
min	6.152-5.944=0.207
max	7.416-6.543=0.873

op=vertical_lookup_row_list() on 2 indexed

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

*mean*	4156.250-4151.750=4.500
σ	1905.520-1898.206=7.315
min	1550.000-1556.000=-6.000
max	7327.000-7296.000=31.000

*mean*	6.050-5.614=0.437
σ	0.095-0.156=-0.061
min	5.844-5.317=0.527
max	6.146-5.889=0.257

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

*mean*	4156.250-4151.750=4.500
σ	1905.520-1898.206=7.315
min	1550.000-1556.000=-6.000
max	7327.000-7296.000=31.000

*mean*	5.859-5.304=0.555
σ	0.101-0.066=0.035
min	5.759-5.203=0.556
max	6.059-5.378=0.681

CSV - loading a lazy table

Factor

allocated MiB

peak allocated MiB

time (ms)

op=load_product(), no indexes

*mean*	2524.606-2524.606=-0.000
σ	0.000-0.000=-0.000
min	2524.606
max	2524.606-2524.607=-0.000

*mean*	7327.000-7296.000=31.000
σ	0.000
min	7327.000-7296.000=31.000
max	7327.000-7296.000=31.000

*mean*	1042.245-1334.737=-292.492
σ	6.987-519.236=-512.249
min	1031.448-1039.789=-8.341
max	1054.081-2524.013=-1469.932

op=load_product(), with indexes

*mean*	8744.721-8744.721=0.000
σ	0.469-0.469=-0.000
min	8744.554-8744.553=0.001
max	8745.882-8745.882=-0.001

*mean*	3580.000-3572.125=7.875
σ	1799.064-1795.941=3.123
min	1050.000-1045.000=5.000
max	5816.000-5793.000=23.000

*mean*	4744.089-4686.320=57.769
σ	1709.919-1274.607=435.311
min	3546.404-3542.583=3.821
max	7581.756-6521.797=1059.959

CSV - unindexed operations

Factor

allocated MiB

peak allocated MiB

time (ms)

op=column_set() on unindexed, dense

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

*mean*	4156.250-4151.750=4.500
σ	1905.520-1898.206=7.315
min	1550.000-1556.000=-6.000
max	7327.000-7296.000=31.000

*mean*	82.925-84.382=-1.457
σ	10.341-12.316=-1.975
min	72.318-72.009=0.309
max	98.938-101.009=-2.071

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

*mean*	7327.000-7296.000=31.000
σ	0.000
min	7327.000-7296.000=31.000
max	7327.000-7296.000=31.000

*mean*	105.414-105.510=-0.096
σ	4.910-5.364=-0.453
min	96.821-94.000=2.820
max	111.143-111.089=0.054

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

*mean*	7327.000-7296.000=31.000
σ	0.000
min	7327.000-7296.000=31.000
max	7327.000-7296.000=31.000

*mean*	163.581-162.028=1.553
σ	8.749-9.140=-0.390
min	144.615-140.615=4.000
max	169.069-167.499=1.570

CSV - warmup

Factor

allocated MiB

peak allocated MiB

time (ms)

op=table_records()

*mean*	11656.836-11656.836=-0.000
σ	4.324-4.324=-0.000
min	11655.305-11655.305=-0.000
max	11667.537-11667.538=-0.001

*mean*	4156.250-4151.750=4.500
σ	1905.520-1898.206=7.315
min	1550.000-1556.000=-6.000
max	7327.000-7296.000=31.000

*mean*	6348.991-6172.312=176.679
σ	1237.904-1192.576=45.328
min	5000.858-4958.274=42.583
max	8017.778-7848.808=168.970

op=vertical_lookup_list() on indexed

*mean*	11560.065-11560.065=0.000
σ	0.001-0.000=0.000
min	11560.064
max	11560.066

*mean*	7327.000-7296.000=31.000
σ	0.000
min	7327.000-7296.000=31.000
max	7327.000-7296.000=31.000

*mean*	5377.807-5564.073=-186.266
σ	1633.120-1478.922=154.198
min	4345.425-4426.929=-81.504
max	8725.436-7773.554=951.882

CSV internal benchmark: pointedIndexFromKvs

Factor

allocated MiB

peak allocated MiB

time (ms)

op=pointedIndexFromKvs

rows=200000

*mean*	172.559
σ	0.001
min	172.558
max	172.562

*mean*	473.875-477.000=-3.125
σ	0.354-0.000=0.354
min	473.000-477.000=-4.000
max	474.000-477.000=-3.000

*mean*	392.646-373.320=19.326
σ	1.540-22.674=-21.134
min	390.642-337.769=52.872
max	394.750-393.706=1.044

op=pointedIndexFromKvs

rows=400000

*mean*	357.322
σ	0.001
min	357.321
max	357.325

*mean*	559.875-560.000=-0.125
σ	0.354-0.000=0.354
min	559.000-560.000=-1.000
max	560.000

*mean*	783.872-741.707=42.165
σ	25.104-55.143=-30.039
min	742.091-634.465=107.626
max	819.203-783.131=36.072

Marine Hull: transactPolicy

Factor

allocated MiB

peak allocated MiB

time

datapoints=1

iterations=20

*mean*	1008.501-1008.497=0.004
σ	0.759-0.761=-0.002
min	1008.026-1008.025=0.001
max	1011.639-1011.643=-0.004

*mean*	1043.450-1045.800=-2.350
σ	300.069-313.863=-13.794
min	562.000-572.000=-10.000
max	1447.000-1510.000=-63.000

*mean*	1.540-1.560=-0.020
σ	0.062-0.104=-0.041
min	1.466-1.478=-0.012
max	1.689-1.888=-0.199

Parser: Comma Sep

Factor

allocated MiB

peak allocated MiB

time (ms)

name=ambiguous_item.art

*mean*	0.913
σ	0.020
min	0.903
max	0.949

*mean*	402.000
σ	0.000
min	402.000
max	402.000

*mean*	0.308-0.401=-0.093
σ	0.293-0.504=-0.211
min	0.150-0.146=0.004
max	0.828-1.300=-0.472

name=error_case.art

*mean*	2.339
σ	0.012
min	2.333
max	2.361

*mean*	402.000
σ	0.000
min	402.000
max	402.000

*mean*	0.491-0.481=0.010
σ	0.320-0.323=-0.003
min	0.338-0.328=0.010
max	1.063-1.058=0.005

name=heavy_item.art

*mean*	1.522
σ	0.002
min	1.521
max	1.525

*mean*	402.000
σ	0.000
min	402.000
max	402.000

*mean*	0.234-0.228=0.006
σ	0.026-0.019=0.007
min	0.208-0.216=-0.009
max	0.271-0.262=0.009

name=nested_use.art

*mean*	2.357
σ	0.002
min	2.356
max	2.360

*mean*	402.000
σ	0.000
min	402.000
max	402.000

*mean*	0.342-0.338=0.004
σ	0.018-0.040=-0.022
min	0.324-0.313=0.011
max	0.372-0.409=-0.037

Parser: Real World

Factor

allocated MiB

peak allocated MiB

time (sec)

name=aon_gpf25_7k_loc.art

*mean*	964.741
σ	0.011
min	964.736
max	964.760

*mean*	436.000-431.400=4.600
σ	2.236-0.894=1.342
min	432.000-431.000=1.000
max	437.000-433.000=4.000

*mean*	0.506-0.565=-0.058
σ	0.048-0.037=0.011
min	0.432-0.531=-0.100
max	0.554-0.610=-0.056

name=cdr_enhanced_4k_loc.art

*mean*	885.814
σ	0.002
min	885.812
max	885.816

*mean*	437.000-439.000=-2.000
σ	0.000
min	437.000-439.000=-2.000
max	437.000-439.000=-2.000

*mean*	0.493-0.456=0.037
σ	0.043-0.054=-0.011
min	0.422-0.392=0.030
max	0.522-0.519=0.003

Parser: Record Parsing

Factor

allocated MiB

peak allocated MiB

time (ms)

name=record_render_large_success.art

*mean*	7.708
σ	0.002
min	7.707
max	7.711

*mean*	437.000-439.000=-2.000
σ	0.000
min	437.000-439.000=-2.000
max	437.000-439.000=-2.000

*mean*	2.178-2.272=-0.094
σ	0.317-0.398=-0.082
min	1.881-1.735=0.146
max	2.941-3.022=-0.081

name=record_render_large_syntax_err.art

*mean*	7.656
σ	0.002
min	7.655
max	7.659

*mean*	437.000-439.000=-2.000
σ	0.000
min	437.000-439.000=-2.000
max	437.000-439.000=-2.000

*mean*	1.946-2.593=-0.647
σ	0.067-0.100=-0.033
min	1.823-2.461=-0.637
max	2.208-3.268=-1.060

name=record_render_success.art

*mean*	2.289
σ	0.002
min	2.288
max	2.292

*mean*	437.000-439.000=-2.000
σ	0.000
min	437.000-439.000=-2.000
max	437.000-439.000=-2.000

*mean*	0.329-0.311=0.018
σ	0.076-0.011=0.065
min	0.296-0.290=0.007
max	0.794-0.373=0.421

name=record_render_syntax_err.art

*mean*	2.165
σ	0.002
min	2.164
max	2.168

*mean*	437.000-439.000=-2.000
σ	0.000
min	437.000-439.000=-2.000
max	437.000-439.000=-2.000

*mean*	0.296-0.304=-0.007
σ	0.008-0.051=-0.043
min	0.279-0.284=-0.005
max	0.346-0.772=-0.426

SoV import

Factor

allocated MiB

peak allocated MiB

time_s

iters=10

rows=1000

*mean*	298.267-297.973=0.295
σ	0.997-0.981=0.016
min	297.800-297.496=0.304
max	301.077-300.742=0.335

*mean*	439.000-442.600=-3.600
σ	15.341-14.191=1.150
min	414.000-418.000=-4.000
max	459.000-464.000=-5.000

*mean*	0.610-0.615=-0.005
σ	0.017-0.018=-0.001
min	0.579-0.577=0.002
max	0.629-0.633=-0.004

Timed compile per phase

Factor

allocated MiB

peak allocated MiB

time (ms)

phase=buildDeclTree

*mean*	222.008-222.008=-0.000
σ	0.000-0.000=0.000
min	222.008-222.008=-0.000
max	222.008-222.008=-0.000

*mean*	1543.750-1739.000=-195.250
σ	190.211-0.000=190.211
min	1242.000-1739.000=-497.000
max	1663.000-1739.000=-76.000

*mean*	207.103-206.386=0.718
σ	1.506-2.436=-0.930
min	205.454-203.754=1.700
max	209.274-210.834=-1.560

phase=macro expansion

*mean*	6.130
σ	0.000
min	6.130
max	6.130

*mean*	1543.750-1739.000=-195.250
σ	190.211-0.000=190.211
min	1242.000-1739.000=-497.000
max	1663.000-1739.000=-76.000

*mean*	10.241-10.514=-0.273
σ	2.143-2.214=-0.070
min	6.199-6.287=-0.088
max	12.559-12.826=-0.267

phase=parser

*mean*	1042.099-1042.099=0.001
σ	0.001-0.000=0.001
min	1042.097-1042.098=-0.002
max	1042.100-1042.099=0.001

*mean*	1543.750-1739.000=-195.250
σ	190.211-0.000=190.211
min	1242.000-1739.000=-497.000
max	1663.000-1739.000=-76.000

*mean*	704.508-649.362=55.146
σ	33.245-119.048=-85.803
min	651.422-405.368=246.054
max	733.341-728.934=4.407

phase=processProdDef

*mean*	6169.660-6169.659=0.002
σ	0.001-0.001=0.000
min	6169.660-6169.658=0.002
max	6169.662-6169.660=0.003

*mean*	1596.375-1739.125=-142.750
σ	148.456-0.354=148.102
min	1242.000-1739.000=-497.000
max	1663.000-1740.000=-77.000

*mean*	5977.079-5264.263=712.816
σ	1168.246-1448.810=-280.564
min	4280.633-3049.933=1230.701
max	7175.856-6825.301=350.555

phase=renaming

*mean*	21.667-21.670=-0.003
σ	0.001-0.000=0.001
min	21.667-21.670=-0.004
max	21.670-21.670=0.000

*mean*	1543.750-1739.000=-195.250
σ	190.211-0.000=190.211
min	1242.000-1739.000=-497.000
max	1663.000-1739.000=-76.000

*mean*	39.529-38.689=0.840
σ	9.164-7.799=1.365
min	29.382-29.384=-0.002
max	50.236-47.815=2.421

phase=type checker

*mean*	958.460-958.457=0.003
σ	0.066-0.066=0.001
min	958.360
max	958.551-958.547=0.004

*mean*	1543.750-1739.000=-195.250
σ	190.211-0.000=190.211
min	1242.000-1739.000=-497.000
max	1663.000-1739.000=-76.000

*mean*	726.223-748.655=-22.432
σ	91.223-88.828=2.394
min	637.860-642.283=-4.423
max	897.778-891.865=5.912

Workflow: transactPolicy

Factor

allocated MiB

peak allocated MiB

time

iters=5

new-facts=1

prior-facts=1

*mean*	293.381-293.379=0.001
σ	0.034-0.038=-0.004
min	293.333-293.329=0.004
max	293.418-293.418=-0.000

*mean*	445.000-446.000=-1.000
σ	0.000
min	445.000-446.000=-1.000
max	445.000-446.000=-1.000

*mean*	0.403-0.405=-0.002
σ	0.006-0.007=-0.000
min	0.392-0.399=-0.007
max	0.410-0.412=-0.002

iters=5

new-facts=1

prior-facts=6402

*mean*	1303.437-1303.471=-0.034
σ	0.069-0.085=-0.017
min	1303.342-1303.325=0.017
max	1303.532-1303.537=-0.005

*mean*	1063.400-1086.400=-23.000
σ	169.076-228.321=-59.244
min	840.000-820.000=20.000
max	1275.000-1387.000=-112.000

*mean*	1.937-2.043=-0.106
σ	0.158-0.173=-0.016
min	1.817-1.841=-0.024
max	2.132-2.182=-0.050

iters=5

new-facts=6402

prior-facts=1

*mean*	1546.498-1546.544=-0.046
σ	4.001-4.010=-0.009
min	1544.527-1544.575=-0.047
max	1553.650-1553.712=-0.062

*mean*	612.000-624.800=-12.800
σ	73.304-92.767=-19.463
min	497.000-496.000=1.000
max	690.000-738.000=-48.000

*mean*	2.245-2.341=-0.097
σ	0.103-0.195=-0.092
min	2.149-2.117=0.032
max	2.365-2.605=-0.240

iters=5

new-facts=6402

prior-facts=6402

*mean*	1865.443-1865.441=0.002
σ	0.042-0.039=0.003
min	1865.397-1865.387=0.010
max	1865.498-1865.493=0.005

*mean*	1716.000-1707.000=9.000
σ	254.366-165.183=89.183
min	1421.000-1525.000=-104.000
max	2078.000-1951.000=127.000

*mean*	2.937-2.949=-0.012
σ	0.094-0.181=-0.087
min	2.860-2.752=0.109
max	3.084-3.226=-0.142

newProductH/cdr_auton/broker

Factor

time_s

iterations=5

*mean*	1.748-1.723=0.025
σ	0.165-0.098=0.068
min	1.551-1.607=-0.056
max	1.937-1.831=0.106

policy addition benchmark

Factor

allocated MiB

db queries

peak allocated MiB

time

policies=2

*mean*	447.982-447.982=-0.000
σ	579.239-579.239=0.000
min	158.361-158.362=-0.001
max	1316.841-1316.841=-0.000

*mean*	96.250
σ	8.500
min	92.000
max	109.000

*mean*	444.000-442.000=2.000
σ	0.000
min	444.000-442.000=2.000
max	444.000-442.000=2.000

*mean*	0.538-0.542=-0.004
σ	0.548-0.547=0.001
min	0.263-0.268=-0.005
max	1.361-1.362=-0.001

policies=20

*mean*	1583.936-1583.912=0.024
σ	0.357-0.359=-0.001
min	1583.685-1583.674=0.011
max	1584.464-1584.444=0.020

*mean*	920.000
σ	0.000
min	920.000
max	920.000

*mean*	446.250-444.250=2.000
σ	1.500
min	444.000-442.000=2.000
max	447.000-445.000=2.000

*mean*	2.649-2.655=-0.006
σ	0.051-0.025=0.026
min	2.596-2.632=-0.036
max	2.712-2.679=0.033

policies=200

*mean*	15847.301-15847.230=0.070
σ	0.101-0.174=-0.072
min	15847.230-15847.080=0.150
max	15847.451-15847.479=-0.027

*mean*	9200.000
σ	0.000
min	9200.000
max	9200.000

*mean*	494.500-495.250=-0.750
σ	3.109-3.862=-0.753
min	490.000
max	497.000-499.000=-2.000

*mean*	26.669-26.674=-0.005
σ	0.120-0.114=0.006
min	26.570-26.570=0.000
max	26.828-26.786=0.042