Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1v6ZVL-006eNg-G6 for pgsql-general@arkaria.postgresql.org; Wed, 08 Oct 2025 19:07:15 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1v6ZVJ-00CQ7g-8h for pgsql-general@arkaria.postgresql.org; Wed, 08 Oct 2025 19:07:14 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1v6ZVI-00CQ7Y-PW for pgsql-general@lists.postgresql.org; Wed, 08 Oct 2025 19:07:13 +0000 Received: from mail-oo1-xc36.google.com ([2607:f8b0:4864:20::c36]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1v6ZVG-000igX-2u for pgsql-general@lists.postgresql.org; Wed, 08 Oct 2025 19:07:12 +0000 Received: by mail-oo1-xc36.google.com with SMTP id 006d021491bc7-64a12d970ccso93663eaf.3 for ; Wed, 08 Oct 2025 12:07:11 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1759950430; x=1760555230; darn=lists.postgresql.org; h=to:subject:message-id:date:from:in-reply-to:references:mime-version :from:to:cc:subject:date:message-id:reply-to; bh=/lcM9X8yhSRnkST9uUTB1I5XG6LwYHJQz6l2yjvSdoY=; b=XSngNJK5XA7uMzav8fhGHJc09YcpVkNYNVHSXQSGN8ZVCLO3oQDa5X7tKK+bgCTNIF sMGefeZMhp63k2TpDVrG0zfn3uRse+5yvSwf2pYAaOqDSvWBSOadca0dz4qqXjcswS/u xSeur95eqzE5Ek4LdZa/nhSzUFEISHAfU6z0F4yWD3rm0bRj2am4ea7ayCzbHWjGciKi vf+pkVcbMKVvsKBeEVmEmi4GhpXKRTi4/SlwmVu2NxPNhziOp500cN3rWPyJQo4mPh+z RLU1KLR52sqrs3BzDrPfCqLBWbYioLIIAHzb3OXYeuIiyXM0zUCs2tzpP9n/b+xtAXHd mg3g== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1759950430; x=1760555230; h=to:subject:message-id:date:from:in-reply-to:references:mime-version :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=/lcM9X8yhSRnkST9uUTB1I5XG6LwYHJQz6l2yjvSdoY=; b=Q25rfhpvSOjbys2Qos/F546fTfiPdRoLzfZ4RUsju/EbsFqN0PvFqYyMpLJpedemVB Stz16ZHP53JyMlFoJp/4TXFHGlhx6n4LdctEbtWEbD2OgPvbUD7NrDdZEfwxAiWZhoqf Bh0IO/Z8/vD8cXexJV/Q3GTZflhQamqJR6aOD6/RKNl/EDLsh8sH1wXY2jg9K1L3BqYX WwkM7oIJ/bJwbxdgDv3he73DuOMAqSpgJBvDEDPas1aRCHpAuHutZaZiQvlu30YO/d1O 6NaV8gcfPB8ZDK1adIGoKw9gNBFfQlSkTZQy0qv6XbTAryu7Bgx7L3bwVljDQEnPIjbs EVSg== X-Gm-Message-State: AOJu0YzOBY06H2wIGp3jqsyXLqNnUGnMPIYBGuUy03wrS8q8NJqmclA7 ye+U8EIZQWHbz30jDCm6xwKfemjuXRuVSYlm5E5DCpktwWb5GWDNzlDvpyATI7+vz+A8WgOZcNu mC1yW+nONtPGYTpZGXokAv81qXyXSPAvsIw== X-Gm-Gg: ASbGncs/HdC3WRJBNDllxSM9KfuU6Y+BBEVS1sHt0XZqzI2urXCRzXMJJpQLkKzbR5e DQcLO0W/iPeqkFVZKekOoKwo7btfwSrNB2KsGC8t7O6S6Q28Y1LKf7khRGOCU2pwrGyPAE//3tI r9F65awqmFfKQpKFpJwsYuFTvxcYFvgSX4a0c6vbtJs1jipxKT1a35IIecNXdX8dXqVh961i+b7 wXEhX40QooIzJtUd/DDmRvYw5vdOBXt X-Google-Smtp-Source: AGHT+IGasCtVP0XrJ6LPvWwbRp84wduVGa94jE8BLmCeGi3V5B3vuzoHpXQuaRqznWYyeEumJgw+1/uehLS/P/BP/mk= X-Received: by 2002:a05:6870:26a:b0:314:b6a6:689b with SMTP id 586e51a60fabf-3c0fac596c9mr2671460fac.47.1759950429704; Wed, 08 Oct 2025 12:07:09 -0700 (PDT) MIME-Version: 1.0 References: <9f175444-6bfc-4c6e-a609-e552d85c45a1@aklaver.com> In-Reply-To: From: Ron Johnson Date: Wed, 8 Oct 2025 15:06:58 -0400 X-Gm-Features: AS18NWBRtIEwWGLfBdlDS9IWDJJWAdGZMRU7WPVO586xLNjqQ7K6rWXzefIWoHU Message-ID: Subject: Re: Alerting on memory use and instance crash To: pgsql-general Content-Type: multipart/alternative; boundary="0000000000002f53480640aa64d4" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000002f53480640aa64d4 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Wed, Oct 8, 2025 at 2:58=E2=80=AFPM sud wrote: [snip] > Do you mean in normal Postgres it's alway a single instance/memory and > single storage attached? then I also do not see any such cluster level > views in aws aurora postgres too? > Yup. > Pardon if it's a silly one to ask. > A Google for "what's the difference between Oracle and Postgresql" _might_ help. I've never done that, so don't know what you'll find. As far as how Aurora works... you need to ask AWS. It's been too heavily modified for a list dedicated to pure/unmodified Postgresql to help. > On Wed, Oct 8, 2025 at 9:52=E2=80=AFPM Adrian Klaver > wrote: > >> On 10/8/25 08:42, sud wrote: >> > 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? >> >> 1) When you say instance do you mean database? >> >> 2) Not all system tables/views are database only. >> >> For instance: >> https://www.postgresql.org/docs/current/catalog-pg-database.html >> https://www.postgresql.org/docs/current/catalog-pg-auth-members.html >> https://www.postgresql.org/docs/current/catalog-pg-authid.html >> https://www.postgresql.org/docs/current/view-pg-roles.html >> >> >> > 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 postgre= s? >> > >> > Appreciate your guidance. >> > >> > Regards >> > Sud >> >> >> -- >> Adrian Klaver >> adrian.klaver@aklaver.com >> > --=20 Death to , and butter sauce. Don't boil me, I'm still alive. lobster! --0000000000002f53480640aa64d4 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
On Wed, Oct 8, 2025 at 2:58=E2=80=AFPM su= d <suds1434@gmail.com> wrot= e:
[snip]=C2=A0<= /div>
Do you mean in normal Postgres it's alway a single instance/memory an= d single storage attached? then I also do not see any such cluster level vi= ews in aws aurora postgres too?

Yup.
=C2=A0
Pardon if it's a silly one to ask.=C2=A0

A Google for "what's the d= ifference between Oracle and Postgresql" _might_ help.=C2=A0 I've = never done that, so don't know what you'll find.

As far as how Aurora works... you need to ask AWS.=C2=A0 It's be= en too heavily modified for a list dedicated to pure/unmodified Postgresql = to help.
=C2=A0
On Wed, Oct 8, 2025 at 9:52=E2=80=AFPM Adrian K= laver <ad= rian.klaver@aklaver.com> wrote:
On 10/8/25 08:42, sud w= rote:
> Hi Experts,
>
> It's postgres version 16. I have two questions on alerting as belo= w.
>
> 1)If we want to have alerting on any node/instance that gets crashed := -
> In other databases like Oracle the catalog Views like "GV$Instanc= e" 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 b= ut
> are restricted to instance level only. So is there any other way to > query the pg_* views to have=C2=A0alerts on the specific instance cras= h?

1) When you say instance do you mean database?

2) Not all system tables/views are database only.

For instance:
https://www.postgresql.org/docs/curr= ent/catalog-pg-database.html
https://www.postgresql.org/docs/= current/catalog-pg-auth-members.html
https://www.postgresql.org/docs/curren= t/catalog-pg-authid.html
https://www.postgresql.org/docs/current/v= iew-pg-roles.html


> 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 postgre= s?
>
> Appreciate your guidance.
>
> Regards
> Sud


--
Adrian Klaver
adrian.klave= r@aklaver.com


--
Death to <Redacted>, and butter sauce.Don't boil me, I'm still alive.
<Redacted> lobs= ter!
--0000000000002f53480640aa64d4--