From: | sud <suds1434(at)gmail(dot)com> |
---|---|
To: | pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | Alerting on memory use and instance crash |
Date: | 2025-10-08 15:42:05 |
Message-ID: | CAD=mzVXjx-ULCM-ZdSz2RDSoL8EA1Bsd+0gBxgOCTWV_tC4GDw@mail.gmail.com |
Views: | Whole Thread | Raw Message | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi Experts,
It's postgres version 16. I have two questions on alerting as below.
1)If we want to have alerting on any node/instance that gets crashed :- In
other databases like Oracle the catalog Views like "GV$Instance" used to
give information on whether the instances are currently active/down or not.
But in postgres it seems all the pg_* views are instance specific and are
not showing information on the global/cluster level but are restricted to
instance level only. So is there any other way to query the pg_* views to
have alerts on the specific instance crash?
2)Is there a way to fetch the data from pg_* view to highlight the specific
connection/session/sqls which is using high memory in postgres?
Appreciate your guidance.
Regards
Sud
From | Date | Subject | |
---|---|---|---|
Next Message | Ron Johnson | 2025-10-08 16:21:53 | Re: Alerting on memory use and instance crash |
Previous Message | Adrian Klaver | 2025-10-08 14:58:43 | Re: JSONB subscripting initializes numeric keys as arrays instead of objects |