Skip to content

Instantly share code, notes, and snippets.

@evita-performance

evita-performance/result.json

Created September 14, 2021 22:40
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save evita-performance/c7de0f4a72631a2b33d70cb77027311a to your computer and use it in GitHub Desktop.
Save evita-performance/c7de0f4a72631a2b33d70cb77027311a to your computer and use it in GitHub Desktop.
Download ZIP
Evita performance results: sql - 2021-09-14T15:06:58+00:00 (node: c-4)
Raw
result.json
[
{
"jmhVersion" : "1.27",
"benchmark" : "io.evitadb.artificial.ArtificialEntitiesBenchmark.attributeFiltering_Sql",
"mode" : "thrpt",
"threads" : 4,
"forks" : 5,
"jvm" : "/usr/local/openjdk-11/bin/java",
"jvmArgs" : [
"-javaagent:jmx_prometheus_javaagent.jar=0.0.0.0:8015:jmx.yml",
"-Ddbhost=pgsql",
"-Ddbport=5432",
"-Xmx4g",
"-DdataFolder=/data"
],
"jdkVersion" : "11.0.11",
"vmName" : "OpenJDK 64-Bit Server VM",
"vmVersion" : "11.0.11+9",
"warmupIterations" : 3,
"warmupTime" : "10 s",
"warmupBatchSize" : 1,
"measurementIterations" : 5,
"measurementTime" : "1 min",
"measurementBatchSize" : 1,
"primaryMetric" : {
"score" : 3.299813519238688,
"scoreError" : 0.3349473880777757,
"scoreConfidence" : [
2.964866131160912,
3.6347609073164637
],
"scorePercentiles" : {
"0.0" : 2.815480206124179,
"50.0" : 3.0013042310112854,
"90.0" : 3.927972134316685,
"95.0" : 3.979983239294717,
"99.0" : 4.000928038862416,
"99.9" : 4.000928038862416,
"99.99" : 4.000928038862416,
"99.999" : 4.000928038862416,
"99.9999" : 4.000928038862416,
"100.0" : 4.000928038862416
},
"scoreUnit" : "ops/s",
"rawData" : [
[
2.8817657627120576,
2.9041588619620553,
2.8905022115490295,
2.83250450294378,
2.815480206124179
],
[
2.9886897378013075,
3.472049724118772,
3.7585903089249877,
3.829007553694944,
4.000928038862416
],
[
3.0013042310112854,
3.416614692558135,
3.7695299231369086,
3.7818898336534166,
3.925878863658862
],
[
2.874472397883528,
2.8867965499816353,
2.929912598689541,
2.874320672447312,
2.8713836650423223
],
[
2.9574546078983635,
3.3923923570231747,
3.761086365092493,
3.747512273893279,
3.9311120403034194
]
]
},
"secondaryMetrics" : {
}
},
{
"jmhVersion" : "1.27",
"benchmark" : "io.evitadb.artificial.ArtificialEntitiesBenchmark.bulkInsertThroughput_Sql",
"mode" : "thrpt",
"threads" : 1,
"forks" : 5,
"jvm" : "/usr/local/openjdk-11/bin/java",
"jvmArgs" : [
"-javaagent:jmx_prometheus_javaagent.jar=0.0.0.0:8015:jmx.yml",
"-Ddbhost=pgsql",
"-Ddbport=5432",
"-Xmx4g",
"-DdataFolder=/data"
],
"jdkVersion" : "11.0.11",
"vmName" : "OpenJDK 64-Bit Server VM",
"vmVersion" : "11.0.11+9",
"warmupIterations" : 3,
"warmupTime" : "10 s",
"warmupBatchSize" : 1,
"measurementIterations" : 5,
"measurementTime" : "1 min",
"measurementBatchSize" : 1,
"primaryMetric" : {
"score" : 524.0632934597891,
"scoreError" : 94.95169188308762,
"scoreConfidence" : [
429.11160157670145,
619.0149853428767
],
"scorePercentiles" : {
"0.0" : 349.8889232829817,
"50.0" : 553.1563094782866,
"90.0" : 712.4756053124464,
"95.0" : 716.6625017724257,
"99.0" : 718.2017319104854,
"99.9" : 718.2017319104854,
"99.99" : 718.2017319104854,
"99.999" : 718.2017319104854,
"99.9999" : 718.2017319104854,
"100.0" : 718.2017319104854
},
"scoreUnit" : "ops/s",
"rawData" : [
[
718.2017319104854,
706.6827842370366,
713.0709647836197,
712.0786989983309,
695.0292922483677
],
[
555.5694985002019,
559.7676320697249,
531.6750239112827,
572.6895867482993,
574.0441857406047
],
[
372.50416879783927,
375.5683362427878,
379.3357259665641,
381.1226018672634,
383.73966901866015
],
[
627.7516144542378,
570.1112622248207,
553.1563094782866,
349.8889232829817,
626.1606407275043
],
[
400.61598167063687,
431.82446181592854,
437.6286900599688,
440.7297163932047,
432.6348353460883
]
]
},
"secondaryMetrics" : {
}
},
{
"jmhVersion" : "1.27",
"benchmark" : "io.evitadb.artificial.ArtificialEntitiesBenchmark.paginatedEntityRead_Sql",
"mode" : "thrpt",
"threads" : 4,
"forks" : 5,
"jvm" : "/usr/local/openjdk-11/bin/java",
"jvmArgs" : [
"-javaagent:jmx_prometheus_javaagent.jar=0.0.0.0:8015:jmx.yml",
"-Ddbhost=pgsql",
"-Ddbport=5432",
"-Xmx4g",
"-DdataFolder=/data"
],
"jdkVersion" : "11.0.11",
"vmName" : "OpenJDK 64-Bit Server VM",
"vmVersion" : "11.0.11+9",
"warmupIterations" : 3,
"warmupTime" : "10 s",
"warmupBatchSize" : 1,
"measurementIterations" : 5,
"measurementTime" : "1 min",
"measurementBatchSize" : 1,
"primaryMetric" : {
"score" : 479.67900466411743,
"scoreError" : 2.554452974602384,
"scoreConfidence" : [
477.12455168951504,
482.2334576387198
],
"scorePercentiles" : {
"0.0" : 470.42180931509824,
"50.0" : 480.3959055902026,
"90.0" : 483.51230408208045,
"95.0" : 485.048512348897,
"99.0" : 485.5590421791245,
"99.9" : 485.5590421791245,
"99.99" : 485.5590421791245,
"99.999" : 485.5590421791245,
"99.9999" : 485.5590421791245,
"100.0" : 485.5590421791245
},
"scoreUnit" : "ops/s",
"rawData" : [
[
470.42180931509824,
476.91440456860585,
480.10420708039885,
479.9954148205069,
481.5435936855219
],
[
477.4804266121707,
477.3041230485072,
480.3959055902026,
479.4362580368029,
477.9576555917036
],
[
476.7430006432335,
475.8179060169397,
482.6421013352276,
481.9560133340325,
485.5590421791245
],
[
472.8949186249606,
480.86784501317675,
483.8572760783663,
483.2823227512232,
480.49461774933934
],
[
481.7842810352478,
480.6692833822216,
481.5675228884905,
479.70858196866936,
482.57660525316567
]
]
},
"secondaryMetrics" : {
}
},
{
"jmhVersion" : "1.27",
"benchmark" : "io.evitadb.artificial.ArtificialEntitiesBenchmark.singleEntityRead_Sql",
"mode" : "thrpt",
"threads" : 4,
"forks" : 5,
"jvm" : "/usr/local/openjdk-11/bin/java",
"jvmArgs" : [
"-javaagent:jmx_prometheus_javaagent.jar=0.0.0.0:8015:jmx.yml",
"-Ddbhost=pgsql",
"-Ddbport=5432",
"-Xmx4g",
"-DdataFolder=/data"
],
"jdkVersion" : "11.0.11",
"vmName" : "OpenJDK 64-Bit Server VM",
"vmVersion" : "11.0.11+9",
"warmupIterations" : 3,
"warmupTime" : "10 s",
"warmupBatchSize" : 1,
"measurementIterations" : 5,
"measurementTime" : "1 min",
"measurementBatchSize" : 1,
"primaryMetric" : {
"score" : 4774.884579798725,
"scoreError" : 42.395964365402975,
"scoreConfidence" : [
4732.488615433322,
4817.2805441641285
],
"scorePercentiles" : {
"0.0" : 4671.642979817447,
"50.0" : 4766.974540964329,
"90.0" : 4874.920606688376,
"95.0" : 4891.47446329956,
"99.0" : 4892.719510138859,
"99.9" : 4892.719510138859,
"99.99" : 4892.719510138859,
"99.999" : 4892.719510138859,
"99.9999" : 4892.719510138859,
"100.0" : 4892.719510138859
},
"scoreUnit" : "ops/s",
"rawData" : [
[
4850.522311749058,
4864.880491998334,
4888.569354007864,
4892.719510138859,
4865.821441808717
],
[
4696.406720134517,
4751.169147257362,
4766.974540964329,
4744.812452365136,
4767.578783442634
],
[
4732.43347615351,
4742.115870884925,
4773.22096378645,
4751.987893461932,
4773.5292900159275
],
[
4671.642979817447,
4769.227351194609,
4759.612257149609,
4770.32469839656,
4741.927924370228
],
[
4715.805110407796,
4768.384975369764,
4758.272399717018,
4754.9095085450845,
4799.265041830439
]
]
},
"secondaryMetrics" : {
}
},
{
"jmhVersion" : "1.27",
"benchmark" : "io.evitadb.senesi.SenesiBenchmark.attributeFiltering_Sql",
"mode" : "thrpt",
"threads" : 4,
"forks" : 5,
"jvm" : "/usr/local/openjdk-11/bin/java",
"jvmArgs" : [
"-javaagent:jmx_prometheus_javaagent.jar=0.0.0.0:8015:jmx.yml",
"-Ddbhost=pgsql",
"-Ddbport=5432",
"-Xmx4g",
"-DdataFolder=/data"
],
"jdkVersion" : "11.0.11",
"vmName" : "OpenJDK 64-Bit Server VM",
"vmVersion" : "11.0.11+9",
"warmupIterations" : 3,
"warmupTime" : "10 s",
"warmupBatchSize" : 1,
"measurementIterations" : 5,
"measurementTime" : "1 min",
"measurementBatchSize" : 1,
"primaryMetric" : {
"score" : 3.0485618991488708,
"scoreError" : 0.3050522243665838,
"scoreConfidence" : [
2.743509674782287,
3.3536141235154546
],
"scorePercentiles" : {
"0.0" : 2.480421210241281,
"50.0" : 2.9782673834279603,
"90.0" : 3.5513001048357715,
"95.0" : 3.605302504972554,
"99.0" : 3.6154107707107315,
"99.9" : 3.6154107707107315,
"99.99" : 3.6154107707107315,
"99.999" : 3.6154107707107315,
"99.9999" : 3.6154107707107315,
"100.0" : 3.6154107707107315
},
"scoreUnit" : "ops/s",
"rawData" : [
[
2.480421210241281,
2.798662330175376,
3.048308853191358,
3.394796164761171,
3.531022473670637
],
[
2.4982872132035725,
2.795958717724434,
2.9705643759140763,
3.465290366164199,
3.4906134970313096
],
[
2.5052616761997397,
2.751012442004195,
2.9696542850970333,
3.399603891903587,
3.5196825855395995
],
[
2.519181068252427,
2.7038866081851367,
2.9782673834279603,
3.4700290572455774,
3.5817165515834737
],
[
2.4982905844723025,
2.751184527397556,
2.998820773842845,
3.478120070782169,
3.6154107707107315
]
]
},
"secondaryMetrics" : {
}
},
{
"jmhVersion" : "1.27",
"benchmark" : "io.evitadb.senesi.SenesiBenchmark.bulkInsertThroughput_Sql",
"mode" : "thrpt",
"threads" : 1,
"forks" : 5,
"jvm" : "/usr/local/openjdk-11/bin/java",
"jvmArgs" : [
"-javaagent:jmx_prometheus_javaagent.jar=0.0.0.0:8015:jmx.yml",
"-Ddbhost=pgsql",
"-Ddbport=5432",
"-Xmx4g",
"-DdataFolder=/data"
],
"jdkVersion" : "11.0.11",
"vmName" : "OpenJDK 64-Bit Server VM",
"vmVersion" : "11.0.11+9",
"warmupIterations" : 3,
"warmupTime" : "10 s",
"warmupBatchSize" : 1,
"measurementIterations" : 5,
"measurementTime" : "1 min",
"measurementBatchSize" : 1,
"primaryMetric" : {
"score" : 432.5232634858172,
"scoreError" : 86.21126226005606,
"scoreConfidence" : [
346.31200122576115,
518.7345257458733
],
"scorePercentiles" : {
"0.0" : 256.9263133329336,
"50.0" : 513.8015083795176,
"90.0" : 531.2236525750302,
"95.0" : 533.7960116696933,
"99.0" : 534.3754342891563,
"99.9" : 534.3754342891563,
"99.99" : 534.3754342891563,
"99.999" : 534.3754342891563,
"99.9999" : 534.3754342891563,
"100.0" : 534.3754342891563
},
"scoreUnit" : "ops/s",
"rawData" : [
[
256.9263133329336,
523.632949466545,
514.3641119312183,
306.97772599338487,
534.3754342891563
],
[
516.4062216517744,
280.0298670838524,
532.444025557613,
518.3909945408274,
318.6321660107884
],
[
290.675218832965,
530.4100705866416,
500.444878796457,
260.12471167574375,
527.9331525701871
],
[
524.8321427573513,
527.3964475644855,
262.2158063290721,
451.2520581287533,
513.8015083795176
],
[
265.66745540978025,
490.270083850797,
522.2170452206308,
323.7649681596289,
519.8962290253269
]
]
},
"secondaryMetrics" : {
}
},
{
"jmhVersion" : "1.27",
"benchmark" : "io.evitadb.senesi.SenesiBenchmark.paginatedEntityRead_Sql",
"mode" : "thrpt",
"threads" : 4,
"forks" : 5,
"jvm" : "/usr/local/openjdk-11/bin/java",
"jvmArgs" : [
"-javaagent:jmx_prometheus_javaagent.jar=0.0.0.0:8015:jmx.yml",
"-Ddbhost=pgsql",
"-Ddbport=5432",
"-Xmx4g",
"-DdataFolder=/data"
],
"jdkVersion" : "11.0.11",
"vmName" : "OpenJDK 64-Bit Server VM",
"vmVersion" : "11.0.11+9",
"warmupIterations" : 3,
"warmupTime" : "10 s",
"warmupBatchSize" : 1,
"measurementIterations" : 5,
"measurementTime" : "1 min",
"measurementBatchSize" : 1,
"primaryMetric" : {
"score" : 201.64856738054345,
"scoreError" : 1.5353431387340553,
"scoreConfidence" : [
200.1132242418094,
203.1839105192775
],
"scorePercentiles" : {
"0.0" : 197.64493672721937,
"50.0" : 202.0578514157016,
"90.0" : 204.01335932237052,
"95.0" : 204.05535591965494,
"99.0" : 204.0642823550771,
"99.9" : 204.0642823550771,
"99.99" : 204.0642823550771,
"99.999" : 204.0642823550771,
"99.9999" : 204.0642823550771,
"100.0" : 204.0642823550771
},
"scoreUnit" : "ops/s",
"rawData" : [
[
198.56158120951508,
197.64493672721937,
199.975897809864,
201.32696797081576,
200.5513140760403
],
[
203.99924715705978,
199.029449185573,
203.73690576691627,
202.8540961810124,
203.14784763331397
],
[
203.43216489908914,
198.03599501902823,
203.03770616567863,
202.89901416667482,
202.0578514157016
],
[
204.0642823550771,
201.51150423169378,
203.35514059403633,
202.92445581107398,
204.0345275703366
],
[
203.93301594838016,
199.32902516815673,
201.30881339741038,
200.2474374249294,
200.21500662899044
]
]
},
"secondaryMetrics" : {
}
},
{
"jmhVersion" : "1.27",
"benchmark" : "io.evitadb.senesi.SenesiBenchmark.singleEntityRead_Sql",
"mode" : "thrpt",
"threads" : 4,
"forks" : 5,
"jvm" : "/usr/local/openjdk-11/bin/java",
"jvmArgs" : [
"-javaagent:jmx_prometheus_javaagent.jar=0.0.0.0:8015:jmx.yml",
"-Ddbhost=pgsql",
"-Ddbport=5432",
"-Xmx4g",
"-DdataFolder=/data"
],
"jdkVersion" : "11.0.11",
"vmName" : "OpenJDK 64-Bit Server VM",
"vmVersion" : "11.0.11+9",
"warmupIterations" : 3,
"warmupTime" : "10 s",
"warmupBatchSize" : 1,
"measurementIterations" : 5,
"measurementTime" : "1 min",
"measurementBatchSize" : 1,
"primaryMetric" : {
"score" : 2947.128556147738,
"scoreError" : 15.975486451701261,
"scoreConfidence" : [
2931.1530696960367,
2963.1040425994393
],
"scorePercentiles" : {
"0.0" : 2904.359782596828,
"50.0" : 2948.410254360363,
"90.0" : 2973.7278043849897,
"95.0" : 2990.448750285644,
"99.0" : 2996.5648770805365,
"99.9" : 2996.5648770805365,
"99.99" : 2996.5648770805365,
"99.999" : 2996.5648770805365,
"99.9999" : 2996.5648770805365,
"100.0" : 2996.5648770805365
},
"scoreUnit" : "ops/s",
"rawData" : [
[
2904.359782596828,
2940.272085706699,
2950.724655366784,
2943.3670304131765,
2937.4252864567343
],
[
2947.5073508139485,
2942.963054316855,
2948.410254360363,
2955.8492201494464,
2968.001960310942
],
[
2948.5086384521796,
2966.816947018143,
2965.2853618568397,
2976.1777877642285,
2996.5648770805365
],
[
2923.955605640775,
2955.4839366693272,
2950.5583466814364,
2959.355513363974,
2972.0944821321636
],
[
2911.6467656056248,
2926.158632482693,
2914.891194503302,
2935.855103218735,
2935.9800307317155
]
]
},
"secondaryMetrics" : {
}
},
{
"jmhVersion" : "1.27",
"benchmark" : "io.evitadb.senesi.SenesiBenchmark.transactionalUpsertThroughput_Sql",
"mode" : "thrpt",
"threads" : 1,
"forks" : 5,
"jvm" : "/usr/local/openjdk-11/bin/java",
"jvmArgs" : [
"-javaagent:jmx_prometheus_javaagent.jar=0.0.0.0:8015:jmx.yml",
"-Ddbhost=pgsql",
"-Ddbport=5432",
"-Xmx4g",
"-DdataFolder=/data"
],
"jdkVersion" : "11.0.11",
"vmName" : "OpenJDK 64-Bit Server VM",
"vmVersion" : "11.0.11+9",
"warmupIterations" : 3,
"warmupTime" : "10 s",
"warmupBatchSize" : 1,
"measurementIterations" : 5,
"measurementTime" : "1 min",
"measurementBatchSize" : 1,
"primaryMetric" : {
"score" : 1.7139482839232318,
"scoreError" : 0.09551424081702627,
"scoreConfidence" : [
1.6184340431062056,
1.809462524740258
],
"scorePercentiles" : {
"0.0" : 1.4298133679231952,
"50.0" : 1.7200765796616129,
"90.0" : 1.9067680580863926,
"95.0" : 1.932429222880895,
"99.0" : 1.941599580243473,
"99.9" : 1.941599580243473,
"99.99" : 1.941599580243473,
"99.999" : 1.941599580243473,
"99.9999" : 1.941599580243473,
"100.0" : 1.941599580243473
},
"scoreUnit" : "ops/s",
"rawData" : [
[
1.6915089613233514,
1.7525798624197886,
1.9039256152318456,
1.8045466840949071,
1.564551806126293
],
[
1.7200765796616129,
1.9110317223682134,
1.6149733406096427,
1.4298133679231952,
1.713462716803743
],
[
1.6692344309904072,
1.708737401377271,
1.521761351190357,
1.811568420927038,
1.627301644563491
],
[
1.6699804937118492,
1.7350964345424302,
1.7834504395936857,
1.941599580243473,
1.7367319432209558
],
[
1.7805767045641814,
1.7689352824737377,
1.6386562156864108,
1.8480134097011462,
1.5005926887317658
]
]
},
"secondaryMetrics" : {
}
}
]
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment