Skip to content

Instantly share code, notes, and snippets.

@pettyjamesm

pettyjamesm/baseline_join.json

Created August 25, 2021 20:51
Show Gist options
  • Save pettyjamesm/4433598a243df755ba13138e67c7005d to your computer and use it in GitHub Desktop.
Save pettyjamesm/4433598a243df755ba13138e67c7005d to your computer and use it in GitHub Desktop.
Download ZIP
Lookup Join Benchmarks
Raw
baseline_join.json
[
{
"jmhVersion" : "1.20",
"benchmark" : "io.trino.operator.join.BenchmarkHashBuildAndJoinOperators.benchmarkJoinHash",
"mode" : "avgt",
"threads" : 1,
"forks" : 1,
"jvm" : "/local/home/pettja/.sdkman/candidates/java/11.0.12-zulu/bin/java",
"jvmArgs" : [
"-Xms8g",
"-Xmx8g",
"-XX:+AlwaysPreTouch",
"-XX:ReservedCodeCacheSize=256M"
],
"jdkVersion" : "11.0.12",
"vmVersion" : "11.0.12+7-LTS",
"warmupIterations" : 5,
"warmupTime" : "1 s",
"warmupBatchSize" : 1,
"measurementIterations" : 10,
"measurementTime" : "2 s",
"measurementBatchSize" : 1,
"params" : {
"buildHashEnabled" : "true",
"buildRowsRepetition" : "1",
"hashColumns" : "bigint",
"matchRate" : "0.1",
"outputColumns" : "all",
"partitionCount" : "4"
},
"primaryMetric" : {
"score" : 306.8187488285714,
"scoreError" : 3.1825881751471488,
"scoreConfidence" : [
303.63616065342427,
310.00133700371856
],
"scorePercentiles" : {
"0.0" : 302.88099957142856,
"50.0" : 306.72107835714286,
"90.0" : 310.59766587142855,
"95.0" : 310.802354,
"99.0" : 310.802354,
"99.9" : 310.802354,
"99.99" : 310.802354,
"99.999" : 310.802354,
"99.9999" : 310.802354,
"100.0" : 310.802354
},
"scoreUnit" : "ms/op",
"rawData" : [
[
306.19340642857145,
305.7513245714286,
307.36280557142857,
307.24875028571427,
308.7554727142857,
305.50111514285715,
310.802354,
302.88099957142856,
307.55542485714284,
306.13583514285716
]
]
},
"secondaryMetrics" : {
"·gc.alloc.rate" : {
"score" : 20.826049318260566,
"scoreError" : 0.17514086434589005,
"scoreConfidence" : [
20.650908453914674,
21.001190182606457
],
"scorePercentiles" : {
"0.0" : 20.608149102728888,
"50.0" : 20.830811596530843,
"90.0" : 21.029086551503994,
"95.0" : 21.04357388350075,
"99.0" : 21.04357388350075,
"99.9" : 21.04357388350075,
"99.99" : 21.04357388350075,
"99.999" : 21.04357388350075,
"99.9999" : 21.04357388350075,
"100.0" : 21.04357388350075
},
"scoreUnit" : "MB/sec",
"rawData" : [
[
20.860396260745947,
20.885156229188308,
20.79547296798176,
20.801226932315735,
20.71879141072626,
20.89870056353319,
20.608149102728888,
21.04357388350075,
20.78596936401948,
20.863056467865327
]
]
},
"·gc.alloc.rate.norm" : {
"score" : 8262132.571428572,
"scoreError" : 4.887060816838359,
"scoreConfidence" : [
8262127.684367755,
8262137.458489388
],
"scorePercentiles" : {
"0.0" : 8262130.285714285,
"50.0" : 8262130.285714285,
"90.0" : 8262138.971428571,
"95.0" : 8262139.428571428,
"99.0" : 8262139.428571428,
"99.9" : 8262139.428571428,
"99.99" : 8262139.428571428,
"99.999" : 8262139.428571428,
"99.9999" : 8262139.428571428,
"100.0" : 8262139.428571428
},
"scoreUnit" : "B/op",
"rawData" : [
[
8262130.285714285,
8262139.428571428,
8262130.285714285,
8262130.285714285,
8262134.857142857,
8262134.857142857,
8262130.285714285,
8262134.857142857,
8262130.285714285,
8262130.285714285
]
]
},
"·gc.count" : {
"score" : 0.0,
"scoreError" : "NaN",
"scoreConfidence" : [
0.0,
0.0
],
"scorePercentiles" : {
"0.0" : 0.0,
"50.0" : 0.0,
"90.0" : 0.0,
"95.0" : 0.0,
"99.0" : 0.0,
"99.9" : 0.0,
"99.99" : 0.0,
"99.999" : 0.0,
"99.9999" : 0.0,
"100.0" : 0.0
},
"scoreUnit" : "counts",
"rawData" : [
[
0.0,
0.0,
0.0,
0.0,
0.0,
0.0,
0.0,
0.0,
0.0,
0.0
]
]
}
}
},
{
"jmhVersion" : "1.20",
"benchmark" : "io.trino.operator.join.BenchmarkHashBuildAndJoinOperators.benchmarkJoinHash",
"mode" : "avgt",
"threads" : 1,
"forks" : 1,
"jvm" : "/local/home/pettja/.sdkman/candidates/java/11.0.12-zulu/bin/java",
"jvmArgs" : [
"-Xms8g",
"-Xmx8g",
"-XX:+AlwaysPreTouch",
"-XX:ReservedCodeCacheSize=256M"
],
"jdkVersion" : "11.0.12",
"vmVersion" : "11.0.12+7-LTS",
"warmupIterations" : 5,
"warmupTime" : "1 s",
"warmupBatchSize" : 1,
"measurementIterations" : 10,
"measurementTime" : "2 s",
"measurementBatchSize" : 1,
"params" : {
"buildHashEnabled" : "true",
"buildRowsRepetition" : "1",
"hashColumns" : "bigint",
"matchRate" : "1",
"outputColumns" : "all",
"partitionCount" : "4"
},
"primaryMetric" : {
"score" : 402.9594135766667,
"scoreError" : 3.643421293537115,
"scoreConfidence" : [
399.31599228312956,
406.6028348702038
],
"scorePercentiles" : {
"0.0" : 399.32649016666664,
"50.0" : 402.4940026,
"90.0" : 407.93479856,
"95.0" : 408.3342296,
"99.0" : 408.3342296,
"99.9" : 408.3342296,
"99.99" : 408.3342296,
"99.999" : 408.3342296,
"99.9999" : 408.3342296,
"100.0" : 408.3342296
},
"scoreUnit" : "ms/op",
"rawData" : [
[
401.6356058,
408.3342296,
401.0238194,
403.8882542,
402.6357678,
399.32649016666664,
404.3399192,
402.1830108,
402.3522374,
403.8748014
]
]
},
"secondaryMetrics" : {
"·gc.alloc.rate" : {
"score" : 111.59894346012004,
"scoreError" : 2.3777884924980572,
"scoreConfidence" : [
109.22115496762198,
113.9767319526181
],
"scorePercentiles" : {
"0.0" : 110.03451511689492,
"50.0" : 111.3100581550089,
"90.0" : 115.46426809783634,
"95.0" : 115.88957942618075,
"99.0" : 115.88957942618075,
"99.9" : 115.88957942618075,
"99.99" : 115.88957942618075,
"99.999" : 115.88957942618075,
"99.9999" : 115.88957942618075,
"100.0" : 115.88957942618075
},
"scoreUnit" : "MB/sec",
"rawData" : [
[
111.50545491563317,
110.03451511689492,
111.63646614273671,
111.00529873152453,
111.28327294585974,
115.88957942618075,
110.90609899560819,
111.38226662241986,
111.33684336415809,
111.00963834018438
]
]
},
"·gc.alloc.rate.norm" : {
"score" : 5.866536205333333E7,
"scoreError" : 35.54743927981478,
"scoreConfidence" : [
5.866532650589405E7,
5.8665397600772604E7
],
"scorePercentiles" : {
"0.0" : 5.8665345333333336E7,
"50.0" : 5.86653536E7,
"90.0" : 5.8665421120000005E7,
"95.0" : 5.86654272E7,
"99.0" : 5.86654272E7,
"99.9" : 5.86654272E7,
"99.99" : 5.86654272E7,
"99.999" : 5.86654272E7,
"99.9999" : 5.86654272E7,
"100.0" : 5.86654272E7
},
"scoreUnit" : "B/op",
"rawData" : [
[
5.86654272E7,
5.866536E7,
5.86653536E7,
5.86653536E7,
5.86653536E7,
5.8665345333333336E7,
5.86653536E7,
5.86653664E7,
5.86653536E7,
5.86653536E7
]
]
},
"·gc.churn.G1_Eden_Space" : {
"score" : 46.4150807336362,
"scoreError" : 221.90644365645443,
"scoreConfidence" : [
-175.4913629228182,
268.32152439009064
],
"scorePercentiles" : {
"0.0" : 0.0,
"50.0" : 0.0,
"90.0" : 417.73572660272595,
"95.0" : 464.150807336362,
"99.0" : 464.150807336362,
"99.9" : 464.150807336362,
"99.99" : 464.150807336362,
"99.999" : 464.150807336362,
"99.9999" : 464.150807336362,
"100.0" : 464.150807336362
},
"scoreUnit" : "MB/sec",
"rawData" : [
[
464.150807336362
]
]
},
"·gc.churn.G1_Eden_Space.norm" : {
"score" : 2.47463936E7,
"scoreError" : 1.1831034461864749E8,
"scoreConfidence" : [
-9.356395101864749E7,
1.4305673821864748E8
],
"scorePercentiles" : {
"0.0" : 0.0,
"50.0" : 0.0,
"90.0" : 2.227175424000001E8,
"95.0" : 2.47463936E8,
"99.0" : 2.47463936E8,
"99.9" : 2.47463936E8,
"99.99" : 2.47463936E8,
"99.999" : 2.47463936E8,
"99.9999" : 2.47463936E8,
"100.0" : 2.47463936E8
},
"scoreUnit" : "B/op",
"rawData" : [
[
2.47463936E8
]
]
},
"·gc.churn.G1_Old_Gen" : {
"score" : 0.03418568437667739,
"scoreError" : 0.16343876869512886,
"scoreConfidence" : [
-0.12925308431845145,
0.19762445307180626
],
"scorePercentiles" : {
"0.0" : 0.0,
"50.0" : 0.0,
"90.0" : 0.30767115939009665,
"95.0" : 0.34185684376677394,
"99.0" : 0.34185684376677394,
"99.9" : 0.34185684376677394,
"99.99" : 0.34185684376677394,
"99.999" : 0.34185684376677394,
"99.9999" : 0.34185684376677394,
"100.0" : 0.34185684376677394
},
"scoreUnit" : "MB/sec",
"rawData" : [
[
0.34185684376677394
]
]
},
"·gc.churn.G1_Old_Gen.norm" : {
"score" : 18226.239999999998,
"scoreError" : 87138.06021020285,
"scoreConfidence" : [
-68911.82021020286,
105364.30021020284
],
"scorePercentiles" : {
"0.0" : 0.0,
"50.0" : 0.0,
"90.0" : 164036.16000000006,
"95.0" : 182262.4,
"99.0" : 182262.4,
"99.9" : 182262.4,
"99.99" : 182262.4,
"99.999" : 182262.4,
"99.9999" : 182262.4,
"100.0" : 182262.4
},
"scoreUnit" : "B/op",
"rawData" : [
[
182262.4
]
]
},
"·gc.count" : {
"score" : 1.0,
"scoreError" : "NaN",
"scoreConfidence" : [
1.0,
1.0
],
"scorePercentiles" : {
"0.0" : 0.0,
"50.0" : 0.0,
"90.0" : 0.9000000000000004,
"95.0" : 1.0,
"99.0" : 1.0,
"99.9" : 1.0,
"99.99" : 1.0,
"99.999" : 1.0,
"99.9999" : 1.0,
"100.0" : 1.0
},
"scoreUnit" : "counts",
"rawData" : [
[
0.0,
1.0,
0.0,
0.0,
0.0,
0.0,
0.0,
0.0,
0.0,
0.0
]
]
},
"·gc.time" : {
"score" : 5.0,
"scoreError" : "NaN",
"scoreConfidence" : [
5.0,
5.0
],
"scorePercentiles" : {
"0.0" : 0.0,
"50.0" : 0.0,
"90.0" : 4.500000000000002,
"95.0" : 5.0,
"99.0" : 5.0,
"99.9" : 5.0,
"99.99" : 5.0,
"99.999" : 5.0,
"99.9999" : 5.0,
"100.0" : 5.0
},
"scoreUnit" : "ms",
"rawData" : [
[
5.0
]
]
}
}
},
{
"jmhVersion" : "1.20",
"benchmark" : "io.trino.operator.join.BenchmarkHashBuildAndJoinOperators.benchmarkJoinHash",
"mode" : "avgt",
"threads" : 1,
"forks" : 1,
"jvm" : "/local/home/pettja/.sdkman/candidates/java/11.0.12-zulu/bin/java",
"jvmArgs" : [
"-Xms8g",
"-Xmx8g",
"-XX:+AlwaysPreTouch",
"-XX:ReservedCodeCacheSize=256M"
],
"jdkVersion" : "11.0.12",
"vmVersion" : "11.0.12+7-LTS",
"warmupIterations" : 5,
"warmupTime" : "1 s",
"warmupBatchSize" : 1,
"measurementIterations" : 10,
"measurementTime" : "2 s",
"measurementBatchSize" : 1,
"params" : {
"buildHashEnabled" : "true",
"buildRowsRepetition" : "1",
"hashColumns" : "bigint",
"matchRate" : "2",
"outputColumns" : "all",
"partitionCount" : "4"
},
"primaryMetric" : {
"score" : 344.91089143333335,
"scoreError" : 3.4382383885380388,
"scoreConfidence" : [
341.4726530447953,
348.3491298218714
],
"scorePercentiles" : {
"0.0" : 341.63344616666666,
"50.0" : 345.01353416666666,
"90.0" : 349.4128524833333,
"95.0" : 349.7131928333333,
"99.0" : 349.7131928333333,
"99.9" : 349.7131928333333,
"99.99" : 349.7131928333333,
"99.999" : 349.7131928333333,
"99.9999" : 349.7131928333333,
"100.0" : 349.7131928333333
},
"scoreUnit" : "ms/op",
"rawData" : [
[
349.7131928333333,
346.70978933333333,
345.40468883333335,
342.34174583333333,
345.51622383333336,
345.11389,
341.63344616666666,
344.14173616666665,
344.91317833333335,
343.621023
]
]
},
"secondaryMetrics" : {
"·gc.alloc.rate" : {
"score" : 130.48979646947618,
"scoreError" : 1.0485460047821231,
"scoreConfidence" : [
129.44125046469406,
131.5383424742583
],
"scorePercentiles" : {
"0.0" : 129.03632775888397,
"50.0" : 130.4561554856847,
"90.0" : 131.47990178549557,
"95.0" : 131.50264926009862,
"99.0" : 131.50264926009862,
"99.9" : 131.50264926009862,
"99.99" : 131.50264926009862,
"99.999" : 131.50264926009862,
"99.9999" : 131.50264926009862,
"100.0" : 131.50264926009862
},
"scoreUnit" : "MB/sec",
"rawData" : [
[
129.03632775888397,
129.93665608796664,
130.3332976876868,
131.27517451406806,
130.30093840093446,
130.43062791746573,
131.50264926009862,
130.72513654922707,
130.48168305390365,
130.87547346452655
]
]
},
"·gc.alloc.rate.norm" : {
"score" : 5.861064586666666E7,
"scoreError" : 30.64796955510904,
"scoreConfidence" : [
5.861061521869711E7,
5.861067651463621E7
],
"scorePercentiles" : {
"0.0" : 5.8610636E7,
"50.0" : 5.8610641333333336E7,
"90.0" : 5.861069706666666E7,
"95.0" : 5.8610702666666664E7,
"99.0" : 5.8610702666666664E7,
"99.9" : 5.8610702666666664E7,
"99.99" : 5.8610702666666664E7,
"99.999" : 5.8610702666666664E7,
"99.9999" : 5.8610702666666664E7,
"100.0" : 5.8610702666666664E7
},
"scoreUnit" : "B/op",
"rawData" : [
[
5.8610702666666664E7,
5.8610641333333336E7,
5.8610641333333336E7,
5.8610636E7,
5.8610646666666664E7,
5.8610636E7,
5.8610636E7,
5.8610636E7,
5.8610641333333336E7,
5.8610641333333336E7
]
]
},
"·gc.churn.G1_Eden_Space" : {
"score" : 44.16981882674189,
"scoreError" : 211.17204274707157,
"scoreConfidence" : [
-167.0022239203297,
255.34186157381345
],
"scorePercentiles" : {
"0.0" : 0.0,
"50.0" : 0.0,
"90.0" : 397.5283694406771,
"95.0" : 441.69818826741886,
"99.0" : 441.69818826741886,
"99.9" : 441.69818826741886,
"99.99" : 441.69818826741886,
"99.999" : 441.69818826741886,
"99.9999" : 441.69818826741886,
"100.0" : 441.69818826741886
},
"scoreUnit" : "MB/sec",
"rawData" : [
[
441.69818826741886
]
]
},
"·gc.churn.G1_Eden_Space.norm" : {
"score" : 2.0062754133333333E7,
"scoreError" : 9.591827374449672E7,
"scoreConfidence" : [
-7.585551961116338E7,
1.1598102787783006E8
],
"scorePercentiles" : {
"0.0" : 0.0,
"50.0" : 0.0,
"90.0" : 1.8056478720000008E8,
"95.0" : 2.0062754133333334E8,
"99.0" : 2.0062754133333334E8,
"99.9" : 2.0062754133333334E8,
"99.99" : 2.0062754133333334E8,
"99.999" : 2.0062754133333334E8,
"99.9999" : 2.0062754133333334E8,
"100.0" : 2.0062754133333334E8
},
"scoreUnit" : "B/op",
"rawData" : [
[
2.0062754133333334E8
]
]
},
"·gc.churn.G1_Old_Gen" : {
"score" : 0.013119086441709596,
"scoreError" : 0.06272120548508889,
"scoreConfidence" : [
-0.04960211904337929,
0.07584029192679849
],
"scorePercentiles" : {
"0.0" : 0.0,
"50.0" : 0.0,
"90.0" : 0.11807177797538641,
"95.0" : 0.13119086441709596,
"99.0" : 0.13119086441709596,
"99.9" : 0.13119086441709596,
"99.99" : 0.13119086441709596,
"99.999" : 0.13119086441709596,
"99.9999" : 0.13119086441709596,
"100.0" : 0.13119086441709596
},
"scoreUnit" : "MB/sec",
"rawData" : [
[
0.13119086441709596
]
]
},
"·gc.churn.G1_Old_Gen.norm" : {
"score" : 5958.933333333333,
"scoreError" : 28489.13937205835,
"scoreConfidence" : [
-22530.206038725017,
34448.072705391685
],
"scorePercentiles" : {
"0.0" : 0.0,
"50.0" : 0.0,
"90.0" : 53630.40000000002,
"95.0" : 59589.333333333336,
"99.0" : 59589.333333333336,
"99.9" : 59589.333333333336,
"99.99" : 59589.333333333336,
"99.999" : 59589.333333333336,
"99.9999" : 59589.333333333336,
"100.0" : 59589.333333333336
},
"scoreUnit" : "B/op",
"rawData" : [
[
59589.333333333336
]
]
},
"·gc.count" : {
"score" : 1.0,
"scoreError" : "NaN",
"scoreConfidence" : [
1.0,
1.0
],
"scorePercentiles" : {
"0.0" : 0.0,
"50.0" : 0.0,
"90.0" : 0.9000000000000004,
"95.0" : 1.0,
"99.0" : 1.0,
"99.9" : 1.0,
"99.99" : 1.0,
"99.999" : 1.0,
"99.9999" : 1.0,
"100.0" : 1.0
},
"scoreUnit" : "counts",
"rawData" : [
[
1.0,
0.0,
0.0,
0.0,
0.0,
0.0,
0.0,
0.0,
0.0,
0.0
]
]
},
"·gc.time" : {
"score" : 5.0,
"scoreError" : "NaN",
"scoreConfidence" : [
5.0,
5.0
],
"scorePercentiles" : {
"0.0" : 0.0,
"50.0" : 0.0,
"90.0" : 4.500000000000002,
"95.0" : 5.0,
"99.0" : 5.0,
"99.9" : 5.0,
"99.99" : 5.0,
"99.999" : 5.0,
"99.9999" : 5.0,
"100.0" : 5.0
},
"scoreUnit" : "ms",
"rawData" : [
[
5.0
]
]
}
}
},
{
"jmhVersion" : "1.20",
"benchmark" : "io.trino.operator.join.BenchmarkHashBuildAndJoinOperators.benchmarkJoinHash",
"mode" : "avgt",
"threads" : 1,
"forks" : 1,
"jvm" : "/local/home/pettja/.sdkman/candidates/java/11.0.12-zulu/bin/java",
"jvmArgs" : [
"-Xms8g",
"-Xmx8g",
"-XX:+AlwaysPreTouch",
"-XX:ReservedCodeCacheSize=256M"
],
"jdkVersion" : "11.0.12",
"vmVersion" : "11.0.12+7-LTS",
"warmupIterations" : 5,
"warmupTime" : "1 s",
"warmupBatchSize" : 1,
"measurementIterations" : 10,
"measurementTime" : "2 s",
"measurementBatchSize" : 1,
"params" : {
"buildHashEnabled" : "true",
"buildRowsRepetition" : "1",
"hashColumns" : "all",
"matchRate" : "0.1",
"outputColumns" : "all",
"partitionCount" : "4"
},
"primaryMetric" : {
"score" : 314.75481522857143,
"scoreError" : 2.1287530217122717,
"scoreConfidence" : [
312.62606220685916,
316.8835682502837
],
"scorePercentiles" : {
"0.0" : 313.1950377142857,
"50.0" : 314.4156465,
"90.0" : 317.6731191571429,
"95.0" : 317.87741785714286,
"99.0" : 317.87741785714286,
"99.9" : 317.87741785714286,
"99.99" : 317.87741785714286,
"99.999" : 317.87741785714286,
"99.9999" : 317.87741785714286,
"100.0" : 317.87741785714286
},
"scoreUnit" : "ms/op",
"rawData" : [
[
315.8344308571429,
317.87741785714286,
314.30529914285717,
314.40992857142857,
313.262612,
314.42136442857145,
313.7756875714286,
314.77559414285713,
315.69078,
313.1950377142857
]
]
},
"secondaryMetrics" : {
"·gc.alloc.rate" : {
"score" : 20.318303629478798,
"scoreError" : 0.11150999681151884,
"scoreConfidence" : [
20.206793632667278,
20.42981362629032
],
"scorePercentiles" : {
"0.0" : 20.155495318613607,
"50.0" : 20.33615347604509,
"90.0" : 20.399866317585037,
"95.0" : 20.400223139116807,
"99.0" : 20.400223139116807,
"99.9" : 20.400223139116807,
"99.99" : 20.400223139116807,
"99.999" : 20.400223139116807,
"99.9999" : 20.400223139116807,
"100.0" : 20.400223139116807
},
"scoreUnit" : "MB/sec",
"rawData" : [
[
20.260234228096433,
20.155495318613607,
20.341257424160244,
20.336360513381152,
20.3966549237991,
20.335946438709026,
20.370198702388404,
20.317082416825844,
20.26958318969737,
20.400223139116807
]
]
},
"·gc.alloc.rate.norm" : {
"score" : 8229654.4,
"scoreError" : 3.9232003358478535,
"scoreConfidence" : [
8229650.476799664,
8229658.323200337
],
"scorePercentiles" : {
"0.0" : 8229650.285714285,
"50.0" : 8229654.857142857,
"90.0" : 8229658.971428571,
"95.0" : 8229659.428571428,
"99.0" : 8229659.428571428,
"99.9" : 8229659.428571428,
"99.99" : 8229659.428571428,
"99.999" : 8229659.428571428,
"99.9999" : 8229659.428571428,
"100.0" : 8229659.428571428
},
"scoreUnit" : "B/op",
"rawData" : [
[
8229654.857142857,
8229654.857142857,
8229654.857142857,
8229650.285714285,
8229659.428571428,
8229654.857142857,
8229654.857142857,
8229654.857142857,
8229654.857142857,
8229650.285714285
]
]
},
"·gc.count" : {
"score" : 0.0,
"scoreError" : "NaN",
"scoreConfidence" : [
0.0,
0.0
],
"scorePercentiles" : {
"0.0" : 0.0,
"50.0" : 0.0,
"90.0" : 0.0,
"95.0" : 0.0,
"99.0" : 0.0,
"99.9" : 0.0,
"99.99" : 0.0,
"99.999" : 0.0,
"99.9999" : 0.0,
"100.0" : 0.0
},
"scoreUnit" : "counts",
"rawData" : [
[
0.0,
0.0,
0.0,
0.0,
0.0,
0.0,
0.0,
0.0,
0.0,
0.0
]
]
}
}
},
{
"jmhVersion" : "1.20",
"benchmark" : "io.trino.operator.join.BenchmarkHashBuildAndJoinOperators.benchmarkJoinHash",
"mode" : "avgt",
"threads" : 1,
"forks" : 1,
"jvm" : "/local/home/pettja/.sdkman/candidates/java/11.0.12-zulu/bin/java",
"jvmArgs" : [
"-Xms8g",
"-Xmx8g",
"-XX:+AlwaysPreTouch",
"-XX:ReservedCodeCacheSize=256M"
],
"jdkVersion" : "11.0.12",
"vmVersion" : "11.0.12+7-LTS",
"warmupIterations" : 5,
"warmupTime" : "1 s",
"warmupBatchSize" : 1,
"measurementIterations" : 10,
"measurementTime" : "2 s",
"measurementBatchSize" : 1,
"params" : {
"buildHashEnabled" : "true",
"buildRowsRepetition" : "1",
"hashColumns" : "all",
"matchRate" : "1",
"outputColumns" : "all",
"partitionCount" : "4"
},
"primaryMetric" : {
"score" : 481.5752271200001,
"scoreError" : 1.848508630016451,
"scoreConfidence" : [
479.7267184899836,
483.42373575001653
],
"scorePercentiles" : {
"0.0" : 479.9106868,
"50.0" : 481.3452389,
"90.0" : 483.50833666,
"95.0" : 483.5355726,
"99.0" : 483.5355726,
"99.9" : 483.5355726,
"99.99" : 483.5355726,
"99.999" : 483.5355726,
"99.9999" : 483.5355726,
"100.0" : 483.5355726
},
"scoreUnit" : "ms/op",
"rawData" : [
[
481.3643052,
482.2013608,
483.5355726,
479.9779788,
482.1176822,
481.3261726,
483.2632132,
480.8731538,
479.9106868,
481.1821452
]
]
},
"secondaryMetrics" : {
"·gc.alloc.rate" : {
"score" : 96.21514329228435,
"scoreError" : 0.30590725726041007,
"scoreConfidence" : [
95.90923603502394,
96.52105054954477
],
"scorePercentiles" : {
"0.0" : 95.89240308772045,
"50.0" : 96.25256353553978,
"90.0" : 96.48981952388527,
"95.0" : 96.49104954575648,
"99.0" : 96.49104954575648,
"99.9" : 96.49104954575648,
"99.99" : 96.49104954575648,
"99.999" : 96.49104954575648,
"99.9999" : 96.49104954575648,
"100.0" : 96.49104954575648
},
"scoreUnit" : "MB/sec",
"rawData" : [
[
96.24988858342138,
96.11017306782612,
95.89240308772045,
96.47874932704443,
96.1261763410571,
96.25523848765818,
95.9346267229582,
96.33432375060063,
96.49104954575648,
96.27880400880056
]
]
},
"·gc.alloc.rate.norm" : {
"score" : 5.86876048E7,
"scoreError" : 36.862320784732084,
"scoreConfidence" : [
5.868756793767921E7,
5.8687641662320785E7
],
"scorePercentiles" : {
"0.0" : 5.86875936E7,
"50.0" : 5.86876E7,
"90.0" : 5.868766624E7,
"95.0" : 5.86876736E7,
"99.0" : 5.86876736E7,
"99.9" : 5.86876736E7,
"99.99" : 5.86876736E7,
"99.999" : 5.86876736E7,
"99.9999" : 5.86876736E7,
"100.0" : 5.86876736E7
},
"scoreUnit" : "B/op",
"rawData" : [
[
5.86876736E7,
5.86876E7,
5.86876E7,
5.86875936E7,
5.86876E7,
5.86875936E7,
5.86876E7,
5.86876E7,
5.86875936E7,
5.86875936E7
]
]
},
"·gc.churn.G1_Eden_Space" : {
"score" : 43.44972330762168,
"scoreError" : 207.72932901663708,
"scoreConfidence" : [
-164.2796057090154,
251.17905232425875
],
"scorePercentiles" : {
"0.0" : 0.0,
"50.0" : 0.0,
"90.0" : 391.0475097685953,
"95.0" : 434.49723307621684,
"99.0" : 434.49723307621684,
"99.9" : 434.49723307621684,
"99.99" : 434.49723307621684,
"99.999" : 434.49723307621684,
"99.9999" : 434.49723307621684,
"100.0" : 434.49723307621684
},
"scoreUnit" : "MB/sec",
"rawData" : [
[
434.49723307621684
]
]
},
"·gc.churn.G1_Eden_Space.norm" : {
"score" : 2.659188736E7,
"scoreError" : 1.2713348896308903E8,
"scoreConfidence" : [
-1.0054160160308903E8,
1.5372537632308903E8
],
"scorePercentiles" : {
"0.0" : 0.0,
"50.0" : 0.0,
"90.0" : 2.393269862400001E8,
"95.0" : 2.659188736E8,
"99.0" : 2.659188736E8,
"99.9" : 2.659188736E8,
"99.99" : 2.659188736E8,
"99.999" : 2.659188736E8,
"99.9999" : 2.659188736E8,
"100.0" : 2.659188736E8
},
"scoreUnit" : "B/op",
"rawData" : [
[
2.659188736E8
]
]
},
"·gc.count" : {
"score" : 1.0,
"scoreError" : "NaN",
"scoreConfidence" : [
1.0,
1.0
],
"scorePercentiles" : {
"0.0" : 0.0,
"50.0" : 0.0,
"90.0" : 0.9000000000000004,
"95.0" : 1.0,
"99.0" : 1.0,
"99.9" : 1.0,
"99.99" : 1.0,
"99.999" : 1.0,
"99.9999" : 1.0,
"100.0" : 1.0
},
"scoreUnit" : "counts",
"rawData" : [
[
0.0,
0.0,
1.0,
0.0,
0.0,
0.0,
0.0,
0.0,
0.0,
0.0
]
]
},
"·gc.time" : {
"score" : 5.0,
"scoreError" : "NaN",
"scoreConfidence" : [
5.0,
5.0
],
"scorePercentiles" : {
"0.0" : 0.0,
"50.0" : 0.0,
"90.0" : 4.500000000000002,
"95.0" : 5.0,
"99.0" : 5.0,
"99.9" : 5.0,
"99.99" : 5.0,
"99.999" : 5.0,
"99.9999" : 5.0,
"100.0" : 5.0
},
"scoreUnit" : "ms",
"rawData" : [
[
5.0
]
]
}
}
},
{
"jmhVersion" : "1.20",
"benchmark" : "io.trino.operator.join.BenchmarkHashBuildAndJoinOperators.benchmarkJoinHash",
"mode" : "avgt",
"threads" : 1,
"forks" : 1,
"jvm" : "/local/home/pettja/.sdkman/candidates/java/11.0.12-zulu/bin/java",
"jvmArgs" : [
"-Xms8g",
"-Xmx8g",
"-XX:+AlwaysPreTouch",
"-XX:ReservedCodeCacheSize=256M"
],
"jdkVersion" : "11.0.12",
"vmVersion" : "11.0.12+7-LTS",
"warmupIterations" : 5,
"warmupTime" : "1 s",
"warmupBatchSize" : 1,
"measurementIterations" : 10,
"measurementTime" : "2 s",
"measurementBatchSize" : 1,
"params" : {
"buildHashEnabled" : "true",
"buildRowsRepetition" : "1",
"hashColumns" : "all",
"matchRate" : "2",
"outputColumns" : "all",
"partitionCount" : "4"
},
"primaryMetric" : {
"score" : 392.85153049999997,
"scoreError" : 2.6279357071158183,
"scoreConfidence" : [
390.22359479288417,
395.47946620711576
],
"scorePercentiles" : {
"0.0" : 390.34310016666666,
"50.0" : 393.07878658333334,
"90.0" : 395.2932876666667,
"95.0" : 395.35765833333335,
"99.0" : 395.35765833333335,
"99.9" : 395.35765833333335,
"99.99" : 395.35765833333335,
"99.999" : 395.35765833333335,
"99.9999" : 395.35765833333335,
"100.0" : 395.35765833333335
},
"scoreUnit" : "ms/op",
"rawData" : [
[
394.7139516666667,
394.2359813333333,
391.2386211666667,
395.35765833333335,
392.7155255,
393.3934086666667,
390.359485,
390.34310016666666,
393.1386785,
393.01889466666665
]
]
},
"secondaryMetrics" : {
"·gc.alloc.rate" : {
"score" : 117.50908839623898,
"scoreError" : 0.6517161211667931,
"scoreConfidence" : [
116.85737227507218,
118.16080451740578
],
"scorePercentiles" : {
"0.0" : 116.89462433359647,
"50.0" : 117.44861349489611,
"90.0" : 118.13359506942724,
"95.0" : 118.13377620794063,
"99.0" : 118.13377620794063,
"99.9" : 118.13377620794063,
"99.99" : 118.13377620794063,
"99.999" : 118.13377620794063,
"99.9999" : 118.13377620794063,
"100.0" : 118.13377620794063
},
"scoreUnit" : "MB/sec",
"rawData" : [
[
117.04270161163733,
117.16713929900529,
117.9054272544871,
116.89462433359647,
117.53740263520737,
117.38062080791663,
118.13377620794063,
118.1319648228068,
117.4333705572524,
117.4638564325398
]
]
},
"·gc.alloc.rate.norm" : {
"score" : 5.8687605333333336E7,
"scoreError" : 30.952873640844118,
"scoreConfidence" : [
5.8687574380459696E7,
5.8687636286206976E7
],
"scorePercentiles" : {
"0.0" : 5.8687596E7,
"50.0" : 5.868759866666667E7,
"90.0" : 5.868765706666666E7,
"95.0" : 5.8687662666666664E7,
"99.0" : 5.8687662666666664E7,
"99.9" : 5.8687662666666664E7,
"99.99" : 5.8687662666666664E7,
"99.999" : 5.8687662666666664E7,
"99.9999" : 5.8687662666666664E7,
"100.0" : 5.8687662666666664E7
},
"scoreUnit" : "B/op",
"rawData" : [
[
5.8687662666666664E7,
5.8687601333333336E7,
5.8687596E7,
5.8687601333333336E7,
5.8687596E7,
5.8687606666666664E7,
5.8687596E7,
5.8687596E7,
5.8687601333333336E7,
5.8687596E7
]
]
},
"·gc.churn.G1_Eden_Space" : {
"score" : 44.97377643319568,
"scoreError" : 215.01569378632163,
"scoreConfidence" : [
-170.04191735312594,
259.98947021951733
],
"scorePercentiles" : {
"0.0" : 0.0,
"50.0" : 0.0,
"90.0" : 404.76398789876134,
"95.0" : 449.73776433195684,
"99.0" : 449.73776433195684,
"99.9" : 449.73776433195684,
"99.99" : 449.73776433195684,
"99.999" : 449.73776433195684,
"99.9999" : 449.73776433195684,
"100.0" : 449.73776433195684
},
"scoreUnit" : "MB/sec",
"rawData" : [
[
449.73776433195684
]
]
},
"·gc.churn.G1_Eden_Space.norm" : {
"score" : 2.2579336533333335E7,
"scoreError" : 1.0794983421418966E8,
"scoreConfidence" : [
-8.537049768085633E7,
1.30529170747523E8
],
"scorePercentiles" : {
"0.0" : 0.0,
"50.0" : 0.0,
"90.0" : 2.032140288000001E8,
"95.0" : 2.2579336533333334E8,
"99.0" : 2.2579336533333334E8,
"99.9" : 2.2579336533333334E8,
"99.99" : 2.2579336533333334E8,
"99.999" : 2.2579336533333334E8,
"99.9999" : 2.2579336533333334E8,
"100.0" : 2.2579336533333334E8
},
"scoreUnit" : "B/op",
"rawData" : [
[
2.2579336533333334E8
]
]
},
"·gc.churn.G1_Survivor_Space" : {
"score" : 0.13923769793559035,
"scoreError" : 0.6656832624963519,
"scoreConfidence" : [
-0.5264455645607615,
0.8049209604319423
],
"scorePercentiles" : {
"0.0" : 0.0,
"50.0" : 0.0,
"90.0" : 1.2531392814203137,
"95.0" : 1.3923769793559035,
"99.0" : 1.3923769793559035,
"99.9" : 1.3923769793559035,
"99.99" : 1.3923769793559035,
"99.999" : 1.3923769793559035,
"99.9999" : 1.3923769793559035,
"100.0" : 1.3923769793559035
},
"scoreUnit" : "MB/sec",
"rawData" : [
[
1.3923769793559035
]
]
},
"·gc.churn.G1_Survivor_Space.norm" : {
"score" : 69905.06666666667,
"scoreError" : 334210.01304702676,
"scoreConfidence" : [
-264304.9463803601,
404115.0797136934
],
"scorePercentiles" : {
"0.0" : 0.0,
"50.0" : 0.0,
"90.0" : 629145.6000000002,
"95.0" : 699050.6666666666,
"99.0" : 699050.6666666666,
"99.9" : 699050.6666666666,
"99.99" : 699050.6666666666,
"99.999" : 699050.6666666666,
"99.9999" : 699050.6666666666,
"100.0" : 699050.6666666666
},
"scoreUnit" : "B/op",
"rawData" : [
[
699050.6666666666
]
]
},
"·gc.count" : {
"score" : 1.0,
"scoreError" : "NaN",
"scoreConfidence" : [
1.0,
1.0
],
"scorePercentiles" : {
"0.0" : 0.0,
"50.0" : 0.0,
"90.0" : 0.9000000000000004,
"95.0" : 1.0,
"99.0" : 1.0,
"99.9" : 1.0,
"99.99" : 1.0,
"99.999" : 1.0,
"99.9999" : 1.0,
"100.0" : 1.0
},
"scoreUnit" : "counts",
"rawData" : [
[
0.0,
0.0,
0.0,
1.0,
0.0,
0.0,
0.0,
0.0,
0.0,
0.0
]
]
},
"·gc.time" : {
"score" : 4.0,
"scoreError" : "NaN",
"scoreConfidence" : [
4.0,
4.0
],
"scorePercentiles" : {
"0.0" : 0.0,
"50.0" : 0.0,
"90.0" : 3.6000000000000014,
"95.0" : 4.0,
"99.0" : 4.0,
"99.9" : 4.0,
"99.99" : 4.0,
"99.999" : 4.0,
"99.9999" : 4.0,
"100.0" : 4.0
},
"scoreUnit" : "ms",
"rawData" : [
[
4.0
]
]
}
}
},
{
"jmhVersion" : "1.20",
"benchmark" : "io.trino.operator.join.BenchmarkHashBuildAndJoinOperators.benchmarkJoinHash",
"mode" : "avgt",
"threads" : 1,
"forks" : 1,
"jvm" : "/local/home/pettja/.sdkman/candidates/java/11.0.12-zulu/bin/java",
"jvmArgs" : [
"-Xms8g",
"-Xmx8g",
"-XX:+AlwaysPreTouch",
"-XX:ReservedCodeCacheSize=256M"
],
"jdkVersion" : "11.0.12",
"vmVersion" : "11.0.12+7-LTS",
"warmupIterations" : 5,
"warmupTime" : "1 s",
"warmupBatchSize" : 1,
"measurementIterations" : 10,
"measurementTime" : "2 s",
"measurementBatchSize" : 1,
"params" : {
"buildHashEnabled" : "true",
"buildRowsRepetition" : "5",
"hashColumns" : "bigint",
"matchRate" : "0.1",
"outputColumns" : "all",
"partitionCount" : "4"
},
"primaryMetric" : {
"score" : 446.180051,
"scoreError" : 4.1583016600978135,
"scoreConfidence" : [
442.02174933990216,
450.3383526600978
],
"scorePercentiles" : {
"0.0" : 441.1521568,
"50.0" : 447.24694999999997,
"90.0" : 450.3595639,
"95.0" : 450.6776278,
"99.0" : 450.6776278,
"99.9" : 450.6776278,
"99.99" : 450.6776278,
"99.999" : 450.6776278,
"99.9999" : 450.6776278,
"100.0" : 450.6776278
},
"scoreUnit" : "ms/op",
"rawData" : [
[
447.1878396,
450.6776278,
442.3770382,
447.3060604,
447.4264724,
447.3339364,
445.5941102,
447.4969888,
441.1521568,
445.2482794
]
]
},
"secondaryMetrics" : {
"·gc.alloc.rate" : {
"score" : 55.90809633836675,
"scoreError" : 0.42552737512727695,
"scoreConfidence" : [
55.48256896323947,
56.33362371349402
],
"scorePercentiles" : {
"0.0" : 55.45341564672854,
"50.0" : 55.797124142509034,
"90.0" : 56.4132544375439,
"95.0" : 56.426002863907485,
"99.0" : 56.426002863907485,
"99.9" : 56.426002863907485,
"99.99" : 56.426002863907485,
"99.999" : 56.426002863907485,
"99.9999" : 56.426002863907485,
"100.0" : 56.426002863907485
},
"scoreUnit" : "MB/sec",
"rawData" : [
[
55.802780807566634,
55.45341564672854,
56.298518600271585,
55.79146747745144,
55.778168081239414,
55.789188442817675,
55.966522092017016,
55.77429896500951,
56.426002863907485,
56.000600406658066
]
]
},
"·gc.alloc.rate.norm" : {
"score" : 3.20267224E7,
"scoreError" : 35.75662389925763,
"scoreConfidence" : [
3.20266866433761E7,
3.2026758156623896E7
],
"scorePercentiles" : {
"0.0" : 3.20267056E7,
"50.0" : 3.2026712E7,
"90.0" : 3.202678064E7,
"95.0" : 3.20267856E7,
"99.0" : 3.20267856E7,
"99.9" : 3.20267856E7,
"99.99" : 3.20267856E7,
"99.999" : 3.20267856E7,
"99.9999" : 3.20267856E7,
"100.0" : 3.20267856E7
},
"scoreUnit" : "B/op",
"rawData" : [
[
3.20267856E7,
3.2026712E7,
3.20267184E7,
3.2026712E7,
3.2026712E7,
3.20267184E7,
3.2026712E7,
3.2026712E7,
3.20267056E7,
3.2026736E7
]
]
},
"·gc.churn.G1_Eden_Space" : {
"score" : 44.422304682773266,
"scoreError" : 212.37915555394164,
"scoreConfidence" : [
-167.95685087116837,
256.8014602367149
],
"scorePercentiles" : {
"0.0" : 0.0,
"50.0" : 0.0,
"90.0" : 399.80074214495954,
"95.0" : 444.2230468277327,
"99.0" : 444.2230468277327,
"99.9" : 444.2230468277327,
"99.99" : 444.2230468277327,
"99.999" : 444.2230468277327,
"99.9999" : 444.2230468277327,
"100.0" : 444.2230468277327
},
"scoreUnit" : "MB/sec",
"rawData" : [
[
444.2230468277327
]
]
},
"·gc.churn.G1_Eden_Space.norm" : {
"score" : 2.550136832E7,
"scoreError" : 1.2191981275955535E8,
"scoreConfidence" : [
-9.641844443955535E7,
1.4742118107955536E8
],
"scorePercentiles" : {
"0.0" : 0.0,
"50.0" : 0.0,
"90.0" : 2.2951231488000008E8,
"95.0" : 2.550136832E8,
"99.0" : 2.550136832E8,
"99.9" : 2.550136832E8,
"99.99" : 2.550136832E8,
"99.999" : 2.550136832E8,
"99.9999" : 2.550136832E8,
"100.0" : 2.550136832E8
},
"scoreUnit" : "B/op",
"rawData" : [
[
2.550136832E8
]
]
},
"·gc.churn.G1_Old_Gen" : {
"score" : 0.012804364527095536,
"scoreError" : 0.06121654752244216,
"scoreConfidence" : [
-0.04841218299534662,
0.0740209120495377
],
"scorePercentiles" : {
"0.0" : 0.0,
"50.0" : 0.0,
"90.0" : 0.11523928074385986,
"95.0" : 0.12804364527095535,
"99.0" : 0.12804364527095535,
"99.9" : 0.12804364527095535,
"99.99" : 0.12804364527095535,
"99.999" : 0.12804364527095535,
"99.9999" : 0.12804364527095535,
"100.0" : 0.12804364527095535
},
"scoreUnit" : "MB/sec",
"rawData" : [
[
0.12804364527095535
]
]
},
"·gc.churn.G1_Old_Gen.norm" : {
"score" : 7350.56,
"scoreError" : 35142.384817642494,
"scoreConfidence" : [
-27791.824817642493,
42492.94481764249
],
"scorePercentiles" : {
"0.0" : 0.0,
"50.0" : 0.0,
"90.0" : 66155.04000000004,
"95.0" : 73505.6,
"99.0" : 73505.6,
"99.9" : 73505.6,
"99.99" : 73505.6,
"99.999" : 73505.6,
"99.9999" : 73505.6,
"100.0" : 73505.6
},
"scoreUnit" : "B/op",
"rawData" : [
[
73505.6
]
]
},
"·gc.churn.G1_Survivor_Space" : {
"score" : 0.5845040089838587,
"scoreError" : 2.794462573078179,
"scoreConfidence" : [
-2.20995856409432,
3.378966582062038
],
"scorePercentiles" : {
"0.0" : 0.0,
"50.0" : 0.0,
"90.0" : 5.260536080854731,
"95.0" : 5.845040089838587,
"99.0" : 5.845040089838587,
"99.9" : 5.845040089838587,
"99.99" : 5.845040089838587,
"99.999" : 5.845040089838587,
"99.9999" : 5.845040089838587,
"100.0" : 5.845040089838587
},
"scoreUnit" : "MB/sec",
"rawData" : [
[
5.845040089838587
]
]
},
"·gc.churn.G1_Survivor_Space.norm" : {
"score" : 335544.32,
"scoreError" : 1604208.0626257288,
"scoreConfidence" : [
-1268663.7426257287,
1939752.3826257288
],
"scorePercentiles" : {
"0.0" : 0.0,
"50.0" : 0.0,
"90.0" : 3019898.8800000013,
"95.0" : 3355443.2,
"99.0" : 3355443.2,
"99.9" : 3355443.2,
"99.99" : 3355443.2,
"99.999" : 3355443.2,
"99.9999" : 3355443.2,
"100.0" : 3355443.2
},
"scoreUnit" : "B/op",
"rawData" : [
[
3355443.2
]
]
},
"·gc.count" : {
"score" : 1.0,
"scoreError" : "NaN",
"scoreConfidence" : [
1.0,
1.0
],
"scorePercentiles" : {
"0.0" : 0.0,
"50.0" : 0.0,
"90.0" : 0.9000000000000004,
"95.0" : 1.0,
"99.0" : 1.0,
"99.9" : 1.0,
"99.99" : 1.0,
"99.999" : 1.0,
"99.9999" : 1.0,
"100.0" : 1.0
},
"scoreUnit" : "counts",
"rawData" : [
[
0.0,
0.0,
0.0,
0.0,
0.0,
1.0,
0.0,
0.0,
0.0,
0.0
]
]
},
"·gc.time" : {
"score" : 4.0,
"scoreError" : "NaN",
"scoreConfidence" : [
4.0,
4.0
],
"scorePercentiles" : {
"0.0" : 0.0,
"50.0" : 0.0,
"90.0" : 3.6000000000000014,
"95.0" : 4.0,
"99.0" : 4.0,
"99.9" : 4.0,
"99.99" : 4.0,
"99.999" : 4.0,
"99.9999" : 4.0,
"100.0" : 4.0
},
"scoreUnit" : "ms",
"rawData" : [
[
4.0
]
]
}
}
},
{
"jmhVersion" : "1.20",
"benchmark" : "io.trino.operator.join.BenchmarkHashBuildAndJoinOperators.benchmarkJoinHash",
"mode" : "avgt",
"threads" : 1,
"forks" : 1,
"jvm" : "/local/home/pettja/.sdkman/candidates/java/11.0.12-zulu/bin/java",
"jvmArgs" : [
"-Xms8g",
"-Xmx8g",
"-XX:+AlwaysPreTouch",
"-XX:ReservedCodeCacheSize=256M"
],
"jdkVersion" : "11.0.12",
"vmVersion" : "11.0.12+7-LTS",
"warmupIterations" : 5,
"warmupTime" : "1 s",
"warmupBatchSize" : 1,
"measurementIterations" : 10,
"measurementTime" : "2 s",
"measurementBatchSize" : 1,
"params" : {
"buildHashEnabled" : "true",
"buildRowsRepetition" : "5",
"hashColumns" : "bigint",
"matchRate" : "1",
"outputColumns" : "all",
"partitionCount" : "4"
},
"primaryMetric" : {
"score" : 1312.98443095,
"scoreError" : 8.901242055309167,
"scoreConfidence" : [
1304.0831888946907,
1321.8856730053092
],
"scorePercentiles" : {
"0.0" : 1303.2612695,
"50.0" : 1313.941612,
"90.0" : 1322.77382915,
"95.0" : 1323.377105,
"99.0" : 1323.377105,
"99.9" : 1323.377105,
"99.99" : 1323.377105,
"99.999" : 1323.377105,
"99.9999" : 1323.377105,
"100.0" : 1323.377105
},
"scoreUnit" : "ms/op",
"rawData" : [
[
1313.2972885,
1310.5848425,
1317.3443465,
1310.494023,
1314.5859355,
1315.7413595,
1303.2612695,
1315.90003,
1323.377105,
1305.2581095
]
]
},
"secondaryMetrics" : {
"·gc.alloc.rate" : {
"score" : 174.66930823995108,
"scoreError" : 0.9963691884169962,
"scoreConfidence" : [
173.6729390515341,
175.66567742836807
],
"scorePercentiles" : {
"0.0" : 173.51538699275798,
"50.0" : 174.5586474153303,
"90.0" : 175.7417860449885,
"95.0" : 175.76438981312725,
"99.0" : 175.76438981312725,
"99.9" : 175.76438981312725,
"99.99" : 175.76438981312725,
"99.999" : 175.76438981312725,
"99.9999" : 175.76438981312725,
"100.0" : 175.76438981312725
},
"scoreUnit" : "MB/sec",
"rawData" : [
[
174.62798409837032,
174.93116996239866,
174.17436042789598,
174.94462262636475,
174.48931073229033,
174.36766236705503,
175.76438981312725,
174.33984324751086,
173.51538699275798,
175.53835213173954
]
]
},
"·gc.alloc.rate.norm" : {
"score" : 2.86323168E8,
"scoreError" : 88.92440290023914,
"scoreConfidence" : [
2.863230790755971E8,
2.863232569244029E8
],
"scorePercentiles" : {
"0.0" : 2.86323132E8,
"50.0" : 2.86323148E8,
"90.0" : 2.863233152E8,
"95.0" : 2.86323332E8,
"99.0" : 2.86323332E8,
"99.9" : 2.86323332E8,
"99.99" : 2.86323332E8,
"99.999" : 2.86323332E8,
"99.9999" : 2.86323332E8,
"100.0" : 2.86323332E8
},
"scoreUnit" : "B/op",
"rawData" : [
[
2.86323164E8,
2.86323148E8,
2.86323164E8,
2.86323148E8,
2.86323132E8,
2.86323332E8,
2.86323164E8,
2.86323148E8,
2.86323148E8,
2.86323132E8
]
]
},
"·gc.churn.G1_Eden_Space" : {
"score" : 154.16019205907094,
"scoreError" : 737.0264024647847,
"scoreConfidence" : [
-582.8662104057138,
891.1865945238557
],
"scorePercentiles" : {
"0.0" : 0.0,
"50.0" : 0.0,
"90.0" : 1387.441728531639,
"95.0" : 1541.6019205907094,
"99.0" : 1541.6019205907094,
"99.9" : 1541.6019205907094,
"99.99" : 1541.6019205907094,
"99.999" : 1541.6019205907094,
"99.9999" : 1541.6019205907094,
"100.0" : 1541.6019205907094
},
"scoreUnit" : "MB/sec",
"rawData" : [
[
1541.6019205907094
]
]
},
"·gc.churn.G1_Eden_Space.norm" : {
"score" : 2.543845376E8,
"scoreError" : 1.2161902374781308E9,
"scoreConfidence" : [
-9.618056998781308E8,
1.4705747750781307E9
],
"scorePercentiles" : {
"0.0" : 0.0,
"50.0" : 0.0,
"90.0" : 2.289460838400001E9,
"95.0" : 2.543845376E9,
"99.0" : 2.543845376E9,
"99.9" : 2.543845376E9,
"99.99" : 2.543845376E9,
"99.999" : 2.543845376E9,
"99.9999" : 2.543845376E9,
"100.0" : 2.543845376E9
},
"scoreUnit" : "B/op",
"rawData" : [
[
2.543845376E9
]
]
},
"·gc.churn.G1_Old_Gen" : {
"score" : 0.06908590195258682,
"scoreError" : 0.33029365815553174,
"scoreConfidence" : [
-0.2612077562029449,
0.3993795601081186
],
"scorePercentiles" : {
"0.0" : 0.0,
"50.0" : 0.0,
"90.0" : 0.6217731175732816,
"95.0" : 0.6908590195258681,
"99.0" : 0.6908590195258681,
"99.9" : 0.6908590195258681,
"99.99" : 0.6908590195258681,
"99.999" : 0.6908590195258681,
"99.9999" : 0.6908590195258681,
"100.0" : 0.6908590195258681
},
"scoreUnit" : "MB/sec",
"rawData" : [
[
0.6908590195258681
]
]
},
"·gc.churn.G1_Old_Gen.norm" : {
"score" : 114000.8,
"scoreError" : 545027.8595262264,
"scoreConfidence" : [
-431027.0595262264,
659028.6595262265
],
"scorePercentiles" : {
"0.0" : 0.0,
"50.0" : 0.0,
"90.0" : 1026007.2000000004,
"95.0" : 1140008.0,
"99.0" : 1140008.0,
"99.9" : 1140008.0,
"99.99" : 1140008.0,
"99.999" : 1140008.0,
"99.9999" : 1140008.0,
"100.0" : 1140008.0
},
"scoreUnit" : "B/op",
"rawData" : [
[
1140008.0
]
]
},
"·gc.count" : {
"score" : 1.0,
"scoreError" : "NaN",
"scoreConfidence" : [
1.0,
1.0
],
"scorePercentiles" : {
"0.0" : 0.0,
"50.0" : 0.0,
"90.0" : 0.9000000000000004,
"95.0" : 1.0,
"99.0" : 1.0,
"99.9" : 1.0,
"99.99" : 1.0,
"99.999" : 1.0,
"99.9999" : 1.0,
"100.0" : 1.0
},
"scoreUnit" : "counts",
"rawData" : [
[
0.0,
0.0,
0.0,
0.0,
0.0,
0.0,
0.0,
0.0,
1.0,
0.0
]
]
},
"·gc.time" : {
"score" : 14.0,
"scoreError" : "NaN",
"scoreConfidence" : [
14.0,
14.0
],
"scorePercentiles" : {
"0.0" : 0.0,
"50.0" : 0.0,
"90.0" : 12.600000000000005,
"95.0" : 14.0,
"99.0" : 14.0,
"99.9" : 14.0,
"99.99" : 14.0,
"99.999" : 14.0,
"99.9999" : 14.0,
"100.0" : 14.0
},
"scoreUnit" : "ms",
"rawData" : [
[
14.0
]
]
}
}
},
{
"jmhVersion" : "1.20",
"benchmark" : "io.trino.operator.join.BenchmarkHashBuildAndJoinOperators.benchmarkJoinHash",
"mode" : "avgt",
"threads" : 1,
"forks" : 1,
"jvm" : "/local/home/pettja/.sdkman/candidates/java/11.0.12-zulu/bin/java",
"jvmArgs" : [
"-Xms8g",
"-Xmx8g",
"-XX:+AlwaysPreTouch",
"-XX:ReservedCodeCacheSize=256M"
],
"jdkVersion" : "11.0.12",
"vmVersion" : "11.0.12+7-LTS",
"warmupIterations" : 5,
"warmupTime" : "1 s",
"warmupBatchSize" : 1,
"measurementIterations" : 10,
"measurementTime" : "2 s",
"measurementBatchSize" : 1,
"params" : {
"buildHashEnabled" : "true",
"buildRowsRepetition" : "5",
"hashColumns" : "bigint",
"matchRate" : "2",
"outputColumns" : "all",
"partitionCount" : "4"
},
"primaryMetric" : {
"score" : 1212.0148459,
"scoreError" : 30.297206125444188,
"scoreConfidence" : [
1181.7176397745557,
1242.3120520254442
],
"scorePercentiles" : {
"0.0" : 1202.433459,
"50.0" : 1205.59593825,
"90.0" : 1262.7328445,
"95.0" : 1268.480818,
"99.0" : 1268.480818,
"99.9" : 1268.480818,
"99.99" : 1268.480818,
"99.999" : 1268.480818,
"99.9999" : 1268.480818,
"100.0" : 1268.480818
},
"scoreUnit" : "ms/op",
"rawData" : [
[
1211.001083,
1204.972934,
1268.480818,
1202.9372345,
1205.8547095,
1203.171581,
1202.433459,
1206.0072915,
1209.9521815,
1205.337167
]
]
},
"secondaryMetrics" : {
"·gc.alloc.rate" : {
"score" : 186.75326620800917,
"scoreError" : 3.7453713499866548,
"scoreConfidence" : [
183.00789485802252,
190.4986375579958
],
"scorePercentiles" : {
"0.0" : 179.78028053245288,
"50.0" : 187.54734658155044,
"90.0" : 187.948861813205,
"95.0" : 187.95464141807514,
"99.0" : 187.95464141807514,
"99.9" : 187.95464141807514,
"99.99" : 187.95464141807514,
"99.999" : 187.95464141807514,
"99.9999" : 187.95464141807514,
"100.0" : 187.95464141807514
},
"scoreUnit" : "MB/sec",
"rawData" : [
[
186.8431734790468,
187.62968249388345,
179.78028053245288,
187.89684536937395,
187.52059778667555,
187.86411510878037,
187.95464141807514,
187.48441512487264,
186.98481539050567,
187.57409537642533
]
]
},
"·gc.alloc.rate.norm" : {
"score" : 2.863233792E8,
"scoreError" : 90.94854610199428,
"scoreConfidence" : [
2.863232882514539E8,
2.863234701485461E8
],
"scorePercentiles" : {
"0.0" : 2.86323348E8,
"50.0" : 2.86323364E8,
"90.0" : 2.863235312E8,
"95.0" : 2.86323548E8,
"99.0" : 2.86323548E8,
"99.9" : 2.86323548E8,
"99.99" : 2.86323548E8,
"99.999" : 2.86323548E8,
"99.9999" : 2.86323548E8,
"100.0" : 2.86323548E8
},
"scoreUnit" : "B/op",
"rawData" : [
[
2.86323364E8,
2.8632338E8,
2.86323348E8,
2.86323364E8,
2.86323364E8,
2.86323548E8,
2.86323348E8,
2.86323348E8,
2.86323364E8,
2.86323364E8
]
]
},
"·gc.churn.G1_Eden_Space" : {
"score" : 47.93101024231767,
"scoreError" : 229.1539701238942,
"scoreConfidence" : [
-181.22295988157651,
277.0849803662119
],
"scorePercentiles" : {
"0.0" : 0.0,
"50.0" : 0.0,
"90.0" : 431.3790921808592,
"95.0" : 479.31010242317666,
"99.0" : 479.31010242317666,
"99.9" : 479.31010242317666,
"99.99" : 479.31010242317666,
"99.999" : 479.31010242317666,
"99.9999" : 479.31010242317666,
"100.0" : 479.31010242317666
},
"scoreUnit" : "MB/sec",
"rawData" : [
[
479.31010242317666
]
]
},
"·gc.churn.G1_Eden_Space.norm" : {
"score" : 7.63363328E7,
"scoreError" : 3.649573342473535E8,
"scoreConfidence" : [
-2.886210014473535E8,
4.412936670473535E8
],
"scorePercentiles" : {
"0.0" : 0.0,
"50.0" : 0.0,
"90.0" : 6.870269952000003E8,
"95.0" : 7.63363328E8,
"99.0" : 7.63363328E8,
"99.9" : 7.63363328E8,
"99.99" : 7.63363328E8,
"99.999" : 7.63363328E8,
"99.9999" : 7.63363328E8,
"100.0" : 7.63363328E8
},
"scoreUnit" : "B/op",
"rawData" : [
[
7.63363328E8
]
]
},
"·gc.churn.G1_Survivor_Space" : {
"score" : 3.2919649891701694,
"scoreError" : 15.738596849168564,
"scoreConfidence" : [
-12.446631859998394,
19.030561838338734
],
"scorePercentiles" : {
"0.0" : 0.0,
"50.0" : 0.0,
"90.0" : 29.627684902531538,
"95.0" : 32.919649891701695,
"99.0" : 32.919649891701695,
"99.9" : 32.919649891701695,
"99.99" : 32.919649891701695,
"99.999" : 32.919649891701695,
"99.9999" : 32.919649891701695,
"100.0" : 32.919649891701695
},
"scoreUnit" : "MB/sec",
"rawData" : [
[
32.919649891701695
]
]
},
"·gc.churn.G1_Survivor_Space.norm" : {
"score" : 5242880.0,
"scoreError" : 2.5065750978527017E7,
"scoreConfidence" : [
-1.9822870978527017E7,
3.0308630978527017E7
],
"scorePercentiles" : {
"0.0" : 0.0,
"50.0" : 0.0,
"90.0" : 4.7185920000000015E7,
"95.0" : 5.24288E7,
"99.0" : 5.24288E7,
"99.9" : 5.24288E7,
"99.99" : 5.24288E7,
"99.999" : 5.24288E7,
"99.9999" : 5.24288E7,
"100.0" : 5.24288E7
},
"scoreUnit" : "B/op",
"rawData" : [
[
5.24288E7
]
]
},
"·gc.count" : {
"score" : 1.0,
"scoreError" : "NaN",
"scoreConfidence" : [
1.0,
1.0
],
"scorePercentiles" : {
"0.0" : 0.0,
"50.0" : 0.0,
"90.0" : 0.9000000000000004,
"95.0" : 1.0,
"99.0" : 1.0,
"99.9" : 1.0,
"99.99" : 1.0,
"99.999" : 1.0,
"99.9999" : 1.0,
"100.0" : 1.0
},
"scoreUnit" : "counts",
"rawData" : [
[
0.0,
0.0,
1.0,
0.0,
0.0,
0.0,
0.0,
0.0,
0.0,
0.0
]
]
},
"·gc.time" : {
"score" : 4.0,
"scoreError" : "NaN",
"scoreConfidence" : [
4.0,
4.0
],
"scorePercentiles" : {
"0.0" : 0.0,
"50.0" : 0.0,
"90.0" : 3.6000000000000014,
"95.0" : 4.0,
"99.0" : 4.0,
"99.9" : 4.0,
"99.99" : 4.0,
"99.999" : 4.0,
"99.9999" : 4.0,
"100.0" : 4.0
},
"scoreUnit" : "ms",
"rawData" : [
[
4.0
]
]
}
}
},
{
"jmhVersion" : "1.20",
"benchmark" : "io.trino.operator.join.BenchmarkHashBuildAndJoinOperators.benchmarkJoinHash",
"mode" : "avgt",
"threads" : 1,
"forks" : 1,
"jvm" : "/local/home/pettja/.sdkman/candidates/java/11.0.12-zulu/bin/java",
"jvmArgs" : [
"-Xms8g",
"-Xmx8g",
"-XX:+AlwaysPreTouch",
"-XX:ReservedCodeCacheSize=256M"
],
"jdkVersion" : "11.0.12",
"vmVersion" : "11.0.12+7-LTS",
"warmupIterations" : 5,
"warmupTime" : "1 s",
"warmupBatchSize" : 1,
"measurementIterations" : 10,
"measurementTime" : "2 s",
"measurementBatchSize" : 1,
"params" : {
"buildHashEnabled" : "true",
"buildRowsRepetition" : "5",
"hashColumns" : "all",
"matchRate" : "0.1",
"outputColumns" : "all",
"partitionCount" : "4"
},
"primaryMetric" : {
"score" : 476.23097648000004,
"scoreError" : 3.24507077407332,
"scoreConfidence" : [
472.9859057059267,
479.47604725407336
],
"scorePercentiles" : {
"0.0" : 472.7404902,
"50.0" : 476.57643310000003,
"90.0" : 479.72485432,
"95.0" : 479.9577498,
"99.0" : 479.9577498,
"99.9" : 479.9577498,
"99.99" : 479.9577498,
"99.999" : 479.9577498,
"99.9999" : 479.9577498,
"100.0" : 479.9577498
},
"scoreUnit" : "ms/op",
"rawData" : [
[
476.9258676,
475.9309312,
479.9577498,
472.9681768,
475.5458298,
472.7404902,
477.628795,
476.611999,
476.5408672,
477.4590582
]
]
},
"secondaryMetrics" : {
"·gc.alloc.rate" : {
"score" : 53.030024162165205,
"scoreError" : 0.29892521909666914,
"scoreConfidence" : [
52.73109894306854,
53.32894938126187
],
"scorePercentiles" : {
"0.0" : 52.687997421985465,
"50.0" : 52.99669743337863,
"90.0" : 53.35027376462023,
"95.0" : 53.35241193573145,
"99.0" : 53.35241193573145,
"99.9" : 53.35241193573145,
"99.99" : 53.35241193573145,
"99.999" : 53.35241193573145,
"99.9999" : 53.35241193573145,
"100.0" : 53.35241193573145
},
"scoreUnit" : "MB/sec",
"rawData" : [
[
52.96727906852427,
53.058078162108444,
52.687997421985465,
53.33103022461925,
53.092280552931214,
53.35241193573145,
52.900637180090975,
52.994140478840556,
52.99925438791671,
52.917132208903624
]
]
},
"·gc.alloc.rate.norm" : {
"score" : 3.204899872E7,
"scoreError" : 35.94794140481895,
"scoreConfidence" : [
3.2048962772058595E7,
3.2049034667941403E7
],
"scorePercentiles" : {
"0.0" : 3.20489856E7,
"50.0" : 3.2048992E7,
"90.0" : 3.2049058880000003E7,
"95.0" : 3.20490656E7,
"99.0" : 3.20490656E7,
"99.9" : 3.20490656E7,
"99.99" : 3.20490656E7,
"99.999" : 3.20490656E7,
"99.9999" : 3.20490656E7,
"100.0" : 3.20490656E7
},
"scoreUnit" : "B/op",
"rawData" : [
[
3.2048992E7,
3.20490656E7,
3.20489984E7,
3.20489856E7,
3.2048992E7,
3.20489856E7,
3.2048992E7,
3.2048992E7,
3.2048992E7,
3.2048992E7
]
]
},
"·gc.churn.G1_Eden_Space" : {
"score" : 44.25231227972839,
"scoreError" : 211.56643673471154,
"scoreConfidence" : [
-167.31412445498316,
255.81874901443993
],
"scorePercentiles" : {
"0.0" : 0.0,
"50.0" : 0.0,
"90.0" : 398.2708105175557,
"95.0" : 442.5231227972839,
"99.0" : 442.5231227972839,
"99.9" : 442.5231227972839,
"99.99" : 442.5231227972839,
"99.999" : 442.5231227972839,
"99.9999" : 442.5231227972839,
"100.0" : 442.5231227972839
},
"scoreUnit" : "MB/sec",
"rawData" : [
[
442.5231227972839
]
]
},
"·gc.churn.G1_Eden_Space.norm" : {
"score" : 2.675965952E7,
"scoreError" : 1.2793559299440192E8,
"scoreConfidence" : [
-1.0117593347440192E8,
1.546952525144019E8
],
"scorePercentiles" : {
"0.0" : 0.0,
"50.0" : 0.0,
"90.0" : 2.408369356800001E8,
"95.0" : 2.675965952E8,
"99.0" : 2.675965952E8,
"99.9" : 2.675965952E8,
"99.99" : 2.675965952E8,
"99.999" : 2.675965952E8,
"99.9999" : 2.675965952E8,
"100.0" : 2.675965952E8
},
"scoreUnit" : "B/op",
"rawData" : [
[
2.675965952E8
]
]
},
"·gc.churn.G1_Survivor_Space" : {
"score" : 0.5548879282724564,
"scoreError" : 2.6528706800590816,
"scoreConfidence" : [
-2.097982751786625,
3.207758608331538
],
"scorePercentiles" : {
"0.0" : 0.0,
"50.0" : 0.0,
"90.0" : 4.993991354452109,
"95.0" : 5.548879282724563,
"99.0" : 5.548879282724563,
"99.9" : 5.548879282724563,
"99.99" : 5.548879282724563,
"99.999" : 5.548879282724563,
"99.9999" : 5.548879282724563,
"100.0" : 5.548879282724563
},
"scoreUnit" : "MB/sec",
"rawData" : [
[
5.548879282724563
]
]
},
"·gc.churn.G1_Survivor_Space.norm" : {
"score" : 335544.32,
"scoreError" : 1604208.0626257288,
"scoreConfidence" : [
-1268663.7426257287,
1939752.3826257288
],
"scorePercentiles" : {
"0.0" : 0.0,
"50.0" : 0.0,
"90.0" : 3019898.8800000013,
"95.0" : 3355443.2,
"99.0" : 3355443.2,
"99.9" : 3355443.2,
"99.99" : 3355443.2,
"99.999" : 3355443.2,
"99.9999" : 3355443.2,
"100.0" : 3355443.2
},
"scoreUnit" : "B/op",
"rawData" : [
[
3355443.2
]
]
},
"·gc.count" : {
"score" : 1.0,
"scoreError" : "NaN",
"scoreConfidence" : [
1.0,
1.0
],
"scorePercentiles" : {
"0.0" : 0.0,
"50.0" : 0.0,
"90.0" : 0.9000000000000004,
"95.0" : 1.0,
"99.0" : 1.0,
"99.9" : 1.0,
"99.99" : 1.0,
"99.999" : 1.0,
"99.9999" : 1.0,
"100.0" : 1.0
},
"scoreUnit" : "counts",
"rawData" : [
[
0.0,
0.0,
0.0,
0.0,
0.0,
0.0,
0.0,
0.0,
1.0,
0.0
]
]
},
"·gc.time" : {
"score" : 4.0,
"scoreError" : "NaN",
"scoreConfidence" : [
4.0,
4.0
],
"scorePercentiles" : {
"0.0" : 0.0,
"50.0" : 0.0,
"90.0" : 3.6000000000000014,
"95.0" : 4.0,
"99.0" : 4.0,
"99.9" : 4.0,
"99.99" : 4.0,
"99.999" : 4.0,
"99.9999" : 4.0,
"100.0" : 4.0
},
"scoreUnit" : "ms",
"rawData" : [
[
4.0
]
]
}
}
},
{
"jmhVersion" : "1.20",
"benchmark" : "io.trino.operator.join.BenchmarkHashBuildAndJoinOperators.benchmarkJoinHash",
"mode" : "avgt",
"threads" : 1,
"forks" : 1,
"jvm" : "/local/home/pettja/.sdkman/candidates/java/11.0.12-zulu/bin/java",
"jvmArgs" : [
"-Xms8g",
"-Xmx8g",
"-XX:+AlwaysPreTouch",
"-XX:ReservedCodeCacheSize=256M"
],
"jdkVersion" : "11.0.12",
"vmVersion" : "11.0.12+7-LTS",
"warmupIterations" : 5,
"warmupTime" : "1 s",
"warmupBatchSize" : 1,
"measurementIterations" : 10,
"measurementTime" : "2 s",
"measurementBatchSize" : 1,
"params" : {
"buildHashEnabled" : "true",
"buildRowsRepetition" : "5",
"hashColumns" : "all",
"matchRate" : "1",
"outputColumns" : "all",
"partitionCount" : "4"
},
"primaryMetric" : {
"score" : 1393.6425508999998,
"scoreError" : 11.802066235342494,
"scoreConfidence" : [
1381.8404846646574,
1405.4446171353422
],
"scorePercentiles" : {
"0.0" : 1382.482142,
"50.0" : 1391.4599535,
"90.0" : 1408.4549177,
"95.0" : 1408.8101385,
"99.0" : 1408.8101385,
"99.9" : 1408.8101385,
"99.99" : 1408.8101385,
"99.999" : 1408.8101385,
"99.9999" : 1408.8101385,
"100.0" : 1408.8101385
},
"scoreUnit" : "ms/op",
"rawData" : [
[
1395.311467,
1405.2579305,
1391.5911695,
1382.482142,
1389.5675255,
1408.8101385,
1391.3287375,
1392.023082,
1390.8004195,
1389.252897
]
]
},
"secondaryMetrics" : {
"·gc.alloc.rate" : {
"score" : 166.1136625067177,
"scoreError" : 1.1900878471397551,
"scoreConfidence" : [
164.92357465957795,
167.30375035385745
],
"scorePercentiles" : {
"0.0" : 164.5882862353154,
"50.0" : 166.3328678844819,
"90.0" : 167.17828854497316,
"95.0" : 167.24765003831584,
"99.0" : 167.24765003831584,
"99.9" : 167.24765003831584,
"99.99" : 167.24765003831584,
"99.999" : 167.24765003831584,
"99.9999" : 167.24765003831584,
"100.0" : 167.24765003831584
},
"scoreUnit" : "MB/sec",
"rawData" : [
[
165.93616554958635,
164.94511005379928,
166.32262546755814,
167.24765003831584,
166.52434879920267,
164.5882862353154,
166.34311030140572,
166.27535757336392,
166.3999359437408,
166.5540351048889
]
]
},
"·gc.alloc.rate.norm" : {
"score" : 2.863454448E8,
"scoreError" : 90.59040906964385,
"scoreConfidence" : [
2.86345354209591E8,
2.8634553539040905E8
],
"scorePercentiles" : {
"0.0" : 2.86345412E8,
"50.0" : 2.86345428E8,
"90.0" : 2.863455952E8,
"95.0" : 2.86345612E8,
"99.0" : 2.86345612E8,
"99.9" : 2.86345612E8,
"99.99" : 2.86345612E8,
"99.999" : 2.86345612E8,
"99.9999" : 2.86345612E8,
"100.0" : 2.86345612E8
},
"scoreUnit" : "B/op",
"rawData" : [
[
2.86345444E8,
2.86345428E8,
2.86345412E8,
2.86345428E8,
2.86345444E8,
2.86345612E8,
2.86345428E8,
2.86345412E8,
2.86345428E8,
2.86345412E8
]
]
},
"·gc.churn.G1_Eden_Space" : {
"score" : 112.54774464076763,
"scoreError" : 381.7960155536905,
"scoreConfidence" : [
-269.24827091292286,
494.3437601944581
],
"scorePercentiles" : {
"0.0" : 0.0,
"50.0" : 0.0,
"90.0" : 709.4716007323298,
"95.0" : 746.1548201144525,
"99.0" : 746.1548201144525,
"99.9" : 746.1548201144525,
"99.99" : 746.1548201144525,
"99.999" : 746.1548201144525,
"99.9999" : 746.1548201144525,
"100.0" : 746.1548201144525
},
"scoreUnit" : "MB/sec",
"rawData" : [
[
379.3226262932237,
746.1548201144525
]
]
},
"·gc.churn.G1_Eden_Space.norm" : {
"score" : 1.956642816E8,
"scoreError" : 6.639837897471796E8,
"scoreConfidence" : [
-4.683195081471796E8,
8.596480713471797E8
],
"scorePercentiles" : {
"0.0" : 0.0,
"50.0" : 0.0,
"90.0" : 1.2341739520000002E9,
"95.0" : 1.298137088E9,
"99.0" : 1.298137088E9,
"99.9" : 1.298137088E9,
"99.99" : 1.298137088E9,
"99.999" : 1.298137088E9,
"99.9999" : 1.298137088E9,
"100.0" : 1.298137088E9
},
"scoreUnit" : "B/op",
"rawData" : [
[
6.58505728E8,
1.298137088E9
]
]
},
"·gc.churn.G1_Survivor_Space" : {
"score" : 2.5360868375677397,
"scoreError" : 10.347457835459625,
"scoreConfidence" : [
-7.811370997891886,
12.883544673027366
],
"scorePercentiles" : {
"0.0" : 0.0,
"50.0" : 0.0,
"90.0" : 19.93177415802132,
"95.0" : 21.744609150566966,
"99.0" : 21.744609150566966,
"99.9" : 21.744609150566966,
"99.99" : 21.744609150566966,
"99.999" : 21.744609150566966,
"99.9999" : 21.744609150566966,
"100.0" : 21.744609150566966
},
"scoreUnit" : "MB/sec",
"rawData" : [
[
21.744609150566966,
3.6162592251104324
]
]
},
"·gc.churn.G1_Survivor_Space.norm" : {
"score" : 4404019.2,
"scoreError" : 1.796359389207969E7,
"scoreConfidence" : [
-1.355957469207969E7,
2.2367613092079688E7
],
"scorePercentiles" : {
"0.0" : 0.0,
"50.0" : 0.0,
"90.0" : 3.4603008000000015E7,
"95.0" : 3.7748736E7,
"99.0" : 3.7748736E7,
"99.9" : 3.7748736E7,
"99.99" : 3.7748736E7,
"99.999" : 3.7748736E7,
"99.9999" : 3.7748736E7,
"100.0" : 3.7748736E7
},
"scoreUnit" : "B/op",
"rawData" : [
[
3.7748736E7,
6291456.0
]
]
},
"·gc.count" : {
"score" : 2.0,
"scoreError" : "NaN",
"scoreConfidence" : [
2.0,
2.0
],
"scorePercentiles" : {
"0.0" : 0.0,
"50.0" : 0.0,
"90.0" : 1.0,
"95.0" : 1.0,
"99.0" : 1.0,
"99.9" : 1.0,
"99.99" : 1.0,
"99.999" : 1.0,
"99.9999" : 1.0,
"100.0" : 1.0
},
"scoreUnit" : "counts",
"rawData" : [
[
0.0,
1.0,
0.0,
0.0,
0.0,
1.0,
0.0,
0.0,
0.0,
0.0
]
]
},
"·gc.time" : {
"score" : 13.0,
"scoreError" : "NaN",
"scoreConfidence" : [
13.0,
13.0
],
"scorePercentiles" : {
"0.0" : 0.0,
"50.0" : 0.0,
"90.0" : 6.9,
"95.0" : 7.0,
"99.0" : 7.0,
"99.9" : 7.0,
"99.99" : 7.0,
"99.999" : 7.0,
"99.9999" : 7.0,
"100.0" : 7.0
},
"scoreUnit" : "ms",
"rawData" : [
[
7.0,
6.0
]
]
}
}
},
{
"jmhVersion" : "1.20",
"benchmark" : "io.trino.operator.join.BenchmarkHashBuildAndJoinOperators.benchmarkJoinHash",
"mode" : "avgt",
"threads" : 1,
"forks" : 1,
"jvm" : "/local/home/pettja/.sdkman/candidates/java/11.0.12-zulu/bin/java",
"jvmArgs" : [
"-Xms8g",
"-Xmx8g",
"-XX:+AlwaysPreTouch",
"-XX:ReservedCodeCacheSize=256M"
],
"jdkVersion" : "11.0.12",
"vmVersion" : "11.0.12+7-LTS",
"warmupIterations" : 5,
"warmupTime" : "1 s",
"warmupBatchSize" : 1,
"measurementIterations" : 10,
"measurementTime" : "2 s",
"measurementBatchSize" : 1,
"params" : {
"buildHashEnabled" : "true",
"buildRowsRepetition" : "5",
"hashColumns" : "all",
"matchRate" : "2",
"outputColumns" : "all",
"partitionCount" : "4"
},
"primaryMetric" : {
"score" : 1212.26683095,
"scoreError" : 10.652771200199393,
"scoreConfidence" : [
1201.6140597498006,
1222.9196021501994
],
"scorePercentiles" : {
"0.0" : 1199.325236,
"50.0" : 1211.275458,
"90.0" : 1223.31545835,
"95.0" : 1223.348422,
"99.0" : 1223.348422,
"99.9" : 1223.348422,
"99.99" : 1223.348422,
"99.999" : 1223.348422,
"99.9999" : 1223.348422,
"100.0" : 1223.348422
},
"scoreUnit" : "ms/op",
"rawData" : [
[
1211.839903,
1208.071309,
1208.9514035,
1210.1546365,
1223.348422,
1210.711013,
1199.325236,
1212.728976,
1223.0187855,
1214.518625
]
]
},
"secondaryMetrics" : {
"·gc.alloc.rate" : {
"score" : 186.7122285412691,
"scoreError" : 1.3613328910229097,
"scoreConfidence" : [
185.3508956502462,
188.073561432292
],
"scorePercentiles" : {
"0.0" : 185.30595092842015,
"50.0" : 186.83747352588813,
"90.0" : 188.2692493328426,
"95.0" : 188.38321642983936,
"99.0" : 188.38321642983936,
"99.9" : 188.38321642983936,
"99.99" : 188.38321642983936,
"99.999" : 188.38321642983936,
"99.9999" : 188.38321642983936,
"100.0" : 188.38321642983936
},
"scoreUnit" : "MB/sec",
"rawData" : [
[
186.75667594334644,
187.24354545987185,
187.1236463128761,
186.97766529444056,
185.30595092842015,
186.91827110842985,
188.38321642983936,
186.6495486390026,
185.34432090499806,
186.41944439146567
]
]
},
"·gc.alloc.rate.norm" : {
"score" : 2.863456224E8,
"scoreError" : 89.43473364912366,
"scoreConfidence" : [
2.8634553296526635E8,
2.863457118347336E8
],
"scorePercentiles" : {
"0.0" : 2.86345588E8,
"50.0" : 2.86345604E8,
"90.0" : 2.863457712E8,
"95.0" : 2.86345788E8,
"99.0" : 2.86345788E8,
"99.9" : 2.86345788E8,
"99.99" : 2.86345788E8,
"99.999" : 2.86345788E8,
"99.9999" : 2.86345788E8,
"100.0" : 2.86345788E8
},
"scoreUnit" : "B/op",
"rawData" : [
[
2.8634562E8,
2.86345604E8,
2.86345604E8,
2.86345604E8,
2.86345604E8,
2.86345788E8,
2.86345604E8,
2.86345588E8,
2.8634562E8,
2.86345588E8
]
]
},
"·gc.churn.G1_Eden_Space" : {
"score" : 82.10774595613142,
"scoreError" : 392.54995604411096,
"scoreConfidence" : [
-310.44221008797956,
474.65770200024235
],
"scorePercentiles" : {
"0.0" : 0.0,
"50.0" : 0.0,
"90.0" : 738.9697136051831,
"95.0" : 821.0774595613142,
"99.0" : 821.0774595613142,
"99.9" : 821.0774595613142,
"99.99" : 821.0774595613142,
"99.999" : 821.0774595613142,
"99.9999" : 821.0774595613142,
"100.0" : 821.0774595613142
},
"scoreUnit" : "MB/sec",
"rawData" : [
[
821.0774595613142
]
]
},
"·gc.churn.G1_Eden_Space.norm" : {
"score" : 1.26877696E8,
"scoreError" : 6.065911736803538E8,
"scoreConfidence" : [
-4.7971347768035376E8,
7.334688696803538E8
],
"scorePercentiles" : {
"0.0" : 0.0,
"50.0" : 0.0,
"90.0" : 1.1418992640000005E9,
"95.0" : 1.26877696E9,
"99.0" : 1.26877696E9,
"99.9" : 1.26877696E9,
"99.99" : 1.26877696E9,
"99.999" : 1.26877696E9,
"99.9999" : 1.26877696E9,
"100.0" : 1.26877696E9
},
"scoreUnit" : "B/op",
"rawData" : [
[
1.26877696E9
]
]
},
"·gc.churn.G1_Survivor_Space" : {
"score" : 1.7642986734375348,
"scoreError" : 8.434957733179244,
"scoreConfidence" : [
-6.670659059741709,
10.19925640661678
],
"scorePercentiles" : {
"0.0" : 0.0,
"50.0" : 0.0,
"90.0" : 15.87868806093782,
"95.0" : 17.64298673437535,
"99.0" : 17.64298673437535,
"99.9" : 17.64298673437535,
"99.99" : 17.64298673437535,
"99.999" : 17.64298673437535,
"99.9999" : 17.64298673437535,
"100.0" : 17.64298673437535
},
"scoreUnit" : "MB/sec",
"rawData" : [
[
17.64298673437535
]
]
},
"·gc.churn.G1_Survivor_Space.norm" : {
"score" : 2726297.6,
"scoreError" : 1.3034190508834045E7,
"scoreConfidence" : [
-1.0307892908834046E7,
1.5760488108834045E7
],
"scorePercentiles" : {
"0.0" : 0.0,
"50.0" : 0.0,
"90.0" : 2.453667840000001E7,
"95.0" : 2.7262976E7,
"99.0" : 2.7262976E7,
"99.9" : 2.7262976E7,
"99.99" : 2.7262976E7,
"99.999" : 2.7262976E7,
"99.9999" : 2.7262976E7,
"100.0" : 2.7262976E7
},
"scoreUnit" : "B/op",
"rawData" : [
[
2.7262976E7
]
]
},
"·gc.count" : {
"score" : 1.0,
"scoreError" : "NaN",
"scoreConfidence" : [
1.0,
1.0
],
"scorePercentiles" : {
"0.0" : 0.0,
"50.0" : 0.0,
"90.0" : 0.9000000000000004,
"95.0" : 1.0,
"99.0" : 1.0,
"99.9" : 1.0,
"99.99" : 1.0,
"99.999" : 1.0,
"99.9999" : 1.0,
"100.0" : 1.0
},
"scoreUnit" : "counts",
"rawData" : [
[
0.0,
0.0,
0.0,
0.0,
1.0,
0.0,
0.0,
0.0,
0.0,
0.0
]
]
},
"·gc.time" : {
"score" : 5.0,
"scoreError" : "NaN",
"scoreConfidence" : [
5.0,
5.0
],
"scorePercentiles" : {
"0.0" : 0.0,
"50.0" : 0.0,
"90.0" : 4.500000000000002,
"95.0" : 5.0,
"99.0" : 5.0,
"99.9" : 5.0,
"99.99" : 5.0,
"99.999" : 5.0,
"99.9999" : 5.0,
"100.0" : 5.0
},
"scoreUnit" : "ms",
"rawData" : [
[
5.0
]
]
}
}
}
]
Raw
improved_join.json
[
{
"jmhVersion" : "1.20",
"benchmark" : "io.trino.operator.join.BenchmarkHashBuildAndJoinOperators.benchmarkJoinHash",
"mode" : "avgt",
"threads" : 1,
"forks" : 1,
"jvm" : "/local/home/pettja/.sdkman/candidates/java/11.0.12-zulu/bin/java",
"jvmArgs" : [
"-Xms8g",
"-Xmx8g",
"-XX:+AlwaysPreTouch",
"-XX:ReservedCodeCacheSize=256M"
],
"jdkVersion" : "11.0.12",
"vmVersion" : "11.0.12+7-LTS",
"warmupIterations" : 5,
"warmupTime" : "1 s",
"warmupBatchSize" : 1,
"measurementIterations" : 10,
"measurementTime" : "2 s",
"measurementBatchSize" : 1,
"params" : {
"buildHashEnabled" : "true",
"buildRowsRepetition" : "1",
"hashColumns" : "bigint",
"matchRate" : "0.1",
"outputColumns" : "all",
"partitionCount" : "4"
},
"primaryMetric" : {
"score" : 289.5161083285714,
"scoreError" : 2.4312782961182,
"scoreConfidence" : [
287.0848300324532,
291.9473866246896
],
"scorePercentiles" : {
"0.0" : 286.55562114285715,
"50.0" : 289.38422428571425,
"90.0" : 292.18023259999995,
"95.0" : 292.32140728571426,
"99.0" : 292.32140728571426,
"99.9" : 292.32140728571426,
"99.99" : 292.32140728571426,
"99.999" : 292.32140728571426,
"99.9999" : 292.32140728571426,
"100.0" : 292.32140728571426
},
"scoreUnit" : "ms/op",
"rawData" : [
[
290.1194835714286,
288.4653102857143,
286.55562114285715,
292.32140728571426,
290.75395585714284,
289.2351602857143,
289.53328828571426,
288.80892,
288.45827614285713,
290.90966042857144
]
]
},
"secondaryMetrics" : {
"·gc.alloc.rate" : {
"score" : 21.39088869470082,
"scoreError" : 0.14403499770933406,
"scoreConfidence" : [
21.246853696991487,
21.534923692410153
],
"scorePercentiles" : {
"0.0" : 21.22588307245989,
"50.0" : 21.398361440677096,
"90.0" : 21.55608263074037,
"95.0" : 21.567516829746765,
"99.0" : 21.567516829746765,
"99.9" : 21.567516829746765,
"99.99" : 21.567516829746765,
"99.999" : 21.567516829746765,
"99.9999" : 21.567516829746765,
"100.0" : 21.567516829746765
},
"scoreUnit" : "MB/sec",
"rawData" : [
[
21.355148548627366,
21.453174839682813,
21.567516829746765,
21.22588307245989,
21.317467887410892,
21.406915317906257,
21.389807563447935,
21.432320196541646,
21.45284581853521,
21.30780687264942
]
]
},
"·gc.alloc.rate.norm" : {
"score" : 8097971.199999998,
"scoreError" : 2.9140800526315505,
"scoreConfidence" : [
8097968.285919946,
8097974.114080051
],
"scorePercentiles" : {
"0.0" : 8097970.285714285,
"50.0" : 8097970.285714285,
"90.0" : 8097974.857142857,
"95.0" : 8097974.857142857,
"99.0" : 8097974.857142857,
"99.9" : 8097974.857142857,
"99.99" : 8097974.857142857,
"99.999" : 8097974.857142857,
"99.9999" : 8097974.857142857,
"100.0" : 8097974.857142857
},
"scoreUnit" : "B/op",
"rawData" : [
[
8097970.285714285,
8097974.857142857,
8097970.285714285,
8097970.285714285,
8097970.285714285,
8097974.857142857,
8097970.285714285,
8097970.285714285,
8097970.285714285,
8097970.285714285
]
]
},
"·gc.count" : {
"score" : 0.0,
"scoreError" : "NaN",
"scoreConfidence" : [
0.0,
0.0
],
"scorePercentiles" : {
"0.0" : 0.0,
"50.0" : 0.0,
"90.0" : 0.0,
"95.0" : 0.0,
"99.0" : 0.0,
"99.9" : 0.0,
"99.99" : 0.0,
"99.999" : 0.0,
"99.9999" : 0.0,
"100.0" : 0.0
},
"scoreUnit" : "counts",
"rawData" : [
[
0.0,
0.0,
0.0,
0.0,
0.0,
0.0,
0.0,
0.0,
0.0,
0.0
]
]
}
}
},
{
"jmhVersion" : "1.20",
"benchmark" : "io.trino.operator.join.BenchmarkHashBuildAndJoinOperators.benchmarkJoinHash",
"mode" : "avgt",
"threads" : 1,
"forks" : 1,
"jvm" : "/local/home/pettja/.sdkman/candidates/java/11.0.12-zulu/bin/java",
"jvmArgs" : [
"-Xms8g",
"-Xmx8g",
"-XX:+AlwaysPreTouch",
"-XX:ReservedCodeCacheSize=256M"
],
"jdkVersion" : "11.0.12",
"vmVersion" : "11.0.12+7-LTS",
"warmupIterations" : 5,
"warmupTime" : "1 s",
"warmupBatchSize" : 1,
"measurementIterations" : 10,
"measurementTime" : "2 s",
"measurementBatchSize" : 1,
"params" : {
"buildHashEnabled" : "true",
"buildRowsRepetition" : "1",
"hashColumns" : "bigint",
"matchRate" : "1",
"outputColumns" : "all",
"partitionCount" : "4"
},
"primaryMetric" : {
"score" : 392.6130685333334,
"scoreError" : 1.6338123006280256,
"scoreConfidence" : [
390.9792562327053,
394.2468808339614
],
"scorePercentiles" : {
"0.0" : 390.01016933333335,
"50.0" : 392.6425888333333,
"90.0" : 394.02972708333334,
"95.0" : 394.08433766666667,
"99.0" : 394.08433766666667,
"99.9" : 394.08433766666667,
"99.99" : 394.08433766666667,
"99.999" : 394.08433766666667,
"99.9999" : 394.08433766666667,
"100.0" : 394.08433766666667
},
"scoreUnit" : "ms/op",
"rawData" : [
[
392.927281,
394.08433766666667,
393.5382318333333,
392.6772355,
392.60794216666665,
392.5223265,
390.01016933333335,
392.10353433333336,
393.18351633333333,
392.47611066666667
]
]
},
"secondaryMetrics" : {
"·gc.alloc.rate" : {
"score" : 105.9319220642534,
"scoreError" : 0.3646277090413343,
"scoreConfidence" : [
105.56729435521207,
106.29654977329473
],
"scorePercentiles" : {
"0.0" : 105.60730384669284,
"50.0" : 105.92388479394597,
"90.0" : 106.46730060472785,
"95.0" : 106.5140988511321,
"99.0" : 106.5140988511321,
"99.9" : 106.5140988511321,
"99.99" : 106.5140988511321,
"99.999" : 106.5140988511321,
"99.9999" : 106.5140988511321,
"100.0" : 106.5140988511321
},
"scoreUnit" : "MB/sec",
"rawData" : [
[
105.85919253404543,
105.60730384669284,
105.72715975361223,
105.91303181343422,
105.93473777445774,
105.95730454250061,
106.5140988511321,
106.04611638708955,
105.80086699835974,
105.95940814120965
]
]
},
"·gc.alloc.rate.norm" : {
"score" : 5.287930133333333E7,
"scoreError" : 33.5295680481538,
"scoreConfidence" : [
5.287926780376528E7,
5.2879334862901375E7
],
"scorePercentiles" : {
"0.0" : 5.2879292E7,
"50.0" : 5.287929466666667E7,
"90.0" : 5.2879357333333336E7,
"95.0" : 5.2879364E7,
"99.0" : 5.2879364E7,
"99.9" : 5.2879364E7,
"99.99" : 5.2879364E7,
"99.999" : 5.2879364E7,
"99.9999" : 5.2879364E7,
"100.0" : 5.2879364E7
},
"scoreUnit" : "B/op",
"rawData" : [
[
5.2879364E7,
5.2879297333333336E7,
5.2879292E7,
5.2879297333333336E7,
5.2879297333333336E7,
5.2879292E7,
5.2879297333333336E7,
5.2879292E7,
5.2879292E7,
5.2879292E7
]
]
},
"·gc.churn.G1_Eden_Space" : {
"score" : 41.184988578029255,
"scoreError" : 196.90183024413315,
"scoreConfidence" : [
-155.7168416661039,
238.0868188221624
],
"scorePercentiles" : {
"0.0" : 0.0,
"50.0" : 0.0,
"90.0" : 370.66489720226343,
"95.0" : 411.84988578029254,
"99.0" : 411.84988578029254,
"99.9" : 411.84988578029254,
"99.99" : 411.84988578029254,
"99.999" : 411.84988578029254,
"99.9999" : 411.84988578029254,
"100.0" : 411.84988578029254
},
"scoreUnit" : "MB/sec",
"rawData" : [
[
411.84988578029254
]
]
},
"·gc.churn.G1_Eden_Space.norm" : {
"score" : 2.0621994666666664E7,
"scoreError" : 9.859195384887294E7,
"scoreConfidence" : [
-7.796995918220627E7,
1.1921394851553962E8
],
"scorePercentiles" : {
"0.0" : 0.0,
"50.0" : 0.0,
"90.0" : 1.8559795200000006E8,
"95.0" : 2.0621994666666666E8,
"99.0" : 2.0621994666666666E8,
"99.9" : 2.0621994666666666E8,
"99.99" : 2.0621994666666666E8,
"99.999" : 2.0621994666666666E8,
"99.9999" : 2.0621994666666666E8,
"100.0" : 2.0621994666666666E8
},
"scoreUnit" : "B/op",
"rawData" : [
[
2.0621994666666666E8
]
]
},
"·gc.churn.G1_Old_Gen" : {
"score" : 0.016224756752009777,
"scoreError" : 0.07756914375935593,
"scoreConfidence" : [
-0.06134438700734615,
0.09379390051136571
],
"scorePercentiles" : {
"0.0" : 0.0,
"50.0" : 0.0,
"90.0" : 0.14602281076808807,
"95.0" : 0.16224756752009778,
"99.0" : 0.16224756752009778,
"99.9" : 0.16224756752009778,
"99.99" : 0.16224756752009778,
"99.999" : 0.16224756752009778,
"99.9999" : 0.16224756752009778,
"100.0" : 0.16224756752009778
},
"scoreUnit" : "MB/sec",
"rawData" : [
[
0.16224756752009778
]
]
},
"·gc.churn.G1_Old_Gen.norm" : {
"score" : 8124.0,
"scoreError" : 38840.13384810514,
"scoreConfidence" : [
-30716.133848105143,
46964.13384810514
],
"scorePercentiles" : {
"0.0" : 0.0,
"50.0" : 0.0,
"90.0" : 73116.00000000003,
"95.0" : 81240.0,
"99.0" : 81240.0,
"99.9" : 81240.0,
"99.99" : 81240.0,
"99.999" : 81240.0,
"99.9999" : 81240.0,
"100.0" : 81240.0
},
"scoreUnit" : "B/op",
"rawData" : [
[
81240.0
]
]
},
"·gc.count" : {
"score" : 1.0,
"scoreError" : "NaN",
"scoreConfidence" : [
1.0,
1.0
],
"scorePercentiles" : {
"0.0" : 0.0,
"50.0" : 0.0,
"90.0" : 0.9000000000000004,
"95.0" : 1.0,
"99.0" : 1.0,
"99.9" : 1.0,
"99.99" : 1.0,
"99.999" : 1.0,
"99.9999" : 1.0,
"100.0" : 1.0
},
"scoreUnit" : "counts",
"rawData" : [
[
0.0,
1.0,
0.0,
0.0,
0.0,
0.0,
0.0,
0.0,
0.0,
0.0
]
]
},
"·gc.time" : {
"score" : 6.0,
"scoreError" : "NaN",
"scoreConfidence" : [
6.0,
6.0
],
"scorePercentiles" : {
"0.0" : 0.0,
"50.0" : 0.0,
"90.0" : 5.400000000000002,
"95.0" : 6.0,
"99.0" : 6.0,
"99.9" : 6.0,
"99.99" : 6.0,
"99.999" : 6.0,
"99.9999" : 6.0,
"100.0" : 6.0
},
"scoreUnit" : "ms",
"rawData" : [
[
6.0
]
]
}
}
},
{
"jmhVersion" : "1.20",
"benchmark" : "io.trino.operator.join.BenchmarkHashBuildAndJoinOperators.benchmarkJoinHash",
"mode" : "avgt",
"threads" : 1,
"forks" : 1,
"jvm" : "/local/home/pettja/.sdkman/candidates/java/11.0.12-zulu/bin/java",
"jvmArgs" : [
"-Xms8g",
"-Xmx8g",
"-XX:+AlwaysPreTouch",
"-XX:ReservedCodeCacheSize=256M"
],
"jdkVersion" : "11.0.12",
"vmVersion" : "11.0.12+7-LTS",
"warmupIterations" : 5,
"warmupTime" : "1 s",
"warmupBatchSize" : 1,
"measurementIterations" : 10,
"measurementTime" : "2 s",
"measurementBatchSize" : 1,
"params" : {
"buildHashEnabled" : "true",
"buildRowsRepetition" : "1",
"hashColumns" : "bigint",
"matchRate" : "2",
"outputColumns" : "all",
"partitionCount" : "4"
},
"primaryMetric" : {
"score" : 329.7872005,
"scoreError" : 1.3690421610436287,
"scoreConfidence" : [
328.41815833895635,
331.1562426610436
],
"scorePercentiles" : {
"0.0" : 328.2632557142857,
"50.0" : 329.8461962857143,
"90.0" : 331.0018861142857,
"95.0" : 331.0365184285714,
"99.0" : 331.0365184285714,
"99.9" : 331.0365184285714,
"99.99" : 331.0365184285714,
"99.999" : 331.0365184285714,
"99.9999" : 331.0365184285714,
"100.0" : 331.0365184285714
},
"scoreUnit" : "ms/op",
"rawData" : [
[
331.0365184285714,
330.34044971428574,
330.5875574285714,
330.6901952857143,
330.15694585714283,
328.984427,
329.29484157142855,
329.53544671428574,
328.9823672857143,
328.2632557142857
]
]
},
"secondaryMetrics" : {
"·gc.alloc.rate" : {
"score" : 125.53169891685113,
"scoreError" : 0.4283886782594021,
"scoreConfidence" : [
125.10331023859173,
125.96008759511052
],
"scorePercentiles" : {
"0.0" : 125.13895810055074,
"50.0" : 125.51413352039552,
"90.0" : 125.98480171312394,
"95.0" : 126.00702210517713,
"99.0" : 126.00702210517713,
"99.9" : 126.00702210517713,
"99.99" : 126.00702210517713,
"99.999" : 126.00702210517713,
"99.9999" : 126.00702210517713,
"100.0" : 126.00702210517713
},
"scoreUnit" : "MB/sec",
"rawData" : [
[
125.13895810055074,
125.35444829010177,
125.2832644275559,
125.25058616631834,
125.41817423540785,
125.78300910297988,
125.68661575039104,
125.6100928053832,
125.78481818464522,
126.00702210517713
]
]
},
"·gc.alloc.rate.norm" : {
"score" : 5.282457302857143E7,
"scoreError" : 4.832455072266486,
"scoreConfidence" : [
5.282456819611636E7,
5.2824577861026496E7
],
"scorePercentiles" : {
"0.0" : 5.282457028571428E7,
"50.0" : 5.282457257142857E7,
"90.0" : 5.2824578971428566E7,
"95.0" : 5.2824579428571425E7,
"99.0" : 5.2824579428571425E7,
"99.9" : 5.2824579428571425E7,
"99.99" : 5.2824579428571425E7,
"99.999" : 5.2824579428571425E7,
"99.9999" : 5.2824579428571425E7,
"100.0" : 5.2824579428571425E7
},
"scoreUnit" : "B/op",
"rawData" : [
[
5.282457028571428E7,
5.2824579428571425E7,
5.282457485714286E7,
5.282457485714286E7,
5.282457028571428E7,
5.282457028571428E7,
5.282457028571428E7,
5.282457485714286E7,
5.282457028571428E7,
5.282457485714286E7
]
]
},
"·gc.churn.G1_Eden_Space" : {
"score" : 40.45416919173725,
"scoreError" : 193.4078466421671,
"scoreConfidence" : [
-152.95367745042984,
233.86201583390437
],
"scorePercentiles" : {
"0.0" : 0.0,
"50.0" : 0.0,
"90.0" : 364.0875227256354,
"95.0" : 404.5416919173725,
"99.0" : 404.5416919173725,
"99.9" : 404.5416919173725,
"99.99" : 404.5416919173725,
"99.999" : 404.5416919173725,
"99.9999" : 404.5416919173725,
"100.0" : 404.5416919173725
},
"scoreUnit" : "MB/sec",
"rawData" : [
[
404.5416919173725
]
]
},
"·gc.churn.G1_Eden_Space.norm" : {
"score" : 1.707680914285714E7,
"scoreError" : 8.164273175863084E7,
"scoreConfidence" : [
-6.45659226157737E7,
9.871954090148798E7
],
"scorePercentiles" : {
"0.0" : 0.0,
"50.0" : 0.0,
"90.0" : 1.5369128228571436E8,
"95.0" : 1.7076809142857143E8,
"99.0" : 1.7076809142857143E8,
"99.9" : 1.7076809142857143E8,
"99.99" : 1.7076809142857143E8,
"99.999" : 1.7076809142857143E8,
"99.9999" : 1.7076809142857143E8,
"100.0" : 1.7076809142857143E8
},
"scoreUnit" : "B/op",
"rawData" : [
[
1.7076809142857143E8
]
]
},
"·gc.count" : {
"score" : 1.0,
"scoreError" : "NaN",
"scoreConfidence" : [
1.0,
1.0
],
"scorePercentiles" : {
"0.0" : 0.0,
"50.0" : 0.0,
"90.0" : 0.9000000000000004,
"95.0" : 1.0,
"99.0" : 1.0,
"99.9" : 1.0,
"99.99" : 1.0,
"99.999" : 1.0,
"99.9999" : 1.0,
"100.0" : 1.0
},
"scoreUnit" : "counts",
"rawData" : [
[
1.0,
0.0,
0.0,
0.0,
0.0,
0.0,
0.0,
0.0,
0.0,
0.0
]
]
},
"·gc.time" : {
"score" : 5.0,
"scoreError" : "NaN",
"scoreConfidence" : [
5.0,
5.0
],
"scorePercentiles" : {
"0.0" : 0.0,
"50.0" : 0.0,
"90.0" : 4.500000000000002,
"95.0" : 5.0,
"99.0" : 5.0,
"99.9" : 5.0,
"99.99" : 5.0,
"99.999" : 5.0,
"99.9999" : 5.0,
"100.0" : 5.0
},
"scoreUnit" : "ms",
"rawData" : [
[
5.0
]
]
}
}
},
{
"jmhVersion" : "1.20",
"benchmark" : "io.trino.operator.join.BenchmarkHashBuildAndJoinOperators.benchmarkJoinHash",
"mode" : "avgt",
"threads" : 1,
"forks" : 1,
"jvm" : "/local/home/pettja/.sdkman/candidates/java/11.0.12-zulu/bin/java",
"jvmArgs" : [
"-Xms8g",
"-Xmx8g",
"-XX:+AlwaysPreTouch",
"-XX:ReservedCodeCacheSize=256M"
],
"jdkVersion" : "11.0.12",
"vmVersion" : "11.0.12+7-LTS",
"warmupIterations" : 5,
"warmupTime" : "1 s",
"warmupBatchSize" : 1,
"measurementIterations" : 10,
"measurementTime" : "2 s",
"measurementBatchSize" : 1,
"params" : {
"buildHashEnabled" : "true",
"buildRowsRepetition" : "1",
"hashColumns" : "all",
"matchRate" : "0.1",
"outputColumns" : "all",
"partitionCount" : "4"
},
"primaryMetric" : {
"score" : 292.0962166142857,
"scoreError" : 2.693321367618577,
"scoreConfidence" : [
289.40289524666713,
294.7895379819043
],
"scorePercentiles" : {
"0.0" : 290.09250057142856,
"50.0" : 292.05418035714285,
"90.0" : 295.08586144285715,
"95.0" : 295.19469428571426,
"99.0" : 295.19469428571426,
"99.9" : 295.19469428571426,
"99.99" : 295.19469428571426,
"99.999" : 295.19469428571426,
"99.9999" : 295.19469428571426,
"100.0" : 295.19469428571426
},
"scoreUnit" : "ms/op",
"rawData" : [
[
292.3516377142857,
294.10636585714286,
295.19469428571426,
293.441831,
290.32370457142855,
290.4204284285714,
290.50938028571426,
290.09250057142856,
292.7649004285714,
291.756723
]
]
},
"secondaryMetrics" : {
"·gc.alloc.rate" : {
"score" : 21.269106644893608,
"scoreError" : 0.15785601490087006,
"scoreConfidence" : [
21.11125062999274,
21.426962659794476
],
"scorePercentiles" : {
"0.0" : 21.08857002038884,
"50.0" : 21.270000450850247,
"90.0" : 21.38524842422794,
"95.0" : 21.38662928222669,
"99.0" : 21.38662928222669,
"99.9" : 21.38662928222669,
"99.99" : 21.38662928222669,
"99.999" : 21.38662928222669,
"99.9999" : 21.38662928222669,
"100.0" : 21.38662928222669
},
"scoreUnit" : "MB/sec",
"rawData" : [
[
21.25266725072056,
21.151148018938844,
21.08857002038884,
21.19176028302116,
21.372820702239196,
21.3684841187285,
21.363473218974683,
21.38662928222669,
21.228179902717667,
21.28733365097994
]
]
},
"·gc.alloc.rate.norm" : {
"score" : 8109267.657142857,
"scoreError" : 3.338498105586245,
"scoreConfidence" : [
8109264.318644752,
8109270.995640962
],
"scorePercentiles" : {
"0.0" : 8109266.285714285,
"50.0" : 8109266.285714285,
"90.0" : 8109270.857142857,
"95.0" : 8109270.857142857,
"99.0" : 8109270.857142857,
"99.9" : 8109270.857142857,
"99.99" : 8109270.857142857,
"99.999" : 8109270.857142857,
"99.9999" : 8109270.857142857,
"100.0" : 8109270.857142857
},
"scoreUnit" : "B/op",
"rawData" : [
[
8109270.857142857,
8109266.285714285,
8109270.857142857,
8109266.285714285,
8109266.285714285,
8109266.285714285,
8109270.857142857,
8109266.285714285,
8109266.285714285,
8109266.285714285
]
]
},
"·gc.count" : {
"score" : 0.0,
"scoreError" : "NaN",
"scoreConfidence" : [
0.0,
0.0
],
"scorePercentiles" : {
"0.0" : 0.0,
"50.0" : 0.0,
"90.0" : 0.0,
"95.0" : 0.0,
"99.0" : 0.0,
"99.9" : 0.0,
"99.99" : 0.0,
"99.999" : 0.0,
"99.9999" : 0.0,
"100.0" : 0.0
},
"scoreUnit" : "counts",
"rawData" : [
[
0.0,
0.0,
0.0,
0.0,
0.0,
0.0,
0.0,
0.0,
0.0,
0.0
]
]
}
}
},
{
"jmhVersion" : "1.20",
"benchmark" : "io.trino.operator.join.BenchmarkHashBuildAndJoinOperators.benchmarkJoinHash",
"mode" : "avgt",
"threads" : 1,
"forks" : 1,
"jvm" : "/local/home/pettja/.sdkman/candidates/java/11.0.12-zulu/bin/java",
"jvmArgs" : [
"-Xms8g",
"-Xmx8g",
"-XX:+AlwaysPreTouch",
"-XX:ReservedCodeCacheSize=256M"
],
"jdkVersion" : "11.0.12",
"vmVersion" : "11.0.12+7-LTS",
"warmupIterations" : 5,
"warmupTime" : "1 s",
"warmupBatchSize" : 1,
"measurementIterations" : 10,
"measurementTime" : "2 s",
"measurementBatchSize" : 1,
"params" : {
"buildHashEnabled" : "true",
"buildRowsRepetition" : "1",
"hashColumns" : "all",
"matchRate" : "1",
"outputColumns" : "all",
"partitionCount" : "4"
},
"primaryMetric" : {
"score" : 441.0287815,
"scoreError" : 3.365020283857686,
"scoreConfidence" : [
437.6637612161423,
444.39380178385767
],
"scorePercentiles" : {
"0.0" : 438.3332196,
"50.0" : 440.23312480000004,
"90.0" : 444.38575454,
"95.0" : 444.4374572,
"99.0" : 444.4374572,
"99.9" : 444.4374572,
"99.99" : 444.4374572,
"99.999" : 444.4374572,
"99.9999" : 444.4374572,
"100.0" : 444.4374572
},
"scoreUnit" : "ms/op",
"rawData" : [
[
440.3392658,
444.4374572,
442.948783,
442.4037108,
440.1269838,
438.3332196,
443.9204306,
439.612905,
439.7507382,
438.414321
]
]
},
"secondaryMetrics" : {
"·gc.alloc.rate" : {
"score" : 93.20948983005746,
"scoreError" : 0.5769524707492389,
"scoreConfidence" : [
92.63253735930823,
93.7864423008067
],
"scorePercentiles" : {
"0.0" : 92.62546927500617,
"50.0" : 93.34573945872641,
"90.0" : 93.67233766266163,
"95.0" : 93.67394926828946,
"99.0" : 93.67394926828946,
"99.9" : 93.67394926828946,
"99.99" : 93.67394926828946,
"99.999" : 93.67394926828946,
"99.9999" : 93.67394926828946,
"100.0" : 93.67394926828946
},
"scoreUnit" : "MB/sec",
"rawData" : [
[
93.32776882761226,
92.62546927500617,
92.88061823451483,
92.96976830708195,
93.36371008984057,
93.67394926828946,
92.71645656682588,
93.45451806355854,
93.42480645583383,
93.65783321201117
]
]
},
"·gc.alloc.rate.norm" : {
"score" : 5.289061344E7,
"scoreError" : 33.053379313978866,
"scoreConfidence" : [
5.2890580386620685E7,
5.289064649337931E7
],
"scorePercentiles" : {
"0.0" : 5.28906016E7,
"50.0" : 5.2890608E7,
"90.0" : 5.2890668480000004E7,
"95.0" : 5.28906752E7,
"99.0" : 5.28906752E7,
"99.9" : 5.28906752E7,
"99.99" : 5.28906752E7,
"99.999" : 5.28906752E7,
"99.9999" : 5.28906752E7,
"100.0" : 5.28906752E7
},
"scoreUnit" : "B/op",
"rawData" : [
[
5.28906752E7,
5.2890608E7,
5.28906016E7,
5.28906016E7,
5.2890608E7,
5.2890608E7,
5.2890608E7,
5.2890608E7,
5.2890608E7,
5.2890608E7
]
]
},
"·gc.churn.G1_Eden_Space" : {
"score" : 42.45605183646528,
"scoreError" : 202.97867257390473,
"scoreConfidence" : [
-160.52262073743947,
245.43472441037
],
"scorePercentiles" : {
"0.0" : 0.0,
"50.0" : 0.0,
"90.0" : 382.1044665281877,
"95.0" : 424.5605183646528,
"99.0" : 424.5605183646528,
"99.9" : 424.5605183646528,
"99.99" : 424.5605183646528,
"99.999" : 424.5605183646528,
"99.9999" : 424.5605183646528,
"100.0" : 424.5605183646528
},
"scoreUnit" : "MB/sec",
"rawData" : [
[
424.5605183646528
]
]
},
"·gc.churn.G1_Eden_Space.norm" : {
"score" : 2.4243077119999997E7,
"scoreError" : 1.1590403252470888E8,
"scoreConfidence" : [
-9.166095540470889E7,
1.4014710964470887E8
],
"scorePercentiles" : {
"0.0" : 0.0,
"50.0" : 0.0,
"90.0" : 2.1818769408000007E8,
"95.0" : 2.424307712E8,
"99.0" : 2.424307712E8,
"99.9" : 2.424307712E8,
"99.99" : 2.424307712E8,
"99.999" : 2.424307712E8,
"99.9999" : 2.424307712E8,
"100.0" : 2.424307712E8
},
"scoreUnit" : "B/op",
"rawData" : [
[
2.424307712E8
]
]
},
"·gc.churn.G1_Survivor_Space" : {
"score" : 0.5876270150375817,
"scoreError" : 2.809393392026362,
"scoreConfidence" : [
-2.2217663769887803,
3.397020407063944
],
"scorePercentiles" : {
"0.0" : 0.0,
"50.0" : 0.0,
"90.0" : 5.288643135338238,
"95.0" : 5.8762701503758175,
"99.0" : 5.8762701503758175,
"99.9" : 5.8762701503758175,
"99.99" : 5.8762701503758175,
"99.999" : 5.8762701503758175,
"99.9999" : 5.8762701503758175,
"100.0" : 5.8762701503758175
},
"scoreUnit" : "MB/sec",
"rawData" : [
[
5.8762701503758175
]
]
},
"·gc.churn.G1_Survivor_Space.norm" : {
"score" : 335544.32,
"scoreError" : 1604208.0626257288,
"scoreConfidence" : [
-1268663.7426257287,
1939752.3826257288
],
"scorePercentiles" : {
"0.0" : 0.0,
"50.0" : 0.0,
"90.0" : 3019898.8800000013,
"95.0" : 3355443.2,
"99.0" : 3355443.2,
"99.9" : 3355443.2,
"99.99" : 3355443.2,
"99.999" : 3355443.2,
"99.9999" : 3355443.2,
"100.0" : 3355443.2
},
"scoreUnit" : "B/op",
"rawData" : [
[
3355443.2
]
]
},
"·gc.count" : {
"score" : 1.0,
"scoreError" : "NaN",
"scoreConfidence" : [
1.0,
1.0
],
"scorePercentiles" : {
"0.0" : 0.0,
"50.0" : 0.0,
"90.0" : 0.9000000000000004,
"95.0" : 1.0,
"99.0" : 1.0,
"99.9" : 1.0,
"99.99" : 1.0,
"99.999" : 1.0,
"99.9999" : 1.0,
"100.0" : 1.0
},
"scoreUnit" : "counts",
"rawData" : [
[
0.0,
1.0,
0.0,
0.0,
0.0,
0.0,
0.0,
0.0,
0.0,
0.0
]
]
},
"·gc.time" : {
"score" : 4.0,
"scoreError" : "NaN",
"scoreConfidence" : [
4.0,
4.0
],
"scorePercentiles" : {
"0.0" : 0.0,
"50.0" : 0.0,
"90.0" : 3.6000000000000014,
"95.0" : 4.0,
"99.0" : 4.0,
"99.9" : 4.0,
"99.99" : 4.0,
"99.999" : 4.0,
"99.9999" : 4.0,
"100.0" : 4.0
},
"scoreUnit" : "ms",
"rawData" : [
[
4.0
]
]
}
}
},
{
"jmhVersion" : "1.20",
"benchmark" : "io.trino.operator.join.BenchmarkHashBuildAndJoinOperators.benchmarkJoinHash",
"mode" : "avgt",
"threads" : 1,
"forks" : 1,
"jvm" : "/local/home/pettja/.sdkman/candidates/java/11.0.12-zulu/bin/java",
"jvmArgs" : [
"-Xms8g",
"-Xmx8g",
"-XX:+AlwaysPreTouch",
"-XX:ReservedCodeCacheSize=256M"
],
"jdkVersion" : "11.0.12",
"vmVersion" : "11.0.12+7-LTS",
"warmupIterations" : 5,
"warmupTime" : "1 s",
"warmupBatchSize" : 1,
"measurementIterations" : 10,
"measurementTime" : "2 s",
"measurementBatchSize" : 1,
"params" : {
"buildHashEnabled" : "true",
"buildRowsRepetition" : "1",
"hashColumns" : "all",
"matchRate" : "2",
"outputColumns" : "all",
"partitionCount" : "4"
},
"primaryMetric" : {
"score" : 349.9888275166667,
"scoreError" : 1.9226260439727956,
"scoreConfidence" : [
348.0662014726939,
351.9114535606395
],
"scorePercentiles" : {
"0.0" : 347.64065416666665,
"50.0" : 350.33447416666667,
"90.0" : 351.5837926,
"95.0" : 351.5959613333333,
"99.0" : 351.5959613333333,
"99.9" : 351.5959613333333,
"99.99" : 351.5959613333333,
"99.999" : 351.5959613333333,
"99.9999" : 351.5959613333333,
"100.0" : 351.5959613333333
},
"scoreUnit" : "ms/op",
"rawData" : [
[
350.497237,
351.5959613333333,
350.11919083333333,
348.3039325,
351.474274,
350.42910283333333,
350.4233775,
347.64065416666665,
350.2455708333333,
349.15897416666667
]
]
},
"secondaryMetrics" : {
"·gc.alloc.rate" : {
"score" : 116.37483060955041,
"scoreError" : 0.5152819247078675,
"scoreConfidence" : [
115.85954868484255,
116.89011253425828
],
"scorePercentiles" : {
"0.0" : 115.9467727879728,
"50.0" : 116.27968796257593,
"90.0" : 116.98449843615235,
"95.0" : 117.00149001765688,
"99.0" : 117.00149001765688,
"99.9" : 117.00149001765688,
"99.99" : 117.00149001765688,
"99.999" : 117.00149001765688,
"99.9999" : 117.00149001765688,
"100.0" : 117.00149001765688
},
"scoreUnit" : "MB/sec",
"rawData" : [
[
116.23394767025142,
115.9467727879728,
116.34272571245586,
116.83157420261155,
115.9778460829032,
116.25949356074571,
116.25696496291769,
117.00149001765688,
116.29988236440616,
116.5976087335827
]
]
},
"·gc.alloc.rate.norm" : {
"score" : 5.289060853333333E7,
"scoreError" : 37.34178352085498,
"scoreConfidence" : [
5.289057119154981E7,
5.2890645875116855E7
],
"scorePercentiles" : {
"0.0" : 5.2890596E7,
"50.0" : 5.2890596E7,
"90.0" : 5.289066506666667E7,
"95.0" : 5.2890668E7,
"99.0" : 5.2890668E7,
"99.9" : 5.2890668E7,
"99.99" : 5.2890668E7,
"99.999" : 5.2890668E7,
"99.9999" : 5.2890668E7,
"100.0" : 5.2890668E7
},
"scoreUnit" : "B/op",
"rawData" : [
[
5.2890668E7,
5.2890596E7,
5.2890596E7,
5.2890596E7,
5.2890596E7,
5.2890601333333336E7,
5.2890601333333336E7,
5.2890596E7,
5.2890596E7,
5.2890638666666664E7
]
]
},
"·gc.churn.G1_Eden_Space" : {
"score" : 45.82052351190937,
"scoreError" : 219.06391755204433,
"scoreConfidence" : [
-173.24339404013494,
264.8844410639537
],
"scorePercentiles" : {
"0.0" : 0.0,
"50.0" : 0.0,
"90.0" : 412.3847116071845,
"95.0" : 458.2052351190937,
"99.0" : 458.2052351190937,
"99.9" : 458.2052351190937,
"99.99" : 458.2052351190937,
"99.999" : 458.2052351190937,
"99.9999" : 458.2052351190937,
"100.0" : 458.2052351190937
},
"scoreUnit" : "MB/sec",
"rawData" : [
[
458.2052351190937
]
]
},
"·gc.churn.G1_Eden_Space.norm" : {
"score" : 2.0901614933333334E7,
"scoreError" : 9.992879390106104E7,
"scoreConfidence" : [
-7.90271789677277E7,
1.2083040883439438E8
],
"scorePercentiles" : {
"0.0" : 0.0,
"50.0" : 0.0,
"90.0" : 1.881145344000001E8,
"95.0" : 2.0901614933333334E8,
"99.0" : 2.0901614933333334E8,
"99.9" : 2.0901614933333334E8,
"99.99" : 2.0901614933333334E8,
"99.999" : 2.0901614933333334E8,
"99.9999" : 2.0901614933333334E8,
"100.0" : 2.0901614933333334E8
},
"scoreUnit" : "B/op",
"rawData" : [
[
2.0901614933333334E8
]
]
},
"·gc.count" : {
"score" : 1.0,
"scoreError" : "NaN",
"scoreConfidence" : [
1.0,
1.0
],
"scorePercentiles" : {
"0.0" : 0.0,
"50.0" : 0.0,
"90.0" : 0.9000000000000004,
"95.0" : 1.0,
"99.0" : 1.0,
"99.9" : 1.0,
"99.99" : 1.0,
"99.999" : 1.0,
"99.9999" : 1.0,
"100.0" : 1.0
},
"scoreUnit" : "counts",
"rawData" : [
[
0.0,
1.0,
0.0,
0.0,
0.0,
0.0,
0.0,
0.0,
0.0,
0.0
]
]
},
"·gc.time" : {
"score" : 5.0,
"scoreError" : "NaN",
"scoreConfidence" : [
5.0,
5.0
],
"scorePercentiles" : {
"0.0" : 0.0,
"50.0" : 0.0,
"90.0" : 4.500000000000002,
"95.0" : 5.0,
"99.0" : 5.0,
"99.9" : 5.0,
"99.99" : 5.0,
"99.999" : 5.0,
"99.9999" : 5.0,
"100.0" : 5.0
},
"scoreUnit" : "ms",
"rawData" : [
[
5.0
]
]
}
}
},
{
"jmhVersion" : "1.20",
"benchmark" : "io.trino.operator.join.BenchmarkHashBuildAndJoinOperators.benchmarkJoinHash",
"mode" : "avgt",
"threads" : 1,
"forks" : 1,
"jvm" : "/local/home/pettja/.sdkman/candidates/java/11.0.12-zulu/bin/java",
"jvmArgs" : [
"-Xms8g",
"-Xmx8g",
"-XX:+AlwaysPreTouch",
"-XX:ReservedCodeCacheSize=256M"
],
"jdkVersion" : "11.0.12",
"vmVersion" : "11.0.12+7-LTS",
"warmupIterations" : 5,
"warmupTime" : "1 s",
"warmupBatchSize" : 1,
"measurementIterations" : 10,
"measurementTime" : "2 s",
"measurementBatchSize" : 1,
"params" : {
"buildHashEnabled" : "true",
"buildRowsRepetition" : "5",
"hashColumns" : "bigint",
"matchRate" : "0.1",
"outputColumns" : "all",
"partitionCount" : "4"
},
"primaryMetric" : {
"score" : 436.44967598000005,
"scoreError" : 2.0678225858105117,
"scoreConfidence" : [
434.38185339418953,
438.51749856581057
],
"scorePercentiles" : {
"0.0" : 433.755723,
"50.0" : 436.6224818,
"90.0" : 438.34298706,
"95.0" : 438.4274678,
"99.0" : 438.4274678,
"99.9" : 438.4274678,
"99.99" : 438.4274678,
"99.999" : 438.4274678,
"99.9999" : 438.4274678,
"100.0" : 438.4274678
},
"scoreUnit" : "ms/op",
"rawData" : [
[
433.755723,
437.1714668,
437.5826604,
437.382039,
436.8061598,
438.4274678,
436.4388038,
435.24987,
435.2554784,
436.4270908
]
]
},
"secondaryMetrics" : {
"·gc.alloc.rate" : {
"score" : 56.72634777000864,
"scoreError" : 0.21802673222306743,
"scoreConfidence" : [
56.50832103778557,
56.9443745022317
],
"scorePercentiles" : {
"0.0" : 56.518177844871936,
"50.0" : 56.707512773869745,
"90.0" : 56.995010642968126,
"95.0" : 57.0107774393424,
"99.0" : 57.0107774393424,
"99.9" : 57.0107774393424,
"99.99" : 57.0107774393424,
"99.999" : 57.0107774393424,
"99.9999" : 57.0107774393424,
"100.0" : 57.0107774393424
},
"scoreUnit" : "MB/sec",
"rawData" : [
[
57.0107774393424,
56.65074498144993,
56.60625649308614,
56.62843368585761,
56.68834753190846,
56.518177844871936,
56.72934337202807,
56.85310947559964,
56.85160886011118,
56.72667801583103
]
]
},
"·gc.alloc.rate.norm" : {
"score" : 3.1917319360000003E7,
"scoreError" : 35.77389346007938,
"scoreConfidence" : [
3.1917283586106542E7,
3.1917355133893464E7
],
"scorePercentiles" : {
"0.0" : 3.19173056E7,
"50.0" : 3.1917312E7,
"90.0" : 3.1917378880000003E7,
"95.0" : 3.19173856E7,
"99.0" : 3.19173856E7,
"99.9" : 3.19173856E7,
"99.99" : 3.19173856E7,
"99.999" : 3.19173856E7,
"99.9999" : 3.19173856E7,
"100.0" : 3.19173856E7
},
"scoreUnit" : "B/op",
"rawData" : [
[
3.19173856E7,
3.1917312E7,
3.19173184E7,
3.1917312E7,
3.1917312E7,
3.19173184E7,
3.1917312E7,
3.19173056E7,
3.1917312E7,
3.19173056E7
]
]
},
"·gc.churn.G1_Eden_Space" : {
"score" : 43.968673849872985,
"scoreError" : 210.21038619556225,
"scoreConfidence" : [
-166.24171234568928,
254.17906004543522
],
"scorePercentiles" : {
"0.0" : 0.0,
"50.0" : 0.0,
"90.0" : 395.718064648857,
"95.0" : 439.6867384987298,
"99.0" : 439.6867384987298,
"99.9" : 439.6867384987298,
"99.99" : 439.6867384987298,
"99.999" : 439.6867384987298,
"99.9999" : 439.6867384987298,
"100.0" : 439.6867384987298
},
"scoreUnit" : "MB/sec",
"rawData" : [
[
439.6867384987298
]
]
},
"·gc.churn.G1_Eden_Space.norm" : {
"score" : 2.483027968E7,
"scoreError" : 1.1871139663430397E8,
"scoreConfidence" : [
-9.388111695430398E7,
1.4354167631430396E8
],
"scorePercentiles" : {
"0.0" : 0.0,
"50.0" : 0.0,
"90.0" : 2.234725171200001E8,
"95.0" : 2.483027968E8,
"99.0" : 2.483027968E8,
"99.9" : 2.483027968E8,
"99.99" : 2.483027968E8,
"99.999" : 2.483027968E8,
"99.9999" : 2.483027968E8,
"100.0" : 2.483027968E8
},
"scoreUnit" : "B/op",
"rawData" : [
[
2.483027968E8
]
]
},
"·gc.churn.G1_Old_Gen" : {
"score" : 0.07779906244410613,
"scoreError" : 0.37195051681267494,
"scoreConfidence" : [
-0.2941514543685688,
0.44974957925678105
],
"scorePercentiles" : {
"0.0" : 0.0,
"50.0" : 0.0,
"90.0" : 0.7001915619969554,
"95.0" : 0.7779906244410613,
"99.0" : 0.7779906244410613,
"99.9" : 0.7779906244410613,
"99.99" : 0.7779906244410613,
"99.999" : 0.7779906244410613,
"99.9999" : 0.7779906244410613,
"100.0" : 0.7779906244410613
},
"scoreUnit" : "MB/sec",
"rawData" : [
[
0.7779906244410613
]
]
},
"·gc.churn.G1_Old_Gen.norm" : {
"score" : 43935.2,
"scoreError" : 210050.35064540486,
"scoreConfidence" : [
-166115.15064540488,
253985.55064540484
],
"scorePercentiles" : {
"0.0" : 0.0,
"50.0" : 0.0,
"90.0" : 395416.80000000016,
"95.0" : 439352.0,
"99.0" : 439352.0,
"99.9" : 439352.0,
"99.99" : 439352.0,
"99.999" : 439352.0,
"99.9999" : 439352.0,
"100.0" : 439352.0
},
"scoreUnit" : "B/op",
"rawData" : [
[
439352.0
]
]
},
"·gc.churn.G1_Survivor_Space" : {
"score" : 0.2970856341207634,
"scoreError" : 1.420340447267312,
"scoreConfidence" : [
-1.1232548131465485,
1.7174260813880755
],
"scorePercentiles" : {
"0.0" : 0.0,
"50.0" : 0.0,
"90.0" : 2.673770707086872,
"95.0" : 2.970856341207634,
"99.0" : 2.970856341207634,
"99.9" : 2.970856341207634,
"99.99" : 2.970856341207634,
"99.999" : 2.970856341207634,
"99.9999" : 2.970856341207634,
"100.0" : 2.970856341207634
},
"scoreUnit" : "MB/sec",
"rawData" : [
[
2.970856341207634
]
]
},
"·gc.churn.G1_Survivor_Space.norm" : {
"score" : 167772.16,
"scoreError" : 802104.0313128644,
"scoreConfidence" : [
-634331.8713128644,
969876.1913128644
],
"scorePercentiles" : {
"0.0" : 0.0,
"50.0" : 0.0,
"90.0" : 1509949.4400000006,
"95.0" : 1677721.6,
"99.0" : 1677721.6,
"99.9" : 1677721.6,
"99.99" : 1677721.6,
"99.999" : 1677721.6,
"99.9999" : 1677721.6,
"100.0" : 1677721.6
},
"scoreUnit" : "B/op",
"rawData" : [
[
1677721.6
]
]
},
"·gc.count" : {
"score" : 1.0,
"scoreError" : "NaN",
"scoreConfidence" : [
1.0,
1.0
],
"scorePercentiles" : {
"0.0" : 0.0,
"50.0" : 0.0,
"90.0" : 0.9000000000000004,
"95.0" : 1.0,
"99.0" : 1.0,
"99.9" : 1.0,
"99.99" : 1.0,
"99.999" : 1.0,
"99.9999" : 1.0,
"100.0" : 1.0
},
"scoreUnit" : "counts",
"rawData" : [
[
0.0,
0.0,
0.0,
0.0,
0.0,
1.0,
0.0,
0.0,
0.0,
0.0
]
]
},
"·gc.time" : {
"score" : 4.0,
"scoreError" : "NaN",
"scoreConfidence" : [
4.0,
4.0
],
"scorePercentiles" : {
"0.0" : 0.0,
"50.0" : 0.0,
"90.0" : 3.6000000000000014,
"95.0" : 4.0,
"99.0" : 4.0,
"99.9" : 4.0,
"99.99" : 4.0,
"99.999" : 4.0,
"99.9999" : 4.0,
"100.0" : 4.0
},
"scoreUnit" : "ms",
"rawData" : [
[
4.0
]
]
}
}
},
{
"jmhVersion" : "1.20",
"benchmark" : "io.trino.operator.join.BenchmarkHashBuildAndJoinOperators.benchmarkJoinHash",
"mode" : "avgt",
"threads" : 1,
"forks" : 1,
"jvm" : "/local/home/pettja/.sdkman/candidates/java/11.0.12-zulu/bin/java",
"jvmArgs" : [
"-Xms8g",
"-Xmx8g",
"-XX:+AlwaysPreTouch",
"-XX:ReservedCodeCacheSize=256M"
],
"jdkVersion" : "11.0.12",
"vmVersion" : "11.0.12+7-LTS",
"warmupIterations" : 5,
"warmupTime" : "1 s",
"warmupBatchSize" : 1,
"measurementIterations" : 10,
"measurementTime" : "2 s",
"measurementBatchSize" : 1,
"params" : {
"buildHashEnabled" : "true",
"buildRowsRepetition" : "5",
"hashColumns" : "bigint",
"matchRate" : "1",
"outputColumns" : "all",
"partitionCount" : "4"
},
"primaryMetric" : {
"score" : 1332.4241530000002,
"scoreError" : 7.325245378444958,
"scoreConfidence" : [
1325.098907621555,
1339.7493983784452
],
"scorePercentiles" : {
"0.0" : 1323.680606,
"50.0" : 1332.6099765,
"90.0" : 1340.6454288,
"95.0" : 1341.2023915,
"99.0" : 1341.2023915,
"99.9" : 1341.2023915,
"99.99" : 1341.2023915,
"99.999" : 1341.2023915,
"99.9999" : 1341.2023915,
"100.0" : 1341.2023915
},
"scoreUnit" : "ms/op",
"rawData" : [
[
1334.318206,
1332.819557,
1332.400396,
1335.6327645,
1331.4727975,
1334.552027,
1341.2023915,
1323.680606,
1326.2568835,
1331.905901
]
]
},
"secondaryMetrics" : {
"·gc.alloc.rate" : {
"score" : 172.4228301665608,
"scoreError" : 0.7982620599414691,
"scoreConfidence" : [
171.62456810661934,
173.22109222650226
],
"scorePercentiles" : {
"0.0" : 171.47859142753143,
"50.0" : 172.39831477655008,
"90.0" : 173.3567882058331,
"95.0" : 173.38583951830918,
"99.0" : 173.38583951830918,
"99.9" : 173.38583951830918,
"99.99" : 173.38583951830918,
"99.999" : 173.38583951830918,
"99.9999" : 173.38583951830918,
"100.0" : 173.38583951830918
},
"scoreUnit" : "MB/sec",
"rawData" : [
[
172.20966488617177,
172.37625339839636,
172.42037615470383,
172.07278245205924,
172.52923384345877,
172.1901555630641,
171.47859142753143,
173.38583951830918,
173.0953263935485,
172.47007802836475
]
]
},
"·gc.alloc.rate.norm" : {
"score" : 2.861582624E8,
"scoreError" : 80.64246810262519,
"scoreConfidence" : [
2.861581817575319E8,
2.861583430424681E8
],
"scorePercentiles" : {
"0.0" : 2.86158228E8,
"50.0" : 2.86158244E8,
"90.0" : 2.861583968E8,
"95.0" : 2.86158412E8,
"99.0" : 2.86158412E8,
"99.9" : 2.86158412E8,
"99.99" : 2.86158412E8,
"99.999" : 2.86158412E8,
"99.9999" : 2.86158412E8,
"100.0" : 2.86158412E8
},
"scoreUnit" : "B/op",
"rawData" : [
[
2.86158244E8,
2.8615826E8,
2.86158244E8,
2.86158244E8,
2.86158244E8,
2.8615826E8,
2.86158412E8,
2.86158244E8,
2.86158244E8,
2.86158228E8
]
]
},
"·gc.churn.G1_Eden_Space" : {
"score" : 138.4888770658653,
"scoreError" : 662.1032153756755,
"scoreConfidence" : [
-523.6143383098103,
800.5920924415408
],
"scorePercentiles" : {
"0.0" : 0.0,
"50.0" : 0.0,
"90.0" : 1246.3998935927882,
"95.0" : 1384.888770658653,
"99.0" : 1384.888770658653,
"99.9" : 1384.888770658653,
"99.99" : 1384.888770658653,
"99.999" : 1384.888770658653,
"99.9999" : 1384.888770658653,
"100.0" : 1384.888770658653
},
"scoreUnit" : "MB/sec",
"rawData" : [
[
1384.888770658653
]
]
},
"·gc.churn.G1_Eden_Space.norm" : {
"score" : 2.311061504E8,
"scoreError" : 1.104898303133471E9,
"scoreConfidence" : [
-8.73792152733471E8,
1.336004453533471E9
],
"scorePercentiles" : {
"0.0" : 0.0,
"50.0" : 0.0,
"90.0" : 2.0799553536000009E9,
"95.0" : 2.311061504E9,
"99.0" : 2.311061504E9,
"99.9" : 2.311061504E9,
"99.99" : 2.311061504E9,
"99.999" : 2.311061504E9,
"99.9999" : 2.311061504E9,
"100.0" : 2.311061504E9
},
"scoreUnit" : "B/op",
"rawData" : [
[
2.311061504E9
]
]
},
"·gc.churn.G1_Old_Gen" : {
"score" : 0.0012354005657782263,
"scoreError" : 0.005906342113595657,
"scoreConfidence" : [
-0.004670941547817431,
0.007141742679373884
],
"scorePercentiles" : {
"0.0" : 0.0,
"50.0" : 0.0,
"90.0" : 0.011118605092004042,
"95.0" : 0.012354005657782264,
"99.0" : 0.012354005657782264,
"99.9" : 0.012354005657782264,
"99.99" : 0.012354005657782264,
"99.999" : 0.012354005657782264,
"99.9999" : 0.012354005657782264,
"100.0" : 0.012354005657782264
},
"scoreUnit" : "MB/sec",
"rawData" : [
[
0.012354005657782264
]
]
},
"·gc.churn.G1_Old_Gen.norm" : {
"score" : 2061.6,
"scoreError" : 9856.329387155782,
"scoreConfidence" : [
-7794.729387155781,
11917.929387155782
],
"scorePercentiles" : {
"0.0" : 0.0,
"50.0" : 0.0,
"90.0" : 18554.40000000001,
"95.0" : 20616.0,
"99.0" : 20616.0,
"99.9" : 20616.0,
"99.99" : 20616.0,
"99.999" : 20616.0,
"99.9999" : 20616.0,
"100.0" : 20616.0
},
"scoreUnit" : "B/op",
"rawData" : [
[
20616.0
]
]
},
"·gc.count" : {
"score" : 1.0,
"scoreError" : "NaN",
"scoreConfidence" : [
1.0,
1.0
],
"scorePercentiles" : {
"0.0" : 0.0,
"50.0" : 0.0,
"90.0" : 0.9000000000000004,
"95.0" : 1.0,
"99.0" : 1.0,
"99.9" : 1.0,
"99.99" : 1.0,
"99.999" : 1.0,
"99.9999" : 1.0,
"100.0" : 1.0
},
"scoreUnit" : "counts",
"rawData" : [
[
0.0,
0.0,
0.0,
0.0,
0.0,
0.0,
1.0,
0.0,
0.0,
0.0
]
]
},
"·gc.time" : {
"score" : 14.0,
"scoreError" : "NaN",
"scoreConfidence" : [
14.0,
14.0
],
"scorePercentiles" : {
"0.0" : 0.0,
"50.0" : 0.0,
"90.0" : 12.600000000000005,
"95.0" : 14.0,
"99.0" : 14.0,
"99.9" : 14.0,
"99.99" : 14.0,
"99.999" : 14.0,
"99.9999" : 14.0,
"100.0" : 14.0
},
"scoreUnit" : "ms",
"rawData" : [
[
14.0
]
]
}
}
},
{
"jmhVersion" : "1.20",
"benchmark" : "io.trino.operator.join.BenchmarkHashBuildAndJoinOperators.benchmarkJoinHash",
"mode" : "avgt",
"threads" : 1,
"forks" : 1,
"jvm" : "/local/home/pettja/.sdkman/candidates/java/11.0.12-zulu/bin/java",
"jvmArgs" : [
"-Xms8g",
"-Xmx8g",
"-XX:+AlwaysPreTouch",
"-XX:ReservedCodeCacheSize=256M"
],
"jdkVersion" : "11.0.12",
"vmVersion" : "11.0.12+7-LTS",
"warmupIterations" : 5,
"warmupTime" : "1 s",
"warmupBatchSize" : 1,
"measurementIterations" : 10,
"measurementTime" : "2 s",
"measurementBatchSize" : 1,
"params" : {
"buildHashEnabled" : "true",
"buildRowsRepetition" : "5",
"hashColumns" : "bigint",
"matchRate" : "2",
"outputColumns" : "all",
"partitionCount" : "4"
},
"primaryMetric" : {
"score" : 1158.7126048,
"scoreError" : 7.54044594310153,
"scoreConfidence" : [
1151.1721588568985,
1166.2530507431015
],
"scorePercentiles" : {
"0.0" : 1152.114234,
"50.0" : 1158.6435535,
"90.0" : 1169.47656815,
"95.0" : 1170.518437,
"99.0" : 1170.518437,
"99.9" : 1170.518437,
"99.99" : 1170.518437,
"99.999" : 1170.518437,
"99.9999" : 1170.518437,
"100.0" : 1170.518437
},
"scoreUnit" : "ms/op",
"rawData" : [
[
1152.5883085,
1159.011638,
1160.0997485,
1159.034055,
1152.114234,
1157.926886,
1158.267475,
1170.518437,
1159.289797,
1158.275469
]
]
},
"secondaryMetrics" : {
"·gc.alloc.rate" : {
"score" : 193.6794651037329,
"scoreError" : 1.0371108680947205,
"scoreConfidence" : [
192.64235423563818,
194.7165759718276
],
"scorePercentiles" : {
"0.0" : 192.06112202020566,
"50.0" : 193.6865793717402,
"90.0" : 194.5904227519659,
"95.0" : 194.59827363820955,
"99.0" : 194.59827363820955,
"99.9" : 194.59827363820955,
"99.99" : 194.59827363820955,
"99.999" : 194.59827363820955,
"99.9999" : 194.59827363820955,
"100.0" : 194.59827363820955
},
"scoreUnit" : "MB/sec",
"rawData" : [
[
194.51976477577298,
193.63126234381792,
193.48578396051042,
193.6429064889599,
194.59827363820955,
193.78419697813996,
193.74452899279052,
192.06112202020566,
193.5965595844016,
193.73025225452054
]
]
},
"·gc.alloc.rate.norm" : {
"score" : 2.861584272E8,
"scoreError" : 82.31812751065108,
"scoreConfidence" : [
2.861583448818725E8,
2.861585095181275E8
],
"scorePercentiles" : {
"0.0" : 2.86158396E8,
"50.0" : 2.86158412E8,
"90.0" : 2.861585648E8,
"95.0" : 2.8615858E8,
"99.0" : 2.8615858E8,
"99.9" : 2.8615858E8,
"99.99" : 2.8615858E8,
"99.999" : 2.8615858E8,
"99.9999" : 2.8615858E8,
"100.0" : 2.8615858E8
},
"scoreUnit" : "B/op",
"rawData" : [
[
2.86158412E8,
2.86158412E8,
2.86158428E8,
2.86158412E8,
2.86158412E8,
2.86158412E8,
2.8615858E8,
2.86158412E8,
2.86158396E8,
2.86158396E8
]
]
},
"·gc.churn.G1_Eden_Space" : {
"score" : 147.51090795923568,
"scoreError" : 705.23675642445,
"scoreConfidence" : [
-557.7258484652143,
852.7476643836858
],
"scorePercentiles" : {
"0.0" : 0.0,
"50.0" : 0.0,
"90.0" : 1327.5981716331216,
"95.0" : 1475.1090795923567,
"99.0" : 1475.1090795923567,
"99.9" : 1475.1090795923567,
"99.99" : 1475.1090795923567,
"99.999" : 1475.1090795923567,
"99.9999" : 1475.1090795923567,
"100.0" : 1475.1090795923567
},
"scoreUnit" : "MB/sec",
"rawData" : [
[
1475.1090795923567
]
]
},
"·gc.churn.G1_Eden_Space.norm" : {
"score" : 2.197815296E8,
"scoreError" : 1.0507562810198529E9,
"scoreConfidence" : [
-8.309747514198529E8,
1.2705378106198528E9
],
"scorePercentiles" : {
"0.0" : 0.0,
"50.0" : 0.0,
"90.0" : 1.9780337664000008E9,
"95.0" : 2.197815296E9,
"99.0" : 2.197815296E9,
"99.9" : 2.197815296E9,
"99.99" : 2.197815296E9,
"99.999" : 2.197815296E9,
"99.9999" : 2.197815296E9,
"100.0" : 2.197815296E9
},
"scoreUnit" : "B/op",
"rawData" : [
[
2.197815296E9
]
]
},
"·gc.count" : {
"score" : 1.0,
"scoreError" : "NaN",
"scoreConfidence" : [
1.0,
1.0
],
"scorePercentiles" : {
"0.0" : 0.0,
"50.0" : 0.0,
"90.0" : 0.9000000000000004,
"95.0" : 1.0,
"99.0" : 1.0,
"99.9" : 1.0,
"99.99" : 1.0,
"99.999" : 1.0,
"99.9999" : 1.0,
"100.0" : 1.0
},
"scoreUnit" : "counts",
"rawData" : [
[
0.0,
0.0,
0.0,
0.0,
0.0,
0.0,
0.0,
1.0,
0.0,
0.0
]
]
},
"·gc.time" : {
"score" : 13.0,
"scoreError" : "NaN",
"scoreConfidence" : [
13.0,
13.0
],
"scorePercentiles" : {
"0.0" : 0.0,
"50.0" : 0.0,
"90.0" : 11.700000000000005,
"95.0" : 13.0,
"99.0" : 13.0,
"99.9" : 13.0,
"99.99" : 13.0,
"99.999" : 13.0,
"99.9999" : 13.0,
"100.0" : 13.0
},
"scoreUnit" : "ms",
"rawData" : [
[
13.0
]
]
}
}
},
{
"jmhVersion" : "1.20",
"benchmark" : "io.trino.operator.join.BenchmarkHashBuildAndJoinOperators.benchmarkJoinHash",
"mode" : "avgt",
"threads" : 1,
"forks" : 1,
"jvm" : "/local/home/pettja/.sdkman/candidates/java/11.0.12-zulu/bin/java",
"jvmArgs" : [
"-Xms8g",
"-Xmx8g",
"-XX:+AlwaysPreTouch",
"-XX:ReservedCodeCacheSize=256M"
],
"jdkVersion" : "11.0.12",
"vmVersion" : "11.0.12+7-LTS",
"warmupIterations" : 5,
"warmupTime" : "1 s",
"warmupBatchSize" : 1,
"measurementIterations" : 10,
"measurementTime" : "2 s",
"measurementBatchSize" : 1,
"params" : {
"buildHashEnabled" : "true",
"buildRowsRepetition" : "5",
"hashColumns" : "all",
"matchRate" : "0.1",
"outputColumns" : "all",
"partitionCount" : "4"
},
"primaryMetric" : {
"score" : 448.06526554000004,
"scoreError" : 4.378434245128628,
"scoreConfidence" : [
443.6868312948714,
452.4436997851287
],
"scorePercentiles" : {
"0.0" : 442.5332106,
"50.0" : 447.8063763,
"90.0" : 452.78811872,
"95.0" : 452.9496242,
"99.0" : 452.9496242,
"99.9" : 452.9496242,
"99.99" : 452.9496242,
"99.999" : 452.9496242,
"99.9999" : 452.9496242,
"100.0" : 452.9496242
},
"scoreUnit" : "ms/op",
"rawData" : [
[
452.9496242,
448.1562684,
447.0074284,
446.6676014,
450.0777924,
451.3345694,
447.8347906,
447.777962,
446.313408,
442.5332106
]
]
},
"secondaryMetrics" : {
"·gc.alloc.rate" : {
"score" : 55.545661358833925,
"scoreError" : 0.4434265537010256,
"scoreConfidence" : [
55.1022348051329,
55.98908791253495
],
"scorePercentiles" : {
"0.0" : 55.05432612421427,
"50.0" : 55.568790656495466,
"90.0" : 56.07038904110393,
"95.0" : 56.10895558478326,
"99.0" : 56.10895558478326,
"99.9" : 56.10895558478326,
"99.99" : 56.10895558478326,
"99.999" : 56.10895558478326,
"99.9999" : 56.10895558478326,
"100.0" : 56.10895558478326
},
"scoreUnit" : "MB/sec",
"rawData" : [
[
55.05432612421427,
55.538310896211804,
55.65167580773009,
55.68721147285914,
55.340382565576945,
55.21487967598293,
55.5678435538459,
55.569737759145035,
55.72329014798995,
56.10895558478326
]
]
},
"·gc.alloc.rate.norm" : {
"score" : 3.1928613440000005E7,
"scoreError" : 33.366614260346935,
"scoreConfidence" : [
3.1928580073385745E7,
3.1928646806614265E7
],
"scorePercentiles" : {
"0.0" : 3.19286016E7,
"50.0" : 3.1928608E7,
"90.0" : 3.192866912E7,
"95.0" : 3.19286752E7,
"99.0" : 3.19286752E7,
"99.9" : 3.19286752E7,
"99.99" : 3.19286752E7,
"99.999" : 3.19286752E7,
"99.9999" : 3.19286752E7,
"100.0" : 3.19286752E7
},
"scoreUnit" : "B/op",
"rawData" : [
[
3.19286752E7,
3.19286144E7,
3.1928608E7,
3.1928608E7,
3.1928608E7,
3.1928608E7,
3.19286016E7,
3.1928608E7,
3.19286016E7,
3.19286016E7
]
]
},
"·gc.churn.G1_Eden_Space" : {
"score" : 43.08464260846867,
"scoreError" : 205.98391010717592,
"scoreConfidence" : [
-162.89926749870725,
249.06855271564459
],
"scorePercentiles" : {
"0.0" : 0.0,
"50.0" : 0.0,
"90.0" : 387.76178347621817,
"95.0" : 430.8464260846867,
"99.0" : 430.8464260846867,
"99.9" : 430.8464260846867,
"99.99" : 430.8464260846867,
"99.999" : 430.8464260846867,
"99.9999" : 430.8464260846867,
"100.0" : 430.8464260846867
},
"scoreUnit" : "MB/sec",
"rawData" : [
[
430.8464260846867
]
]
},
"·gc.churn.G1_Eden_Space.norm" : {
"score" : 2.4914165759999998E7,
"scoreError" : 1.1911244864996041E8,
"scoreConfidence" : [
-9.419828288996041E7,
1.4402661440996042E8
],
"scorePercentiles" : {
"0.0" : 0.0,
"50.0" : 0.0,
"90.0" : 2.242274918400001E8,
"95.0" : 2.491416576E8,
"99.0" : 2.491416576E8,
"99.9" : 2.491416576E8,
"99.99" : 2.491416576E8,
"99.999" : 2.491416576E8,
"99.9999" : 2.491416576E8,
"100.0" : 2.491416576E8
},
"scoreUnit" : "B/op",
"rawData" : [
[
2.491416576E8
]
]
},
"·gc.churn.G1_Old_Gen" : {
"score" : 0.015673754591520705,
"scoreError" : 0.07493485059539841,
"scoreConfidence" : [
-0.0592610960038777,
0.09060860518691911
],
"scorePercentiles" : {
"0.0" : 0.0,
"50.0" : 0.0,
"90.0" : 0.1410637913236864,
"95.0" : 0.15673754591520705,
"99.0" : 0.15673754591520705,
"99.9" : 0.15673754591520705,
"99.99" : 0.15673754591520705,
"99.999" : 0.15673754591520705,
"99.9999" : 0.15673754591520705,
"100.0" : 0.15673754591520705
},
"scoreUnit" : "MB/sec",
"rawData" : [
[
0.15673754591520705
]
]
},
"·gc.churn.G1_Old_Gen.norm" : {
"score" : 9063.52,
"scoreError" : 43331.89684083922,
"scoreConfidence" : [
-34268.37684083922,
52395.416840839214
],
"scorePercentiles" : {
"0.0" : 0.0,
"50.0" : 0.0,
"90.0" : 81571.68000000004,
"95.0" : 90635.2,
"99.0" : 90635.2,
"99.9" : 90635.2,
"99.99" : 90635.2,
"99.999" : 90635.2,
"99.9999" : 90635.2,
"100.0" : 90635.2
},
"scoreUnit" : "B/op",
"rawData" : [
[
90635.2
]
]
},
"·gc.churn.G1_Survivor_Space" : {
"score" : 0.4351984101865522,
"scoreError" : 2.08064555663814,
"scoreConfidence" : [
-1.6454471464515878,
2.515843966824692
],
"scorePercentiles" : {
"0.0" : 0.0,
"50.0" : 0.0,
"90.0" : 3.9167856916789714,
"95.0" : 4.351984101865522,
"99.0" : 4.351984101865522,
"99.9" : 4.351984101865522,
"99.99" : 4.351984101865522,
"99.999" : 4.351984101865522,
"99.9999" : 4.351984101865522,
"100.0" : 4.351984101865522
},
"scoreUnit" : "MB/sec",
"rawData" : [
[
4.351984101865522
]
]
},
"·gc.churn.G1_Survivor_Space.norm" : {
"score" : 251658.24,
"scoreError" : 1203156.0469692966,
"scoreConfidence" : [
-951497.8069692967,
1454814.2869692966
],
"scorePercentiles" : {
"0.0" : 0.0,
"50.0" : 0.0,
"90.0" : 2264924.1600000006,
"95.0" : 2516582.4,
"99.0" : 2516582.4,
"99.9" : 2516582.4,
"99.99" : 2516582.4,
"99.999" : 2516582.4,
"99.9999" : 2516582.4,
"100.0" : 2516582.4
},
"scoreUnit" : "B/op",
"rawData" : [
[
2516582.4
]
]
},
"·gc.count" : {
"score" : 1.0,
"scoreError" : "NaN",
"scoreConfidence" : [
1.0,
1.0
],
"scorePercentiles" : {
"0.0" : 0.0,
"50.0" : 0.0,
"90.0" : 0.9000000000000004,
"95.0" : 1.0,
"99.0" : 1.0,
"99.9" : 1.0,
"99.99" : 1.0,
"99.999" : 1.0,
"99.9999" : 1.0,
"100.0" : 1.0
},
"scoreUnit" : "counts",
"rawData" : [
[
0.0,
0.0,
0.0,
0.0,
0.0,
1.0,
0.0,
0.0,
0.0,
0.0
]
]
},
"·gc.time" : {
"score" : 4.0,
"scoreError" : "NaN",
"scoreConfidence" : [
4.0,
4.0
],
"scorePercentiles" : {
"0.0" : 0.0,
"50.0" : 0.0,
"90.0" : 3.6000000000000014,
"95.0" : 4.0,
"99.0" : 4.0,
"99.9" : 4.0,
"99.99" : 4.0,
"99.999" : 4.0,
"99.9999" : 4.0,
"100.0" : 4.0
},
"scoreUnit" : "ms",
"rawData" : [
[
4.0
]
]
}
}
},
{
"jmhVersion" : "1.20",
"benchmark" : "io.trino.operator.join.BenchmarkHashBuildAndJoinOperators.benchmarkJoinHash",
"mode" : "avgt",
"threads" : 1,
"forks" : 1,
"jvm" : "/local/home/pettja/.sdkman/candidates/java/11.0.12-zulu/bin/java",
"jvmArgs" : [
"-Xms8g",
"-Xmx8g",
"-XX:+AlwaysPreTouch",
"-XX:ReservedCodeCacheSize=256M"
],
"jdkVersion" : "11.0.12",
"vmVersion" : "11.0.12+7-LTS",
"warmupIterations" : 5,
"warmupTime" : "1 s",
"warmupBatchSize" : 1,
"measurementIterations" : 10,
"measurementTime" : "2 s",
"measurementBatchSize" : 1,
"params" : {
"buildHashEnabled" : "true",
"buildRowsRepetition" : "5",
"hashColumns" : "all",
"matchRate" : "1",
"outputColumns" : "all",
"partitionCount" : "4"
},
"primaryMetric" : {
"score" : 1363.6721626500002,
"scoreError" : 6.244935106201501,
"scoreConfidence" : [
1357.4272275437988,
1369.9170977562017
],
"scorePercentiles" : {
"0.0" : 1356.29994,
"50.0" : 1364.39106,
"90.0" : 1368.5425229,
"95.0" : 1368.5886295,
"99.0" : 1368.5886295,
"99.9" : 1368.5886295,
"99.99" : 1368.5886295,
"99.999" : 1368.5886295,
"99.9999" : 1368.5886295,
"100.0" : 1368.5886295
},
"scoreUnit" : "ms/op",
"rawData" : [
[
1366.215595,
1359.1952035,
1366.584095,
1363.6495955,
1368.1275635,
1368.5886295,
1359.425485,
1365.1325245,
1363.502995,
1356.29994
]
]
},
"secondaryMetrics" : {
"·gc.alloc.rate" : {
"score" : 169.0911573221073,
"scoreError" : 0.6575986707399839,
"scoreConfidence" : [
168.43355865136732,
169.7487559928473
],
"scorePercentiles" : {
"0.0" : 168.5789205678778,
"50.0" : 169.01733455265327,
"90.0" : 169.8398717308462,
"95.0" : 169.87097008878683,
"99.0" : 169.87097008878683,
"99.9" : 169.87097008878683,
"99.99" : 169.87097008878683,
"99.999" : 169.87097008878683,
"99.9999" : 169.87097008878683,
"100.0" : 169.87097008878683
},
"scoreUnit" : "MB/sec",
"rawData" : [
[
168.8234777635694,
169.55998650938048,
168.77356661958981,
169.0939174049099,
168.6253704496636,
168.5789205678778,
169.53847764319747,
168.94075170039667,
169.1061344737012,
169.87097008878683
]
]
},
"·gc.alloc.rate.norm" : {
"score" : 2.861695568E8,
"scoreError" : 81.92226983060615,
"scoreConfidence" : [
2.861694748777302E8,
2.8616963872226983E8
],
"scorePercentiles" : {
"0.0" : 2.86169524E8,
"50.0" : 2.8616954E8,
"90.0" : 2.861696928E8,
"95.0" : 2.86169708E8,
"99.0" : 2.86169708E8,
"99.9" : 2.86169708E8,
"99.99" : 2.86169708E8,
"99.999" : 2.86169708E8,
"99.9999" : 2.86169708E8,
"100.0" : 2.86169708E8
},
"scoreUnit" : "B/op",
"rawData" : [
[
2.86169556E8,
2.8616954E8,
2.86169556E8,
2.86169524E8,
2.86169708E8,
2.8616954E8,
2.8616954E8,
2.8616954E8,
2.8616954E8,
2.86169524E8
]
]
},
"·gc.churn.G1_Eden_Space" : {
"score" : 74.6390501489098,
"scoreError" : 356.8427742588736,
"scoreConfidence" : [
-282.2037241099638,
431.4818244077834
],
"scorePercentiles" : {
"0.0" : 0.0,
"50.0" : 0.0,
"90.0" : 671.7514513401885,
"95.0" : 746.390501489098,
"99.0" : 746.390501489098,
"99.9" : 746.390501489098,
"99.99" : 746.390501489098,
"99.999" : 746.390501489098,
"99.9999" : 746.390501489098,
"100.0" : 746.390501489098
},
"scoreUnit" : "MB/sec",
"rawData" : [
[
746.390501489098
]
]
},
"·gc.churn.G1_Eden_Space.norm" : {
"score" : 1.266679808E8,
"scoreError" : 6.055885436412125E8,
"scoreConfidence" : [
-4.7892056284121245E8,
7.322565244412124E8
],
"scorePercentiles" : {
"0.0" : 0.0,
"50.0" : 0.0,
"90.0" : 1.1400118272000005E9,
"95.0" : 1.266679808E9,
"99.0" : 1.266679808E9,
"99.9" : 1.266679808E9,
"99.99" : 1.266679808E9,
"99.999" : 1.266679808E9,
"99.9999" : 1.266679808E9,
"100.0" : 1.266679808E9
},
"scoreUnit" : "B/op",
"rawData" : [
[
1.266679808E9
]
]
},
"·gc.churn.G1_Survivor_Space" : {
"score" : 1.730044208749565,
"scoreError" : 8.271190131828195,
"scoreConfidence" : [
-6.541145923078631,
10.00123434057776
],
"scorePercentiles" : {
"0.0" : 0.0,
"50.0" : 0.0,
"90.0" : 15.57039787874609,
"95.0" : 17.30044208749565,
"99.0" : 17.30044208749565,
"99.9" : 17.30044208749565,
"99.99" : 17.30044208749565,
"99.999" : 17.30044208749565,
"99.9999" : 17.30044208749565,
"100.0" : 17.30044208749565
},
"scoreUnit" : "MB/sec",
"rawData" : [
[
17.30044208749565
]
]
},
"·gc.churn.G1_Survivor_Space.norm" : {
"score" : 2936012.8,
"scoreError" : 1.4036820547975132E7,
"scoreConfidence" : [
-1.1100807747975133E7,
1.697283334797513E7
],
"scorePercentiles" : {
"0.0" : 0.0,
"50.0" : 0.0,
"90.0" : 2.642411520000001E7,
"95.0" : 2.9360128E7,
"99.0" : 2.9360128E7,
"99.9" : 2.9360128E7,
"99.99" : 2.9360128E7,
"99.999" : 2.9360128E7,
"99.9999" : 2.9360128E7,
"100.0" : 2.9360128E7
},
"scoreUnit" : "B/op",
"rawData" : [
[
2.9360128E7
]
]
},
"·gc.count" : {
"score" : 1.0,
"scoreError" : "NaN",
"scoreConfidence" : [
1.0,
1.0
],
"scorePercentiles" : {
"0.0" : 0.0,
"50.0" : 0.0,
"90.0" : 0.9000000000000004,
"95.0" : 1.0,
"99.0" : 1.0,
"99.9" : 1.0,
"99.99" : 1.0,
"99.999" : 1.0,
"99.9999" : 1.0,
"100.0" : 1.0
},
"scoreUnit" : "counts",
"rawData" : [
[
0.0,
0.0,
0.0,
0.0,
1.0,
0.0,
0.0,
0.0,
0.0,
0.0
]
]
},
"·gc.time" : {
"score" : 6.0,
"scoreError" : "NaN",
"scoreConfidence" : [
6.0,
6.0
],
"scorePercentiles" : {
"0.0" : 0.0,
"50.0" : 0.0,
"90.0" : 5.400000000000002,
"95.0" : 6.0,
"99.0" : 6.0,
"99.9" : 6.0,
"99.99" : 6.0,
"99.999" : 6.0,
"99.9999" : 6.0,
"100.0" : 6.0
},
"scoreUnit" : "ms",
"rawData" : [
[
6.0
]
]
}
}
},
{
"jmhVersion" : "1.20",
"benchmark" : "io.trino.operator.join.BenchmarkHashBuildAndJoinOperators.benchmarkJoinHash",
"mode" : "avgt",
"threads" : 1,
"forks" : 1,
"jvm" : "/local/home/pettja/.sdkman/candidates/java/11.0.12-zulu/bin/java",
"jvmArgs" : [
"-Xms8g",
"-Xmx8g",
"-XX:+AlwaysPreTouch",
"-XX:ReservedCodeCacheSize=256M"
],
"jdkVersion" : "11.0.12",
"vmVersion" : "11.0.12+7-LTS",
"warmupIterations" : 5,
"warmupTime" : "1 s",
"warmupBatchSize" : 1,
"measurementIterations" : 10,
"measurementTime" : "2 s",
"measurementBatchSize" : 1,
"params" : {
"buildHashEnabled" : "true",
"buildRowsRepetition" : "5",
"hashColumns" : "all",
"matchRate" : "2",
"outputColumns" : "all",
"partitionCount" : "4"
},
"primaryMetric" : {
"score" : 1242.3987571,
"scoreError" : 61.062099595658005,
"scoreConfidence" : [
1181.336657504342,
1303.460856695658
],
"scorePercentiles" : {
"0.0" : 1224.229793,
"50.0" : 1229.89303825,
"90.0" : 1344.8126854500001,
"95.0" : 1357.0040465,
"99.0" : 1357.0040465,
"99.9" : 1357.0040465,
"99.99" : 1357.0040465,
"99.999" : 1357.0040465,
"99.9999" : 1357.0040465,
"100.0" : 1357.0040465
},
"scoreUnit" : "ms/op",
"rawData" : [
[
1228.930757,
1226.9108725,
1357.0040465,
1232.5593105,
1232.0798605,
1230.8553195,
1224.229793,
1235.090436,
1227.7679875,
1228.559188
]
]
},
"secondaryMetrics" : {
"·gc.alloc.rate" : {
"score" : 182.93691395855726,
"scoreError" : 7.012920163812802,
"scoreConfidence" : [
175.92399379474446,
189.94983412237005
],
"scorePercentiles" : {
"0.0" : 169.78148821603207,
"50.0" : 184.36917002218314,
"90.0" : 185.0494673617613,
"95.0" : 185.08460018374245,
"99.0" : 185.08460018374245,
"99.9" : 185.08460018374245,
"99.99" : 185.08460018374245,
"99.999" : 185.08460018374245,
"99.9999" : 185.08460018374245,
"100.0" : 185.08460018374245
},
"scoreUnit" : "MB/sec",
"rawData" : [
[
184.48087098803728,
184.73327196393092,
169.78148821603207,
184.04059699999058,
184.10196881733657,
184.257469056329,
185.08460018374245,
183.72287366327208,
184.63675067600278,
184.52924902089876
]
]
},
"·gc.alloc.rate.norm" : {
"score" : 2.861697248E8,
"scoreError" : 89.86985351096934,
"scoreConfidence" : [
2.861696349301465E8,
2.861698146698535E8
],
"scorePercentiles" : {
"0.0" : 2.86169692E8,
"50.0" : 2.86169708E8,
"90.0" : 2.861698752E8,
"95.0" : 2.86169892E8,
"99.0" : 2.86169892E8,
"99.9" : 2.86169892E8,
"99.99" : 2.86169892E8,
"99.999" : 2.86169892E8,
"99.9999" : 2.86169892E8,
"100.0" : 2.86169892E8
},
"scoreUnit" : "B/op",
"rawData" : [
[
2.86169708E8,
2.86169708E8,
2.86169708E8,
2.86169724E8,
2.86169692E8,
2.86169892E8,
2.86169708E8,
2.86169708E8,
2.86169692E8,
2.86169708E8
]
]
},
"·gc.churn.G1_Eden_Space" : {
"score" : 46.90702990683451,
"scoreError" : 224.25840965023676,
"scoreConfidence" : [
-177.35137974340225,
271.1654395570713
],
"scorePercentiles" : {
"0.0" : 0.0,
"50.0" : 0.0,
"90.0" : 422.16326916151075,
"95.0" : 469.0702990683451,
"99.0" : 469.0702990683451,
"99.9" : 469.0702990683451,
"99.99" : 469.0702990683451,
"99.999" : 469.0702990683451,
"99.9999" : 469.0702990683451,
"100.0" : 469.0702990683451
},
"scoreUnit" : "MB/sec",
"rawData" : [
[
469.0702990683451
]
]
},
"·gc.churn.G1_Eden_Space.norm" : {
"score" : 7.90626304E7,
"scoreError" : 3.779915247561873E8,
"scoreConfidence" : [
-2.9892889435618734E8,
4.570541551561873E8
],
"scorePercentiles" : {
"0.0" : 0.0,
"50.0" : 0.0,
"90.0" : 7.115636736000003E8,
"95.0" : 7.90626304E8,
"99.0" : 7.90626304E8,
"99.9" : 7.90626304E8,
"99.99" : 7.90626304E8,
"99.999" : 7.90626304E8,
"99.9999" : 7.90626304E8,
"100.0" : 7.90626304E8
},
"scoreUnit" : "B/op",
"rawData" : [
[
7.90626304E8
]
]
},
"·gc.churn.G1_Survivor_Space" : {
"score" : 3.8570767297397075,
"scoreError" : 18.44034668211495,
"scoreConfidence" : [
-14.583269952375241,
22.297423411854655
],
"scorePercentiles" : {
"0.0" : 0.0,
"50.0" : 0.0,
"90.0" : 34.71369056765738,
"95.0" : 38.570767297397076,
"99.0" : 38.570767297397076,
"99.9" : 38.570767297397076,
"99.99" : 38.570767297397076,
"99.999" : 38.570767297397076,
"99.9999" : 38.570767297397076,
"100.0" : 38.570767297397076
},
"scoreUnit" : "MB/sec",
"rawData" : [
[
38.570767297397076
]
]
},
"·gc.churn.G1_Survivor_Space.norm" : {
"score" : 6501171.2,
"scoreError" : 3.10815312133735E7,
"scoreConfidence" : [
-2.45803600133735E7,
3.75827024133735E7
],
"scorePercentiles" : {
"0.0" : 0.0,
"50.0" : 0.0,
"90.0" : 5.851054080000003E7,
"95.0" : 6.5011712E7,
"99.0" : 6.5011712E7,
"99.9" : 6.5011712E7,
"99.99" : 6.5011712E7,
"99.999" : 6.5011712E7,
"99.9999" : 6.5011712E7,
"100.0" : 6.5011712E7
},
"scoreUnit" : "B/op",
"rawData" : [
[
6.5011712E7
]
]
},
"·gc.count" : {
"score" : 1.0,
"scoreError" : "NaN",
"scoreConfidence" : [
1.0,
1.0
],
"scorePercentiles" : {
"0.0" : 0.0,
"50.0" : 0.0,
"90.0" : 0.9000000000000004,
"95.0" : 1.0,
"99.0" : 1.0,
"99.9" : 1.0,
"99.99" : 1.0,
"99.999" : 1.0,
"99.9999" : 1.0,
"100.0" : 1.0
},
"scoreUnit" : "counts",
"rawData" : [
[
0.0,
0.0,
1.0,
0.0,
0.0,
0.0,
0.0,
0.0,
0.0,
0.0
]
]
},
"·gc.time" : {
"score" : 2.0,
"scoreError" : "NaN",
"scoreConfidence" : [
2.0,
2.0
],
"scorePercentiles" : {
"0.0" : 0.0,
"50.0" : 0.0,
"90.0" : 1.8000000000000007,
"95.0" : 2.0,
"99.0" : 2.0,
"99.9" : 2.0,
"99.99" : 2.0,
"99.999" : 2.0,
"99.9999" : 2.0,
"100.0" : 2.0
},
"scoreUnit" : "ms",
"rawData" : [
[
2.0
]
]
}
}
}
]
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment