Hi
Unfortunately, there's no built-in functionality within RDS to view historical RAM usage by PostgreSQL processes directly, You can use some approaches that might have insight into your RAM load.
Analyze RDS cloud watch logs, long queries, connection spikes, and CPU utilization.
If this didn't work, go for RDS support so that they can show you the Pg_stat_activity view because, generally, they don't offer it.(Enabling extended statistics or setting up custom CloudWatch metrics might require coordination with AWS support.)
Thanks
Regards
Unfortunately, there's no built-in functionality within RDS to view historical RAM usage by PostgreSQL processes directly, You can use some approaches that might have insight into your RAM load.
Analyze RDS cloud watch logs, long queries, connection spikes, and CPU utilization.
If this didn't work, go for RDS support so that they can show you the Pg_stat_activity view because, generally, they don't offer it.(Enabling extended statistics or setting up custom CloudWatch metrics might require coordination with AWS support.)
Thanks
Regards
Muhammad Affan (아판)
PostgreSQL Technical Support Engineer / Pakistan R&D
Interlace Plaza 4th floor, Twinhub office, 32 I8 Markaz, Islamabad, Pakistan |
On Sat, Jul 13, 2024 at 2:22 AM Wells Oliver <wells.oliver@xxxxxxxxx> wrote:
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?--Wells Oliver
wells.oliver@xxxxxxxxx