What we read
pg_stat_activity — sessions, wait events and blocking chains
pg_stat_statements — per-query timing and call statistics (once enabled through the parameter group)
pg_stat_user_tables / user_indexes — dead tuple accumulation, vacuum history and index usage
pg_stat_replication — replication lag and replica state
transaction ID age — distance to wraparound and whether autovacuum is keeping up
database and table sizes — storage consumption and the growth curve
Cloud Eye — CPU, memory, disk and network metrics, via the node the instance publishes under
What it does specifically for Huawei Cloud RDS
Unified view with Cloud Eye host metrics
The in-database wait profile and the Cloud Eye host series share a timeline, separating a resource ceiling from a workload-driven slowdown.
TLS verified against the vendor CA
Huawei RDS presents a certificate signed by a CA that is not in the operating system trust store. ClusterEye takes that CA at registration and verifies the chain against it — connecting without turning certificate verification off.
Storage growth forecasting
Storage consumption is tracked and the date of reaching the limit projected.
Autovacuum and wraparound tracking
Dead tuple ratio, whether autovacuum is keeping up, and distance to transaction ID wraparound are tracked to give early warning.
Minimum privileges required
The baseline is read-only and safe to grant in production.
Prerequisites
·Agentless: the connection is made from the ClusterEye API server; nothing is installed on the RDS instance.
·TLS defaults to verify-ca — Huawei's CA is not in the operating system trust store, so you upload that certificate during registration.
·For query intelligence: enable pg_stat_statements through the parameter group, then run CREATE EXTENSION in each database.
·Host metrics (CPU, memory, disk) come from Cloud Eye and need an access key/secret and the project region. Without them in-database monitoring is unaffected; only the host series stays empty.