Skip to content

Instantly share code, notes, and snippets.

@pettyjamesm
Created August 27, 2021 23:14
Show Gist options
  • Save pettyjamesm/7915122e54d7ced83b824ab062aea2cf to your computer and use it in GitHub Desktop.
Save pettyjamesm/7915122e54d7ced83b824ab062aea2cf to your computer and use it in GitHub Desktop.
PrestoDB InterpretedHashGenerator
[
{
"jmhVersion" : "1.20",
"benchmark" : "com.facebook.presto.operator.BenchmarkGroupByHash.benchmarkHashPosition",
"mode" : "avgt",
"threads" : 1,
"forks" : 1,
"jvm" : "/local/home/pettja/.sdkman/candidates/java/8.0.265-amzn/jre/bin/java",
"jvmArgs" : [
"-Xms8g",
"-Xmx8g",
"-XX:+AlwaysPreTouch",
"-XX:ReservedCodeCacheSize=256M"
],
"jdkVersion" : "1.8.0_265",
"vmVersion" : "25.265-b01",
"warmupIterations" : 8,
"warmupTime" : "500 ms",
"warmupBatchSize" : 1,
"measurementIterations" : 8,
"measurementTime" : "500 ms",
"measurementBatchSize" : 1,
"params" : {
"channelCount" : "2",
"dataType" : "VARCHAR",
"groupByType" : "notDistinct",
"groupCount" : "3000000",
"hashEnabled" : "false"
},
"primaryMetric" : {
"score" : 19.559044441666664,
"scoreError" : 0.2844513773284033,
"scoreConfidence" : [
19.274593064338262,
19.843495818995066
],
"scorePercentiles" : {
"0.0" : 19.4199588,
"50.0" : 19.54259365,
"90.0" : 19.900567133333332,
"95.0" : 19.900567133333332,
"99.0" : 19.900567133333332,
"99.9" : 19.900567133333332,
"99.99" : 19.900567133333332,
"99.999" : 19.900567133333332,
"99.9999" : 19.900567133333332,
"100.0" : 19.900567133333332
},
"scoreUnit" : "ns/op",
"rawData" : [
[
19.5690509,
19.4199588,
19.4376199,
19.560539266666666,
19.900567133333332,
19.54021596666667,
19.544971333333333,
19.499432233333334
]
]
},
"secondaryMetrics" : {
"·gc.alloc.rate" : {
"score" : 210.55276596380614,
"scoreError" : 1.6388656321090438,
"scoreConfidence" : [
208.9139003316971,
212.19163159591517
],
"scorePercentiles" : {
"0.0" : 208.5895274476529,
"50.0" : 210.65147951669923,
"90.0" : 211.36651781454768,
"95.0" : 211.36651781454768,
"99.0" : 211.36651781454768,
"99.9" : 211.36651781454768,
"99.99" : 211.36651781454768,
"99.999" : 211.36651781454768,
"99.9999" : 211.36651781454768,
"100.0" : 211.36651781454768
},
"scoreUnit" : "MB/sec",
"rawData" : [
[
210.50939347791856,
211.36651781454768,
211.28001763124212,
210.54556348232902,
208.5895274476529,
210.66551164907003,
210.6374473843284,
210.8281488233604
]
]
},
"·gc.alloc.rate.norm" : {
"score" : 8.001499933333333,
"scoreError" : 2.773567393439786E-4,
"scoreConfidence" : [
8.001222576593989,
8.001777290072678
],
"scorePercentiles" : {
"0.0" : 8.001448,
"50.0" : 8.001448,
"90.0" : 8.001858933333333,
"95.0" : 8.001858933333333,
"99.0" : 8.001858933333333,
"99.9" : 8.001858933333333,
"99.99" : 8.001858933333333,
"99.999" : 8.001858933333333,
"99.9999" : 8.001858933333333,
"100.0" : 8.001858933333333
},
"scoreUnit" : "B/op",
"rawData" : [
[
8.001448,
8.001448,
8.001448,
8.001449066666666,
8.001451466666667,
8.001448,
8.001448,
8.001858933333333
]
]
},
"·gc.churn.PS_Eden_Space" : {
"score" : 233.31806432797055,
"scoreError" : 1261.7566818386395,
"scoreConfidence" : [
-1028.4386175106688,
1495.07474616661
],
"scorePercentiles" : {
"0.0" : 0.0,
"50.0" : 0.0,
"90.0" : 1866.5445146237644,
"95.0" : 1866.5445146237644,
"99.0" : 1866.5445146237644,
"99.9" : 1866.5445146237644,
"99.99" : 1866.5445146237644,
"99.999" : 1866.5445146237644,
"99.9999" : 1866.5445146237644,
"100.0" : 1866.5445146237644
},
"scoreUnit" : "MB/sec",
"rawData" : [
[
1866.5445146237644
]
]
},
"·gc.churn.PS_Eden_Space.norm" : {
"score" : 8.950033066666666,
"scoreError" : 48.40072738075447,
"scoreConfidence" : [
-39.4506943140878,
57.35076044742114
],
"scorePercentiles" : {
"0.0" : 0.0,
"50.0" : 0.0,
"90.0" : 71.60026453333333,
"95.0" : 71.60026453333333,
"99.0" : 71.60026453333333,
"99.9" : 71.60026453333333,
"99.99" : 71.60026453333333,
"99.999" : 71.60026453333333,
"99.9999" : 71.60026453333333,
"100.0" : 71.60026453333333
},
"scoreUnit" : "B/op",
"rawData" : [
[
71.60026453333333
]
]
},
"·gc.count" : {
"score" : 1.0,
"scoreError" : "NaN",
"scoreConfidence" : [
1.0,
1.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,
0.0,
0.0,
0.0,
1.0,
0.0,
0.0,
0.0
]
]
},
"·gc.time" : {
"score" : 9.0,
"scoreError" : "NaN",
"scoreConfidence" : [
9.0,
9.0
],
"scorePercentiles" : {
"0.0" : 0.0,
"50.0" : 0.0,
"90.0" : 9.0,
"95.0" : 9.0,
"99.0" : 9.0,
"99.9" : 9.0,
"99.99" : 9.0,
"99.999" : 9.0,
"99.9999" : 9.0,
"100.0" : 9.0
},
"scoreUnit" : "ms",
"rawData" : [
[
9.0
]
]
}
}
},
{
"jmhVersion" : "1.20",
"benchmark" : "com.facebook.presto.operator.BenchmarkGroupByHash.benchmarkHashPosition",
"mode" : "avgt",
"threads" : 1,
"forks" : 1,
"jvm" : "/local/home/pettja/.sdkman/candidates/java/8.0.265-amzn/jre/bin/java",
"jvmArgs" : [
"-Xms8g",
"-Xmx8g",
"-XX:+AlwaysPreTouch",
"-XX:ReservedCodeCacheSize=256M"
],
"jdkVersion" : "1.8.0_265",
"vmVersion" : "25.265-b01",
"warmupIterations" : 8,
"warmupTime" : "500 ms",
"warmupBatchSize" : 1,
"measurementIterations" : 8,
"measurementTime" : "500 ms",
"measurementBatchSize" : 1,
"params" : {
"channelCount" : "2",
"dataType" : "BIGINT",
"groupByType" : "notDistinct",
"groupCount" : "3000000",
"hashEnabled" : "false"
},
"primaryMetric" : {
"score" : 12.014546952499998,
"scoreError" : 0.291727206055754,
"scoreConfidence" : [
11.722819746444245,
12.306274158555752
],
"scorePercentiles" : {
"0.0" : 11.91362974,
"50.0" : 11.9384273,
"90.0" : 12.29326192,
"95.0" : 12.29326192,
"99.0" : 12.29326192,
"99.9" : 12.29326192,
"99.99" : 12.29326192,
"99.999" : 12.29326192,
"99.9999" : 12.29326192,
"100.0" : 12.29326192
},
"scoreUnit" : "ns/op",
"rawData" : [
[
11.91362974,
12.22560808,
11.9406105,
11.92675358,
11.9362441,
11.93094022,
12.29326192,
11.94932748
]
]
},
"secondaryMetrics" : {
"·gc.alloc.rate" : {
"score" : 346.5291997738449,
"scoreError" : 4.554546742824347,
"scoreConfidence" : [
341.9746530310205,
351.08374651666924
],
"scorePercentiles" : {
"0.0" : 342.196440552188,
"50.0" : 347.73057996244756,
"90.0" : 348.1271135259121,
"95.0" : 348.1271135259121,
"99.0" : 348.1271135259121,
"99.9" : 348.1271135259121,
"99.99" : 348.1271135259121,
"99.999" : 348.1271135259121,
"99.9999" : 348.1271135259121,
"100.0" : 348.1271135259121
},
"scoreUnit" : "MB/sec",
"rawData" : [
[
348.1271135259121,
343.21661037380363,
347.69951175226515,
347.9026839315894,
347.7616481726299,
347.84889660406935,
342.196440552188,
347.4806932783015
]
]
},
"·gc.alloc.rate.norm" : {
"score" : 8.002598200000001,
"scoreError" : 1.6641822108573115E-4,
"scoreConfidence" : [
8.002431781778915,
8.002764618221088
],
"scorePercentiles" : {
"0.0" : 8.00256704,
"50.0" : 8.00256704,
"90.0" : 8.0028136,
"95.0" : 8.0028136,
"99.0" : 8.0028136,
"99.9" : 8.0028136,
"99.99" : 8.0028136,
"99.999" : 8.0028136,
"99.9999" : 8.0028136,
"100.0" : 8.0028136
},
"scoreUnit" : "B/op",
"rawData" : [
[
8.00256704,
8.00256976,
8.00256704,
8.00256704,
8.00256704,
8.00256704,
8.00256704,
8.0028136
]
]
},
"·gc.churn.PS_Eden_Space" : {
"score" : 459.9375471925481,
"scoreError" : 1628.3147689773,
"scoreConfidence" : [
-1168.3772217847518,
2088.252316169848
],
"scorePercentiles" : {
"0.0" : 0.0,
"50.0" : 0.0,
"90.0" : 1842.4881630771315,
"95.0" : 1842.4881630771315,
"99.0" : 1842.4881630771315,
"99.9" : 1842.4881630771315,
"99.99" : 1842.4881630771315,
"99.999" : 1842.4881630771315,
"99.9999" : 1842.4881630771315,
"100.0" : 1842.4881630771315
},
"scoreUnit" : "MB/sec",
"rawData" : [
[
1842.4881630771315,
1837.0122144632533
]
]
},
"·gc.churn.PS_Eden_Space.norm" : {
"score" : 10.74003968,
"scoreError" : 38.022856613696405,
"scoreConfidence" : [
-27.282816933696402,
48.76289629369641
],
"scorePercentiles" : {
"0.0" : 0.0,
"50.0" : 0.0,
"90.0" : 42.96015872,
"95.0" : 42.96015872,
"99.0" : 42.96015872,
"99.9" : 42.96015872,
"99.99" : 42.96015872,
"99.999" : 42.96015872,
"99.9999" : 42.96015872,
"100.0" : 42.96015872
},
"scoreUnit" : "B/op",
"rawData" : [
[
42.96015872,
42.96015872
]
]
},
"·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,
0.0,
1.0,
0.0
]
]
},
"·gc.time" : {
"score" : 33.0,
"scoreError" : "NaN",
"scoreConfidence" : [
33.0,
33.0
],
"scorePercentiles" : {
"0.0" : 0.0,
"50.0" : 0.0,
"90.0" : 18.0,
"95.0" : 18.0,
"99.0" : 18.0,
"99.9" : 18.0,
"99.99" : 18.0,
"99.999" : 18.0,
"99.9999" : 18.0,
"100.0" : 18.0
},
"scoreUnit" : "ms",
"rawData" : [
[
15.0,
18.0
]
]
}
}
},
{
"jmhVersion" : "1.20",
"benchmark" : "com.facebook.presto.operator.BenchmarkGroupByHash.benchmarkHashPosition",
"mode" : "avgt",
"threads" : 1,
"forks" : 1,
"jvm" : "/local/home/pettja/.sdkman/candidates/java/8.0.265-amzn/jre/bin/java",
"jvmArgs" : [
"-Xms8g",
"-Xmx8g",
"-XX:+AlwaysPreTouch",
"-XX:ReservedCodeCacheSize=256M"
],
"jdkVersion" : "1.8.0_265",
"vmVersion" : "25.265-b01",
"warmupIterations" : 8,
"warmupTime" : "500 ms",
"warmupBatchSize" : 1,
"measurementIterations" : 8,
"measurementTime" : "500 ms",
"measurementBatchSize" : 1,
"params" : {
"channelCount" : "8",
"dataType" : "VARCHAR",
"groupByType" : "notDistinct",
"groupCount" : "3000000",
"hashEnabled" : "false"
},
"primaryMetric" : {
"score" : 71.2335729375,
"scoreError" : 2.74525030375492,
"scoreConfidence" : [
68.48832263374508,
73.97882324125491
],
"scorePercentiles" : {
"0.0" : 70.539719,
"50.0" : 70.75255285,
"90.0" : 74.7676431,
"95.0" : 74.7676431,
"99.0" : 74.7676431,
"99.9" : 74.7676431,
"99.99" : 74.7676431,
"99.999" : 74.7676431,
"99.9999" : 74.7676431,
"100.0" : 74.7676431
},
"scoreUnit" : "ns/op",
"rawData" : [
[
74.7676431,
70.968846,
70.8771991,
70.8172908,
70.6878149,
70.6333512,
70.5767194,
70.539719
]
]
},
"secondaryMetrics" : {
"·gc.alloc.rate" : {
"score" : 62.967462657551394,
"scoreError" : 1.3900984581958964,
"scoreConfidence" : [
61.5773641993555,
64.35756111574729
],
"scorePercentiles" : {
"0.0" : 61.17835219481247,
"50.0" : 63.21187058017143,
"90.0" : 63.3148452219503,
"95.0" : 63.3148452219503,
"99.0" : 63.3148452219503,
"99.9" : 63.3148452219503,
"99.99" : 63.3148452219503,
"99.999" : 63.3148452219503,
"99.9999" : 63.3148452219503,
"100.0" : 63.3148452219503
},
"scoreUnit" : "MB/sec",
"rawData" : [
[
61.17835219481247,
63.09782933394125,
63.14653832436974,
63.17528915946507,
63.24845200087778,
63.27564404312571,
63.30275098186886,
63.3148452219503
]
]
},
"·gc.alloc.rate.norm" : {
"score" : 8.006795700000001,
"scoreError" : 8.261104268406893E-4,
"scoreConfidence" : [
8.00596958957316,
8.007621810426842
],
"scorePercentiles" : {
"0.0" : 8.0066288,
"50.0" : 8.0066288,
"90.0" : 8.0078616,
"95.0" : 8.0078616,
"99.0" : 8.0078616,
"99.9" : 8.0078616,
"99.99" : 8.0078616,
"99.999" : 8.0078616,
"99.9999" : 8.0078616,
"100.0" : 8.0078616
},
"scoreUnit" : "B/op",
"rawData" : [
[
8.0066288,
8.006632,
8.0066288,
8.0066288,
8.0066288,
8.006728,
8.0066288,
8.0078616
]
]
},
"·gc.churn.PS_Eden_Space" : {
"score" : 205.1606070863748,
"scoreError" : 1109.484460994957,
"scoreConfidence" : [
-904.3238539085824,
1314.6450680813318
],
"scorePercentiles" : {
"0.0" : 0.0,
"50.0" : 0.0,
"90.0" : 1641.2848566909984,
"95.0" : 1641.2848566909984,
"99.0" : 1641.2848566909984,
"99.9" : 1641.2848566909984,
"99.99" : 1641.2848566909984,
"99.999" : 1641.2848566909984,
"99.9999" : 1641.2848566909984,
"100.0" : 1641.2848566909984
},
"scoreUnit" : "MB/sec",
"rawData" : [
[
1641.2848566909984
]
]
},
"·gc.churn.PS_Eden_Space.norm" : {
"score" : 26.8500992,
"scoreError" : 145.20218214226338,
"scoreConfidence" : [
-118.35208294226338,
172.05228134226337
],
"scorePercentiles" : {
"0.0" : 0.0,
"50.0" : 0.0,
"90.0" : 214.8007936,
"95.0" : 214.8007936,
"99.0" : 214.8007936,
"99.9" : 214.8007936,
"99.99" : 214.8007936,
"99.999" : 214.8007936,
"99.9999" : 214.8007936,
"100.0" : 214.8007936
},
"scoreUnit" : "B/op",
"rawData" : [
[
214.8007936
]
]
},
"·gc.count" : {
"score" : 1.0,
"scoreError" : "NaN",
"scoreConfidence" : [
1.0,
1.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" : [
[
1.0,
0.0,
0.0,
0.0,
0.0,
0.0,
0.0,
0.0
]
]
},
"·gc.time" : {
"score" : 30.0,
"scoreError" : "NaN",
"scoreConfidence" : [
30.0,
30.0
],
"scorePercentiles" : {
"0.0" : 0.0,
"50.0" : 0.0,
"90.0" : 30.0,
"95.0" : 30.0,
"99.0" : 30.0,
"99.9" : 30.0,
"99.99" : 30.0,
"99.999" : 30.0,
"99.9999" : 30.0,
"100.0" : 30.0
},
"scoreUnit" : "ms",
"rawData" : [
[
30.0
]
]
}
}
},
{
"jmhVersion" : "1.20",
"benchmark" : "com.facebook.presto.operator.BenchmarkGroupByHash.benchmarkHashPosition",
"mode" : "avgt",
"threads" : 1,
"forks" : 1,
"jvm" : "/local/home/pettja/.sdkman/candidates/java/8.0.265-amzn/jre/bin/java",
"jvmArgs" : [
"-Xms8g",
"-Xmx8g",
"-XX:+AlwaysPreTouch",
"-XX:ReservedCodeCacheSize=256M"
],
"jdkVersion" : "1.8.0_265",
"vmVersion" : "25.265-b01",
"warmupIterations" : 8,
"warmupTime" : "500 ms",
"warmupBatchSize" : 1,
"measurementIterations" : 8,
"measurementTime" : "500 ms",
"measurementBatchSize" : 1,
"params" : {
"channelCount" : "8",
"dataType" : "BIGINT",
"groupByType" : "notDistinct",
"groupCount" : "3000000",
"hashEnabled" : "false"
},
"primaryMetric" : {
"score" : 37.0007558875,
"scoreError" : 0.1156807358221462,
"scoreConfidence" : [
36.88507515167785,
37.116436623322144
],
"scorePercentiles" : {
"0.0" : 36.9117943,
"50.0" : 37.000515525,
"90.0" : 37.08381475,
"95.0" : 37.08381475,
"99.0" : 37.08381475,
"99.9" : 37.08381475,
"99.99" : 37.08381475,
"99.999" : 37.08381475,
"99.9999" : 37.08381475,
"100.0" : 37.08381475
},
"scoreUnit" : "ns/op",
"rawData" : [
[
36.97110305,
37.05551885,
37.08381475,
37.029928,
36.9117943,
37.0439548,
36.95834595,
36.9515874
]
]
},
"secondaryMetrics" : {
"·gc.alloc.rate" : {
"score" : 123.19263626505952,
"scoreError" : 0.22705619381249373,
"scoreConfidence" : [
122.96558007124703,
123.419692458872
],
"scorePercentiles" : {
"0.0" : 123.02932537243716,
"50.0" : 123.19570516499456,
"90.0" : 123.36877908833179,
"95.0" : 123.36877908833179,
"99.0" : 123.36877908833179,
"99.9" : 123.36877908833179,
"99.99" : 123.36877908833179,
"99.999" : 123.36877908833179,
"99.9999" : 123.36877908833179,
"100.0" : 123.36877908833179
},
"scoreUnit" : "MB/sec",
"rawData" : [
[
123.2560087754017,
123.07944276123303,
123.02932537243716,
123.13540155458743,
123.36877908833179,
123.11463170944381,
123.27789127725549,
123.27960958178578
]
]
},
"·gc.alloc.rate.norm" : {
"score" : 8.01193085,
"scoreError" : 4.165242128831054E-4,
"scoreConfidence" : [
8.011514325787118,
8.012347374212883
],
"scorePercentiles" : {
"0.0" : 8.0118536,
"50.0" : 8.0118536,
"90.0" : 8.01247,
"95.0" : 8.01247,
"99.0" : 8.01247,
"99.9" : 8.01247,
"99.99" : 8.01247,
"99.999" : 8.01247,
"99.9999" : 8.01247,
"100.0" : 8.01247
},
"scoreUnit" : "B/op",
"rawData" : [
[
8.0118536,
8.0118536,
8.0118536,
8.0118552,
8.0118536,
8.0118536,
8.0118536,
8.01247
]
]
},
"·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
]
]
}
}
},
{
"jmhVersion" : "1.20",
"benchmark" : "com.facebook.presto.operator.BenchmarkGroupByHash.benchmarkHashPosition",
"mode" : "avgt",
"threads" : 1,
"forks" : 1,
"jvm" : "/local/home/pettja/.sdkman/candidates/java/8.0.265-amzn/jre/bin/java",
"jvmArgs" : [
"-Xms8g",
"-Xmx8g",
"-XX:+AlwaysPreTouch",
"-XX:ReservedCodeCacheSize=256M"
],
"jdkVersion" : "1.8.0_265",
"vmVersion" : "25.265-b01",
"warmupIterations" : 8,
"warmupTime" : "500 ms",
"warmupBatchSize" : 1,
"measurementIterations" : 8,
"measurementTime" : "500 ms",
"measurementBatchSize" : 1,
"params" : {
"channelCount" : "15",
"dataType" : "VARCHAR",
"groupByType" : "notDistinct",
"groupCount" : "3000000",
"hashEnabled" : "false"
},
"primaryMetric" : {
"score" : 128.3464927375,
"scoreError" : 0.2396920693257066,
"scoreConfidence" : [
128.1068006681743,
128.5861848068257
],
"scorePercentiles" : {
"0.0" : 128.1682404,
"50.0" : 128.3943552,
"90.0" : 128.4829162,
"95.0" : 128.4829162,
"99.0" : 128.4829162,
"99.9" : 128.4829162,
"99.99" : 128.4829162,
"99.999" : 128.4829162,
"99.9999" : 128.4829162,
"100.0" : 128.4829162
},
"scoreUnit" : "ns/op",
"rawData" : [
[
128.4461248,
128.4829162,
128.1879056,
128.4467333,
128.1682404,
128.415106,
128.3736044,
128.2513112
]
]
},
"secondaryMetrics" : {
"·gc.alloc.rate" : {
"score" : 42.84307664773318,
"scoreError" : 0.05886013186942639,
"scoreConfidence" : [
42.784216515863754,
42.9019367796026
],
"scorePercentiles" : {
"0.0" : 42.810301737360305,
"50.0" : 42.831618505623084,
"90.0" : 42.886584670592605,
"95.0" : 42.886584670592605,
"99.0" : 42.886584670592605,
"99.9" : 42.886584670592605,
"99.99" : 42.886584670592605,
"99.999" : 42.886584670592605,
"99.9999" : 42.886584670592605,
"100.0" : 42.886584670592605
},
"scoreUnit" : "MB/sec",
"rawData" : [
[
42.81852311971505,
42.810301737360305,
42.88173853363189,
42.81712315429431,
42.886584670592605,
42.82633993426271,
42.83689707698345,
42.86710495502507
]
]
},
"·gc.alloc.rate.norm" : {
"score" : 8.0142501,
"scoreError" : 8.327412397288882E-4,
"scoreConfidence" : [
8.013417358760272,
8.015082841239728
],
"scorePercentiles" : {
"0.0" : 8.0140952,
"50.0" : 8.0140952,
"90.0" : 8.015328,
"95.0" : 8.015328,
"99.0" : 8.015328,
"99.9" : 8.015328,
"99.99" : 8.015328,
"99.999" : 8.015328,
"99.9999" : 8.015328,
"100.0" : 8.015328
},
"scoreUnit" : "B/op",
"rawData" : [
[
8.0140952,
8.0140984,
8.0140952,
8.0140952,
8.0140984,
8.0140952,
8.0140952,
8.015328
]
]
},
"·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
]
]
}
}
},
{
"jmhVersion" : "1.20",
"benchmark" : "com.facebook.presto.operator.BenchmarkGroupByHash.benchmarkHashPosition",
"mode" : "avgt",
"threads" : 1,
"forks" : 1,
"jvm" : "/local/home/pettja/.sdkman/candidates/java/8.0.265-amzn/jre/bin/java",
"jvmArgs" : [
"-Xms8g",
"-Xmx8g",
"-XX:+AlwaysPreTouch",
"-XX:ReservedCodeCacheSize=256M"
],
"jdkVersion" : "1.8.0_265",
"vmVersion" : "25.265-b01",
"warmupIterations" : 8,
"warmupTime" : "500 ms",
"warmupBatchSize" : 1,
"measurementIterations" : 8,
"measurementTime" : "500 ms",
"measurementBatchSize" : 1,
"params" : {
"channelCount" : "15",
"dataType" : "BIGINT",
"groupByType" : "notDistinct",
"groupCount" : "3000000",
"hashEnabled" : "false"
},
"primaryMetric" : {
"score" : 67.3988581875,
"scoreError" : 0.3158422776661647,
"scoreConfidence" : [
67.08301590983383,
67.71470046516616
],
"scorePercentiles" : {
"0.0" : 67.142009,
"50.0" : 67.46868365,
"90.0" : 67.5437287,
"95.0" : 67.5437287,
"99.0" : 67.5437287,
"99.9" : 67.5437287,
"99.99" : 67.5437287,
"99.999" : 67.5437287,
"99.9999" : 67.5437287,
"100.0" : 67.5437287
},
"scoreUnit" : "ns/op",
"rawData" : [
[
67.5083685,
67.5437287,
67.1437724,
67.5184832,
67.142009,
67.5069809,
67.4303864,
67.3971364
]
]
},
"secondaryMetrics" : {
"·gc.alloc.rate" : {
"score" : 65.16694112378073,
"scoreError" : 0.17921613409469175,
"scoreConfidence" : [
64.98772498968604,
65.34615725787542
],
"scorePercentiles" : {
"0.0" : 65.0802878355021,
"50.0" : 65.13049466889896,
"90.0" : 65.31422017118115,
"95.0" : 65.31422017118115,
"99.0" : 65.31422017118115,
"99.9" : 65.31422017118115,
"99.99" : 65.31422017118115,
"99.999" : 65.31422017118115,
"99.9999" : 65.31422017118115,
"100.0" : 65.31422017118115
},
"scoreUnit" : "MB/sec",
"rawData" : [
[
65.10654817548883,
65.0802878355021,
65.31422017118115,
65.09933520903127,
65.31026717093312,
65.10957097607034,
65.15141836172758,
65.1638810903114
]
]
},
"·gc.alloc.rate.norm" : {
"score" : 8.0254605,
"scoreError" : 8.333546964373765E-4,
"scoreConfidence" : [
8.024627145303562,
8.026293854696437
],
"scorePercentiles" : {
"0.0" : 8.0253064,
"50.0" : 8.0253064,
"90.0" : 8.0265392,
"95.0" : 8.0265392,
"99.0" : 8.0265392,
"99.9" : 8.0265392,
"99.99" : 8.0265392,
"99.999" : 8.0265392,
"99.9999" : 8.0265392,
"100.0" : 8.0265392
},
"scoreUnit" : "B/op",
"rawData" : [
[
8.0253064,
8.0253064,
8.0253064,
8.0253064,
8.0253064,
8.0253064,
8.0253064,
8.0265392
]
]
},
"·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
]
]
}
}
}
]
[
{
"jmhVersion" : "1.20",
"benchmark" : "com.facebook.presto.operator.BenchmarkGroupByHash.benchmarkHashPosition",
"mode" : "avgt",
"threads" : 1,
"forks" : 1,
"jvm" : "/local/home/pettja/.sdkman/candidates/java/8.0.265-amzn/jre/bin/java",
"jvmArgs" : [
"-Xms8g",
"-Xmx8g",
"-XX:+AlwaysPreTouch",
"-XX:ReservedCodeCacheSize=256M"
],
"jdkVersion" : "1.8.0_265",
"vmVersion" : "25.265-b01",
"warmupIterations" : 8,
"warmupTime" : "500 ms",
"warmupBatchSize" : 1,
"measurementIterations" : 8,
"measurementTime" : "500 ms",
"measurementBatchSize" : 1,
"params" : {
"channelCount" : "2",
"dataType" : "VARCHAR",
"groupByType" : "notDistinct",
"groupCount" : "3000000",
"hashEnabled" : "false"
},
"primaryMetric" : {
"score" : 15.505848878124999,
"scoreError" : 0.26405875955041985,
"scoreConfidence" : [
15.24179011857458,
15.769907637675418
],
"scorePercentiles" : {
"0.0" : 15.364363575,
"50.0" : 15.4671493125,
"90.0" : 15.821282825,
"95.0" : 15.821282825,
"99.0" : 15.821282825,
"99.9" : 15.821282825,
"99.99" : 15.821282825,
"99.999" : 15.821282825,
"99.9999" : 15.821282825,
"100.0" : 15.821282825
},
"scoreUnit" : "ns/op",
"rawData" : [
[
15.53422915,
15.821282825,
15.519110325,
15.477338925,
15.364363575,
15.42519745,
15.4569597,
15.448309075
]
]
},
"secondaryMetrics" : {
"·gc.alloc.rate" : {
"score" : 272.35453844102136,
"scoreError" : 2.5493265320268876,
"scoreConfidence" : [
269.80521190899447,
274.90386497304826
],
"scorePercentiles" : {
"0.0" : 269.3243079453918,
"50.0" : 272.7363127243257,
"90.0" : 273.7578737021776,
"95.0" : 273.7578737021776,
"99.0" : 273.7578737021776,
"99.9" : 273.7578737021776,
"99.99" : 273.7578737021776,
"99.999" : 273.7578737021776,
"99.9999" : 273.7578737021776,
"100.0" : 273.7578737021776
},
"scoreUnit" : "MB/sec",
"rawData" : [
[
272.05312867669215,
269.3243079453918,
272.23360621771656,
272.63389003836437,
273.7578737021776,
273.153267374683,
272.84149816285793,
272.8387354102871
]
]
},
"·gc.alloc.rate.norm" : {
"score" : 8.001487,
"scoreError" : 2.0577330536897736E-4,
"scoreConfidence" : [
8.00128122669463,
8.001692773305368
],
"scorePercentiles" : {
"0.0" : 8.0014444,
"50.0" : 8.001446099999999,
"90.0" : 8.0017526,
"95.0" : 8.0017526,
"99.0" : 8.0017526,
"99.9" : 8.0017526,
"99.99" : 8.0017526,
"99.999" : 8.0017526,
"99.9999" : 8.0017526,
"100.0" : 8.0017526
},
"scoreUnit" : "B/op",
"rawData" : [
[
8.0014444,
8.001447,
8.0014444,
8.0014452,
8.0014444,
8.0014684,
8.0014496,
8.0017526
]
]
},
"·gc.churn.PS_Eden_Space" : {
"score" : 225.93989516224744,
"scoreError" : 1221.8564097726887,
"scoreConfidence" : [
-995.9165146104413,
1447.7963049349362
],
"scorePercentiles" : {
"0.0" : 0.0,
"50.0" : 0.0,
"90.0" : 1807.5191612979795,
"95.0" : 1807.5191612979795,
"99.0" : 1807.5191612979795,
"99.9" : 1807.5191612979795,
"99.99" : 1807.5191612979795,
"99.999" : 1807.5191612979795,
"99.9999" : 1807.5191612979795,
"100.0" : 1807.5191612979795
},
"scoreUnit" : "MB/sec",
"rawData" : [
[
1807.5191612979795
]
]
},
"·gc.churn.PS_Eden_Space.norm" : {
"score" : 6.7125248,
"scoreError" : 36.300545535565846,
"scoreConfidence" : [
-29.588020735565845,
43.01307033556584
],
"scorePercentiles" : {
"0.0" : 0.0,
"50.0" : 0.0,
"90.0" : 53.7001984,
"95.0" : 53.7001984,
"99.0" : 53.7001984,
"99.9" : 53.7001984,
"99.99" : 53.7001984,
"99.999" : 53.7001984,
"99.9999" : 53.7001984,
"100.0" : 53.7001984
},
"scoreUnit" : "B/op",
"rawData" : [
[
53.7001984
]
]
},
"·gc.count" : {
"score" : 1.0,
"scoreError" : "NaN",
"scoreConfidence" : [
1.0,
1.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,
0.0,
0.0,
0.0
]
]
},
"·gc.time" : {
"score" : 12.0,
"scoreError" : "NaN",
"scoreConfidence" : [
12.0,
12.0
],
"scorePercentiles" : {
"0.0" : 0.0,
"50.0" : 0.0,
"90.0" : 12.0,
"95.0" : 12.0,
"99.0" : 12.0,
"99.9" : 12.0,
"99.99" : 12.0,
"99.999" : 12.0,
"99.9999" : 12.0,
"100.0" : 12.0
},
"scoreUnit" : "ms",
"rawData" : [
[
12.0
]
]
}
}
},
{
"jmhVersion" : "1.20",
"benchmark" : "com.facebook.presto.operator.BenchmarkGroupByHash.benchmarkHashPosition",
"mode" : "avgt",
"threads" : 1,
"forks" : 1,
"jvm" : "/local/home/pettja/.sdkman/candidates/java/8.0.265-amzn/jre/bin/java",
"jvmArgs" : [
"-Xms8g",
"-Xmx8g",
"-XX:+AlwaysPreTouch",
"-XX:ReservedCodeCacheSize=256M"
],
"jdkVersion" : "1.8.0_265",
"vmVersion" : "25.265-b01",
"warmupIterations" : 8,
"warmupTime" : "500 ms",
"warmupBatchSize" : 1,
"measurementIterations" : 8,
"measurementTime" : "500 ms",
"measurementBatchSize" : 1,
"params" : {
"channelCount" : "2",
"dataType" : "BIGINT",
"groupByType" : "notDistinct",
"groupCount" : "3000000",
"hashEnabled" : "false"
},
"primaryMetric" : {
"score" : 8.972291914583334,
"scoreError" : 0.22227198459104383,
"scoreConfidence" : [
8.75001992999229,
9.194563899174378
],
"scorePercentiles" : {
"0.0" : 8.923339083333333,
"50.0" : 8.930110358333334,
"90.0" : 9.259281633333334,
"95.0" : 9.259281633333334,
"99.0" : 9.259281633333334,
"99.9" : 9.259281633333334,
"99.99" : 9.259281633333334,
"99.999" : 9.259281633333334,
"99.9999" : 9.259281633333334,
"100.0" : 9.259281633333334
},
"scoreUnit" : "ns/op",
"rawData" : [
[
8.939134033333334,
8.923339083333333,
8.9336767,
9.259281633333334,
8.924370933333334,
8.926544016666666,
8.946676716666667,
8.9253122
]
]
},
"secondaryMetrics" : {
"·gc.alloc.rate" : {
"score" : 440.80299953641736,
"scoreError" : 5.556587188340603,
"scoreConfidence" : [
435.2464123480768,
446.35958672475795
],
"scorePercentiles" : {
"0.0" : 433.6280811989506,
"50.0" : 441.8152978603398,
"90.0" : 442.0461421693403,
"95.0" : 442.0461421693403,
"99.0" : 442.0461421693403,
"99.9" : 442.0461421693403,
"99.99" : 442.0461421693403,
"99.999" : 442.0461421693403,
"99.9999" : 442.0461421693403,
"100.0" : 442.0461421693403
},
"scoreUnit" : "MB/sec",
"rawData" : [
[
441.6551448747113,
442.0461421693403,
441.78354478188766,
433.6280811989506,
442.03025979623607,
441.98430548826354,
441.44946704315714,
441.847050938792
]
]
},
"·gc.alloc.rate.norm" : {
"score" : 8.002591283333333,
"scoreError" : 1.388924494054289E-4,
"scoreConfidence" : [
8.002452390883928,
8.002730175782737
],
"scorePercentiles" : {
"0.0" : 8.0025656,
"50.0" : 8.0025656,
"90.0" : 8.002771066666666,
"95.0" : 8.002771066666666,
"99.0" : 8.002771066666666,
"99.9" : 8.002771066666666,
"99.99" : 8.002771066666666,
"99.999" : 8.002771066666666,
"99.9999" : 8.002771066666666,
"100.0" : 8.002771066666666
},
"scoreUnit" : "B/op",
"rawData" : [
[
8.0025656,
8.0025656,
8.0025656,
8.0025656,
8.0025656,
8.0025656,
8.0025656,
8.002771066666666
]
]
},
"·gc.churn.PS_Eden_Space" : {
"score" : 242.4838395180307,
"scoreError" : 1311.324117277468,
"scoreConfidence" : [
-1068.8402777594374,
1553.8079567954987
],
"scorePercentiles" : {
"0.0" : 0.0,
"50.0" : 0.0,
"90.0" : 1939.8707161442455,
"95.0" : 1939.8707161442455,
"99.0" : 1939.8707161442455,
"99.9" : 1939.8707161442455,
"99.99" : 1939.8707161442455,
"99.999" : 1939.8707161442455,
"99.9999" : 1939.8707161442455,
"100.0" : 1939.8707161442455
},
"scoreUnit" : "MB/sec",
"rawData" : [
[
1939.8707161442455
]
]
},
"·gc.churn.PS_Eden_Space.norm" : {
"score" : 4.475016533333333,
"scoreError" : 24.200363690377234,
"scoreConfidence" : [
-19.7253471570439,
28.67538022371057
],
"scorePercentiles" : {
"0.0" : 0.0,
"50.0" : 0.0,
"90.0" : 35.800132266666665,
"95.0" : 35.800132266666665,
"99.0" : 35.800132266666665,
"99.9" : 35.800132266666665,
"99.99" : 35.800132266666665,
"99.999" : 35.800132266666665,
"99.9999" : 35.800132266666665,
"100.0" : 35.800132266666665
},
"scoreUnit" : "B/op",
"rawData" : [
[
35.800132266666665
]
]
},
"·gc.count" : {
"score" : 1.0,
"scoreError" : "NaN",
"scoreConfidence" : [
1.0,
1.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,
0.0,
0.0,
1.0,
0.0,
0.0,
0.0,
0.0
]
]
},
"·gc.time" : {
"score" : 18.0,
"scoreError" : "NaN",
"scoreConfidence" : [
18.0,
18.0
],
"scorePercentiles" : {
"0.0" : 0.0,
"50.0" : 0.0,
"90.0" : 18.0,
"95.0" : 18.0,
"99.0" : 18.0,
"99.9" : 18.0,
"99.99" : 18.0,
"99.999" : 18.0,
"99.9999" : 18.0,
"100.0" : 18.0
},
"scoreUnit" : "ms",
"rawData" : [
[
18.0
]
]
}
}
},
{
"jmhVersion" : "1.20",
"benchmark" : "com.facebook.presto.operator.BenchmarkGroupByHash.benchmarkHashPosition",
"mode" : "avgt",
"threads" : 1,
"forks" : 1,
"jvm" : "/local/home/pettja/.sdkman/candidates/java/8.0.265-amzn/jre/bin/java",
"jvmArgs" : [
"-Xms8g",
"-Xmx8g",
"-XX:+AlwaysPreTouch",
"-XX:ReservedCodeCacheSize=256M"
],
"jdkVersion" : "1.8.0_265",
"vmVersion" : "25.265-b01",
"warmupIterations" : 8,
"warmupTime" : "500 ms",
"warmupBatchSize" : 1,
"measurementIterations" : 8,
"measurementTime" : "500 ms",
"measurementBatchSize" : 1,
"params" : {
"channelCount" : "8",
"dataType" : "VARCHAR",
"groupByType" : "notDistinct",
"groupCount" : "3000000",
"hashEnabled" : "false"
},
"primaryMetric" : {
"score" : 56.40597321250001,
"scoreError" : 2.334024192183774,
"scoreConfidence" : [
54.07194902031623,
58.739997404683784
],
"scorePercentiles" : {
"0.0" : 55.3461659,
"50.0" : 56.17430065,
"90.0" : 59.3167705,
"95.0" : 59.3167705,
"99.0" : 59.3167705,
"99.9" : 59.3167705,
"99.99" : 59.3167705,
"99.999" : 59.3167705,
"99.9999" : 59.3167705,
"100.0" : 59.3167705
},
"scoreUnit" : "ns/op",
"rawData" : [
[
55.9043551,
56.1970403,
55.7356364,
56.3361753,
56.151561,
56.2600812,
59.3167705,
55.3461659
]
]
},
"secondaryMetrics" : {
"·gc.alloc.rate" : {
"score" : 71.73557277966265,
"scoreError" : 1.5383182014972552,
"scoreConfidence" : [
70.19725457816538,
73.27389098115991
],
"scorePercentiles" : {
"0.0" : 69.81831747931324,
"50.0" : 71.88751830443904,
"90.0" : 72.43159700823718,
"95.0" : 72.43159700823718,
"99.0" : 72.43159700823718,
"99.9" : 72.43159700823718,
"99.99" : 72.43159700823718,
"99.999" : 72.43159700823718,
"99.9999" : 72.43159700823718,
"100.0" : 72.43159700823718
},
"scoreUnit" : "MB/sec",
"rawData" : [
[
72.06781974629551,
71.87164559909526,
72.18662790793906,
71.77507991690842,
71.90339100978282,
71.83010356972964,
69.81831747931324,
72.43159700823718
]
]
},
"·gc.alloc.rate.norm" : {
"score" : 8.0067953,
"scoreError" : 8.264443431682081E-4,
"scoreConfidence" : [
8.005968855656832,
8.007621744343169
],
"scorePercentiles" : {
"0.0" : 8.0066288,
"50.0" : 8.0066288,
"90.0" : 8.0078616,
"95.0" : 8.0078616,
"99.0" : 8.0078616,
"99.9" : 8.0078616,
"99.99" : 8.0078616,
"99.999" : 8.0078616,
"99.9999" : 8.0078616,
"100.0" : 8.0078616
},
"scoreUnit" : "B/op",
"rawData" : [
[
8.0066288,
8.0066288,
8.0066288,
8.0066288,
8.0066288,
8.006728,
8.0066288,
8.0078616
]
]
},
"·gc.churn.PS_Eden_Space" : {
"score" : 234.13458986591888,
"scoreError" : 1266.1723560230007,
"scoreConfidence" : [
-1032.037766157082,
1500.3069458889195
],
"scorePercentiles" : {
"0.0" : 0.0,
"50.0" : 0.0,
"90.0" : 1873.076718927351,
"95.0" : 1873.076718927351,
"99.0" : 1873.076718927351,
"99.9" : 1873.076718927351,
"99.99" : 1873.076718927351,
"99.999" : 1873.076718927351,
"99.9999" : 1873.076718927351,
"100.0" : 1873.076718927351
},
"scoreUnit" : "MB/sec",
"rawData" : [
[
1873.076718927351
]
]
},
"·gc.churn.PS_Eden_Space.norm" : {
"score" : 26.8500992,
"scoreError" : 145.20218214226338,
"scoreConfidence" : [
-118.35208294226338,
172.05228134226337
],
"scorePercentiles" : {
"0.0" : 0.0,
"50.0" : 0.0,
"90.0" : 214.8007936,
"95.0" : 214.8007936,
"99.0" : 214.8007936,
"99.9" : 214.8007936,
"99.99" : 214.8007936,
"99.999" : 214.8007936,
"99.9999" : 214.8007936,
"100.0" : 214.8007936
},
"scoreUnit" : "B/op",
"rawData" : [
[
214.8007936
]
]
},
"·gc.count" : {
"score" : 1.0,
"scoreError" : "NaN",
"scoreConfidence" : [
1.0,
1.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,
0.0,
0.0,
0.0,
0.0,
0.0,
1.0,
0.0
]
]
},
"·gc.time" : {
"score" : 30.0,
"scoreError" : "NaN",
"scoreConfidence" : [
30.0,
30.0
],
"scorePercentiles" : {
"0.0" : 0.0,
"50.0" : 0.0,
"90.0" : 30.0,
"95.0" : 30.0,
"99.0" : 30.0,
"99.9" : 30.0,
"99.99" : 30.0,
"99.999" : 30.0,
"99.9999" : 30.0,
"100.0" : 30.0
},
"scoreUnit" : "ms",
"rawData" : [
[
30.0
]
]
}
}
},
{
"jmhVersion" : "1.20",
"benchmark" : "com.facebook.presto.operator.BenchmarkGroupByHash.benchmarkHashPosition",
"mode" : "avgt",
"threads" : 1,
"forks" : 1,
"jvm" : "/local/home/pettja/.sdkman/candidates/java/8.0.265-amzn/jre/bin/java",
"jvmArgs" : [
"-Xms8g",
"-Xmx8g",
"-XX:+AlwaysPreTouch",
"-XX:ReservedCodeCacheSize=256M"
],
"jdkVersion" : "1.8.0_265",
"vmVersion" : "25.265-b01",
"warmupIterations" : 8,
"warmupTime" : "500 ms",
"warmupBatchSize" : 1,
"measurementIterations" : 8,
"measurementTime" : "500 ms",
"measurementBatchSize" : 1,
"params" : {
"channelCount" : "8",
"dataType" : "BIGINT",
"groupByType" : "notDistinct",
"groupCount" : "3000000",
"hashEnabled" : "false"
},
"primaryMetric" : {
"score" : 27.716916225000006,
"scoreError" : 0.04400281624224768,
"scoreConfidence" : [
27.672913408757758,
27.760919041242254
],
"scorePercentiles" : {
"0.0" : 27.69007225,
"50.0" : 27.7132424,
"90.0" : 27.76791945,
"95.0" : 27.76791945,
"99.0" : 27.76791945,
"99.9" : 27.76791945,
"99.99" : 27.76791945,
"99.999" : 27.76791945,
"99.9999" : 27.76791945,
"100.0" : 27.76791945
},
"scoreUnit" : "ns/op",
"rawData" : [
[
27.7117165,
27.70446815,
27.7041975,
27.76791945,
27.71999615,
27.7221915,
27.69007225,
27.7147683
]
]
},
"secondaryMetrics" : {
"·gc.alloc.rate" : {
"score" : 144.86794843265486,
"scoreError" : 0.12204136267170758,
"scoreConfidence" : [
144.74590706998316,
144.98998979532655
],
"scorePercentiles" : {
"0.0" : 144.73551124053475,
"50.0" : 144.878521927657,
"90.0" : 144.94814630305126,
"95.0" : 144.94814630305126,
"99.0" : 144.94814630305126,
"99.9" : 144.94814630305126,
"99.99" : 144.94814630305126,
"99.999" : 144.94814630305126,
"99.9999" : 144.94814630305126,
"100.0" : 144.94814630305126
},
"scoreUnit" : "MB/sec",
"rawData" : [
[
144.88785067687726,
144.89930531703948,
144.91043128311924,
144.73551124053475,
144.86919317843675,
144.8615614177393,
144.94814630305126,
144.8315880444408
]
]
},
"·gc.alloc.rate.norm" : {
"score" : 8.01193085,
"scoreError" : 4.165242128831054E-4,
"scoreConfidence" : [
8.011514325787118,
8.012347374212883
],
"scorePercentiles" : {
"0.0" : 8.0118536,
"50.0" : 8.0118536,
"90.0" : 8.01247,
"95.0" : 8.01247,
"99.0" : 8.01247,
"99.9" : 8.01247,
"99.99" : 8.01247,
"99.999" : 8.01247,
"99.9999" : 8.01247,
"100.0" : 8.01247
},
"scoreUnit" : "B/op",
"rawData" : [
[
8.0118536,
8.0118536,
8.0118536,
8.0118536,
8.0118536,
8.0118552,
8.0118536,
8.01247
]
]
},
"·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
]
]
}
}
},
{
"jmhVersion" : "1.20",
"benchmark" : "com.facebook.presto.operator.BenchmarkGroupByHash.benchmarkHashPosition",
"mode" : "avgt",
"threads" : 1,
"forks" : 1,
"jvm" : "/local/home/pettja/.sdkman/candidates/java/8.0.265-amzn/jre/bin/java",
"jvmArgs" : [
"-Xms8g",
"-Xmx8g",
"-XX:+AlwaysPreTouch",
"-XX:ReservedCodeCacheSize=256M"
],
"jdkVersion" : "1.8.0_265",
"vmVersion" : "25.265-b01",
"warmupIterations" : 8,
"warmupTime" : "500 ms",
"warmupBatchSize" : 1,
"measurementIterations" : 8,
"measurementTime" : "500 ms",
"measurementBatchSize" : 1,
"params" : {
"channelCount" : "15",
"dataType" : "VARCHAR",
"groupByType" : "notDistinct",
"groupCount" : "3000000",
"hashEnabled" : "false"
},
"primaryMetric" : {
"score" : 101.6136798125,
"scoreError" : 1.302030012510622,
"scoreConfidence" : [
100.31164979998937,
102.91570982501062
],
"scorePercentiles" : {
"0.0" : 101.1962178,
"50.0" : 101.40664975,
"90.0" : 103.2881916,
"95.0" : 103.2881916,
"99.0" : 103.2881916,
"99.9" : 103.2881916,
"99.99" : 103.2881916,
"99.999" : 103.2881916,
"99.9999" : 103.2881916,
"100.0" : 103.2881916
},
"scoreUnit" : "ns/op",
"rawData" : [
[
101.3555636,
101.4492487,
101.4122743,
101.4042191,
103.2881916,
101.394643,
101.1962178,
101.4090804
]
]
},
"secondaryMetrics" : {
"·gc.alloc.rate" : {
"score" : 50.39621677793426,
"scoreError" : 0.4275869190826107,
"scoreConfidence" : [
49.96862985885164,
50.82380369701687
],
"scorePercentiles" : {
"0.0" : 49.84638140523097,
"50.0" : 50.464260318662795,
"90.0" : 50.53438156460495,
"95.0" : 50.53438156460495,
"99.0" : 50.53438156460495,
"99.9" : 50.53438156460495,
"99.99" : 50.53438156460495,
"99.999" : 50.53438156460495,
"99.9999" : 50.53438156460495,
"100.0" : 50.53438156460495
},
"scoreUnit" : "MB/sec",
"rawData" : [
[
50.47916547671877,
50.45139836765533,
50.46302812166418,
50.46549251566142,
49.84638140523097,
50.46987369583306,
50.53438156460495,
50.46001307610539
]
]
},
"·gc.alloc.rate.norm" : {
"score" : 8.0142501,
"scoreError" : 8.327412397288882E-4,
"scoreConfidence" : [
8.013417358760272,
8.015082841239728
],
"scorePercentiles" : {
"0.0" : 8.0140952,
"50.0" : 8.0140952,
"90.0" : 8.015328,
"95.0" : 8.015328,
"99.0" : 8.015328,
"99.9" : 8.015328,
"99.99" : 8.015328,
"99.999" : 8.015328,
"99.9999" : 8.015328,
"100.0" : 8.015328
},
"scoreUnit" : "B/op",
"rawData" : [
[
8.0140952,
8.0140984,
8.0140952,
8.0140952,
8.0140952,
8.0140984,
8.0140952,
8.015328
]
]
},
"·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
]
]
}
}
},
{
"jmhVersion" : "1.20",
"benchmark" : "com.facebook.presto.operator.BenchmarkGroupByHash.benchmarkHashPosition",
"mode" : "avgt",
"threads" : 1,
"forks" : 1,
"jvm" : "/local/home/pettja/.sdkman/candidates/java/8.0.265-amzn/jre/bin/java",
"jvmArgs" : [
"-Xms8g",
"-Xmx8g",
"-XX:+AlwaysPreTouch",
"-XX:ReservedCodeCacheSize=256M"
],
"jdkVersion" : "1.8.0_265",
"vmVersion" : "25.265-b01",
"warmupIterations" : 8,
"warmupTime" : "500 ms",
"warmupBatchSize" : 1,
"measurementIterations" : 8,
"measurementTime" : "500 ms",
"measurementBatchSize" : 1,
"params" : {
"channelCount" : "15",
"dataType" : "BIGINT",
"groupByType" : "notDistinct",
"groupCount" : "3000000",
"hashEnabled" : "false"
},
"primaryMetric" : {
"score" : 51.253531224999996,
"scoreError" : 0.4412103093493824,
"scoreConfidence" : [
50.812320915650616,
51.694741534349376
],
"scorePercentiles" : {
"0.0" : 50.7227653,
"50.0" : 51.2899794,
"90.0" : 51.4902239,
"95.0" : 51.4902239,
"99.0" : 51.4902239,
"99.9" : 51.4902239,
"99.99" : 51.4902239,
"99.999" : 51.4902239,
"99.9999" : 51.4902239,
"100.0" : 51.4902239
},
"scoreUnit" : "ns/op",
"rawData" : [
[
51.4163735,
51.2986065,
51.4902239,
51.2375801,
50.7227653,
51.2540459,
51.2813523,
51.3273023
]
]
},
"secondaryMetrics" : {
"·gc.alloc.rate" : {
"score" : 75.55282271766484,
"scoreError" : 0.3311310827856536,
"scoreConfidence" : [
75.22169163487918,
75.8839538004505
],
"scorePercentiles" : {
"0.0" : 75.37992353943267,
"50.0" : 75.52565034246793,
"90.0" : 75.95190016406585,
"95.0" : 75.95190016406585,
"99.0" : 75.95190016406585,
"99.9" : 75.95190016406585,
"99.99" : 75.95190016406585,
"99.999" : 75.95190016406585,
"99.9999" : 75.95190016406585,
"100.0" : 75.95190016406585
},
"scoreUnit" : "MB/sec",
"rawData" : [
[
75.43302323609333,
75.51721898812012,
75.37992353943267,
75.56653521009235,
75.95190016406585,
75.55517336092416,
75.53408169681573,
75.48472554577448
]
]
},
"·gc.alloc.rate.norm" : {
"score" : 8.0254605,
"scoreError" : 8.333546964373765E-4,
"scoreConfidence" : [
8.024627145303562,
8.026293854696437
],
"scorePercentiles" : {
"0.0" : 8.0253064,
"50.0" : 8.0253064,
"90.0" : 8.0265392,
"95.0" : 8.0265392,
"99.0" : 8.0265392,
"99.9" : 8.0265392,
"99.99" : 8.0265392,
"99.999" : 8.0265392,
"99.9999" : 8.0265392,
"100.0" : 8.0265392
},
"scoreUnit" : "B/op",
"rawData" : [
[
8.0253064,
8.0253064,
8.0253064,
8.0253064,
8.0253064,
8.0253064,
8.0253064,
8.0265392
]
]
},
"·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
]
]
}
}
}
]
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment