Skip to content

Instantly share code, notes, and snippets.

@evita-performance

evita-performance/result.json

Created September 15, 2021 16:33
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/b074d375cef22a35cfe24c8ed1bec374 to your computer and use it in GitHub Desktop.
Save evita-performance/b074d375cef22a35cfe24c8ed1bec374 to your computer and use it in GitHub Desktop.
Download ZIP
Evita performance results: sql - 2021-09-15T09:11:48+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.157489956214003,
"scoreError" : 0.31308360794270623,
"scoreConfidence" : [
2.844406348271297,
3.4705735641567093
],
"scorePercentiles" : {
"0.0" : 2.8042234240364694,
"50.0" : 2.908438169622912,
"90.0" : 3.8646170453732327,
"95.0" : 3.935973589592196,
"99.0" : 3.9467203012326824,
"99.9" : 3.9467203012326824,
"99.99" : 3.9467203012326824,
"99.999" : 3.9467203012326824,
"99.9999" : 3.9467203012326824,
"100.0" : 3.9467203012326824
},
"scoreUnit" : "ops/s",
"rawData" : [
[
3.04354637360241,
3.3843502623065667,
3.833763122890236,
3.7833773801829453,
3.910897929097728
],
[
2.8464071905411115,
2.9068027436679444,
2.9223294701728904,
2.872730632749306,
2.845440111584514
],
[
2.8574383867184943,
2.9021017515829683,
2.917935864614442,
2.8748326069521846,
2.848370785830494
],
[
2.8605591656826164,
2.9000478401263683,
2.908438169622912,
2.831956880098854,
2.8042234240364694
],
[
2.9834530662576206,
3.3945443761544642,
3.810207211519168,
3.7467738581246675,
3.9467203012326824
]
]
},
"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" : 556.3037998405748,
"scoreError" : 93.09201765767847,
"scoreConfidence" : [
463.21178218289634,
649.3958174982533
],
"scorePercentiles" : {
"0.0" : 380.0003470425938,
"50.0" : 577.4274041464923,
"90.0" : 717.9810880044728,
"95.0" : 731.9290224289095,
"99.0" : 736.7491913270385,
"99.9" : 736.7491913270385,
"99.99" : 736.7491913270385,
"99.999" : 736.7491913270385,
"99.9999" : 736.7491913270385,
"100.0" : 736.7491913270385
},
"scoreUnit" : "ops/s",
"rawData" : [
[
720.6819616666087,
736.7491913270385,
716.1805055630488,
712.3202182208618,
712.9691131110422
],
[
569.663738512895,
579.632298720685,
577.4274041464923,
571.49876364414,
578.420888315904
],
[
380.0003470425938,
381.5356461287817,
381.6901694801733,
385.80288117831907,
386.06597121468513
],
[
642.3372121809786,
636.8085187411643,
643.0655840412221,
635.759448938486,
658.4427047988103
],
[
452.5273345017502,
454.0411859454448,
464.9040673870382,
464.52435664320586,
464.5454845629969
]
]
},
"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" : 504.4885750557394,
"scoreError" : 3.3185985984413526,
"scoreConfidence" : [
501.16997645729805,
507.8071736541807
],
"scorePercentiles" : {
"0.0" : 496.1394810420621,
"50.0" : 504.8532997490728,
"90.0" : 509.99419150905464,
"95.0" : 510.0942256003591,
"99.0" : 510.10208785088514,
"99.9" : 510.10208785088514,
"99.99" : 510.10208785088514,
"99.999" : 510.10208785088514,
"99.9999" : 510.10208785088514,
"100.0" : 510.10208785088514
},
"scoreUnit" : "ops/s",
"rawData" : [
[
501.4360304948433,
505.208984949777,
508.04346901292485,
510.0758803491317,
508.19932044999206
],
[
504.3738650550455,
504.1016199754455,
505.1802432229068,
503.16351579891125,
507.4530685455071
],
[
497.78978108015775,
498.2375248181198,
498.06732576996774,
496.1394810420621,
496.6439888222846
],
[
500.8484444958807,
509.93973228233665,
509.502687023071,
508.60500219353884,
510.10208785088514
],
[
504.345035736613,
504.75338492886164,
507.8306302906139,
504.8532997490728,
507.3199724555364
]
]
},
"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" : 4837.02777514292,
"scoreError" : 25.490298821273917,
"scoreConfidence" : [
4811.537476321646,
4862.518073964195
],
"scorePercentiles" : {
"0.0" : 4738.754464259921,
"50.0" : 4832.397510619783,
"90.0" : 4892.816195810335,
"95.0" : 4910.484694326023,
"99.0" : 4912.449985713299,
"99.9" : 4912.449985713299,
"99.99" : 4912.449985713299,
"99.999" : 4912.449985713299,
"99.9999" : 4912.449985713299,
"100.0" : 4912.449985713299
},
"scoreUnit" : "ops/s",
"rawData" : [
[
4862.680054004847,
4884.094316735638,
4912.449985713299,
4850.322122776336,
4905.89901442238
],
[
4824.855811969098,
4855.725993664784,
4846.089394120911,
4849.886818597572,
4847.993889018293
],
[
4801.731251221426,
4814.681345914998,
4846.454931280407,
4835.0164332115955,
4822.350017437031
],
[
4816.937394907664,
4824.845428587479,
4838.022842664421,
4832.397510619783,
4821.38941593283
],
[
4738.754464259921,
4824.738359317511,
4830.997577629243,
4823.866294685764,
4813.513709879777
]
]
},
"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.152210953021943,
"scoreError" : 0.3159585874762837,
"scoreConfidence" : [
2.836252365545659,
3.4681695404982267
],
"scorePercentiles" : {
"0.0" : 2.5414614078617253,
"50.0" : 3.1160424927512738,
"90.0" : 3.7228623465613557,
"95.0" : 3.7406089273001863,
"99.0" : 3.744203096608156,
"99.9" : 3.744203096608156,
"99.99" : 3.744203096608156,
"99.999" : 3.744203096608156,
"99.9999" : 3.744203096608156,
"100.0" : 3.744203096608156
},
"scoreUnit" : "ops/s",
"rawData" : [
[
2.5758770760762792,
2.958439390556598,
3.0325938669795107,
3.5059366485120154,
3.744203096608156
],
[
2.5414614078617253,
2.8907554209423303,
3.180150314620458,
3.541399581396016,
3.716622222770088
],
[
2.5688028668569642,
2.7995624362658167,
3.1160424927512738,
3.525841417778791,
3.6140595089230683
],
[
2.5863007269707348,
2.9006945990902944,
3.1370165814706272,
3.584432479178285,
3.732222532248258
],
[
2.555308188062821,
2.86952489082043,
3.025109314840685,
3.5287205110906674,
3.57419625287666
]
]
},
"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" : 454.01489650672977,
"scoreError" : 97.32272872177565,
"scoreConfidence" : [
356.6921677849541,
551.3376252285054
],
"scorePercentiles" : {
"0.0" : 209.78815208456345,
"50.0" : 545.5320861065235,
"90.0" : 556.1554448480724,
"95.0" : 558.8112152322802,
"99.0" : 559.806793144931,
"99.9" : 559.806793144931,
"99.99" : 559.806793144931,
"99.999" : 559.806793144931,
"99.9999" : 559.806793144931,
"100.0" : 559.806793144931
},
"scoreUnit" : "ops/s",
"rawData" : [
[
548.8479646075508,
209.78815208456345,
530.3889147680763,
330.6838037722426,
554.4897799641161
],
[
534.67588174912,
266.88444221819265,
555.9336080116129,
545.5320861065235,
303.0316174222791
],
[
330.5751812711873,
546.3602369454962,
547.2823879037804,
270.07432795901235,
559.806793144931
],
[
550.4569806008456,
547.0024013250991,
323.2326296176764,
546.7019699361796,
551.6794857923645
],
[
542.19798099787,
261.96806405039473,
556.4882001027618,
548.2508904470212,
288.0386318693464
]
]
},
"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" : 209.33535205601234,
"scoreError" : 1.421547954543104,
"scoreConfidence" : [
207.91380410146922,
210.75690001055546
],
"scorePercentiles" : {
"0.0" : 206.4550343185041,
"50.0" : 208.8426178813677,
"90.0" : 212.4552037868976,
"95.0" : 212.84924553533205,
"99.0" : 212.87444743693712,
"99.9" : 212.87444743693712,
"99.99" : 212.87444743693712,
"99.999" : 212.87444743693712,
"99.9999" : 212.87444743693712,
"100.0" : 212.87444743693712
},
"scoreUnit" : "ops/s",
"rawData" : [
[
208.78038278400078,
206.88981777378993,
206.960632745661,
208.45552781549569,
207.04208882094863
],
[
211.3622181230658,
208.8426178813677,
209.80072002559297,
212.23171224599366,
212.79044109825355
],
[
209.5030504487649,
208.42549548791447,
208.11930973883412,
209.69609676137907,
208.5363818871836
],
[
210.11982523524495,
208.6152063010644,
211.6635581871322,
212.87444743693712,
212.13477287533672
],
[
209.38434514705892,
206.4550343185041,
207.74549337530652,
209.27075750140827,
207.68386738406815
]
]
},
"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" : 2982.6318754067597,
"scoreError" : 14.596328683287643,
"scoreConfidence" : [
2968.035546723472,
2997.2282040900473
],
"scorePercentiles" : {
"0.0" : 2944.1233800386635,
"50.0" : 2985.4722869156194,
"90.0" : 3014.8579186566362,
"95.0" : 3023.363579464825,
"99.0" : 3024.003320900889,
"99.9" : 3024.003320900889,
"99.99" : 3024.003320900889,
"99.999" : 3024.003320900889,
"99.9999" : 3024.003320900889,
"100.0" : 3024.003320900889
},
"scoreUnit" : "ops/s",
"rawData" : [
[
2944.1233800386635,
2980.927237742113,
2969.266072603391,
2979.6951944031885,
2989.085454549756
],
[
2986.256460662783,
3010.1826314628324,
2987.2067980861593,
2997.7695529929997,
3021.870849447342
],
[
2954.881759382517,
2967.0249445460627,
2949.05564751731,
2995.7127006836754,
3024.003320900889
],
[
2962.965115969081,
2971.99150629181,
2975.602604004213,
2975.375982863353,
2988.2185796415097
],
[
2980.2898492451827,
2986.2702801453893,
2990.0995854367275,
2985.4722869156194,
2992.4490896364227
]
]
},
"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.8659416650792162,
"scoreError" : 0.13001958681173137,
"scoreConfidence" : [
1.735922078267485,
1.9959612518909475
],
"scorePercentiles" : {
"0.0" : 1.5605498726166154,
"50.0" : 1.839344481468759,
"90.0" : 2.1389069050193568,
"95.0" : 2.1589122062566473,
"99.0" : 2.1632931026803943,
"99.9" : 2.1632931026803943,
"99.99" : 2.1632931026803943,
"99.999" : 2.1632931026803943,
"99.9999" : 2.1632931026803943,
"100.0" : 2.1632931026803943
},
"scoreUnit" : "ops/s",
"rawData" : [
[
2.043999256652405,
2.1323847652981027,
1.839344481468759,
1.6293617454226736,
2.0320717520671385
],
[
1.921083278298975,
1.751893224532046,
2.1486901146012376,
1.8215186830506138,
1.5605498726166154
],
[
2.020472253027525,
1.7808983368094768,
1.926580991574369,
1.652579183746842,
1.9587207310566184
],
[
1.9274948992467884,
1.7309711157965093,
2.1632931026803943,
1.8276244620235214,
1.56992315434993
],
[
1.7661090933982009,
1.7840933291110042,
1.9213280308660763,
2.0041723089860914,
1.7333834602984888
]
]
},
"secondaryMetrics" : {
}
}
]
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment