Reporting and Logging / When to Log

2025-09-26

log_min_duration_sample

Attribute	Value
Category	Reporting and Logging / When to Log
Description	Sets the minimum execution time above which a sample of statements will be logged. Sampling is determined by log_statement_sample_rate. Zero logs a sample of all queries. -1 turns this feature off.
Data type	integer
Default value	`-1`
Allowed values	`-1-2147483647`
Parameter type	dynamic
Documentation	log_min_duration_sample

log_min_duration_statement

Attribute	Value
Category	Reporting and Logging / When to Log
Description	Sets the minimum execution time above which all statements will be logged. Zero prints all queries. -1 turns this feature off.
Data type	integer
Default value	`-1`
Allowed values	`-1-2147483647`
Parameter type	dynamic
Documentation	log_min_duration_statement

log_min_error_statement

Attribute	Value
Category	Reporting and Logging / When to Log
Description	Causes all statements generating error at or above this level to be logged. Each level includes all the levels that follow it. The later the level, the fewer messages are sent.
Data type	enumeration
Default value	`error`
Allowed values	`debug5,debug4,debug3,debug2,debug1,info,notice,warning,error,log,fatal,panic`
Parameter type	dynamic
Documentation	log_min_error_statement

log_min_messages

Attribute	Value
Category	Reporting and Logging / When to Log
Description	Sets the message levels that are logged. Each level includes all the levels that follow it. The later the level, the fewer messages are sent.
Data type	enumeration
Default value	`warning`
Allowed values	`debug5,debug4,debug3,debug2,debug1,info,notice,warning,error,log,fatal,panic`
Parameter type	dynamic
Documentation	log_min_messages

log_startup_progress_interval

Attribute	Value
Category	Reporting and Logging / When to Log
Description	Time between progress updates for long-running startup operations. 0 turns this feature off.
Data type	integer
Default value	`10000`
Allowed values	`10000`
Parameter type	read-only
Documentation	log_startup_progress_interval

log_statement_sample_rate

Attribute	Value
Category	Reporting and Logging / When to Log
Description	Fraction of statements exceeding "log_min_duration_sample" to be logged. Use a value between 0.0 (never log) and 1.0 (always log).
Data type	numeric
Default value	`1`
Allowed values	`0-1`
Parameter type	dynamic
Documentation	log_statement_sample_rate

log_transaction_sample_rate

Attribute	Value
Category	Reporting and Logging / When to Log
Description	Sets the fraction of transactions from which to log all statements. Use a value between 0.0 (never log) and 1.0 (log all statements for all transactions).
Data type	numeric
Default value	`0`
Allowed values	`0`
Parameter type	read-only
Documentation	log_transaction_sample_rate

log_min_duration_sample

Attribute	Value
Category	Reporting and Logging / When to Log
Description	Sets the minimum execution time above which a sample of statements will be logged. Sampling is determined by log_statement_sample_rate.
Data type	integer
Default value	`-1`
Allowed values	`-1-2147483647`
Parameter type	dynamic
Documentation	log_min_duration_sample

log_min_duration_statement

Attribute	Value
Category	Reporting and Logging / When to Log
Description	Sets the minimum execution time (in milliseconds) above which statements will be logged. -1 disables logging statement durations.
Data type	integer
Default value	`-1`
Allowed values	`-1-2147483647`
Parameter type	dynamic
Documentation	log_min_duration_statement

log_min_error_statement

Attribute	Value
Category	Reporting and Logging / When to Log
Description	Causes all statements generating error at or above this level to be logged.
Data type	enumeration
Default value	`error`
Allowed values	`debug5,debug4,debug3,debug2,debug1,info,notice,warning,error,log,fatal,panic`
Parameter type	dynamic
Documentation	log_min_error_statement

log_min_messages

Attribute	Value
Category	Reporting and Logging / When to Log
Description	Controls which message levels are written to the server log.
Data type	enumeration
Default value	`warning`
Allowed values	`debug5,debug4,debug3,debug2,debug1,info,notice,warning,error,log,fatal,panic`
Parameter type	dynamic
Documentation	log_min_messages

