MIME-Version: 1.0
From: sud <suds1434@gmail.com>
Date: Wed, 8 Oct 2025 21:12:05 +0530
Message-ID: <CAD=mzVXjx-ULCM-ZdSz2RDSoL8EA1Bsd+0gBxgOCTWV_tC4GDw@mail.gmail.com>
Subject: Alerting on memory use and instance crash
To: pgsql-general <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000007dfa3f0640a78774"
Archived-At: <https://www.postgresql.org/message-id/CAD%3DmzVXjx-ULCM-ZdSz2RDSoL8EA1Bsd%2B0gBxgOCTWV_tC4GDw%40mail.gmail.com>
Precedence: bulk

--0000000000007dfa3f0640a78774
Content-Type: text/plain; charset="UTF-8"

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

--0000000000007dfa3f0640a78774
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Hi Experts,<br><br>It&#39;s postgres version 16. I have tw=
o questions on alerting as below.<br><br><div>1)If we want to have alerting=
 on any node/instance that gets crashed :- In other databases like Oracle t=
he catalog Views like &quot;GV$Instance&quot; used to give information on w=
hether the instances are currently active/down or not. But in postgres it s=
eems all the pg_* views are instance specific and are not showing informati=
on on the global/cluster level but are restricted to instance level only. S=
o is there any other way to query the pg_* views to have=C2=A0alerts on the=
 specific instance crash?<br>2)Is there a way to fetch the data from pg_* v=
iew to highlight the specific connection/session/sqls which is using high m=
emory in postgres? <br><br><div>Appreciate your guidance.<br><div><br></div=
><div>Regards</div><div>Sud</div></div></div></div>

--0000000000007dfa3f0640a78774--