Search PostgreSQL documentation

lc_monetaryConfigurationReferencelc_monetary Client Connection Defaults 10 Sets the locale to use for formatting monetary amounts, for example with the to_char family of functions. Acceptable values are system-dependent; se…Configuration · Client Connection Defaults lc_numericConfigurationReferencelc_numeric Client Connection Defaults 10 Sets the locale to use for formatting numbers, for example with the to_char family of functions. Acceptable values are system-dependent; see Section …Configuration · Client Connection Defaults lc_timeConfigurationReferencelc_time Client Connection Defaults 10 Sets the locale to use for formatting dates and times, for example with the to_char family of functions. Acceptable values are system-dependent; see Sec…Configuration · Client Connection Defaults listen_addressesConfigurationReferencelisten_addresses Connections and Authentication 10 Specifies the TCP/IP address(es) on which the server is to listen for connections from client applications. The value takes the form of a c…Configuration · Connections and Authentication lo_compat_privilegesConfigurationReferencelo_compat_privileges Version and Platform Compatibility 10 In PostgreSQL releases prior to 9.0, large objects did not have access privileges and were, therefore, always readable and writable…Configuration · Version and Platform Compatibility local_preload_librariesConfigurationReferencelocal_preload_libraries Client Connection Defaults 10 This variable specifies one or more shared libraries that are to be preloaded at connection start. It contains a comma-separated list of…Configuration · Client Connection Defaults lock_timeoutConfigurationReferencelock_timeout Client Connection Defaults 10 Abort any statement that waits longer than the specified number of milliseconds while attempting to acquire a lock on a table, index, row, or other…Configuration · Client Connection Defaults log_autoanalyze_min_durationConfigurationReferencelog_autoanalyze_min_duration Reporting and Logging 19 Causes analyze action executed by autovacuum to be logged if it ran for at least the specified amount of time. Setting this to zero logs…Configuration · Reporting and Logging log_autovacuum_min_durationConfigurationReferencelog_autovacuum_min_duration Reporting and Logging 10 Causes each action executed by autovacuum to be logged if it ran for at least the specified number of milliseconds. Setting this to zero …Configuration · Reporting and Logging log_btree_build_statsConfigurationReferencelog_btree_build_stats Developer Options 10 If set, logs system resource usage statistics (memory and CPU) on various B-tree operations. This parameter is only available if the BTREE_BUILD_ST…Configuration · Developer Options 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_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_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_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