Toggle navigation

log_parameter_max_length

Type: integer
Default: -1
Min: -1
Max: 1073741823
Unit: B
Context: superuser
Restart: false
Since: 13

If greater than zero, each bind parameter value reported in non-error statement-logging messages is trimmed to this many bytes. Zero disables logging bind parameters with statements. -1 (the default) allows bind parameters to be logged in full. If this value is specified without units, it is taken as bytes. Only superusers can change this setting.

This setting only affects log messages printed as a result of log_statement, log_duration, and related settings. Non-zero values of this setting add some overhead, particularly if parameters are sent in binary form, since then conversion to text is required.

Comments