Database Analyzer

This tool can help you analyze storage usage of your database and find performance issues in the database as well.

How to access the tool ?

Visit frappecloud.com/dashboard and check the sidebar. From Sidebar > Dev Tools > DB Analyzer, you can acccess the tool.

Or, you can simply visit - https://frappecloud.com/dashboard/database-analyzer

Storage Breakdown

If you want to check disk usage by every table in your database, you can click on the Storage Bar

You can then view usage by each table

Database Processes

If you want to view all the active database queries, you can view them from the same page and even kill the query if it's stuck.

Slow Queries

Slow queries usually affect the performance of your site. You can find all the information about slow queries.

Time Consuming Queries

Sometimes there are queries that execute very fast but run very frequently and, in total, consume a lot of your database's CPU time.

These queries don't always affect database performance, but the results can help you further optimize your code.

Full Table Scan Queries

If queries lack indexing or have issues, they can cause full table scans, which hurt your database performance the most.

You can find these kinds of queries and optimize them for better performance.

Index Analysis

Other than that, you can click on Suggest Indexes, and the system will try to analyze slow queries and provide suggestions based on that.

Discard
Save

On this page

Review Changes ← Back to Content
Message Status Space Raised By Last update on