Thanks for working on this!
On 2021-10-09 22:23, Bharath Rupireddy wrote:
Hi,
Currently pg_log_backend_memory_contexts() doesn't log the memory
contexts of auxiliary processes such as bgwriter, checkpointer, wal
writer, archiver, startup process and wal receiver. It will be useful
to look at the memory contexts of these processes too, for debugging
purposes and better understanding of the memory usage pattern of these
processes.
As the discussion below, we thought logging memory contexts of other
than client backends is possible but were not sure how useful it is.
After all, we have ended up restricting the target process to client
backends for now.
https://www.postgresql.org/message-id/0b0657d5febd0e46565a6bc9c62ba3f6%40oss.nttdata.com
If we can use debuggers, it's possible to know the memory contexts e.g.
using MemoryContextStats().
So IMHO if it's necessary to know memory contexts without attaching gdb
for other than client backends(probably this means using under
production environment), this enhancement would be pay.
--
Regards,
--
Atsushi Torikoshi
NTT DATA CORPORATION