log_startup_progress_interval

Attribute	Value
Category	Reporting and Logging / When to Log
Description	Time between progress updates for long-running startup operations.
Data type	integer
Default value	`10000`
Allowed values	`10000`
Parameter type	read-only
Documentation	log_startup_progress_interval

log_statement_sample_rate

Attribute	Value
Category	Reporting and Logging / When to Log
Description	Fraction of statements exceeding log_min_duration_sample to be logged.
Data type	numeric
Default value	`1`
Allowed values	`0-1`
Parameter type	dynamic
Documentation	log_statement_sample_rate

log_transaction_sample_rate

Attribute	Value
Category	Reporting and Logging / When to Log
Description	Sets the fraction of transactions from which to log all statements.
Data type	numeric
Default value	`0`
Allowed values	`0`
Parameter type	read-only
Documentation	log_transaction_sample_rate

log_min_duration_sample

Attribute	Value
Category	Reporting and Logging / When to Log
Description	Sets the minimum execution time above which a sample of statements will be logged. Sampling is determined by log_statement_sample_rate.
Data type	integer
Default value	`-1`
Allowed values	`-1-2147483647`
Parameter type	dynamic
Documentation	log_min_duration_sample

log_min_duration_statement

Attribute	Value
Category	Reporting and Logging / When to Log
Description	Sets the minimum execution time (in milliseconds) above which statements will be logged. -1 disables logging statement durations.
Data type	integer
Default value	`-1`
Allowed values	`-1-2147483647`
Parameter type	dynamic
Documentation	log_min_duration_statement

log_min_error_statement

Attribute	Value
Category	Reporting and Logging / When to Log
Description	Causes all statements generating error at or above this level to be logged.
Data type	enumeration
Default value	`error`
Allowed values	`debug5,debug4,debug3,debug2,debug1,info,notice,warning,error,log,fatal,panic`
Parameter type	dynamic
Documentation	log_min_error_statement

log_min_messages

Attribute	Value
Category	Reporting and Logging / When to Log
Description	Controls which message levels are written to the server log.
Data type	enumeration
Default value	`warning`
Allowed values	`debug5,debug4,debug3,debug2,debug1,info,notice,warning,error,log,fatal,panic`
Parameter type	dynamic
Documentation	log_min_messages

log_startup_progress_interval

Attribute	Value
Category	Reporting and Logging / When to Log
Description	Time between progress updates for long-running startup operations.
Data type	integer
Default value	`10000`
Allowed values	`10000`
Parameter type	read-only
Documentation	log_startup_progress_interval

log_statement_sample_rate

Attribute	Value
Category	Reporting and Logging / When to Log
Description	Fraction of statements exceeding log_min_duration_sample to be logged.
Data type	numeric
Default value	`1`
Allowed values	`0-1`
Parameter type	dynamic
Documentation	log_statement_sample_rate

log_transaction_sample_rate

Attribute	Value
Category	Reporting and Logging / When to Log
Description	Sets the fraction of transactions from which to log all statements.
Data type	numeric
Default value	`0`
Allowed values	`0`
Parameter type	read-only
Documentation	log_transaction_sample_rate

log_min_duration_sample

Attribute	Value
Category	Reporting and Logging / When to Log
Description	Sets the minimum execution time above which a sample of statements will be logged. Sampling is determined by log_statement_sample_rate.
Data type	integer
Default value	`-1`
Allowed values	`-1-2147483647`
Parameter type	dynamic
Documentation	log_min_duration_sample

log_min_duration_statement

Attribute	Value
Category	Reporting and Logging / When to Log
Description	Sets the minimum execution time (in milliseconds) above which statements will be logged. -1 disables logging statement durations.
Data type	integer
Default value	`-1`
Allowed values	`-1-2147483647`
Parameter type	dynamic
Documentation	log_min_duration_statement

log_min_error_statement

Attribute	Value
Category	Reporting and Logging / When to Log
Description	Causes all statements generating error at or above this level to be logged.
Data type	enumeration
Default value	`error`
Allowed values	`debug5,debug4,debug3,debug2,debug1,info,notice,warning,error,log,fatal,panic`
Parameter type	dynamic
Documentation	log_min_error_statement

log_min_messages

Attribute	Value
Category	Reporting and Logging / When to Log
Description	Controls which message levels are written to the server log.
Data type	enumeration
Default value	`warning`
Allowed values	`debug5,debug4,debug3,debug2,debug1,info,notice,warning,error,log,fatal,panic`
Parameter type	dynamic
Documentation	log_min_messages

log_startup_progress_interval

Attribute	Value
Category	Reporting and Logging / When to Log
Description	Time between progress updates for long-running startup operations.
Data type	integer
Default value	`10000`
Allowed values	`10000`
Parameter type	read-only
Documentation	log_startup_progress_interval

log_statement_sample_rate

Attribute	Value
Category	Reporting and Logging / When to Log
Description	Fraction of statements exceeding log_min_duration_sample to be logged.
Data type	numeric
Default value	`1`
Allowed values	`0-1`
Parameter type	dynamic
Documentation	log_statement_sample_rate

log_transaction_sample_rate

Attribute	Value
Category	Reporting and Logging / When to Log
Description	Sets the fraction of transactions from which to log all statements.
Data type	numeric
Default value	`0`
Allowed values	`0`
Parameter type	read-only
Documentation	log_transaction_sample_rate

log_min_duration_sample

Attribute	Value
Category	Reporting and Logging / When to Log
Description	Sets the minimum execution time above which a sample of statements will be logged. Sampling is determined by log_statement_sample_rate.
Data type	integer
Default value	`-1`
Allowed values	`-1-2147483647`
Parameter type	dynamic
Documentation	log_min_duration_sample

log_min_duration_statement

Attribute	Value
Category	Reporting and Logging / When to Log
Description	Sets the minimum execution time (in milliseconds) above which statements will be logged. -1 disables logging statement durations.
Data type	integer
Default value	`-1`
Allowed values	`-1-2147483647`
Parameter type	dynamic
Documentation	log_min_duration_statement

log_min_error_statement

Attribute	Value
Category	Reporting and Logging / When to Log
Description	Causes all statements generating error at or above this level to be logged.
Data type	enumeration
Default value	`error`
Allowed values	`debug5,debug4,debug3,debug2,debug1,info,notice,warning,error,log,fatal,panic`
Parameter type	dynamic
Documentation	log_min_error_statement

log_min_messages

Attribute	Value
Category	Reporting and Logging / When to Log
Description	Controls which message levels are written to the server log.
Data type	enumeration
Default value	`warning`
Allowed values	`debug5,debug4,debug3,debug2,debug1,info,notice,warning,error,log,fatal,panic`
Parameter type	dynamic
Documentation	log_min_messages

log_statement_sample_rate

Attribute	Value
Category	Reporting and Logging / When to Log
Description	Fraction of statements exceeding log_min_duration_sample to be logged.
Data type	numeric
Default value	`1`
Allowed values	`0-1`
Parameter type	dynamic
Documentation	log_statement_sample_rate

log_transaction_sample_rate

Attribute	Value
Category	Reporting and Logging / When to Log
Description	Sets the fraction of transactions from which to log all statements.
Data type	numeric
Default value	`0`
Allowed values	`0`
Parameter type	read-only
Documentation	log_transaction_sample_rate

log_min_duration_sample

Attribute	Value
Category	Reporting and Logging / When to Log
Description	Sets the minimum execution time above which a sample of statements will be logged. Sampling is determined by log_statement_sample_rate.
Data type	integer
Default value	`-1`
Allowed values	`-1-2147483647`
Parameter type	dynamic
Documentation	log_min_duration_sample

log_min_duration_statement

