Metrics support v1.3.2

Hybrid Manager (HM) collects and displays a wide range of metrics to give you comprehensive visibility into your database clusters.

The availability of metrics you can see in the HM console depends on the metric and cluster type.

Summarized overview

This overview shows the available metrics per database cluster type.

Host metricsPostgres metricsCluster metricsQuery metricsRecommendationsLogs
HM-managed clusterYesYesYesYesYesYes
External:
Self-managed cluster
YesYesNoYesYesYes
External:
CNPG database cluster
YesYesYesYesYesYes
External:
AWS RDS database
Yespartial supportNoNoNoNo
Limitations
  • Currently, the Hybrid Manager supports monitoring for EDB CloudNativePG clusters. Monitoring for open-source CloudNativePG clusters will be supported in a future release.
  • Monitoring isn't supported for external EDB Postgres Distributed clusters.

Detailed overview

Host metrics

Host metrics display resource utilization for the underlying server infrastructure hosting your database instances. You can see them in the Estate view and in the cluster view's Monitoring tab in the Host section.

MetricHM-managed clusterExternal:
Self-managed cluster
External:
CNPG database cluster
External:
AWS RDS database
MemoryYesYesYesYes
CPUYesYesYesYes
StorageYesYesYesYes
Disk IOPSYesYesYesYes
Disk throughputYesYesYesYes
Network activityYesYesYesYes
Important

Memory, CPU, and storage metrics show the average percentage usage for Postgres processes on the hosting node. To monitor system-wide usage on HM-managed clusters, use Grafana. System-wide monitoring isn't currently supported for external clusters.

Postgres metrics

Postgres metrics show performance and operational statistics specific to the Postgres database server. You can see them in the Estate view and in the cluster view's Monitoring tab.

MetricHM-managed clusterExternal:
Self-managed cluster
External:
CNPG database cluster
External:
AWS RDS database
Connections
ConnectionsYesYesYesYes
AAS by Wait TypeYesYesYesNo
Nr. of blocked backendsYesYesYesNo
Transactions
Tuples inYesYesYesYes
Tuples outYesYesYesYes
Transactions rateYesYesYesYes
Buffer cache hit rationYesYesYesYes
Longest running transactionYesYesYesNo
Queries
Query latencyYesYesYesNo
Query rateYesYesYesNo
Storage
Database sizeYesYesYesNo
Disk usageYesYesYesNo
WAL sizeYesYesYesYes
WAL usageYesYesYesNo
Live/Dead tuplesYesYesYesNo
Index/table/temp estimated sizeYesYesYesYes
Internals
Time since last autovacuumYesYesYesYes
Autovacuum StatsYesYesYesYes
Time since last checkpointYesYesYesYes
Checkpoint statsYesYesYesYes
Time since last successful WAL archiveYesYesYesNo
WAL archiving statsYesYesYesYes

Cluster metrics

Cluster metrics are host and postgres metrics, individual and aggregated for database deployments spanning multiple nodes (HA, AHA, and DHA topologies). You can see them in the Estate view and in the cluster view's Monitoring tab in the Topology and Replication sections. Cluster metrics aren't displayed for single node deployments.

MetricHM-managed clusterExternal:
Self-managed cluster
External:
CNPG database cluster
External:
AWS RDS database
RAFT status (AHA, and DHA)YesNoNoNo
Replication slot statusYesNoYesNo
Clock skewYesNoYesNo
Node statusYesNoYesNo
Transaction rateYesNoYesNo
Connections (total)YesNoYesNo
Connections (per node)YesNoYesNo
Memory (per node)YesNoYesNo
Storage (per node)YesNoYesNo
WAL size (per node)YesNoYesNo
Replication statusYesNoYesNo

Query metrics

Query metrics offer insights into the performance and characteristics of the database Postgres queries being executed. You can see them in the cluster view's Query diagnostics tab.

MetricHM-managed clusterExternal:
Self-managed cluster
External:
CNPG database cluster
External:
AWS RDS database
Query latencyYesYesYesNo
Nr. of queries executedYesYesYesNo
Query latency histogramYesYesYesNo
Nr. of active sessionsYesYesYesNo

Recommendations

Recommendations suggest actions and optimizations based on observed metrics to improve your database environment (for example, improve indexes). You can see them in the cluster view's Recommendations tab.

MetricHM-managed clusterExternal:
Self-managed cluster
External:
CNPG database cluster
External:
AWS RDS database
IndexesYesYesYesNo
StatisticsYesYesYesNo
ConfigurationYesYesYesNo
SecurityNoNoNoNo
WorkloadNoNoNoNo

Logs

Logs present raw and processed log data from various components of your database system for troubleshooting and auditing. You can see them in the cluster view's Logs tab.

MetricHM-managed clusterExternal:
Self-managed cluster
External:
CNPG database cluster
External:
AWS RDS database
LogsYesYesYesNo