pgsql: Enhance pg_log_backend_memory_contexts() for auxiliary processes

Enhance pg_log_backend_memory_contexts() for auxiliary processes.

Previously pg_log_backend_memory_contexts() could request to
log the memory contexts of backends, but not of auxiliary processes
such as checkpointer. This commit enhances the function so that
it can also send the request to auxiliary processes. It's useful to
look at the memory contexts of those processes for debugging purpose
and better understanding of the memory usage pattern of them.

Note that pg_log_backend_memory_contexts() cannot send the request
to logger or statistics collector. Because this logging request
mechanism is based on shared memory but those processes aren't
connected to that.

Author: Bharath Rupireddy
Reviewed-by: Vignesh C, Kyotaro Horiguchi, Fujii Masao
Discussion: https://postgr.es/m/CALj2ACU1nBzpacOK2q=a65S_4+Oaz_rLTsU1Ri0gf7YUmnmhfQ@mail.gmail.com

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/790fbda902093c71ae47bff1414799cd716abb80

Modified Files
--------------
doc/src/sgml/func.sgml | 4 ++-
src/backend/postmaster/checkpointer.c | 4 +++
src/backend/postmaster/interrupt.c | 5 ++++
src/backend/postmaster/pgarch.c | 10 ++++++--
src/backend/postmaster/startup.c | 5 ++++
src/backend/postmaster/walwriter.c | 4 +++
src/backend/utils/adt/mcxtfuncs.c | 38 +++++++++++++++++++---------
src/test/regress/expected/misc_functions.out | 7 +++++
src/test/regress/sql/misc_functions.sql | 3 +++
9 files changed, 65 insertions(+), 15 deletions(-)