Re: Add pg_stat_kind_info system view

On Tue, Jul 28, 2026 at 04:38:54PM -0500, Sami Imseih wrote:
> pg_stat_kind_info could also expose the shmem allocation name
> as a column, so users can join back to
> pg_dsm_registry_allocations. And once [1] lands,
> pg_stat_kind_info would also expose whether a kind uses
> the shared or dedicated hash.

Noted.

> I think to switch to GetNamedDSHash(), we would need to
> return the DSA area from GetNamedDSHash() so entry body
> allocations can use the same DSA that backs the hash. I already
> have a patch for this [2]. More thought is needed, but I can look
> into it.

In terms of this thread, more thought is a synonym of making sure that
your proposal [2] is good enough for the purpose to be able to monitor
the pgstats activity. I'll try to look double-check this part
separately; this naturally adds more value to the other proposal.
--
Michael