RDSSwapUtilization #

Meaning #

Alert is triggered when RDS move data on its swap.

Impact #

• Performance could be degraded

Diagnosis #

1. Check memory usage over last weeks to identify if server is missing memory

2. Check if there long running PostgreSQL clients that don’t execute SQL queries for a while on live dashboard

   SQL

   SELECT
       pid,
       usename,
       datname,
       application_name,
       age(now(), query_start) as last_query_age,
       age(now(), backend_start) as backend_age,
       backend_start,
       query_start last_query,
       left(query, 60) query
   FROM pg_stat_activity
   WHERE query_start is not null
       AND pid != pg_backend_pid()
       AND usename != 'rdsrepladmin'
       AND state != 'active'
       AND query not like 'START_REPLICATION %'
       AND query_start < NOW() - INTERVAL '24 HOURS'
   ORDER by query_start asc;
   

Mitigation #

1. Reduce number of concurrent connections on the server

2. Increase RDS instance type to have more memory

Additional resources #

n/a