On Fri, Oct 10, 2025 at 8:58 PM sud wrote:>
> Thank you so much. That helps.
>
> I am planning to use pg_stat_get_backend_memory_contexts function
something as below by joining this to the pg_stat_activity. Hope this is
the right usage. Somehow i am getting an error stating the function doesn't
ex
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
Thank you.
My understanding may be wrong here.And my apology as I am using the example
of Oracle again even though these two are not the same. But being worked
for a long time in Oracle so trying to understand exactly how it's
different.
In oracle RAC(real application cluster) database, we have si
On 10/8/25 11:58, sud wrote:
Thank you.
My understanding may be wrong here.And my apology as I am using the
example of Oracle again even though these two are not the same. But
being worked for a long time in Oracle so trying to understand exactly
how it's different.
In oracle RAC(real applic
Hi,
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
>
>From a purely postgresql database point of view, this feature is being
developed, y
My 2cents:-
In regards to the memory consumption question of OP:- Wouldn't the column
"temp_blks_read" and "temp_blks_written" in pg_stats_statements provide
details around the memory consumption i.e. when the query exceeds the
work_mem then it tries occupying the temp blocks. Something as below.
C
Thank you so much. That helps.
I am planning to use pg_stat_get_backend_memory_contexts function something
as below by joining this to the pg_stat_activity. Hope this is the right
usage. Somehow i am getting an error stating the function doesn't exist but
it might be because of the version. I will
On Wed, Oct 8, 2025 at 11:42 AM 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 inform
On Wed, Oct 8, 2025 at 2:58 PM 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 "wh
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 ins
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 wrote:
> On Wed, Oct 8, 2025 at 2:58
11 matches
Mail list logo
