Skip to content

AspNetCore Built In Endpoints

Jump to bottom
Furkan Güngör edited this page Oct 27, 2021 · 1 revision

Purpose

With the EasyProfiler.AspNetCore library, it lists the slowest, fastest, advanced-filter and most used endpoints for you.

Usage

Install EasyProfiler.AspNetCore from Nuget Package

Slowest Endpoints

METHOD : GET
URL : {BASE_URL}/easy-profiler/slowest-endpoint
RESPONSE : 

[
  {
    "requestUrl": "EasyProfiler.Web.Controllers.DefaultController.GetAllCustomersAsync (EasyProfiler.Web)",
    "count": 101,
    "avarageDurationTime": {
      "ticks": 162402,
      "days": 0,
      "hours": 0,
      "milliseconds": 16,
      "minutes": 0,
      "seconds": 0,
      "totalDays": 1.879652777777778e-7,
      "totalHours": 0.000004511166666666667,
      "totalMilliseconds": 16.2402,
      "totalMinutes": 0.00027067,
      "totalSeconds": 0.0162402
    }
  }
]

Fastest Endpoints

METHOD : GET
URL : {BASE_URL}/easy-profiler/fastest-endpoint
RESPONSE : 

[
  {
    "requestUrl": "EasyProfiler.Web.Controllers.DefaultController.GetAllCustomersAsync (EasyProfiler.Web)",
    "count": 110,
    "avarageDurationTime": {
      "ticks": 154592,
      "days": 0,
      "hours": 0,
      "milliseconds": 15,
      "minutes": 0,
      "seconds": 0,
      "totalDays": 1.7892592592592593e-7,
      "totalHours": 0.000004294222222222222,
      "totalMilliseconds": 15.4592,
      "totalMinutes": 0.0002576533333333333,
      "totalSeconds": 0.0154592
    }
  }
]

Most Requested Endpoints

METHOD : GET
URL : {BASE_URL}/easy-profiler/most-requested-endpoint
RESPONSE : 

[
  {
    "name": "EasyProfiler.Web.Controllers.DefaultController.GetAllCustomersAsync (EasyProfiler.Web)",
    "count": 110
  }
]

Advanced Filter

METHOD : GET
URL : {BASE_URL}/easy-profiler/advanced-filter
RESPONSE : 

