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 | -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 | 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 | 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 |
Feedback
https://aka.ms/ContentUserFeedback.
În curând: Pe parcursul anului 2024, vom elimina treptat Probleme legate de GitHub ca mecanism de feedback pentru conținut și îl vom înlocui cu un nou sistem de feedback. Pentru mai multe informații, consultați:Trimiteți și vizualizați feedback pentru