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.
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 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?
> 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