Attribute	Value
Category	Reporting and Logging / When to Log
Description	Sets the minimum execution time (in milliseconds) above which statements will be logged. -1 disables logging statement durations.
Data type	integer
Default value	`-1`
Allowed values	`-1-2147483647`
Parameter type	dynamic
Documentation	log_min_duration_statement

log_min_error_statement

Attribute	Value
Category	Reporting and Logging / When to Log
Description	Causes all statements generating error at or above this level to be logged.
Data type	enumeration
Default value	`error`
Allowed values	`debug5,debug4,debug3,debug2,debug1,info,notice,warning,error,log,fatal,panic`
Parameter type	dynamic
Documentation	log_min_error_statement

log_min_messages

Attribute	Value
Category	Reporting and Logging / When to Log
Description	Controls which message levels are written to the server log.
Data type	enumeration
Default value	`warning`
Allowed values	`debug5,debug4,debug3,debug2,debug1,info,notice,warning,error,log,fatal,panic`
Parameter type	dynamic
Documentation	log_min_messages

log_statement_sample_rate

Attribute	Value
Category	Reporting and Logging / When to Log
Description	Fraction of statements exceeding log_min_duration_sample to be logged.
Data type	numeric
Default value	`1`
Allowed values	`0-1`
Parameter type	dynamic
Documentation	log_statement_sample_rate

log_transaction_sample_rate

Attribute	Value
Category	Reporting and Logging / When to Log
Description	Set the fraction of transactions to log for new transactions.
Data type	numeric
Default value	`0`
Allowed values	`0`
Parameter type	read-only
Documentation	log_transaction_sample_rate

log_min_duration_statement

Attribute	Value
Category	Reporting and Logging / When to Log
Description	Sets the minimum execution time (in milliseconds) above which statements will be logged. -1 disables logging statement durations.
Data type	integer
Default value	`-1`
Allowed values	`-1-2147483647`
Parameter type	dynamic
Documentation	log_min_duration_statement

log_min_error_statement

Attribute	Value
Category	Reporting and Logging / When to Log
Description	Causes all statements generating error at or above this level to be logged.
Data type	enumeration
Default value	`error`
Allowed values	`debug5,debug4,debug3,debug2,debug1,info,notice,warning,error,log,fatal,panic`
Parameter type	dynamic
Documentation	log_min_error_statement

log_min_messages

Attribute	Value
Category	Reporting and Logging / When to Log
Description	Controls which message levels are written to the server log.
Data type	enumeration
Default value	`warning`
Allowed values	`debug5,debug4,debug3,debug2,debug1,info,notice,warning,error,log,fatal,panic`
Parameter type	dynamic
Documentation	log_min_messages

log_transaction_sample_rate

Attribute	Value
Category	Reporting and Logging / When to Log
Description	Set the fraction of transactions to log for new transactions.
Data type	numeric
Default value	`0`
Allowed values	`0`
Parameter type	read-only
Documentation	log_transaction_sample_rate

log_min_duration_statement

Attribute	Value
Category	Reporting and Logging / When to Log
Description	Sets the minimum execution time (in milliseconds) above which statements will be logged. -1 disables logging statement durations.
Data type	integer
Default value	`-1`
Allowed values	`-1-2147483647`
Parameter type	dynamic
Documentation	log_min_duration_statement

log_min_error_statement

Attribute	Value
Category	Reporting and Logging / When to Log
Description	Causes all statements generating error at or above this level to be logged.
Data type	enumeration
Default value	`error`
Allowed values	`debug5,debug4,debug3,debug2,debug1,info,notice,warning,error,log,fatal,panic`
Parameter type	dynamic
Documentation	log_min_error_statement

log_min_messages

Attribute	Value
Category	Reporting and Logging / When to Log
Description	Controls which message levels are written to the server log.
Data type	enumeration
Default value	`warning`
Allowed values	`debug5,debug4,debug3,debug2,debug1,info,notice,warning,error,log,fatal,panic`
Parameter type	dynamic
Documentation	log_min_messages

Feedback

Was this page helpful?