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 | off |
Parameter type | read-only |
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 | off |
Parameter type | read-only |
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 | off |
Parameter type | read-only |
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 | off |
Parameter type | read-only |
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 | off |
Parameter type | read-only |
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 | off |
Parameter type | read-only |
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 |