public inbox for [email protected]  

help / color / mirror / Atom feed

From: Adrian Klaver <[email protected]>
To: sud <[email protected]>
To: pgsql-general <[email protected]>
Subject: Re: Alerting on memory use and instance crash
Date: Wed, 8 Oct 2025 09:22:27 -0700
Message-ID: <[email protected]> (raw)
In-Reply-To: <CAD=mzVXjx-ULCM-ZdSz2RDSoL8EA1Bsd+0gBxgOCTWV_tC4GDw@mail.gmail.com>
References: <CAD=mzVXjx-ULCM-ZdSz2RDSoL8EA1Bsd+0gBxgOCTWV_tC4GDw@mail.gmail.com>

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 postgres?
> 
> Appreciate your guidance.
> 
> Regards
> Sud


-- 
Adrian Klaver
[email protected]

view thread (11+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: Alerting on memory use and instance crash
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox