Collecting RDS metrics from PostgreSQL databases

This text discusses how to collect and analyze metrics from Amazon RDS PostgreSQL database instances using CloudWatch and native PostgreSQL statistics views. It provides step-by-step instructions on accessing RDS metrics from the AWS Management Console, querying them through the AWS CLI, and setting up a monitoring tool that integrates with CloudWatch. The text also explains how to collect native PostgreSQL metrics directly from each database instance using various statistics views such as pg_stat_database, pg_stat_user_tables, and pg_stat_user_indexes. Additionally, it covers querying other PostgreSQL statistics for tracking replication delay, connection metrics, locks, and disk usage. The text concludes by mentioning that the next part of this series will explore how to use Datadog to automatically collect, visualize, and alert on RDS PostgreSQL data alongside metrics from more than 650 other technologies.