Is your RDS for PostgreSQL or Aurora PostgreSQL instance running slowly? Dale shows how to pinpoint the cause with CloudWatch, Enhanced Monitoring, and Database Insights, then find and fix problem queries, idle connections, dead tuples, and lock waits.
0:00 Introduction
0:34 Check CPU utilization
1:04 Check memory and swap usage
1:23 Check network throughput
1:41 Check I/O performance
2:17 Enhanced Monitoring and Database Insights
2:50 Find long-running queries
3:17 Manage idle connections
3:50 Dead tuples, autovacuum, and locks
4:21 Scale up the instance class
4:39 Closing
For more information, see the Knowledge Center article:
https://repost.aws/knowledge-center/rds-aurora-postgresql-performance-issues
This video is part of the AWS Knowledge Center series: trusted, expert-reviewed answers to common questions across AWS services.
Subscribe to AWS: https://go.aws/subscribe
Create a free AWS account: https://go.aws/signup
Try AWS for free: https://go.aws/free
Connect with an expert: https://go.aws/contact
Explore more: https://go.aws/more
Next steps:
Explore on AWS in Analyst Research: https://go.aws/reports
Discover, deploy, and manage software that runs on AWS: https://go.aws/marketplace
Join the AWS Partner Network: https://go.aws/partners
Learn more on how Amazon builds and operates software: https://go.aws/library
Do you have technical AWS questions?
Ask the community of experts on AWS re:Post: https://go.aws/3lPaoPb
Why AWS?
Amazon Web Services is the world’s most comprehensive and broadly adopted cloud, enabling customers to build anything they can imagine. We offer the greatest choice of innovative cloud capabilities and expertise, on the most extensive global infrastructure with industry-leading security, reliability, and performance.
#AWS #AmazonWebServices #CloudComputing
