When everything feels slow
Last updated
Was this helpful?
Last updated
Was this helpful?
A. Look at Instance Usage - When you log into Xano, the Instance Dashboard will reflect where there might be a usage spike based on your capacity. This is a near real-time graph (delayed by a few min) of the last 24 hours. Ideally, you want to keep things below 50% at all times, but if you aren't on the appropriate Scale plan, usage spikes could push your Database and API capacity up.
If API usage is high - When the API usage is high on its own, this usually indicates that there is a traffic spike and your server is running out of capacity. This normally happens when multiple users are trying to request data from your API at the same time. You can increase your capacity by upgrading to a different Scale package.
B. Instance Stats You can see the volume of requests happening across all your workspaces here. This is also across a 24-hour window and is updated every hour. If you see a large volume of requests as pictured above, proceed to step 2 to see where it's coming from.
To dig deeper into the details of each request, you can proceed to Step 2 below.
Each workspace has a dashboard item of request history. Click DETAILS at the top right of the graph to see each request.
A. You can filter down the requests that are taking the longest. Select the magnifying class to do this. A good rule of thumb is to select requests that are greater than 5s.
B. You can click the refresh button to ensure you're getting the latest data.
If Database usage is high - When the Database (blue) request line is high as shown above, this usually means that your Database is not optimized or indexed properly. Please visit the section to look at ways to fix the tables that are being queried. Usually, API usage goes hand-in-hand with Database usage, so it isn't surprising to see them at the same level in the above example. Once fixed, you should see both Database and API usage go down.
If you need hands-on private help diagnosing this, you can schedule a with one of our Xano team members.
C. Click on the request that takes a long time to show the details.
