View PostgreSQL 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