Re: Enhancing Memory Context Statistics Reporting

Rahila Syed <rahilasyed90@gmail.com>

View thread

From: Rahila Syed <rahilasyed90@gmail.com>

To: torikoshia <torikoshia@oss.nttdata.com>

Cc: PostgreSQL Hackers <pgsql-hackers@postgresql.org>, Daniel Gustafsson <daniel@yesql.se>

Date: 2025-08-19T21:42:52Z

Lists: pgsql-hackers

Attachments

v34-0001-Add-pg_get_process_memory_context-function.patch (application/octet-stream)

Hi,


   =# select  pg_get_process_memory_contexts(pg_backend_pid(), true, 1)
> from pg_stat_activity ;
>
>     pg_get_process_memory_contexts
>    --------------------------------
>    (0 rows)
>
>    Time: 6026.291 ms (00:06.026)
>
> Since v32 patch quickly returned the memory contexts as expected with
> the same parameter specified, there seems to be some degradation. Could
> you check it?
>

Thank you for reporting this failure. This issue was a regression caused by
the absence of a
ConditionVariableSignal() call in the summary = true code path,
which happened due to recent code refactoring.

PFA the fix.

Thank you,
Rahila Syed