Thank you. The other question I had was , are there any pg_* views using which, we are able to see which session/connection is using the highest amount of memory? I don't see any such columns in pg_stats_activity.
On Thu, Oct 9, 2025 at 12:37 AM Ron Johnson <[email protected]> wrote: > On Wed, Oct 8, 2025 at 2:58 PM sud <[email protected]> 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 PM Adrian Klaver <[email protected]> >> 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 >>> postgres? >>> > >>> > Appreciate your guidance. >>> > >>> > Regards >>> > Sud >>> >>> >>> -- >>> Adrian Klaver >>> [email protected] >>> >> > > -- > Death to <Redacted>, and butter sauce. > Don't boil me, I'm still alive. > <Redacted> lobster! >
