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