agora inbox for pgsql-admin@postgresql.org
help / color / mirror / Atom feedRDS Postgres & FreeableMemory issues
3+ messages / 3 participants
[nested] [flat]
* RDS Postgres & FreeableMemory issues
@ 2024-07-12 21:21 Wells Oliver <wells.oliver@gmail.com>
2024-07-12 21:44 ` RE: RDS Postgres & FreeableMemory issues lennam@incisivetechgroup.com
2024-07-15 12:28 ` Re: RDS Postgres & FreeableMemory issues khan Affan <bawag773@gmail.com>
0 siblings, 2 replies; 3+ messages in thread
From: Wells Oliver @ 2024-07-12 21:21 UTC (permalink / raw)
To: pgsql-admin
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@gmail.com <wellsoliver@gmail.com>
^ permalink raw reply [nested|flat] 3+ messages in thread
* RE: RDS Postgres & FreeableMemory issues
2024-07-12 21:21 RDS Postgres & FreeableMemory issues Wells Oliver <wells.oliver@gmail.com>
@ 2024-07-12 21:44 ` lennam@incisivetechgroup.com
1 sibling, 0 replies; 3+ messages in thread
From: lennam@incisivetechgroup.com @ 2024-07-12 21:44 UTC (permalink / raw)
To: 'Wells Oliver' <wells.oliver@gmail.com>; pgsql-admin
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?
--
Wells Oliver
wells.oliver@gmail.com <mailto:wellsoliver@gmail.com>
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: RDS Postgres & FreeableMemory issues
2024-07-12 21:21 RDS Postgres & FreeableMemory issues Wells Oliver <wells.oliver@gmail.com>
@ 2024-07-15 12:28 ` khan Affan <bawag773@gmail.com>
1 sibling, 0 replies; 3+ messages in thread
From: khan Affan @ 2024-07-15 12:28 UTC (permalink / raw)
To: Wells Oliver <wells.oliver@gmail.com>; +Cc: pgsql-admin
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@gmail.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.oliver@gmail.com <wellsoliver@gmail.com>
>
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2024-07-15 12:28 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2024-07-12 21:21 RDS Postgres & FreeableMemory issues Wells Oliver <wells.oliver@gmail.com>
2024-07-12 21:44 ` lennam@incisivetechgroup.com
2024-07-15 12:28 ` khan Affan <bawag773@gmail.com>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox