Insights and metrics

Crunchy Bridge provides a few different mechanisms for getting insights into your Postgres database and metrics related to it:

• Insights - These are point in time insights into your database base on Postgres' internal systems.
• Metrics - These are metrics that Crunchy Bridge's internal monitoring captures and records against your system
• Production check - This lists the status of your cluster using our list of recommended settings.
• Scope - cb scope is the equivalent of insights available in your CLI.

Insights

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

Manual resetting

If you have made recent performance improvements and want to validate them, you can reset most of your system statistics with:

SELECT pg_stat_reset();
Copy

If you want to see the last time insights were refreshed, run:

SELECT stats_reset FROM pg_stat_database WHERE datname = current_database();
Copy

Metrics

You can find system metrics on the Crunchy Bridge Dashboard under the Metrics tab. Metrics monitored and displayed in the Dashboard include:

• CPU
• IOPS
• Load average
• Memory
• Postgres Connections

Resetting metrics

Metrics are tied to the individual instance and are reset anytime you have a failover to a new machine for maintenance, upgrade, or version change. If you currently have HA enabled, you will see duplicate metrics.

Production checks

You can find the production check under Cluster Overview panel at the bottom left. See Production check for additional documentation.

Scope

The data in the insights tab in the Dashboard is available by running cb scope --cluster CLUSTER_ID --suite all.