Help Center/ Relational Database Service/ User Guide (Ally Region)/ Working with RDS for PostgreSQL/ Common Performance Problems/ High CPU Usage of RDS for PostgreSQL Instances
Updated on 2026-04-24 GMT+08:00
View PDF
Share

High CPU Usage of RDS for PostgreSQL Instances

If the CPU usage is high or close to 100% on your RDS for PostgreSQL instance, data read/write processing and network connection will slow down and errors will be reported when you delete data. Your workload will be affected.

Solution

Analyze slow SQL logs and CPU usage to locate and optimize slow queries.

  1. View the slow SQL logs to check for slowly executed SQL queries and view their performance characteristics (if any) to locate the cause.

    For details on viewing RDS for PostgreSQL logs, see Querying Slow Query Logs.

  2. View the CPU usage of your RDS instance to facilitate problem locating.

    For details, see Monitoring by Cloud Eye.

  3. Create read replicas to reduce read pressure on primary instances.
  4. Add indexes for associated fields in multi-table join queries.
  5. Do not use the SELECT * statement for full table scans. Instead, specify the fields you need or add the WHERE clause.