---
schema_version: "1"
id: 828dce0ffa74e52946522dde6669e6b1c0e0d8b708de9f1243271f3e00aa32a3
title: Database Insights
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/xcloud/264-0-0/database_insights_overview.md
canonical_url: https://help.salesforce.com/s/articleView?id=xcloud.database_insights_overview.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 0a44d57dcc8504c6aba453c20eceec24bdc1798a1dc87728a0f555b7add28bc8
description: Fix expensive SOQL queries and reduce database time.
products:
  - Cross Cloud
release: "264"
---
# 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:

1. From Setup, in the Quick Find box, enter Scale Insights, then click **Database Insights**.
2. Click **Generate Insight Report** for on-demand analysis. Database Insights analyzes your queries and provides recommendations to improve database time.

![Database Insight Categories](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-xcloud-scalability-264-0-0-production-enus/18f3af65-f4ea-4406-9c30-319b9afa03cd/images/icon_example.png)

Database Insight Categories <table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small ">
            <colgroup>
              <col style="width:35.46099290780141%">
              <col style="width:64.53900709219857%">
            </colgroup>
            <thead class="slds-text-title_caps ">
              <tr class="">
                <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d4037e83">Insight</th>
                <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d4037e86">Definition</th>
              </tr>
            </thead>
            <tbody>
              <tr class="">
                <td data-label="Insight" class="slds-cell-wrap" style="vertical-align:top;" headers="d4037e83 ">Top 15 Expensive SOQL Queries</td>

                <td data-label="Definition" class="slds-cell-wrap" style="vertical-align:top;" headers="d4037e86 ">
                  <p style="margin-bottom:0;">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.</p>
                </td>

              </tr>
              <tr class="">
                <td data-label="Insight" class="slds-cell-wrap" style="vertical-align:top;" headers="d4037e83 ">Regressed SOQLs</td>

                <td data-label="Definition" class="slds-cell-wrap" style="vertical-align:top;" headers="d4037e86 ">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.</td>

              </tr>
              <tr class="">
                <td data-label="Insight" class="slds-cell-wrap" style="vertical-align:top;" headers="d4037e83 ">Takeaways &amp; Impact</td>

                <td data-label="Definition" class="slds-cell-wrap" style="vertical-align:top;" headers="d4037e86 ">Use the recommendations to optimize suboptimal queries, reducing database time and
                  improving scale.</td>

              </tr>
              <tr class="">
                <td data-label="Insight" class="slds-cell-wrap" style="vertical-align:top;" headers="d4037e83 ">Query Plan Analyzer Integration</td>

                <td data-label="Definition" class="slds-cell-wrap" style="vertical-align:top;" headers="d4037e86 ">Use Query Plan Analyzer to get recommendations for speeding up SOQL queries against
                  large volumes and optimizing for scale.</td>

              </tr>
            </tbody>
          </table>