Memory activities to monitor in statistics collector?

From: Yu Watanabe <yu(dot)w(dot)tennis(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Memory activities to monitor in statistics collector?
Date: 2021-06-28 11:41:07
Message-ID: CALKrq=n2t9dLSheM6hA9jWwh_TaGjR_yUm-QaG2jD+P4uCqxYw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-general by date

  From Date Subject
Next Message Abraham, Danny 2021-06-28 13:26:25 WARNING: skipping "pg_database" --- only superuser can analyze it
Previous Message Marc Mamin 2021-06-28 10:50:23 schema prefixes in default values (was RE: removing "serial" from table definitions).