Monitor Cloud-Managed Instances

Datasentinel supports monitoring of managed PostgreSQL instances from major cloud providers, including Amazon Web Services, Google Cloud, and Microsoft Azure, among others.

This guide focuses on AWS RDS as a representative example, but the same monitoring principles and configuration approach apply to other supported cloud-managed PostgreSQL services.

Supported Monitoring Approach

AWS RDS PostgreSQL instances are monitored using the Agentless approach.

• Monitoring relies on direct database connections and cloud-native capabilities

AWS RDS PostgreSQL instances are declared in Datasentinel like any other PostgreSQL instance, using agentless registration.

During registration, you can:

• Specify the RDS endpoint and port

• Provide database credentials

• Associate tags for filtering, analysis, and access control

Tags such as environment, application, or provider=aws are recommended.

Read Replicas and High Availability

For RDS deployments with replicas:

• Datasentinel automatically detects primary and read-only replicas

• Replica roles are identified dynamically

This allows you to analyze workload distribution and replication behavior across your RDS cluster.

Viewing Replication Statistics

For RDS PostgreSQL replicas, Datasentinel collects replication-related metrics, including:

• Replication delay, showing how far replicas lag behind the primary

• WAL delta size, representing the volume of data remaining to be replicated

These metrics help assess replication health and detect lagging replicas that may impact read scalability or failover readiness.

Consolidated Workload Analysis

Datasentinel provides consolidated views that allow you to analyze activity across multiple RDS instances or replicas.

Using dashboards and analysis modules, you can:

• View Top Queries across all RDS instances of an application

• Analyze DB workloads between primary and replicas

• Identify read vs write traffic patterns

Role-Based Access Control

Datasentinel’s role-based access control (RBAC) integrates seamlessly with AWS RDS monitoring.

By defining roles based on instance tags, administrators can:

• Restrict user access to specific RDS environments

• Grant application-level visibility across RDS instances

• Isolate production RDS clusters from non-production access

RBAC rules apply dynamically as new RDS instances are added or tags change.

Limitations and Notes

• Operating system–level metrics are not available for RDS instances

These limitation is inherent to managed PostgreSQL services.

Best Practices

• Use consistent tags across all AWS RDS instances

• Combine instance-level and consolidated views

• Monitor replication lag regularly in read-heavy architectures

• Use RBAC to enforce least-privilege access

Conclusion

Datasentinel enables secure, agentless monitoring of cloud managed PostgreSQL instances, providing visibility into workload, replication behavior, and high-availability configurations.

By combining tagging, consolidated analysis, and role-based access control, organizations can effectively monitor and manage PostgreSQL workloads running on cloud managed instances at scale.