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.
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
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). |