What is it?
Database Analyzer is a tool that helps you understand how your website uses the database. It works like a performance monitor that shows which plugins and functions put the most load on your database.
Main Features
Real-time Query Monitoring
When you enable monitoring, the tool tracks every database query your website executes. This way you see exactly what's happening "under the hood" of your site.
Plugin Analysis
The tool shows which plugins generate the most database queries. Each plugin receives a score from 0 to 100 points:
- Low score = plugin works efficiently
- High score = plugin may be slowing down your site
Risk Levels
Each plugin is marked with colors:
- 🟢 LOW (green) - plugin works well
- 🟡 MEDIUM (yellow) - worth paying attention to
- 🟠 HIGH (orange) - plugin may be slowing down your site
- 🔴 CRITICAL (red) - urgent need for optimization
Detailed Statistics
For each plugin you'll see:
- Number of database queries
- Execution time of all queries
- Average time of a single query
- Query complexity (simple vs complex)
Optimization Recommendations
The tool suggests what you can do to speed up your site:
- Enable object caching
- Optimize database queries
- Add indexes to tables
- Disable unnecessary plugin features
Query Export
You can download a detailed list of the slowest queries to a CSV file. This is useful when you want to show the problem to a developer or plugin for further analysis.
Database Table Analysis
The tool shows which tables in the database are largest and which plugins they belong to. This helps identify plugins that accumulate a lot of data.
How it works?
- Enable monitoring - click the "Start Monitoring" button (feature available in PRO version)
- Use your site - visit different pages, add products, publish posts
- Stop monitoring - click "Stop Monitoring" to see the results
- Analyze results - browse plugin cards and recommendations
Why is this important?
- Faster site - identifying slow plugins allows you to speed up your website
- Lower resource usage - query optimization reduces server load
- Better user experience - a faster site means satisfied visitors
- Cost savings - lower server load can mean cheaper hosting
Special Treatment
The tool intelligently recognizes:
- WordPress Core - the WordPress core receives more lenient scores because it's essential
- WooCommerce - an online store naturally performs more queries, so it has higher scoring thresholds
- Action Scheduler - a background task tool that is normally used by many plugins
Security
- Monitoring automatically stops after 1 hour
- Maximum of 10,000 queries are stored
- Data is temporary and can be deleted at any time
