{"Entry":{"collection":"guc","key":"log_checkpoints","name":"log_checkpoints","aliases":[],"metadata":{"baseline":false,"boot_human":"Not specified","boot_val":null,"category":"Reporting and Logging / What to Log","category_zh":"","changed_in":["15"],"changes":[{"documentation_changed":false,"fields":{},"from":"8.2","status":"added","to":"8.3"},{"documentation_changed":true,"fields":{},"from":"9.0","status":"changed","to":"9.1"},{"documentation_changed":true,"fields":{"boot_val":{"from":"off","to":"on"}},"from":"14","status":"changed","to":"15"}],"content_hash":"c6925037e646d81c23241586ee0354f5519e8edfc4eb6dbb899c47df163cb8d1","context":"","default_changed_in":["15"],"default_history":[{"from":"9.0","to":"14","value":"off"},{"from":"15","to":"19","value":"on"}],"editorial":{"advice":{"olap":"Analytical jobs can justify richer log_checkpoints telemetry, but account for long statements, large bind values, and bursty completion patterns in the log pipeline.","oltp":"Tune log_checkpoints against an explicit observability question and a measured log-volume budget. Prefer selective thresholds, sampling, or role-level overrides over indiscriminate capture.","small":"Keep log_checkpoints useful but bounded: verify disk, collector, retention, and redaction capacity before increasing detail or frequency."},"mechanism":["log_checkpoints logs each checkpoint. A checkpoint record includes elapsed phases and buffer or WAL work, exposing checkpoint cadence and write pressure rather than merely a marker.","log_checkpoints is a SIGHUP-context setting: a configuration reload activates the new server value without a restart; subsequent operations that consult it use the refreshed value.","It changes emitted diagnostic data rather than query semantics, but volume, sensitive content, log_line_prefix, destinations, collector throughput, and retention determine operational cost and usefulness."],"pitfalls":["Editing log_checkpoints without reloading configuration and verifying the effective value and subsequent behavior.","Enabling richer logging without budgeting collector throughput, storage, retention, and downstream query cost.","Writing SQL text, bind values, identities, or host data without a redaction and access-control policy.","Changing log_checkpoints globally without a rollback plan and a client or operational compatibility test."],"references":[{"title":"PostgreSQL 19 Beta 4: log_checkpoints","url":"https://www.postgresql.org/docs/19/runtime-config-logging.html#GUC-LOG-CHECKPOINTS"},{"title":"PostgreSQL 19 release notes","url":"https://www.postgresql.org/docs/19/release-19.html"}],"related":["log_autovacuum_min_duration","log_lock_waits","log_lock_failures","log_temp_files","log_replication_commands"],"summary":"log_checkpoints is the PostgreSQL setting that controls whether PostgreSQL logs each checkpoint."},"enumvals":[],"first_version":"8.3","group":"Reporting and Logging","group_slug":"logging","imported_at":"2026-09-30T00:40:57.281902+08:00","intro_commit":{},"key":"log_checkpoints","last_version":"20","max_val":"","min_val":"","name":"log_checkpoints","position":219,"present_in":["8.3","8.4","9.0","9.1","9.2","9.3","9.4","9.5","9.6","10","11","12","13","14","15","16","17","18","19","20"],"short_desc":"Causes checkpoints and restartpoints to be logged in the server log.","short_desc_zh":"","source_rev":"english-manuals:a1936df79d0837e29a65f4426f6a728381681bd190205a8e35bb0d2559c14cae","unit":"","vartype":"bool"}},"Definition":{"Collection":"guc","Key":"log_checkpoints","SourceDatabase":"center","Version":"18","SourceTable":"guc","SourceKey":"log_checkpoints","SourceRevision":"english-manuals:a1936df79d0837e29a65f4426f6a728381681bd190205a8e35bb0d2559c14cae","Facts":{"boot_val":"on","category":"Reporting and Logging / What to Log","context":"sighup","description":"Causes checkpoints and restartpoints to be logged in the server log. Some statistics are included in the log messages, including the number of buffers written and the time spent writing them. This parameter can only be set in the postgresql.conf file or on the server command line. The default is on.","doc":{"anchor":"GUC-LOG-CHECKPOINTS","file":"runtime-config-logging.html","lang":"en","sha256":"93c48c522a72fca19705c4c91a71e951eae653662008eee2e4a9a74a11127fde","slug":"18"},"documented":true,"enumvals":null,"extra_desc":null,"lang":"en","max_val":null,"metadata_version":"18","min_val":null,"name":"log_checkpoints","short_desc":"Logs each checkpoint.","source":"pg-settings-source-snapshot","unit":null,"vartype":"bool"},"ManualEvidence":{"doc":{"anchor":"GUC-LOG-CHECKPOINTS","file":"runtime-config-logging.html","lang":"en","sha256":"93c48c522a72fca19705c4c91a71e951eae653662008eee2e4a9a74a11127fde","slug":"18"}},"MeasuredEvidence":{"metadata_version":"18"}},"Text":{"Collection":"guc","Key":"log_checkpoints","SourceDatabase":"center","Version":"18","Locale":"en","Title":"log_checkpoints","Summary":"Causes checkpoints and restartpoints to be logged in the server log. Some statistics are included in the log messages, including the number of buffers written and the time spent writing them. This parameter can only be set in the postgresql.conf file or on the server command line. The default is on.","BodyHTML":"\u003cp\u003eCauses checkpoints and restartpoints to be logged in the server log. Some statistics are included in the log messages, including the number of buffers written and the time spent writing them. This parameter can only be set in the postgresql.conf file or on the server command line. The default is on.\u003c/p\u003e","SourceRevision":"english-manuals:a1936df79d0837e29a65f4426f6a728381681bd190205a8e35bb0d2559c14cae","ContentHash":"c09c1a3c2be53ef52ba0340dbd52c0a51c394c1ca11090141f75f09eb52125a6","Payload":{"description":"Causes checkpoints and restartpoints to be logged in the server log. Some statistics are included in the log messages, including the number of buffers written and the time spent writing them. This parameter can only be set in the postgresql.conf file or on the server command line. The default is on."}},"RequestedLocale":"zh-Hans","Fallback":true,"Versions":["10","11","12","13","14","15","16","17","18","19","20","8.3","8.4","9.0","9.1","9.2","9.3","9.4","9.5","9.6"],"Locales":["en"],"Signatures":null,"Spellings":null,"SQLState":null,"Evidence":null}