search

yugabyte / tpcc

Repo to run TPCC benchmarks against YugabyteDB
Other
24 stars 21 forks source link

Save metrics in Json format into a file. #113

Closed sonalsagarwal closed 3 years ago

sonalsagarwal commented 3 years ago

Output in JSON file :

{
  "Results": {
    "tpmc": 2666.4,
    "Efficiency": 82.93623639191291,
    "throughput": 104.49957258420818
  },
  "Total and Failure Latencies": {
    "Latencies": [
      {
        "Transaction": "NewOrder",
        "Count": "4444",
        "Avg. Latency": "87.19331773177318",
        "P99Latency": "890.829",
        "ConnectionAcq Latency": "167.47797187218723"
      },
      {
        "Transaction": "Payment",
        "Count": "4520",
        "Avg. Latency": "27.181047123893805",
        "P99Latency": "460.341",
        "ConnectionAcq Latency": "158.55155929203542"
      },
      {
        "Transaction": "OrderStatus",
        "Count": "477",
        "Avg. Latency": "180.26904402515723",
        "P99Latency": "1959.577",
        "ConnectionAcq Latency": "107.4127714884696"
      },
      {
        "Transaction": "Delivery",
        "Count": "492",
        "Avg. Latency": "272.41915040650406",
        "P99Latency": "2204.036",
        "ConnectionAcq Latency": "77.73062804878049"
      },
      {
        "Transaction": "StockLevel",
        "Count": "517",
        "Avg. Latency": "218.03172340425533",
        "P99Latency": "1825.583",
        "ConnectionAcq Latency": "86.33394970986461"
      },
      {
        "Transaction": "All",
        "Count": "10450",
        "Avg. Latency": "80.67812382775121",
        "P99Latency": "1381.964",
        "ConnectionAcq Latency": "152.63532708133974"
      }
    ],
    "FailureLatencies": [
      {
        "Transaction": "NewOrder",
        "Count": "178",
        "Avg. Latency": "235.65978651685393",
        "P99Latency": "1338.458",
        "ConnectionAcq Latency": "531.1215"
      },
      {
        "Transaction": "Payment",
        "Count": "499",
        "Avg. Latency": "254.71054108216433",
        "P99Latency": "1227.342",
        "ConnectionAcq Latency": "1114.1103306613227"
      },
      {
        "Transaction": "OrderStatus",
        "Count": "0",
        "Avg. Latency": "-1.0",
        "P99Latency": "-1.0",
        "ConnectionAcq Latency": "-1.0"
      },
      {
        "Transaction": "Delivery",
        "Count": "11",
        "Avg. Latency": "1147.0582727272727",
        "P99Latency": "1648.01",
        "ConnectionAcq Latency": "110.45063636363636"
      },
      {
        "Transaction": "StockLevel",
        "Count": "0",
        "Avg. Latency": "-1.0",
        "P99Latency": "-1.0",
        "ConnectionAcq Latency": "-1.0"
      },
      {
        "Transaction": "All",
        "Count": "688",
        "Avg. Latency": "264.04889970930236",
        "P99Latency": "1312.243",
        "ConnectionAcq Latency": "947.2320334302326"
      }
    ]
  },
  "Work Task Latencies": {
    "NewOrder": [
      {
        "Task": "FetchWork",
        "Count": "4447",
        "Avg. Latency": "29.76425860130425",
        "P99Latency": "239.085"
      },
      {
        "Task": "Keying",
        "Count": "4447",
        "Avg. Latency": "18000.15308005397",
        "P99Latency": "18004.102"
      },
      {
        "Task": "Op With Retry",
        "Count": "4447",
        "Avg. Latency": "264.2759628963346",
        "P99Latency": "1528.336"
      },
      {
        "Task": "Thinking",
        "Count": "4447",
        "Avg. Latency": "10408.837906903529",
        "P99Latency": "45113.061"
      }
    ],
    "Payment": [
      {
        "Task": "FetchWork",
        "Count": "5019",
        "Avg. Latency": "21.556196652719663",
        "P99Latency": "234.452"
      },
      {
        "Task": "Keying",
        "Count": "5019",
        "Avg. Latency": "3002.3411659693165",
        "P99Latency": "3050.689"
      },
      {
        "Task": "Op With Retry",
        "Count": "5019",
        "Avg. Latency": "303.4010771069934",
        "P99Latency": "1683.488"
      },
      {
        "Task": "Thinking",
        "Count": "5019",
        "Avg. Latency": "10713.607325363617",
        "P99Latency": "44928.06"
      }
    ],
    "OrderStatus": [
      {
        "Task": "FetchWork",
        "Count": "477",
        "Avg. Latency": "24.82384067085954",
        "P99Latency": "241.997"
      },
      {
        "Task": "Keying",
        "Count": "477",
        "Avg. Latency": "2000.1101970649895",
        "P99Latency": "2002.88"
      },
      {
        "Task": "Op With Retry",
        "Count": "477",
        "Avg. Latency": "287.85398322851154",
        "P99Latency": "2087.621"
      },
      {
        "Task": "Thinking",
        "Count": "477",
        "Avg. Latency": "9745.491771488469",
        "P99Latency": "44104.061"
      }
    ],
    "Delivery": [
      {
        "Task": "FetchWork",
        "Count": "503",
        "Avg. Latency": "22.51500198807157",
        "P99Latency": "235.636"
      },
      {
        "Task": "Keying",
        "Count": "503",
        "Avg. Latency": "2000.1001212723659",
        "P99Latency": "2001.255"
      },
      {
        "Task": "Op With Retry",
        "Count": "503",
        "Avg. Latency": "370.0120079522863",
        "P99Latency": "2263.294"
      },
      {
        "Task": "Thinking",
        "Count": "503",
        "Avg. Latency": "4821.823013916501",
        "P99Latency": "22449.061"
      }
    ],
    "StockLevel": [
      {
        "Task": "FetchWork",
        "Count": "517",
        "Avg. Latency": "22.946943907156673",
        "P99Latency": "232.029"
      },
      {
        "Task": "Keying",
        "Count": "517",
        "Avg. Latency": "2000.1347814313347",
        "P99Latency": "2001.909"
      },
      {
        "Task": "Op With Retry",
        "Count": "517",
        "Avg. Latency": "304.61895551257254",
        "P99Latency": "2207.142"
      },
      {
        "Task": "Thinking",
        "Count": "517",
        "Avg. Latency": "4718.610222437138",
        "P99Latency": "21454.06"
      }
    ],
    "All": [
      {
        "Task": "FetchWork",
        "Count": "10963",
        "Avg. Latency": "25.13744385660859",
        "P99Latency": "236.862"
      },
      {
        "Task": "Keying",
        "Count": "10963",
        "Avg. Latency": "8949.156587248017",
        "P99Latency": "18000.091"
      },
      {
        "Task": "Op With Retry",
        "Count": "10963",
        "Avg. Latency": "289.96767335583326",
        "P99Latency": "1746.452"
      },
      {
        "Task": "Thinking",
        "Count": "10963",
        "Avg. Latency": "9994.818514457722",
        "P99Latency": "44244.061"
      },
      {
        "Task": "All",
        "Count": "10963",
        "Avg. Latency": "19259.080218918178",
        "P99Latency": "57120.022"
      }
    ]
  },
  "Retry Attempts": [
    {
      "Transaction": "NewOrder",
      "Count": "4447",
      " Retry #0 - Failure Count |": "151 (3.3955475601529126)",
      " Retry #1 - Failure Count |": "24 (0.5396896784348999)",
      " Retry #2 - Failure Count |": "3 (0.06746120980436249)"
    },
    {
      "Transaction": "Payment",
      "Count": "5019",
      " Retry #0 - Failure Count |": "499 (9.942219565650529)",
      " Retry #1 - Failure Count |": "0 (0.0)",
      " Retry #2 - Failure Count |": "0 (0.0)"
    },
    {
      "Transaction": "OrderStatus",
      "Count": "477",
      " Retry #0 - Failure Count |": "0 (0.0)",
      " Retry #1 - Failure Count |": "0 (0.0)",
      " Retry #2 - Failure Count |": "0 (0.0)"
    },
    {
      "Transaction": "Delivery",
      "Count": "503",
      " Retry #0 - Failure Count |": "11 (2.1868787276341948)",
      " Retry #1 - Failure Count |": "0 (0.0)",
      " Retry #2 - Failure Count |": "0 (0.0)"
    },
    {
      "Transaction": "StockLevel",
      "Count": "517",
      " Retry #0 - Failure Count |": "0 (0.0)",
      " Retry #1 - Failure Count |": "0 (0.0)",
      " Retry #2 - Failure Count |": "0 (0.0)"
    }
  ]
}