troubleshooting tool

AWS offers services like Amazon CloudWatch and CloudWatch Database Insights for monitoring Amazon RDS performance metrics. Users can create custom dashboards for Amazon RDS for PostgreSQL and Amazon Aurora PostgreSQL-Compatible Edition. Essential metrics to monitor include Database Connections, CPU Utilization, Freeable Memory, and various I/O metrics. PI Reporter is an open-source tool designed to capture performance metrics and workload snapshots for Amazon Aurora PostgreSQL-Compatible Edition. It integrates with Amazon Bedrock to analyze data and provide actionable recommendations. Users can generate detailed HTML reports comparing performance metrics over time, assess workload changes, and identify performance issues. To use PI Reporter, prerequisites include enabling Amazon CloudWatch Database Insights and the pg_stat_statements extension. Installation involves cloning the repository, configuring IAM policies, and executing commands to create snapshots and reports. The tool is designed for ease of use and can be run on Amazon EC2 or on-premises. The report generated by PI Reporter includes a summary of findings, root causes, and recommendations for performance improvement. It also identifies resource utilization issues during specific operations, such as bulk data inserts or idle transactions. Users are advised to validate AI-generated recommendations with database experts and to monitor for idle transactions to optimize performance. Costs may be incurred from resources created by Amazon Bedrock, and users should clean up these resources when no longer needed.