Reporting and Logging / What to Log

application_name

Attribute Value
Category Reporting and Logging / What to Log
Description Sets the application name to be reported in statistics and logs.
Data type string
Default value
Allowed values [A-Za-z0-9._-]*
Parameter type dynamic
Documentation application_name

debug_pretty_print

Attribute Value
Category Reporting and Logging / What to Log
Description Indents parse and plan tree displays.
Data type boolean
Default value on
Allowed values on,off
Parameter type dynamic
Documentation debug_pretty_print

debug_print_parse

Attribute Value
Category Reporting and Logging / What to Log
Description Logs each query's parse tree.
Data type boolean
Default value off
Allowed values on,off
Parameter type dynamic
Documentation debug_print_parse

debug_print_plan

Attribute Value
Category Reporting and Logging / What to Log
Description Logs each query's execution plan.
Data type boolean
Default value off
Allowed values on,off
Parameter type dynamic
Documentation debug_print_plan

debug_print_rewritten

Attribute Value
Category Reporting and Logging / What to Log
Description Logs each query's rewritten parse tree.
Data type boolean
Default value off
Allowed values on,off
Parameter type dynamic
Documentation debug_print_rewritten

log_autovacuum_min_duration

Attribute Value
Category Reporting and Logging / What to Log
Description Sets the minimum execution time above which autovacuum actions will be logged.
Data type integer
Default value 600000
Allowed values -1-2147483647
Parameter type dynamic
Documentation log_autovacuum_min_duration

log_checkpoints

Attribute Value
Category Reporting and Logging / What to Log
Description Logs each checkpoint.
Data type boolean
Default value on
Allowed values on,off
Parameter type dynamic
Documentation log_checkpoints

log_connections

Attribute Value
Category Reporting and Logging / What to Log
Description Causes each attempted connection to the server to be logged, as well as successful completion of client authentication.
Data type boolean
Default value on
Allowed values on
Parameter type read-only
Documentation log_connections

log_disconnections

Attribute Value
Category Reporting and Logging / What to Log
Description Logs end of a session, including duration.
Data type boolean
Default value on
Allowed values on
Parameter type read-only
Documentation log_disconnections

log_duration

Attribute Value
Category Reporting and Logging / What to Log
Description Logs the duration of each completed SQL statement.
Data type boolean
Default value off
Allowed values on,off
Parameter type dynamic
Documentation log_duration

log_error_verbosity

Attribute Value
Category Reporting and Logging / What to Log
Description Controls the amount of detail written in the server log for each message that is logged.
Data type enumeration
Default value default
Allowed values terse,default,verbose
Parameter type dynamic
Documentation log_error_verbosity

log_hostname

Attribute Value
Category Reporting and Logging / What to Log
Description Logs the host name in the connection logs.
Data type boolean
Default value off
Allowed values on,off
Parameter type dynamic
Documentation log_hostname

log_line_prefix

