RDS-PostgreSQL provides a wide range of log and audit services. You can view or enable corresponding services as needed.
Operation Audits
RDS-PostgreSQL provides monitoring records regarding your key operations on the instance, which can be used in common application scenarios such as security analysis, compliance audit, and issue detection.
For how to monitor and view key operations, see Operation Monitoring.
Logs
Currently, RDS-PostgreSQL provides various log monitoring services to help you detect and analyze issues and optimize query estimation.
• You can check the execution of slow SQL in instance, and filter instances by SQL keywords, execution time, etc. This helps analysis and optimization and improves business efficiency. For details, see Slow Logs.
• You can view error logs and analyze system issues based on logs. For details, see Error Logs.
• The switch log provides detailed records of the master-slave switching of the primary/standby instances, helping you figure out issues such as service stability through the switch log. For details, see Switch Logs.