Database insights

Crunchy Bridge provides database insights for you directly within the Crunchy Bridge dashboard. Database insights are automatically available to any database provisioned after August 30, 2022.

Database insights provides point in time insights into your database along with recommendations on actions you can take to improve performance. These insights include:

  • Cache and index hit rates
  • Unused indexes
  • Bloat
  • Outlier queries
  • Long running queries
  • Vacuum statistics
  • Table sizes

If database insights is not currently available for your cluster, you can initiate a high availability failover to enable database insights.

You can view insights for your database both in the dashboard and the CLI. Within the dashboard insights are available on the insights tab for a cluster. For the CLI you can get a full report of insights:

cb scope --cluster CLUSTERIDHERE --suite all