Runbook: MemoryPressure Alert

Alert Details

• Alert Name: MemoryPressure
• Expression: rate(pg_stat_database_temp_bytes{datname!~"template.*"}[5m]) / 1024 / 1024 > 50

Description

DB has to write to temporary files because memory limit for operations is reached.

Possible Causes

• DB queries are too expensive
• DB memory limit for operations is reached

Troubleshooting Steps

1. increase memory limit

• setting has to be made in aws (contact the responsible lvl3 person)
  • AWS->services->aurora and rds-> paramaeter group -> $database -> paramaters -> work_mem