Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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. Zero prints all actions. -1 turns autovacuum logging off. |
| 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 | Logs each successful connection. |
| Data type | set |
| Default value | on |
| Allowed values | on,off,receipt,authentication,authorization,setup_durations,all |
| Parameter type | dynamic |
| 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,off |
| Parameter type | dynamic |
| 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 | Sets the verbosity of logged messages. |
| 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. By default, connection logs only show the IP address of the connecting host. If you want them to show the host name you can turn this on, but depending on your host name resolution setup it might impose a non-negligible performance penalty. |
| 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 | Controls information prefixed to each log line. If blank, no prefix is used. |
| Data type | string |
| Default value | %t-%c- |
| Allowed values | [^']* |
| Parameter type | dynamic |
| Documentation | log_line_prefix |
log_lock_failure
| Attribute | Value |
|---|---|
| Category | Reporting and Logging / What to Log |
| Description | Controls whether a detailed log message is produced when a lock acquisition fails. |
| Data type | boolean |
| Default value | off |
| Allowed values | on,off |
| Parameter type | dynamic |
| Documentation | log_lock_failure |
log_lock_waits
| Attribute | Value |
|---|---|
| Category | Reporting and Logging / What to Log |
| Description | Logs long lock waits. |
| 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. -1 to print values in full. |
| Data type | integer |
| Default value | -1 |
| Allowed values | -1-1073741823 |
| Parameter type | dynamic |
| 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. -1 to print values in full. |
| Data type | integer |
| Default value | 0 |
| Allowed values | -1-1073741823 |
| Parameter type | dynamic |
| Documentation | log_parameter_max_length_on_error |
log_recovery_conflict_waits
| Attribute | Value |
|---|---|
| Category | Reporting and Logging / What to Log |
| Description | Logs standby recovery conflict waits. |
| 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 | Log the use of temporary files larger than this number of kilobytes. Zero logs all files. The default is -1 (turning this feature off). |
| 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,off |
| Parameter type | dynamic |
| 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,off |
| Parameter type | dynamic |
| 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-1073741823 |
| Parameter type | dynamic |
| 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 | -1-1073741823 |
| Parameter type | dynamic |
| 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,off |
| Parameter type | dynamic |
| 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,off |
| Parameter type | dynamic |
| 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-1073741823 |
| Parameter type | dynamic |
| 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 | -1-1073741823 |
| Parameter type | dynamic |
| 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,off |
| Parameter type | dynamic |
| 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,off |
| Parameter type | dynamic |
| 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-1073741823 |
| Parameter type | dynamic |
| 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 | -1-1073741823 |
| Parameter type | dynamic |
| 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,off |
| Parameter type | dynamic |
| 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,off |
| Parameter type | dynamic |
| 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-1073741823 |
| Parameter type | dynamic |
| 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 | -1-1073741823 |
| Parameter type | dynamic |
| 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,off |
| Parameter type | dynamic |
| 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,off |
| Parameter type | dynamic |
| 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-1073741823 |
| Parameter type | dynamic |
| 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 | -1-1073741823 |
| Parameter type | dynamic |
| 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,off |
| Parameter type | dynamic |
| 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,off |
| Parameter type | dynamic |
| 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,off |
| Parameter type | dynamic |
| 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,off |
| Parameter type | dynamic |
| 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 |