Postgres Pro
Downloads
Home   >   mailing lists

Re: Native postgres query to examine FreeableMemory RDS alerts - Mailing list pgsql-admin

From Wells Oliver
Subject Re: Native postgres query to examine FreeableMemory RDS alerts
Date
Msg-id CAOC+FBV6KZdpcpzTcof-EyxcYJZwzhWsuGLa00yniD8kS0ftPA@mail.gmail.com
Whole thread Raw
In response to Re: Native postgres query to examine FreeableMemory RDS alerts  (Michael Guissine <mguissine@gmail.com>)
List pgsql-admin
Tree view
Perfect, thank you very much.


On Wed, Mar 13, 2024 at 11:39 AM Michael Guissine <mguissine@gmail.com> wrote:
Go to your RDS instance in the console, go to the Monitoring and pull "OS process list", sort by residential memory descending.
This will show you all currently running processes (PIDs) and the amount of memory they use. You can then go to your database and pull information on what that process is doing `select * from pg_stat_activity where pid=?`

image.png


On Wed, Mar 13, 2024 at 2:26 PM Wells Oliver <wells.oliver@gmail.com> wrote:
I have a Cloudwatch alert on a postgres RDS instance when freeable memory drops below a certain amount. I find myself unable to really diagnose what's happening when this does happen, and wondered if there were any PG queries I might make to see what could be using so much RAM.

--


--
Attachment

pgsql-admin by date:

Previous
From: Michael Guissine
Date:
Subject: Re: Native postgres query to examine FreeableMemory RDS alerts
Next
From: hector vass
Date:
Subject: Re: Dynamically generate varying Number of Column Headers from the Row data