Postgres Pro
Downloads
Home   >   mailing lists

Memory activities to monitor in statistics collector? - Mailing list pgsql-general

From Yu Watanabe
Subject Memory activities to monitor in statistics collector?
Date
Msg-id CALKrq=n2t9dLSheM6hA9jWwh_TaGjR_yUm-QaG2jD+P4uCqxYw@mail.gmail.com
Whole thread Raw
List pgsql-general
Tree view
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 by date:

Previous
From: Marc Mamin
Date:
Subject: schema prefixes in default values (was RE: removing "serial" from table definitions).
Next
From: "Abraham, Danny"
Date:
Subject: WARNING: skipping "pg_database" --- only superuser can analyze it