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.
