Memory activities to monitor in statistics collector?

Поиск
Список
Период
Сортировка
От Yu Watanabe
Тема Memory activities to monitor in statistics collector?
Дата
Msg-id CALKrq=n2t9dLSheM6hA9jWwh_TaGjR_yUm-QaG2jD+P4uCqxYw@mail.gmail.com
обсуждение исходный текст
Список pgsql-general
Dear community

I would like to ask a question regarding system monitoring. 
I am sorry if this question was asked before.
My postgresql is running on Azure database for Postgresql (ver 12) which runs on cloud platform.

My goal is to observe memory statistics to see if there are any memory suspicious statistics that might be the reason for query OOM .

https://pganalyze.com/docs/log-insights/server/S5

The guide Microsoft has is too general to detect query OOM.

https://azure.microsoft.com/ja-jp/blog/best-practices-for-alerting-on-metrics-with-azure-database-for-postgresql-monitoring/

Thus I was thinking if there are any statistics I can monitor.
"/proc/*/smaps" seems to be one option but it's not a choice for me.

https://www.depesz.com/2012/06/09/how-much-ram-is-postgresql-using/

Would there be any statistics or any combination of stat items which can lead to query OOM ?

https://www.postgresql.org/docs/12/monitoring-stats.html

Best Regards,
Yu Watanabe

--
Yu Watanabe

linkedin: www.linkedin.com/in/yuwatanabe1/
twitter:   twitter.com/yuwtennis
   

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

Предыдущее
От: Marc Mamin
Дата:
Сообщение: schema prefixes in default values (was RE: removing "serial" from table definitions).
Следующее
От: "Abraham, Danny"
Дата:
Сообщение: WARNING: skipping "pg_database" --- only superuser can analyze it