diff options
| author | Peter Eisentraut <peter@eisentraut.org> | 2020-03-15 11:20:21 +0100 |
|---|---|---|
| committer | Peter Eisentraut <peter@eisentraut.org> | 2020-03-15 11:20:21 +0100 |
| commit | 70a7b4776be4e776221e578d8ca53b2b9f8118c0 (patch) | |
| tree | 69cd988be0d66fa53ea099f714950a2e0dfbaf09 /doc/src | |
| parent | d8cfa82d51f812f886d06bdc7bb73470e55d74b7 (diff) | |
| download | postgresql-70a7b4776be4e776221e578d8ca53b2b9f8118c0.tar.gz postgresql-70a7b4776be4e776221e578d8ca53b2b9f8118c0.zip | |
Add backend type to csvlog and optionally log_line_prefix
The backend type, which corresponds to what
pg_stat_activity.backend_type shows, is added as a column to the
csvlog and can optionally be added to log_line_prefix using the new %b
placeholder.
Reviewed-by: Julien Rouhaud <rjuju123@gmail.com>
Reviewed-by: Kuntal Ghosh <kuntalghosh.2007@gmail.com>
Reviewed-by: Alvaro Herrera <alvherre@2ndquadrant.com>
Reviewed-by: Justin Pryzby <pryzby@telsasoft.com>
Discussion: https://www.postgresql.org/message-id/flat/c65e5196-4f04-4ead-9353-6088c19615a3@2ndquadrant.com
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/config.sgml | 20 |
1 files changed, 19 insertions, 1 deletions
diff --git a/doc/src/sgml/config.sgml b/doc/src/sgml/config.sgml index 371d7838fb6..3cac340f323 100644 --- a/doc/src/sgml/config.sgml +++ b/doc/src/sgml/config.sgml @@ -6438,9 +6438,13 @@ local0.* /var/log/postgresql right with spaces to give it a minimum width, whereas a positive value will pad on the left. Padding can be useful to aid human readability in log files. + </para> + + <para> This parameter can only be set in the <filename>postgresql.conf</filename> file or on the server command line. The default is <literal>'%m [%p] '</literal> which logs a time stamp and the process ID. + </para> <informaltable> <tgroup cols="3"> @@ -6478,6 +6482,11 @@ local0.* /var/log/postgresql <entry>yes</entry> </row> <row> + <entry><literal>%b</literal></entry> + <entry>Backend type</entry> + <entry>no</entry> + </row> + <row> <entry><literal>%p</literal></entry> <entry>Process ID</entry> <entry>no</entry> @@ -6548,6 +6557,14 @@ local0.* /var/log/postgresql </tgroup> </informaltable> + <para> + The backend type corresponds to the column + <structfield>backend_type</structfield> in the view <xref + linkend="pg-stat-activity-view"/>, but additional types can appear + in the log that don't show in that view. + </para> + + <para> The <literal>%c</literal> escape prints a quasi-unique session identifier, consisting of two 4-byte hexadecimal numbers (without leading zeros) separated by a dot. The numbers are the process start time and the @@ -6772,7 +6789,7 @@ log_line_prefix = '%m [%p] %q%u@%d/%a ' character count of the error position therein, location of the error in the PostgreSQL source code (if <varname>log_error_verbosity</varname> is set to <literal>verbose</literal>), - and application name. + application name, and backend type. Here is a sample table definition for storing CSV-format log output: <programlisting> @@ -6801,6 +6818,7 @@ CREATE TABLE postgres_log query_pos integer, location text, application_name text, + backend_type text, PRIMARY KEY (session_id, session_line_num) ); </programlisting> |