You are here:
Database Insights
Fix expensive SOQL queries and reduce database time.
Considerations
- Database Insights shows you SOQL insights and your top 15 expensive SOQL queries.
- Use the Takeaways section to see the impact on your org and follow the recommendations.
To generate database insights:
- From Setup, in the Quick Find box, enter Scale Insights, then click Database Insights.
- Click Generate Insight Report for on-demand analysis. Database Insights analyzes your queries and provides recommendations to improve database time.
Database Insight Categories
| Insight | Definition |
|---|---|
| Top 15 Expensive SOQL Queries | SOQL queries running during peak business hours consume high CPU cycles. Optimize slow queries to reduce CPU consumption and improve transaction speeds during peak hours. |
| Regressed SOQLs | SOQL queries whose performance has degraded relative to their 31-day baseline across metrics like execution count and CPU execution time. Database Insights identifies regressed SOQLs from your most resource-intensive queries and prioritizes the highest-impact regressions, including queries that regress frequently over time. |
| Takeaways & Impact | Use the recommendations to optimize suboptimal queries, reducing database time and improving scale. |
| Query Plan Analyzer Integration | Use Query Plan Analyzer to get recommendations for speeding up SOQL queries against large volumes and optimizing for scale. |
Did this article solve your issue?
Let us know so we can improve!
