diff options
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/func.sgml | 52 |
1 files changed, 52 insertions, 0 deletions
diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml index 3cf243a16ad..9fcee749105 100644 --- a/doc/src/sgml/func.sgml +++ b/doc/src/sgml/func.sgml @@ -24916,6 +24916,26 @@ SELECT collation for ('foo' COLLATE "de_DE"); <row> <entry role="func_table_entry"><para role="func_signature"> <indexterm> + <primary>pg_log_backend_memory_contexts</primary> + </indexterm> + <function>pg_log_backend_memory_contexts</function> ( <parameter>pid</parameter> <type>integer</type> ) + <returnvalue>boolean</returnvalue> + </para> + <para> + Requests to log the memory contexts whose backend process has + the specified process ID. These memory contexts will be logged at + <literal>LOG</literal> message level. They will appear in + the server log based on the log configuration set + (See <xref linkend="runtime-config-logging"/> for more information), + but will not be sent to the client whatever the setting of + <xref linkend="guc-client-min-messages"/>. + Only superusers can request to log the memory contexts. + </para></entry> + </row> + + <row> + <entry role="func_table_entry"><para role="func_signature"> + <indexterm> <primary>pg_reload_conf</primary> </indexterm> <function>pg_reload_conf</function> () @@ -24983,6 +25003,38 @@ SELECT collation for ('foo' COLLATE "de_DE"); <structname>pg_stat_activity</structname> view. </para> + <para> + <function>pg_log_backend_memory_contexts</function> can be used + to log the memory contexts of the backend process. For example, +<programlisting> +postgres=# SELECT pg_log_backend_memory_contexts(pg_backend_pid()); + pg_log_backend_memory_contexts +-------------------------------- + t +(1 row) +</programlisting> +One message for each memory context will be logged. For example: +<screen> +LOG: logging memory contexts of PID 10377 +STATEMENT: SELECT pg_log_backend_memory_contexts(pg_backend_pid()); +LOG: level: 0; TopMemoryContext: 80800 total in 6 blocks; 14432 free (5 chunks); 66368 used +LOG: level: 1; pgstat TabStatusArray lookup hash table: 8192 total in 1 blocks; 1408 free (0 chunks); 6784 used +LOG: level: 1; TopTransactionContext: 8192 total in 1 blocks; 7720 free (1 chunks); 472 used +LOG: level: 1; RowDescriptionContext: 8192 total in 1 blocks; 6880 free (0 chunks); 1312 used +LOG: level: 1; MessageContext: 16384 total in 2 blocks; 5152 free (0 chunks); 11232 used +LOG: level: 1; Operator class cache: 8192 total in 1 blocks; 512 free (0 chunks); 7680 used +LOG: level: 1; smgr relation table: 16384 total in 2 blocks; 4544 free (3 chunks); 11840 used +LOG: level: 1; TransactionAbortContext: 32768 total in 1 blocks; 32504 free (0 chunks); 264 used +... +LOG: level: 1; ErrorContext: 8192 total in 1 blocks; 7928 free (3 chunks); 264 used +LOG: Grand total: 1651920 bytes in 201 blocks; 622360 free (88 chunks); 1029560 used +</screen> + For more than 100 child contexts under the same parent one, + 100 child contexts and a summary of the remaining ones will be logged. + Note that frequent calls to this function could incur significant overhead, + because it may generate a large number of log messages. + </para> + </sect2> <sect2 id="functions-admin-backup"> |