Re: RDS Postgres & FreeableMemory issues

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.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?

--

[Index of Archives]     [Postgresql Home]     [Postgresql General]     [Postgresql Performance]     [Postgresql PHP]     [Postgresql Jobs]     [PHP Users]     [PHP Databases]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Forum]

  Powered by Linux