Attribute Value
Category Reporting and Logging / What to Log
Description Sets the printf-style string that is output at the beginning of each log line.
Data type string
Default value %t-%c-
Allowed values [^']*
Parameter type dynamic
Documentation log_line_prefix

log_lock_waits

Attribute Value
Category Reporting and Logging / What to Log
Description Controls whether a log message is produced when a session waits longer than deadlock_timeout to acquire a lock.
Data type boolean
Default value off
Allowed values on,off
Parameter type dynamic
Documentation log_lock_waits

log_parameter_max_length

Attribute Value
Category Reporting and Logging / What to Log
Description Sets the maximum length in bytes of data logged for bind parameter values when logging statements.
Data type integer
Default value -1
Allowed values -1
Parameter type read-only
Documentation log_parameter_max_length

log_parameter_max_length_on_error

Attribute Value
Category Reporting and Logging / What to Log
Description Sets the maximum length in bytes of data logged for bind parameter values when logging statements, on error.
Data type integer
Default value 0
Allowed values 0
Parameter type read-only
Documentation log_parameter_max_length_on_error

log_recovery_conflict_waits

Attribute Value
Category Reporting and Logging / What to Log
Description Controls whether a log message is produced when the startup process waits longer than deadlock_timeout for recovery conflicts.
Data type boolean
Default value off
Allowed values on,off
Parameter type dynamic
Documentation log_recovery_conflict_waits

log_replication_commands

Attribute Value
Category Reporting and Logging / What to Log
Description Logs each replication command.
Data type boolean
Default value on
Allowed values on
Parameter type read-only
Documentation log_replication_commands

log_statement

Attribute Value
Category Reporting and Logging / What to Log
Description Sets the type of statements logged.
Data type enumeration
Default value none
Allowed values none,ddl,mod,all
Parameter type dynamic
Documentation log_statement

log_temp_files

Attribute Value
Category Reporting and Logging / What to Log
Description Logs the use of temporary files larger than this number of kilobytes.
Data type integer
Default value -1
Allowed values -1-2147483647
Parameter type dynamic
Documentation log_temp_files

log_timezone

Attribute Value
Category Reporting and Logging / What to Log
Description Sets the time zone to use in log messages.
Data type string
Default value UTC
Allowed values UTC
Parameter type read-only
Documentation log_timezone

application_name

Attribute Value
Category Reporting and Logging / What to Log
Description Sets the application name to be reported in statistics and logs.
Data type string
Default value
Allowed values [A-Za-z0-9._-]*
Parameter type dynamic
Documentation application_name

debug_pretty_print

Attribute Value
Category Reporting and Logging / What to Log
Description Indents parse and plan tree displays.
Data type boolean
Default value on
Allowed values on,off
Parameter type dynamic
Documentation debug_pretty_print

debug_print_parse

Attribute Value
Category Reporting and Logging / What to Log
Description Logs each query's parse tree.
Data type boolean
Default value off
Allowed values on,off
Parameter type dynamic
Documentation debug_print_parse

debug_print_plan

Attribute Value
Category Reporting and Logging / What to Log
Description Logs each query's execution plan.
Data type boolean
Default value off
Allowed values on,off
Parameter type dynamic
Documentation debug_print_plan

debug_print_rewritten

Attribute Value
Category Reporting and Logging / What to Log
Description Logs each query's rewritten parse tree.
Data type boolean
Default value off
Allowed values on,off
Parameter type dynamic
Documentation debug_print_rewritten

log_autovacuum_min_duration

Attribute Value
Category Reporting and Logging / What to Log
Description Sets the minimum execution time above which autovacuum actions will be logged.
Data type integer
Default value 600000
Allowed values -1-2147483647
Parameter type dynamic
Documentation log_autovacuum_min_duration

log_checkpoints

Attribute Value
Category Reporting and Logging / What to Log
Description Logs each checkpoint.
Data type boolean
Default value on
Allowed values on,off
Parameter type dynamic
Documentation log_checkpoints

log_connections

Attribute Value
Category Reporting and Logging / What to Log
Description Causes each attempted connection to the server to be logged, as well as successful completion of client authentication.
Data type boolean
Default value on
Allowed values on
Parameter type read-only
Documentation log_connections

log_disconnections

Attribute Value
Category Reporting and Logging / What to Log
Description Logs end of a session, including duration.
Data type boolean
Default value on
Allowed values on
Parameter type read-only
Documentation log_disconnections

log_duration

Attribute Value
Category Reporting and Logging / What to Log
Description Logs the duration of each completed SQL statement.
Data type boolean
Default value off
Allowed values on,off
Parameter type dynamic
Documentation log_duration

log_error_verbosity

Attribute Value
Category Reporting and Logging / What to Log
Description Controls the amount of detail written in the server log for each message that is logged.
Data type enumeration
Default value default
Allowed values terse,default,verbose
Parameter type dynamic
Documentation log_error_verbosity

log_hostname

Attribute Value
Category Reporting and Logging / What to Log
Description Logs the host name in the connection logs.
Data type boolean
Default value off
Allowed values on,off
Parameter type dynamic
Documentation log_hostname

log_line_prefix

Attribute Value
Category Reporting and Logging / What to Log
Description Sets the printf-style string that is output at the beginning of each log line.
Data type string
Default value %t-%c-
Allowed values [^']*
Parameter type dynamic
Documentation log_line_prefix

log_lock_waits

Attribute Value
Category Reporting and Logging / What to Log
Description Controls whether a log message is produced when a session waits longer than deadlock_timeout to acquire a lock.
Data type boolean
Default value off
Allowed values on,off
Parameter type dynamic
Documentation log_lock_waits

log_parameter_max_length

Attribute Value
Category Reporting and Logging / What to Log
Description Sets the maximum length in bytes of data logged for bind parameter values when logging statements.
Data type integer
Default value -1
Allowed values -1
Parameter type read-only
Documentation log_parameter_max_length

log_parameter_max_length_on_error

Attribute Value
Category Reporting and Logging / What to Log
Description Sets the maximum length in bytes of data logged for bind parameter values when logging statements, on error.
Data type integer
Default value 0
Allowed values 0
Parameter type read-only
Documentation log_parameter_max_length_on_error

log_recovery_conflict_waits

Attribute Value
Category Reporting and Logging / What to Log
Description Controls whether a log message is produced when the startup process waits longer than deadlock_timeout for recovery conflicts.
Data type boolean
Default value off
Allowed values on,off
Parameter type dynamic
Documentation log_recovery_conflict_waits

log_replication_commands

Attribute Value
Category Reporting and Logging / What to Log
Description Logs each replication command.
Data type boolean
Default value on
Allowed values on
Parameter type read-only
Documentation log_replication_commands

log_statement

Attribute Value
Category Reporting and Logging / What to Log
Description Sets the type of statements logged.
Data type enumeration
Default value none
Allowed values none,ddl,mod,all
Parameter type dynamic
Documentation log_statement

log_temp_files

Attribute Value
Category Reporting and Logging / What to Log
Description Logs the use of temporary files larger than this number of kilobytes.
Data type integer
Default value -1
Allowed values -1-2147483647
Parameter type dynamic
Documentation log_temp_files

log_timezone

Attribute Value
Category Reporting and Logging / What to Log
Description Sets the time zone to use in log messages.
Data type string
Default value UTC
Allowed values UTC
Parameter type read-only
Documentation log_timezone

application_name

Attribute Value
Category Reporting and Logging / What to Log
Description Sets the application name to be reported in statistics and logs.
Data type string
Default value
Allowed values [A-Za-z0-9._-]*
Parameter type dynamic
Documentation application_name

debug_pretty_print

Attribute Value
Category Reporting and Logging / What to Log
Description Indents parse and plan tree displays.
Data type boolean
Default value on
Allowed values on,off
Parameter type dynamic
Documentation debug_pretty_print

debug_print_parse

Attribute Value
Category Reporting and Logging / What to Log
Description Logs each query's parse tree.
Data type boolean
Default value off
Allowed values on,off
Parameter type dynamic
Documentation debug_print_parse

debug_print_plan

Attribute Value
Category Reporting and Logging / What to Log
Description Logs each query's execution plan.
Data type boolean
Default value off
Allowed values on,off
Parameter type dynamic
Documentation debug_print_plan

debug_print_rewritten

Attribute Value
Category Reporting and Logging / What to Log
Description Logs each query's rewritten parse tree.
Data type boolean
Default value off
Allowed values on,off
Parameter type dynamic
Documentation debug_print_rewritten

log_autovacuum_min_duration

Attribute Value
Category Reporting and Logging / What to Log
Description Sets the minimum execution time above which autovacuum actions will be logged.
Data type integer
Default value -1
Allowed values -1-2147483647
Parameter type dynamic
Documentation log_autovacuum_min_duration

log_checkpoints

Attribute Value
Category Reporting and Logging / What to Log
Description Logs each checkpoint.
Data type boolean
Default value on
Allowed values on,off
Parameter type dynamic
Documentation log_checkpoints

log_connections

Attribute Value
Category Reporting and Logging / What to Log
Description Causes each attempted connection to the server to be logged, as well as successful completion of client authentication.
Data type boolean
Default value on
Allowed values on
Parameter type read-only
Documentation log_connections

log_disconnections

Attribute Value
Category Reporting and Logging / What to Log
Description Logs end of a session, including duration.
Data type boolean
Default value on
Allowed values on
Parameter type read-only
Documentation log_disconnections

log_duration

Attribute Value
Category Reporting and Logging / What to Log
Description Logs the duration of each completed SQL statement.
Data type boolean
Default value off
Allowed values on,off
Parameter type dynamic
Documentation log_duration

log_error_verbosity

Attribute Value
Category Reporting and Logging / What to Log
Description Controls the amount of detail written in the server log for each message that is logged.
Data type enumeration
Default value default
Allowed values terse,default,verbose
Parameter type dynamic
Documentation log_error_verbosity

log_hostname

Attribute Value
Category Reporting and Logging / What to Log
Description Logs the host name in the connection logs.
Data type boolean
Default value off
Allowed values on,off
Parameter type dynamic
Documentation log_hostname

log_line_prefix

Attribute Value
Category Reporting and Logging / What to Log
Description Sets the printf-style string that is output at the beginning of each log line.
Data type string
Default value %t-%c-
Allowed values [^']*
Parameter type dynamic
Documentation log_line_prefix

log_lock_waits

Attribute Value
Category Reporting and Logging / What to Log
Description Controls whether a log message is produced when a session waits longer than deadlock_timeout to acquire a lock.
Data type boolean
Default value off
Allowed values on,off
Parameter type dynamic
Documentation log_lock_waits

log_parameter_max_length

Attribute Value
Category Reporting and Logging / What to Log
Description When logging statements, limit logged parameter values to first N bytes.
Data type integer
Default value -1
Allowed values -1
Parameter type read-only
Documentation log_parameter_max_length

log_parameter_max_length_on_error

Attribute Value
Category Reporting and Logging / What to Log
Description When reporting an error, limit logged parameter values to first N bytes.
Data type integer
Default value 0
Allowed values 0
Parameter type read-only
Documentation log_parameter_max_length_on_error

log_recovery_conflict_waits

Attribute Value
Category Reporting and Logging / What to Log
Description Controls whether a log message is produced when the startup process waits longer than deadlock_timeout for recovery conflicts.
Data type boolean
Default value off
Allowed values on,off
Parameter type dynamic
Documentation log_recovery_conflict_waits

log_replication_commands

Attribute Value
Category Reporting and Logging / What to Log
Description Logs each replication command.
Data type boolean
Default value on
Allowed values on
Parameter type read-only
Documentation log_replication_commands

log_statement

Attribute Value
Category Reporting and Logging / What to Log
Description Sets the type of statements logged.
Data type enumeration
Default value none
Allowed values none,ddl,mod,all
Parameter type dynamic
Documentation log_statement

log_temp_files

Attribute Value
Category Reporting and Logging / What to Log
Description Logs the use of temporary files larger than this number of kilobytes.
Data type integer
Default value -1
Allowed values -1-2147483647
Parameter type dynamic
Documentation log_temp_files

log_timezone

Attribute Value
Category Reporting and Logging / What to Log
Description Sets the time zone to use in log messages.
Data type string
Default value UTC
Allowed values UTC
Parameter type read-only
Documentation log_timezone

application_name

Attribute Value
Category Reporting and Logging / What to Log
Description Sets the application name to be reported in statistics and logs.
Data type string
Default value
Allowed values [A-Za-z0-9._-]*
Parameter type dynamic
Documentation application_name

debug_pretty_print

Attribute Value
Category Reporting and Logging / What to Log
Description Indents parse and plan tree displays.
Data type boolean
Default value on
Allowed values on,off
Parameter type dynamic
Documentation debug_pretty_print

debug_print_parse

Attribute Value
Category Reporting and Logging / What to Log
Description Logs each query's parse tree.
Data type boolean
Default value off
Allowed values on,off
Parameter type dynamic
Documentation debug_print_parse

debug_print_plan

Attribute Value
Category Reporting and Logging / What to Log
Description Logs each query's execution plan.
Data type boolean
Default value off
Allowed values on,off
Parameter type dynamic
Documentation debug_print_plan

debug_print_rewritten

Attribute Value
Category Reporting and Logging / What to Log
Description Logs each query's rewritten parse tree.
Data type boolean
Default value off
Allowed values on,off
Parameter type dynamic
Documentation debug_print_rewritten

log_autovacuum_min_duration

Attribute Value
Category Reporting and Logging / What to Log
Description Sets the minimum execution time above which autovacuum actions will be logged.
Data type integer
Default value -1
Allowed values -1-2147483647
Parameter type dynamic
Documentation log_autovacuum_min_duration

log_checkpoints

Attribute Value
Category Reporting and Logging / What to Log
Description Logs each checkpoint.
Data type boolean
Default value on
Allowed values on,off
Parameter type dynamic
Documentation log_checkpoints

log_connections

Attribute Value
Category Reporting and Logging / What to Log
Description Causes each attempted connection to the server to be logged, as well as successful completion of client authentication.
Data type boolean
Default value on
Allowed values on
Parameter type read-only
Documentation log_connections

log_disconnections

Attribute Value
Category Reporting and Logging / What to Log
Description Logs end of a session, including duration.
Data type boolean
Default value on
Allowed values on
Parameter type read-only
Documentation log_disconnections

log_duration

Attribute Value
Category Reporting and Logging / What to Log
Description Logs the duration of each completed SQL statement.
Data type boolean
Default value off
Allowed values on,off
Parameter type dynamic
Documentation log_duration

log_error_verbosity

Attribute Value
Category Reporting and Logging / What to Log
Description Controls the amount of detail written in the server log for each message that is logged.
Data type enumeration
Default value default
Allowed values terse,default,verbose
Parameter type dynamic
Documentation log_error_verbosity

log_hostname

Attribute Value
Category Reporting and Logging / What to Log
Description Logs the host name in the connection logs.
Data type boolean
Default value off
Allowed values on,off
Parameter type dynamic
Documentation log_hostname

log_line_prefix

Attribute Value
Category Reporting and Logging / What to Log
Description Sets the printf-style string that is output at the beginning of each log line.
Data type string
Default value %t-%c-
Allowed values [^']*
Parameter type dynamic
Documentation log_line_prefix

log_lock_waits

Attribute Value
Category Reporting and Logging / What to Log
Description Controls whether a log message is produced when a session waits longer than deadlock_timeout to acquire a lock.
Data type boolean
Default value off
Allowed values on,off
Parameter type dynamic
Documentation log_lock_waits

log_parameter_max_length

Attribute Value
Category Reporting and Logging / What to Log
Description When logging statements, limit logged parameter values to first N bytes.
Data type integer
Default value -1
Allowed values -1
Parameter type read-only
Documentation log_parameter_max_length

log_parameter_max_length_on_error

Attribute Value
Category Reporting and Logging / What to Log
Description When reporting an error, limit logged parameter values to first N bytes.
Data type integer
Default value 0
Allowed values 0
Parameter type read-only
Documentation log_parameter_max_length_on_error

log_replication_commands

Attribute Value
Category Reporting and Logging / What to Log
Description Logs each replication command.
Data type boolean
Default value on
Allowed values on
Parameter type read-only
Documentation log_replication_commands

log_statement

Attribute Value
Category Reporting and Logging / What to Log
Description Sets the type of statements logged.
Data type enumeration
Default value none
Allowed values none,ddl,mod,all
Parameter type dynamic
Documentation log_statement

log_temp_files

Attribute Value
Category Reporting and Logging / What to Log
Description Logs the use of temporary files larger than this number of kilobytes.
Data type integer
Default value -1
Allowed values -1-2147483647
Parameter type dynamic
Documentation log_temp_files

log_timezone

Attribute Value
Category Reporting and Logging / What to Log
Description Sets the time zone to use in log messages.
Data type string
Default value UTC
Allowed values UTC
Parameter type read-only
Documentation log_timezone

application_name

Attribute Value
Category Reporting and Logging / What to Log
Description Sets the application name to be reported in statistics and logs.
Data type string
Default value
Allowed values [A-Za-z0-9._-]*
Parameter type dynamic
Documentation application_name

debug_pretty_print

Attribute Value
Category Reporting and Logging / What to Log
Description Indents parse and plan tree displays.
Data type boolean
Default value on
Allowed values on,off
Parameter type dynamic
Documentation debug_pretty_print

debug_print_parse

Attribute Value
Category Reporting and Logging / What to Log
Description Logs each query's parse tree.
Data type boolean
Default value off
Allowed values on,off
Parameter type dynamic
Documentation debug_print_parse

debug_print_plan

Attribute Value
Category Reporting and Logging / What to Log
Description Logs each query's execution plan.
Data type boolean
Default value off
Allowed values on,off
Parameter type dynamic
Documentation debug_print_plan

debug_print_rewritten

Attribute Value
Category Reporting and Logging / What to Log
Description Logs each query's rewritten parse tree.
Data type boolean
Default value off
Allowed values on,off
Parameter type dynamic
Documentation debug_print_rewritten

log_autovacuum_min_duration

Attribute Value
Category Reporting and Logging / What to Log
Description Sets the minimum execution time above which autovacuum actions will be logged.
Data type integer
Default value -1
Allowed values -1-2147483647
Parameter type dynamic
Documentation log_autovacuum_min_duration

log_checkpoints

Attribute Value
Category Reporting and Logging / What to Log
Description Logs each checkpoint.
Data type boolean
Default value on
Allowed values on,off
Parameter type dynamic
Documentation log_checkpoints

log_connections

Attribute Value
Category Reporting and Logging / What to Log
Description Causes each attempted connection to the server to be logged, as well as successful completion of client authentication.
Data type boolean
Default value on
Allowed values on
Parameter type read-only
Documentation log_connections

log_disconnections

Attribute Value
Category Reporting and Logging / What to Log
Description Logs end of a session, including duration.
Data type boolean
Default value on
Allowed values on
Parameter type read-only
Documentation log_disconnections

log_duration

Attribute Value
Category Reporting and Logging / What to Log
Description Logs the duration of each completed SQL statement.
Data type boolean
Default value off
Allowed values on,off
Parameter type dynamic
Documentation log_duration

log_error_verbosity

Attribute Value
Category Reporting and Logging / What to Log
Description Controls the amount of detail written in the server log for each message that is logged.
Data type enumeration
Default value default
Allowed values terse,default,verbose
Parameter type dynamic
Documentation log_error_verbosity

log_hostname

Attribute Value
Category Reporting and Logging / What to Log
Description Logs the host name in the connection logs.
Data type boolean
Default value off
Allowed values on,off
Parameter type dynamic
Documentation log_hostname

log_line_prefix

Attribute Value
Category Reporting and Logging / What to Log
Description Sets the printf-style string that is output at the beginning of each log line.
Data type string
Default value %t-%c-
Allowed values [^']*
Parameter type dynamic
Documentation log_line_prefix

log_lock_waits

Attribute Value
Category Reporting and Logging / What to Log
Description Controls whether a log message is produced when a session waits longer than deadlock_timeout to acquire a lock.
Data type boolean
Default value off
Allowed values on,off
Parameter type dynamic
Documentation log_lock_waits

log_replication_commands

Attribute Value
Category Reporting and Logging / What to Log
Description Logs each replication command.
Data type boolean
Default value on
Allowed values on
Parameter type read-only
Documentation log_replication_commands

log_statement

Attribute Value
Category Reporting and Logging / What to Log
Description Sets the type of statements logged.
Data type enumeration
Default value none
Allowed values none,ddl,mod,all
Parameter type dynamic
Documentation log_statement

log_temp_files

Attribute Value
Category Reporting and Logging / What to Log
Description Logs the use of temporary files larger than this number of kilobytes.
Data type integer
Default value -1
Allowed values -1-2147483647
Parameter type dynamic
Documentation log_temp_files

log_timezone

Attribute Value
Category Reporting and Logging / What to Log
Description Sets the time zone to use in log messages.
Data type string
Default value UTC
Allowed values UTC
Parameter type read-only
Documentation log_timezone

application_name

Attribute Value
Category Reporting and Logging / What to Log
Description Sets the application name to be reported in statistics and logs.
Data type string
Default value
Allowed values [A-Za-z0-9._-]*
Parameter type dynamic
Documentation application_name

debug_pretty_print

Attribute Value
Category Reporting and Logging / What to Log
Description Indents parse and plan tree displays.
Data type boolean
Default value on
Allowed values on,off
Parameter type dynamic
Documentation debug_pretty_print

debug_print_parse

Attribute Value
Category Reporting and Logging / What to Log
Description Logs each query's parse tree.
Data type boolean
Default value off
Allowed values on,off
Parameter type dynamic
Documentation debug_print_parse

debug_print_plan

Attribute Value
Category Reporting and Logging / What to Log
Description Logs each query's execution plan.
Data type boolean
Default value off
Allowed values on,off
Parameter type dynamic
Documentation debug_print_plan

debug_print_rewritten

Attribute Value
Category Reporting and Logging / What to Log
Description Logs each query's rewritten parse tree.
Data type boolean
Default value off
Allowed values on,off
Parameter type dynamic
Documentation debug_print_rewritten

log_autovacuum_min_duration

Attribute Value
Category Reporting and Logging / What to Log
Description Sets the minimum execution time above which autovacuum actions will be logged.
Data type integer
Default value -1
Allowed values -1-2147483647
Parameter type dynamic
Documentation log_autovacuum_min_duration

log_checkpoints

Attribute Value
Category Reporting and Logging / What to Log
Description Logs each checkpoint.
Data type boolean
Default value on
Allowed values on,off
Parameter type dynamic
Documentation log_checkpoints

log_connections

Attribute Value
Category Reporting and Logging / What to Log
Description Causes each attempted connection to the server to be logged, as well as successful completion of client authentication.
Data type boolean
Default value on
Allowed values on
Parameter type read-only
Documentation log_connections

log_disconnections

Attribute Value
Category Reporting and Logging / What to Log
Description Logs end of a session, including duration.
Data type boolean
Default value on
Allowed values on
Parameter type read-only
Documentation log_disconnections

log_duration

Attribute Value
Category Reporting and Logging / What to Log
Description Logs the duration of each completed SQL statement.
Data type boolean
Default value off
Allowed values on,off
Parameter type dynamic
Documentation log_duration

log_error_verbosity

Attribute Value
Category Reporting and Logging / What to Log
Description Controls the amount of detail written in the server log for each message that is logged.
Data type enumeration
Default value default
Allowed values terse,default,verbose
Parameter type dynamic
Documentation log_error_verbosity

log_hostname

Attribute Value
Category Reporting and Logging / What to Log
Description Logs the host name in the connection logs.
Data type boolean
Default value off
Allowed values on,off
Parameter type dynamic
Documentation log_hostname

log_line_prefix

Attribute Value
Category Reporting and Logging / What to Log
Description Sets the printf-style string that is output at the beginning of each log line.
Data type string
Default value %t-%c-
Allowed values [^']*
Parameter type dynamic
Documentation log_line_prefix

log_lock_waits

Attribute Value
Category Reporting and Logging / What to Log
Description Controls whether a log message is produced when a session waits longer than deadlock_timeout to acquire a lock.
Data type boolean
Default value off
Allowed values on,off
Parameter type dynamic
Documentation log_lock_waits

log_replication_commands

Attribute Value
Category Reporting and Logging / What to Log
Description Logs each replication command.
Data type boolean
Default value on
Allowed values on
Parameter type read-only
Documentation log_replication_commands

log_statement

Attribute Value
Category Reporting and Logging / What to Log
Description Sets the type of statements logged.
Data type enumeration
Default value none
Allowed values none,ddl,mod,all
Parameter type dynamic
Documentation log_statement

log_temp_files

Attribute Value
Category Reporting and Logging / What to Log
Description Logs the use of temporary files larger than this number of kilobytes.
Data type integer
Default value -1
Allowed values -1-2147483647
Parameter type dynamic
Documentation log_temp_files

log_timezone

Attribute Value
Category Reporting and Logging / What to Log
Description Sets the time zone to use in log messages.
Data type string
Default value UTC
Allowed values UTC
Parameter type read-only
Documentation log_timezone