[
  {
    "query": "SELECT c.\"CustomerId\", c.\"CreateDate\", c.\"Name\", c.\"Surname\"\r\nFROM \"Customers\" AS c",
    "duration": {
      "ticks": 8208923,
      "days": 0,
      "hours": 0,
      "milliseconds": 820,
      "minutes": 0,
      "seconds": 0,
      "totalDays": 0.000009501068287037037,
      "totalHours": 0.0002280256388888889,
      "totalMilliseconds": 820.8923,
      "totalMinutes": 0.013681538333333333,
      "totalSeconds": 0.8208923
    },
    "requestUrl": "EasyProfiler.Web.Controllers.DefaultController.GetAllCustomersAsync (EasyProfiler.Web)",
    "queryType": "SELECT",
    "id": "ea523271-2093-410c-81c9-13fbc7deae1e",
    "startDate": "2021-09-28T19:36:52.832979",
    "endDate": "2021-09-28T19:36:53.65387"
  },
  {
    "query": "SELECT c.\"CustomerId\", c.\"CreateDate\", c.\"Name\", c.\"Surname\"\r\nFROM \"Customers\" AS c",
    "duration": {
      "ticks": 1876700,
      "days": 0,
      "hours": 0,
      "milliseconds": 187,
      "minutes": 0,
      "seconds": 0,
      "totalDays": 0.0000021721064814814815,
      "totalHours": 0.000052130555555555556,
      "totalMilliseconds": 187.67,
      "totalMinutes": 0.003127833333333333,
      "totalSeconds": 0.18767
    },
    "requestUrl": "EasyProfiler.Web.Controllers.DefaultController.GetAllCustomersAsync (EasyProfiler.Web)",
    "queryType": "SELECT",
    "id": "bd5e309d-dc23-4248-a16a-317a58f545a5",
    "startDate": "2021-09-28T19:36:53.884952",
    "endDate": "2021-09-28T19:36:54.072619"
  },
  {
    "query": "SELECT c.\"CustomerId\", c.\"CreateDate\", c.\"Name\", c.\"Surname\"\r\nFROM \"Customers\" AS c",
    "duration": {
      "ticks": 1778589,
      "days": 0,
      "hours": 0,
      "milliseconds": 177,
      "minutes": 0,
      "seconds": 0,
      "totalDays": 0.0000020585520833333333,
      "totalHours": 0.00004940525,
      "totalMilliseconds": 177.8589,
      "totalMinutes": 0.002964315,
      "totalSeconds": 0.1778589
    },
    "requestUrl": "EasyProfiler.Web.Controllers.DefaultController.GetAllCustomersAsync (EasyProfiler.Web)",
    "queryType": "SELECT",
    "id": "4d385817-0b7d-439d-95ee-0661a25142d4",
    "startDate": "2021-09-28T19:36:54.283705",
    "endDate": "2021-09-28T19:36:54.461563"
  },
  {
    "query": "SELECT c.\"CustomerId\", c.\"CreateDate\", c.\"Name\", c.\"Surname\"\nFROM \"Customers\" AS c",
    "duration": {
      "ticks": 498182,
      "days": 0,
      "hours": 0,
      "milliseconds": 49,
      "minutes": 0,
      "seconds": 0,
      "totalDays": 5.765995370370371e-7,
      "totalHours": 0.000013838388888888889,
      "totalMilliseconds": 49.8182,
      "totalMinutes": 0.0008303033333333334,
      "totalSeconds": 0.0498182
    },
    "requestUrl": "EasyProfiler.Web.Controllers.DefaultController.GetAllCustomersAsync (EasyProfiler.Web)",
    "queryType": "SELECT",
    "id": "8df02cc9-0c0f-4d67-b648-904c03590ebb",
    "startDate": "2021-10-23T21:29:11.298575",
    "endDate": "2021-10-23T21:29:11.348372"
  },
  {
    "query": "SELECT c.\"CustomerId\", c.\"CreateDate\", c.\"Name\", c.\"Surname\"\nFROM \"Customers\" AS c",
    "duration": {
      "ticks": 468410,
      "days": 0,
      "hours": 0,
      "milliseconds": 46,
      "minutes": 0,
      "seconds": 0,
      "totalDays": 5.421412037037037e-7,
      "totalHours": 0.000013011388888888888,
      "totalMilliseconds": 46.841,
      "totalMinutes": 0.0007806833333333334,
      "totalSeconds": 0.046841
    },
    "requestUrl": "EasyProfiler.Web.Controllers.DefaultController.GetAllCustomersAsync (EasyProfiler.Web)",
    "queryType": "SELECT",
    "id": "8e56b453-d08a-43f3-bf84-0a8252ed25d5",
    "startDate": "2021-10-06T06:55:41.869834",
    "endDate": "2021-10-06T06:55:41.916648"
  },
  {
    "query": "SELECT c.\"CustomerId\", c.\"CreateDate\", c.\"Name\", c.\"Surname\"\r\nFROM \"Customers\" AS c",
    "duration": {
      "ticks": 447323,
      "days": 0,
      "hours": 0,
      "milliseconds": 44,
      "minutes": 0,
      "seconds": 0,
      "totalDays": 5.177349537037037e-7,
      "totalHours": 0.00001242563888888889,
      "totalMilliseconds": 44.7323,
      "totalMinutes": 0.0007455383333333333,
      "totalSeconds": 0.0447323
    },
    "requestUrl": "EasyProfiler.Web.Controllers.DefaultController.GetAllCustomersAsync (EasyProfiler.Web)",
    "queryType": "SELECT",
    "id": "d0ea651c-b700-4053-b007-d05b509e798f",
    "startDate": "2021-09-28T19:36:39.451994",
    "endDate": "2021-09-28T19:36:39.496683"
  },
  {
    "query": "SELECT c.\"CustomerId\", c.\"CreateDate\", c.\"Name\", c.\"Surname\"\r\nFROM \"Customers\" AS c",
    "duration": {
      "ticks": 418016,
      "days": 0,
      "hours": 0,
      "milliseconds": 41,
      "minutes": 0,
      "seconds": 0,
      "totalDays": 4.838148148148149e-7,
      "totalHours": 0.000011611555555555555,
      "totalMilliseconds": 41.8016,
      "totalMinutes": 0.0006966933333333333,
      "totalSeconds": 0.0418016
    },
    "requestUrl": "EasyProfiler.Web.Controllers.DefaultController.GetAllCustomersAsync (EasyProfiler.Web)",
    "queryType": "SELECT",
    "id": "f181448c-decf-45e0-bca4-1dc00c11678b",
    "startDate": "2021-10-27T11:29:28.015941",
    "endDate": "2021-10-27T11:29:28.057697"
  },
  {
    "query": "SELECT c.\"CustomerId\", c.\"CreateDate\", c.\"Name\", c.\"Surname\"\r\nFROM \"Customers\" AS c",
    "duration": {
      "ticks": 340389,
      "days": 0,
      "hours": 0,
      "milliseconds": 34,
      "minutes": 0,
      "seconds": 0,
      "totalDays": 3.9396875e-7,
      "totalHours": 0.00000945525,
      "totalMilliseconds": 34.0389,
      "totalMinutes": 0.000567315,
      "totalSeconds": 0.0340389
    },
    "requestUrl": "EasyProfiler.Web.Controllers.DefaultController.GetAllCustomersAsync (EasyProfiler.Web)",
    "queryType": "SELECT",
    "id": "a457d7d4-c41c-4abc-8709-baf5a2ed5f96",
    "startDate": "2021-09-28T19:36:57.830725",
    "endDate": "2021-09-28T19:36:57.864762"
  },
  {
    "query": "SELECT c.\"CustomerId\", c.\"CreateDate\", c.\"Name\", c.\"Surname\"\r\nFROM \"Customers\" AS c",
    "duration": {
      "ticks": 158191,
      "days": 0,
      "hours": 0,
      "milliseconds": 15,
      "minutes": 0,
      "seconds": 0,
      "totalDays": 1.830914351851852e-7,
      "totalHours": 0.000004394194444444444,
      "totalMilliseconds": 15.8191,
      "totalMinutes": 0.00026365166666666664,
      "totalSeconds": 0.0158191
    },
    "requestUrl": "EasyProfiler.Web.Controllers.DefaultController.GetAllCustomersAsync (EasyProfiler.Web)",
    "queryType": "SELECT",
    "id": "1ab2e36f-11e5-4114-8c16-26b5215a2672",
    "startDate": "2021-09-28T19:36:52.565334",
    "endDate": "2021-09-28T19:36:52.581149"
  },
  {
    "query": "SELECT c.\"CustomerId\", c.\"CreateDate\", c.\"Name\", c.\"Surname\"\nFROM \"Customers\" AS c",
    "duration": {
      "ticks": 148787,
      "days": 0,
      "hours": 0,
      "milliseconds": 14,
      "minutes": 0,
      "seconds": 0,
      "totalDays": 1.7220717592592591e-7,
      "totalHours": 0.000004132972222222222,
      "totalMilliseconds": 14.8787,
      "totalMinutes": 0.0002479783333333333,
      "totalSeconds": 0.0148787
    },
    "requestUrl": "EasyProfiler.Web.Controllers.DefaultController.GetAllCustomersAsync (EasyProfiler.Web)",
    "queryType": "SELECT",
    "id": "a89ce6f3-2c7a-4e2d-8557-365fc44f7fee",
    "startDate": "2021-10-04T08:31:45.408314",
    "endDate": "2021-10-04T08:31:45.423172"
  }
]

