Re: RDS Postgres & FreeableMemory issues

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

*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(dot)oliver(at)gmail(dot)com> 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(dot)oliver(at)gmail(dot)com <wellsoliver(at)gmail(dot)com>
>