In this recipe, we will talk about tuning logging-related parameters.
The following are the logging-related parameters that usually require tuning:
log_line_prefix
log_statement
log_min_duration_statement
log_line_prefix
: Usually the default value related to this parameter is empty and it is not desirable. A good way to put this in context would be to use the following format:
log_line_prefix='%t:%r:%u@%d:[%p]: '
Once this format is used, every line in the log will follow this format. The following is a description of the entries:
%t
: This is the timestamp%u
: This is the database username%r
: This is where the remote host connection is from%d
: This is where the database connection is to%p
: This is the process ID of the connection
Not all of these values will be required initially; however, at a later stage as you drill down further, they will be useful. For instance, the significance of processID
becomes apparent when you...