Search PostgreSQL documentation

log_checkpointsConfigurationReferencelog_checkpoints Reporting and Logging 10 Causes checkpoints and restartpoints to be logged in the server log. Some statistics are included in the log messages, including the number of buffer…Configuration · Reporting and Logging log_connectionsConfigurationReferencelog_connections Reporting and Logging 10 Causes each attempted connection to the server to be logged, as well as successful completion of client authentication. Only superusers can change th…Configuration · Reporting and Logging log_destinationConfigurationReferencelog_destination Reporting and Logging 10 PostgreSQL supports several methods for logging server messages, including stderr, csvlog and syslog. On Windows, eventlog is also supported. Set thi…Configuration · Reporting and Logging log_directoryConfigurationReferencelog_directory Reporting and Logging 10 When logging_collector is enabled, this parameter determines the directory in which log files will be created. It can be specified as an absolute path,…Configuration · Reporting and Logging log_disconnectionsConfigurationReferencelog_disconnections Reporting and Logging 10 Causes session terminations to be logged. The log output provides information similar to log_connections, plus the duration of the session. Only s…Configuration · Reporting and Logging log_durationConfigurationReferencelog_duration Reporting and Logging 10 Causes the duration of every completed statement to be logged. The default is off. Only superusers can change this setting. For clients using extended q…Configuration · Reporting and Logging log_entriesExtensionsExtensionsRow trigger that records who changed a row and when audit trigger log_entries SecuritySecurity · Extensions log_error_verbosityConfigurationReferencelog_error_verbosity Reporting and Logging 10 Controls the amount of detail written in the server log for each message that is logged. Valid values are TERSE, DEFAULT, and VERBOSE, each addin…Configuration · Reporting and Logging log_executor_statsConfigurationReferencelog_executor_stats Statistics 10 For each query, output performance statistics of the respective module to the server log. This is a crude profiling instrument, similar to the Unix getrusage…Configuration · Statistics log_fdwExtensionsExtensionsforeign-data wrapper for Postgres log file access log_fdw Foreign data wrappersForeign data wrappers · Extensions log_file_modeConfigurationReferencelog_file_mode Reporting and Logging 10 On Unix systems this parameter sets the permissions for log files when logging_collector is enabled. (On Microsoft Windows this parameter is ignored.) …Configuration · Reporting and Logging log_filenameConfigurationReferencelog_filename Reporting and Logging 10 When logging_collector is enabled, this parameter sets the file names of the created log files. The value is treated as a strftime pattern, so %-escapes…Configuration · Reporting and Logging log_functionsExtensionsExtensionsModule to log functions function log stored procedure log_functions MonitoringMonitoring · Extensions log_hostnameConfigurationReferencelog_hostname Reporting and Logging 10 By default, connection log messages only show the IP address of the connecting host. Turning this parameter on causes logging of the host name as well. …Configuration · Reporting and Logging log_line_prefixConfigurationReferencelog_line_prefix Reporting and Logging 10 This is a printf-style string that is output at the beginning of each log line. % characters begin “escape sequences” that are replaced with status i…Configuration · Reporting and Logging log_lock_failuresConfigurationReferencelog_lock_failures Reporting and Logging 18 Controls whether a detailed log message is produced when a lock acquisition fails. This is useful for analyzing the causes of lock failures. Curren…Configuration · Reporting and Logging log_lock_waitsConfigurationReferencelog_lock_waits Reporting and Logging 10 Controls whether a log message is produced when a session waits longer than deadlock_timeout to acquire a lock. This is useful in determining if lock …Configuration · Reporting and Logging log_min_duration_sampleConfigurationReferencelog_min_duration_sample Reporting and Logging 13 Allows sampling the duration of completed statements that ran for at least the specified amount of time. This produces the same kind of log e…Configuration · Reporting and Logging log_min_duration_statementConfigurationReferencelog_min_duration_statement Reporting and Logging 10 Causes the duration of each completed statement to be logged if the statement ran for at least the specified number of milliseconds. Setti…Configuration · Reporting and Logging log_min_error_statementConfigurationReferencelog_min_error_statement Reporting and Logging 10 Controls which SQL statements that cause an error condition are recorded in the server log. The current SQL statement is included in the log …Configuration · Reporting and Logging log_min_messagesConfigurationReferencelog_min_messages Reporting and Logging 10 Controls which message levels are written to the server log. Valid values are DEBUG5, DEBUG4, DEBUG3, DEBUG2, DEBUG1, INFO, NOTICE, WARNING, ERROR, …Configuration · Reporting and Logging log_parameter_max_lengthConfigurationReferencelog_parameter_max_length Reporting and Logging 13 If greater than zero, each bind parameter value logged with a non-error statement-logging message is trimmed to this many bytes. Zero disabl…Configuration · Reporting and Logging log_parameter_max_length_on_errorConfigurationReferencelog_parameter_max_length_on_error Reporting and Logging 13 If greater than zero, each bind parameter value reported in error messages is trimmed to this many bytes. Zero (the default) disabl…Configuration · Reporting and Logging log_parser_statsConfigurationReferencelog_parser_stats Statistics 10 For each query, output performance statistics of the respective module to the server log. This is a crude profiling instrument, similar to the Unix getrusage()…Configuration · Statistics log_planner_statsConfigurationReferencelog_planner_stats Statistics 10 For each query, output performance statistics of the respective module to the server log. This is a crude profiling instrument, similar to the Unix getrusage(…Configuration · Statistics log_recovery_conflict_waitsConfigurationReferencelog_recovery_conflict_waits Reporting and Logging 14 Controls whether a log message is produced when the startup process waits longer than deadlock_timeout for recovery conflicts. This is us…Configuration · Reporting and Logging log_replication_commandsConfigurationReferencelog_replication_commands Reporting and Logging 10 Causes each replication command to be logged in the server log. See Section 52.4 for more information about replication command. The default…Configuration · Reporting and Logging log_rotation_ageConfigurationReferencelog_rotation_age Reporting and Logging 10 When logging_collector is enabled, this parameter determines the maximum lifetime of an individual log file. After this many minutes have elapsed, a…Configuration · Reporting and Logging log_rotation_sizeConfigurationReferencelog_rotation_size Reporting and Logging 10 When logging_collector is enabled, this parameter determines the maximum size of an individual log file. After this many kilobytes have been emitte…Configuration · Reporting and Logging log_startup_progress_intervalConfigurationReferencelog_startup_progress_interval Reporting and Logging 15 Sets the amount of time after which the startup process will log a message about a long-running operation that is still in progress, as…Configuration · Reporting and Logging log_statementConfigurationReferencelog_statement Reporting and Logging 10 Controls which SQL statements are logged. Valid values are none (off), ddl, mod, and all (all statements). ddl logs all data definition statements, suc…Configuration · Reporting and Logging log_statement_max_lengthConfigurationReferencelog_statement_max_length Reporting and Logging 20 If greater than zero, each statement logged by log_statement, log_min_duration_statement, log_min_duration_sample, or log_transaction_sample…Configuration · Reporting and Logging log_statement_sample_rateConfigurationReferencelog_statement_sample_rate Reporting and Logging 13 Determines the fraction of statements with duration exceeding log_min_duration_sample that will be logged. Sampling is stochastic, for exam…Configuration · Reporting and Logging log_statement_statsConfigurationReferencelog_statement_stats Statistics 10 For each query, output performance statistics of the respective module to the server log. This is a crude profiling instrument, similar to the Unix getrusag…Configuration · Statistics log_temp_filesConfigurationReferencelog_temp_files Reporting and Logging 10 Controls logging of temporary file names and sizes. Temporary files can be created for sorts, hashes, and temporary query results. A log entry is made…Configuration · Reporting and Logging log_timezoneConfigurationReferencelog_timezone Reporting and Logging 10 Sets the time zone used for timestamps written in the server log. Unlike TimeZone, this value is cluster-wide, so that all sessions will report timestam…Configuration · Reporting and Logging log_transaction_sample_rateConfigurationReferencelog_transaction_sample_rate Reporting and Logging 12 Set the fraction of transactions whose statements are all logged, in addition to statements logged for other reasons. It applies to each …Configuration · Reporting and Logging log_truncate_on_rotationConfigurationReferencelog_truncate_on_rotation Reporting and Logging 10 When logging_collector is enabled, this parameter will cause PostgreSQL to truncate (overwrite), rather than append to, any existing log fil…Configuration · Reporting and Logging logerrorsExtensionsExtensionsFunction for collecting statistics about messages in logfile logerrors SecuritySecurity · Extensions logfmtExtensionsExtensionslogfmt log collector log logging monitoring logfmt MonitoringMonitoring · Extensions