Re: Native postgres query to examine FreeableMemory RDS alerts

Поиск
Список
Период
Сортировка
От Michael Guissine
Тема Re: Native postgres query to examine FreeableMemory RDS alerts
Дата
Msg-id CACxDrAmA0DUKpvWHdjzQ79sUZpdr3fvT6P-neOKhxUJX6G3cwg@mail.gmail.com
обсуждение исходный текст
Ответ на Native postgres query to examine FreeableMemory RDS alerts  (Wells Oliver <wells.oliver@gmail.com>)
Ответы Re: Native postgres query to examine FreeableMemory RDS alerts
Список pgsql-admin
Дерево обсуждения
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.

--
Вложения

В списке pgsql-admin по дате отправления:

Предыдущее
От: Wells Oliver
Дата:
Сообщение: Native postgres query to examine FreeableMemory RDS alerts
Следующее
От: Wells Oliver
Дата:
Сообщение: Re: Native postgres query to examine FreeableMemory RDS alerts