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
