AWS RDS

Size

  • large
  • xlarge
  • 2xlarge
  • 4xlarge
  • 8xlarge
  • 10xlarge
  • 12xlarge
  • 16xlarge
  • 24xlarge

Start from db.r5.large with 1 core, 2 vCPU and 16GB Memory.
Up to db.r5.24xlarge 48 Cores, 96 vCPU and 768GB Memory.

Instance Types

T3 is general purpose and M5 is better T3. R5 is better and memory optimized.

Either start with M5 or R5 for real-production use. R5 is better because the ceiling is higher in case your business succeeds.

You can find IOPS in Databases > Configuration when your instance reached certain size.

Performance Insights

Official Documentation

Activity of RDS. Top SQL / most expensive queries. Adjustable to 5m, 1h, 5h, 24h, 1w, all. OS Metrics.

Enhanced Monitoring

Official Documentation

Since PostgreSQL 10.

Where

  1. Databases > your-database-name > Monitoring (tab) > Monitoring (dropdown middle right) > Enhanced Monitoring

  2. CloudWatch Logs > Log groups > RDSOSMetrics

OS metrics

CloudWatch

CloudWatch metrics and alarms. Performance Insights actually exports metrics to CloudWatch.

Other Monitoring

Operations

Grant Superuser to a user/role:

GRANT rds_superuser TO user-or-role;