Check in CloudWatch , will give , what is happning at RDS
From: Wells Oliver <wells.oliver@gmail.com> Sent: Friday, July 12, 2024 5:22 PM To: pgsql-admin <pgsql-admin@postgresql.org> Subject: RDS Postgres & FreeableMemory issues
Hi, I have an RDS postgres instance and every so often my RDS alarm for FreeableMemory < 16GB (out of 64GB). This gets triggered every so often, and if I'm sitting there I can diagnose it by monitoring the OS processes and seeing what's using the RAM, but I don't know how to diagnose this after the fact.
Is there a way I can figure out which postgres processes were using all the RAM at some time?