· 3 min · PostgreSQL

All Your GUCs in a Row: log_replication_commands

Steampunk illustration of a brass and iron steam engine with gears and pipes billowing white smoke, processing logs on a conveyor belt in a wooden workshop, with a mallard duck perched nearby. log_replication_commands is log_statement = all for walsenders, with the one difference that you should turn it on.

0 comments

· 4 min · PostgreSQL

All Your GUCs in a Row: log_min_duration_sample, log_statement_sample_rate, and log_transaction_sample_rate

Anthropomorphic white duck wearing jeweler's loupe and apron, examining gemstones at a workbench with tools, jewelry display cases, and a desk lamp in a warm workshop setting. Aggregate query statistics hide the forest of cheap queries.

0 comments

· 6 min · PostgreSQL

All Your GUCs in a Row: log_parameter_max_length and log_parameter_max_length_on_error

Anthropomorphic white eagle wearing safety glasses and work apron measures a log with a tape measure at a woodworking bench surrounded by hand tools. Control what bind parameters PostgreSQL logs alongside statements and errors.

0 comments

· 5 min · PostgreSQL

All Your GUCs in a Row: log_min_messages, log_min_error_statement, and log_error_verbosity

Duck surrounded by continuous computer printout paper spilling from a line printer in a data center, with control panels and indicator lights visible in background. Three parameters control what reaches your server log: a severity floor, whether to attach the triggering SQL, and how many fields each message prints.

0 comments

· 5 min · PostgreSQL

All Your GUCs in a Row: log_line_prefix and log_timezone

Illustration of a split-globe showing day and night Earth, mounted on a brass stand in a grand library with an open book, duck, and astronomical charts in the background. `log_line_prefix` is where you attach session, transaction, and client context to every log line PostgreSQL emits.

0 comments

· 5 min · PostgreSQL

All Your GUCs in a Row: log_rotation_age, log_rotation_size, and log_truncate_on_rotation

Vintage carousel with wooden duck figures perched on logs instead of traditional horses, illuminated by strings of lights, at a fairground with tents and rides visible in the background. PostgreSQL's log rotation has three parameters that only make sense together: one rotates at clock boundaries, one at file sizes, and one decides whether to…

0 comments

· 5 min · PostgreSQL

All Your GUCs in a Row: log_directory, log_filename, and log_file_mode

Duck standing in an indoor corridor next to a stack of numbered wooden logs labeled 101 through 107. All three of these do nothing unless logging_collector is on; they describe the files the collector writes. Where, what they’re called, and who can read them. T

0 comments

· 6 min · PostgreSQL

All Your GUCs in a Row: log_destination and logging_collector

Duck standing on ground next to weathered wooden shed filled with stacked firewood logs. PostgreSQL's logging collector is a small pipe-based daemon that prevents message loss and garbling—but turning it on requires a restart, which you'll want on…

0 comments

· 5 min · PostgreSQL

All Your GUCs in a Row: log_connections, log_disconnections, and log_hostname

Wood duck standing among felled logs and blue and purple cables on a forest floor. PostgreSQL 18 adds granular connection logging.

0 comments

· 6 min · PostgreSQL

All Your GUCs in a Row: log_checkpoints, log_autovacuum_min_duration, and log_temp_files

Duck holding a stopwatch stands on a wooden flume carrying felled logs at a timber mill. Watch PostgreSQL's housekeeping in action: three logging parameters that reveal checkpoint costs, autovacuum trouble, and work_mem problems—and why two of them…

0 comments