Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sSO4Q-006nwt-Go for pgsql-admin@arkaria.postgresql.org; Fri, 12 Jul 2024 21:44:50 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1sSO4P-00Bzxf-83 for pgsql-admin@arkaria.postgresql.org; Fri, 12 Jul 2024 21:44:49 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sSO4O-00BzxX-Sw for pgsql-admin@lists.postgresql.org; Fri, 12 Jul 2024 21:44:48 +0000 Received: from chi208.greengeeks.net ([65.60.38.74]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sSO4L-001pop-Lv for pgsql-admin@postgresql.org; Fri, 12 Jul 2024 21:44:48 +0000 Received: from [217.180.196.83] (port=60834 helo=Incisivetech) by chi208.greengeeks.net with esmtpsa (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.97.1) (envelope-from ) id 1sSO5T-00000005l6F-1SzA; Fri, 12 Jul 2024 21:44:43 +0000 From: To: "'Wells Oliver'" , "'pgsql-admin'" References: In-Reply-To: Subject: RE: RDS Postgres & FreeableMemory issues Date: Fri, 12 Jul 2024 17:44:41 -0400 Message-ID: <013e01dad4a4$b47fcb50$1d7f61f0$@incisivetechgroup.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_013F_01DAD483.2D6E7970" X-Mailer: Microsoft Outlook 16.0 Thread-Index: AQDQ+8lIBxEQ/k5bEu4VBCYt2mXWibQHUaVQ Content-Language: en-us X-AntiAbuse: This header was added to track abuse, please include it with any abuse report X-AntiAbuse: Primary Hostname - chi208.greengeeks.net X-AntiAbuse: Original Domain - postgresql.org X-AntiAbuse: Originator/Caller UID/GID - [47 12] / [47 12] X-AntiAbuse: Sender Address Domain - incisivetechgroup.com X-Get-Message-Sender-Via: chi208.greengeeks.net: authenticated_id: lennam@incisivetechgroup.com X-Authenticated-Sender: chi208.greengeeks.net: lennam@incisivetechgroup.com X-Source: X-Source-Args: X-Source-Dir: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multipart message in MIME format. ------=_NextPart_000_013F_01DAD483.2D6E7970 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Check in CloudWatch , will give , what is happning at RDS =20 =20 From: Wells Oliver =20 Sent: Friday, July 12, 2024 5:22 PM To: pgsql-admin Subject: RDS Postgres & FreeableMemory issues =20 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. =20 Is there a way I can figure out which postgres processes were using all = the RAM at some time? =20 --=20 Wells Oliver wells.oliver@gmail.com =20 ------=_NextPart_000_013F_01DAD483.2D6E7970 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable

Check in CloudWatch=C2=A0 , = will give , what is happning at RDS=C2=A0

 

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?

 

--

------=_NextPart_000_013F_01DAD483.2D6E7970--