Slow query report

eliminate app lag with our slow query tool introduction this document defines our generic analytic slow requests report that allows users to focus on response time and monitor the performance of their app requests this report is designed to provide you with the important details about the problematic and slowest requests that have occurred in your application starting from 00 00 utc of the current day in this manner, you get a clear idea of the exact moment the unhandled request occurred you can also ascertain parameters associated with the request as method and path, response status and response time (in milliseconds) this report is exceptionally advantageous for developers as it helps them understand the precise cause of slow requests and eliminate the bottlenecks by identifying inefficient and expensive queries, thereby enabling them to improve app performance this analytic report will work only if the parse server version of your app is equal to or greater than 2 8 4 if you want to manage your parse server version for 2 8 4, follow these instructions getting started to start using the slow requests report of your app, you need to go to back4app website and click on my apps my apps find your app and then click on dashboard dashboard 2 select more more > analytics analytics section and click on slow requests slow requests section under the analytics analytics tab 2\ select more more > analytics analytics section and click on slow requests slow requests section under the analytics analytics tab by now, you should be seeing a list on the right side of the dashboard containing the slowest requests that have occurred in your app, starting from 00 00 utc of the current day this list will show all the vital information about the slow requests, including the exact date and time the request has occurred, its method and path, parameters associated with it, its response status, and also response time in milliseconds the list comprising slow requests is arranged from the request with the longest response time to the one with the shortest response time to see all the entries of the list, scroll down a little bit exploring the report to explore the slow requests report of your app, follow these steps if you don’t want to see all slow requests in the list at once, you can filter the necessary queries that are required in the report to do so, you need to click on the filter filter button located at the top right corner 2\ select the filter you want to apply method method , path path , or response status response status of your slow requests on selecting one of the filters, you can already run a query you can also pick multiple filter items from the options after choosing the filter (or filters) you want, go to the bottom right corner of your dashboard and click on the run query run query button be aware that if you select a new filter, you can’t undo this selection, except if you click on clear all clear all this option will automatically clear all your filter selections 3\ now, your filtered query is done, as shown in the image below 4\ if you want to download the report data, click on the download download button placed on the top right of the screen it’s done! congratulations! now, you can explore the slow requests report of your app through back4app and identify as well as optimize slow requests!