Configuration parameter

log_timezone — PostgreSQL configuration parameter

Category Error Reporting and Logging Change scope Sighup

Sets the time zone used for timestamps written in the server log.

At a glance

Property Value
Parameter log_timezone
Category Error Reporting and Logging
Default GMT
Value type string
Change scope Reload (postgresql.conf, SIGHUP)
Available in PostgreSQL 12, 13, 14, 15, 16, 17, 18, 19 (added in 12)

What it does

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 timestamps consistently. The built-in default is GMT, but that is typically overridden in postgresql.conf; initdb will install a setting there corresponding to its system environment. See datatype_timezones for more information. This parameter can only be set in the postgresql.conf file or on the server command line.

(Description quoted from the official PostgreSQL documentation.)

How to apply a change

Set it in postgresql.conf (or with ALTER SYSTEM) and reload with SELECT pg_reload_conf(); or pg_ctl reload — no restart needed.

Inspect the current value and source with SHOW log_timezone; or SELECT name, setting, unit, context, source FROM pg_settings WHERE name = 'log_timezone';.

Tuning guidance

Tune this for observability versus log volume, not for raw performance. More verbose logging helps diagnose problems but costs disk and I/O; quieter logging saves space but hides detail. Pick a level your log pipeline can store and search, and raise verbosity temporarily when investigating an incident.

Reference

PostgreSQL documentation — log_timezone.

Keep going

Related & next steps

Was this helpful?

← All configuration parameters