View Cluster Metrics

To view cluster metrics in DCD, follow these steps:

1. In the DCD, go to Menu > Databases > PostgreSQL.

2. Select a cluster by clicking on its name or select Details from the OPTIONS column.

Select a Cluster

3. Select Cluster metrics to view the metrics. You can choose a time frame to view metrics for the respective instance.

Result: You can monitor the performance and resource usage of your PostgreSQL cluster in real-time. The Cluster metrics dashboard provides insights into the following key parameters over a selected time range:

— RAM utilization: Displays the percentage of RAM used by the cluster.

— Storage utilization: Indicates the amount of storage consumed.

— CPU utilization: Shows the current CPU usage percentage.

— Memory usage: Visualizes memory consumption over time.

— Storage available: Displays remaining storage capacity with a timeline view.

— CPU usage: Tracks CPU usage over time.

— Disk I/O - Average queue depth: Reflects disk input/output operations and queue depth.

— Connections: Shows active, disabled, and idle connections to the cluster in real time.

— Transactions: Displays the number of transactions processed over time.

— Linux 5 minute load average per instance: Monitors the system load to evaluate how much demand is placed on the cluster resources.

— Number of index scans per table/schema: Indicates how efficiently the database is using indexes for query execution. — Number of sequential scans per table/schema: Displays how often full table scans are performed.

— Current instances count: Displays the number of active instances running within the cluster.

Retrieve PostgreSQL Cluster metrics