Sort Properties

  • {BASE_URL}/easy-profiler/advanced-filter?sort=Duration
  • {BASE_URL}/easy-profiler/advanced-filter?sort=Query
  • {BASE_URL}/easy-profiler/advanced-filter?sortBy=Ascending&sort=Duration
  • {BASE_URL}/easy-profiler/advanced-filter?sortBy=Ascending&sort=Query
  • {BASE_URL}/easy-profiler/advanced-filter?sortBy=Descending&sort=Duration
  • {BASE_URL}/easy-profiler/advanced-filter?sortBy=Descending&sort=Query

Filter Properties

  • {BASE_URL}/easy-profiler/advanced-filter?duration.min=1&duration.max=10
  • {BASE_URL}/easy-profiler/advanced-filter?duration.min=1&duration.max=10&queryType=SELECT
  • {BASE_URL}/easy-profiler/advanced-filter?duration.min=1&duration.max=10&queryType=SELECT&page=1&perPage=10
  • {BASE_URL}/easy-profiler/advanced-filter?requestUrl=getAllCustomer&duration.min=1&duration.max=10&queryType=SELECT&page=1&perPage=10
  • {BASE_URL}/easy-profiler/advanced-filter?requestUrl=getAllCustomer&duration.min=1&duration.max=10&queryType=SELECT&page=1&perPage=10&combineWith=Or
  • {BASE_URL}/easy-profiler/advanced-filter?requestUrl=getAllCustomer&duration.min=1&duration.max=10&queryType=SELECT&page=1&perPage=10&query=customer

Welcome to the EasyProfiler wiki!

Topics:

Clone this wiki locally