{"Entry":{"collection":"waitevent","key":"ipc/CheckpointDelayStart","name":"CheckpointDelayStart","aliases":["CheckpointDelayStart"],"metadata":{"aliases":["CheckpointDelayStart"],"changed_in":[],"changes":[{"from":"16","moved":null,"renamed":null,"reworded":null,"status":"added","to":"17"}],"content_hash":"c150c6f7af04b3d63a98f3f304428b5690021427ee27b1d276012a1ed8d65f7a","dossier":{"actions":{"en":["Identify the peer or phase named by the event.","Inspect that participant's wait, error, and progress state.","Repair the stalled participant or upstream dependency instead of treating the waiter as the root cause."],"zh":["确认事件所指的对端或阶段。","检查该参与者的等待、错误与进展状态。","修复停滞的参与者或上游依赖，不要把等待者当作根因。"]},"diagnostic_sql":[{"id":"sessions","min_version":"13","sql":"SELECT pid, backend_type, usename, datname, application_name,\n       state, now() - query_start AS query_age,\n       now() - xact_start AS xact_age,\n       wait_event_type, wait_event,\n       pg_blocking_pids(pid) AS blocking_pids,\n       left(query, 160) AS query\nFROM pg_stat_activity\nWHERE wait_event_type = 'IPC'\n  AND wait_event = 'CheckpointDelayStart'\nORDER BY query_age DESC NULLS LAST;","title":"Sessions waiting on IPC/CheckpointDelayStart","title_zh":"正在等待 IPC/CheckpointDelayStart 的会话"},{"id":"cohort","min_version":"13","sql":"SELECT wait_event, count(*) AS waiting_sessions,\n       count(*) FILTER (WHERE state = 'active') AS active_waiters,\n       max(now() - query_start) AS oldest_query\nFROM pg_stat_activity\nWHERE wait_event_type = 'IPC'\nGROUP BY wait_event\nORDER BY waiting_sessions DESC, wait_event;","title":"Current IPC cohort","title_zh":"当前 IPC 等待分布"},{"id":"lock_objects","min_version":"13","sql":"SELECT a.pid, l.locktype, l.mode, l.granted, l.fastpath,\n       d.datname, n.nspname, c.relname,\n       l.page, l.tuple, l.virtualxid, l.transactionid,\n       l.classid, l.objid, l.objsubid\nFROM pg_stat_activity AS a\nLEFT JOIN pg_locks AS l ON l.pid = a.pid\nLEFT JOIN pg_database AS d ON d.oid = l.database\nLEFT JOIN pg_class AS c\n  ON c.oid = l.relation\n AND l.database = (\n       SELECT oid FROM pg_database WHERE datname = current_database()\n     )\nLEFT JOIN pg_namespace AS n ON n.oid = c.relnamespace\nWHERE a.wait_event_type = 'IPC'\n  AND a.wait_event = 'CheckpointDelayStart'\nORDER BY a.pid, l.granted, l.locktype, l.mode;","title":"Lock and relation context for these sessions","title_zh":"这些会话的锁与关系上下文"}],"emission":{"status":"active","verified_release":"18.6"},"gucs":["checkpoint_timeout","max_wal_size"],"incident_pattern":{"en":"","zh":""},"mechanism":{"en":"`WAIT_EVENT_CHECKPOINT_DELAY_START` at `src/backend/access/transam/xlog.c:7211` is the grep-verified reporting path. The public identity/resource is mapped at `src/backend/utils/activity/wait_event_names.txt:116`. The instrumented operation is: Waiting for a backend that blocks a checkpoint from starting. The CheckpointDelayStart path has reached a process-coordination point and sleeps until a peer, worker, barrier, queue, or replication phase signals progress.","zh":"`WAIT_EVENT_CHECKPOINT_DELAY_START` 位于 `src/backend/access/transam/xlog.c:7211`，是经 grep 核验的报告路径。公共身份/资源映射位于 `src/backend/utils/activity/wait_event_names.txt:116`。探针覆盖的操作是：等待后端解除对检查点启动的阻塞。CheckpointDelayStart 路径已经到达进程协调点，会休眠到对端、worker、屏障、队列或复制阶段发出进展信号。"},"metrics":["waiting_sessions","wait_event_share","checkpoint_time"],"normal":{"en":"Brief rendezvous is normal when every participant continues to advance.","zh":"只要所有参与者都在继续推进，短暂汇合就属正常。"},"official_descriptions":{"17":"Waiting for a backend that blocks a checkpoint from starting","18":"Waiting for a backend that blocks a checkpoint from starting"},"record_kind":"event","source_locations":[{"commit":"724edf9bde9d356724ad384a2e196edc3c9f80f7","excerpt":"pgstat_report_wait_start(WAIT_EVENT_CHECKPOINT_DELAY_START);","grep_pattern":"WAIT_EVENT_CHECKPOINT_DELAY_START","grep_verified":true,"kind":"trigger","line":7211,"major":18,"path":"src/backend/access/transam/xlog.c","status":"live_trigger","symbol":"WAIT_EVENT_CHECKPOINT_DELAY_START","tag":"REL_18_6","url":"https://github.com/postgres/postgres/blob/REL_18_6/src/backend/access/transam/xlog.c#L7211","version":"18.6"},{"commit":"724edf9bde9d356724ad384a2e196edc3c9f80f7","excerpt":"CHECKPOINT_DELAY_START\t\"Waiting for a backend that blocks a checkpoint from starting.\"","grep_pattern":"CHECKPOINT_DELAY_START","grep_verified":true,"kind":"catalog_definition","line":116,"major":18,"path":"src/backend/utils/activity/wait_event_names.txt","status":"live_trigger","symbol":"CHECKPOINT_DELAY_START","tag":"REL_18_6","url":"https://github.com/postgres/postgres/blob/REL_18_6/src/backend/utils/activity/wait_event_names.txt#L116","version":"18.6"}],"source_status":"live_trigger","trouble":{"en":"Investigate when the same phase persists across three samples, the expected peer is absent or blocked, or a queue and its dependants stop moving.","zh":"同一阶段连续三次采样仍存在、预期对端缺失或被阻塞，或队列及其依赖者停止推进时，应当调查。"}},"first_version":"17","has_dossier":true,"imported_at":"2026-09-27T17:57:32.722296+08:00","key":"ipc/checkpointdelaystart","last_version":"20","name":"CheckpointDelayStart","position":133,"present_in":["17","18","19","20"],"slug":"checkpoint-delay-start","source_rev":"english-manuals:b26b44f91c395987d2f34fa1f8d05e5466235cbeeb45c576c4abbc2c2c090ae2","summary":"Waiting for a backend that blocks a checkpoint from starting.","summary_zh":"","type":"IPC","type_slug":"ipc","type_variants":["IPC"]}},"Definition":{"Collection":"waitevent","Key":"ipc/CheckpointDelayStart","SourceDatabase":"center","Version":"18","SourceTable":"waitevent","SourceKey":"ipc/checkpointdelaystart","SourceRevision":"english-manuals:b26b44f91c395987d2f34fa1f8d05e5466235cbeeb45c576c4abbc2c2c090ae2","Facts":{"description":"Waiting for a backend that blocks a checkpoint from starting.","description_zh":"","doc":{"anchor":"WAIT-EVENT-IPC-TABLE","file":"monitoring-stats.html","lang":"en","sha256":"aa979eed08627fbf715a9d792094a162a73671db5af810f3ab2aad3e073d5722","slug":"18"},"lang":"en","name":"CheckpointDelayStart","source":"english-manual","type":"IPC","zh_from":""},"ManualEvidence":{"doc":{"anchor":"WAIT-EVENT-IPC-TABLE","file":"monitoring-stats.html","lang":"en","sha256":"aa979eed08627fbf715a9d792094a162a73671db5af810f3ab2aad3e073d5722","slug":"18"}},"MeasuredEvidence":{}},"Text":{"Collection":"waitevent","Key":"ipc/CheckpointDelayStart","SourceDatabase":"pgweb","Version":"18","Locale":"zh-Hans","Title":"CheckpointDelayStart","Summary":"等待阻碍检查点开始的后端。","BodyHTML":"\u003cp\u003e等待阻碍检查点开始的后端。\u003c/p\u003e","SourceRevision":"2026-08-31@34d13c8","ContentHash":"561d412120fc5453fc06a0f97ac42efdedcbb88e6dc96c752e379d0e16f93f29","Payload":{"description_zh":"等待阻碍检查点开始的后端。","zh_from":"doc"}},"RequestedLocale":"zh-Hans","Fallback":false,"Versions":["17","18","19","20"],"Locales":["en","zh-Hans"],"Signatures":null,"Spellings":null,"SQLState":null,"Evidence":null}