Tuning logging-related parameters
In this recipe, we will talk about tuning logging-related parameters.
How to do it...
The following are the logging-related parameters that usually require tuning:
log_line_prefixlog_statementlog_min_duration_statement
How it works...
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...
