{"Entry":{"collection":"catalog","key":"pg_stat_checkpointer","name":"pg_stat_checkpointer","aliases":[],"metadata":{"changed_in":["18"],"changes":[{"added":[],"attributes":[],"description_changed":false,"descriptions":[],"from":"16","order":false,"removed":[],"status":"added","to":"17","types":[]},{"added":["num_done","slru_written"],"attributes":[],"description_changed":false,"descriptions":[{"from":"Number of buffers written during checkpoints and restartpoints","name":"buffers_written","to":"Number of shared buffers written during checkpoints and restartpoints"},{"from":"Number of requested checkpoints that have been performed","name":"num_requested","to":"Number of requested checkpoints"},{"from":"Number of scheduled checkpoints due to timeout. Note that checkpoints may be skipped if the server has been idle since the last one, and this value counts both completed and skipped checkpoints","name":"num_timed","to":"Number of scheduled checkpoints due to timeout"}],"from":"17","listing":[],"order":false,"removed":[],"status":"changed","to":"18","types":[],"unlisted":[]}],"column_count":11,"content_hash":"f4be6bc7c16515a81cb0c4c24a679aea4a8eb89ec0d85f261662c4b3d33de12c","first_version":"17","imported_at":"2026-09-30T00:40:55.894139+08:00","kind":"statistics","last_version":"20","name":"pg_stat_checkpointer","position":87,"present_in":["17","18","19","20"],"relation_oid":null,"relkind":"v","shared":false,"source_rev":"english-manuals:ffaed59895c47852c39b0b818ec746bdc386a3c9fa4133dc999b3d933783d5c3","summary":"The pg_stat_checkpointer view will always have a single row, containing data about the checkpointer process of the cluster.","summary_zh":""}},"Definition":{"Collection":"catalog","Key":"pg_stat_checkpointer","SourceDatabase":"center","Version":"18","SourceTable":"catalog","SourceKey":"pg_stat_checkpointer","SourceRevision":"english-manuals:ffaed59895c47852c39b0b818ec746bdc386a3c9fa4133dc999b3d933783d5c3","Facts":{"columns":[{"array_dimensions":0,"attnum":1,"description":"Number of scheduled checkpoints due to timeout","description_zh":"","documented":true,"documented_name":"num_timed","hidden":false,"name":"num_timed","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20},{"array_dimensions":0,"attnum":2,"description":"Number of requested checkpoints","description_zh":"","documented":true,"documented_name":"num_requested","hidden":false,"name":"num_requested","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20},{"array_dimensions":0,"attnum":3,"description":"Number of checkpoints that have been performed","description_zh":"","documented":true,"documented_name":"num_done","hidden":false,"name":"num_done","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20},{"array_dimensions":0,"attnum":4,"description":"Number of scheduled restartpoints due to timeout or after a failed attempt to perform it","description_zh":"","documented":true,"documented_name":"restartpoints_timed","hidden":false,"name":"restartpoints_timed","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20},{"array_dimensions":0,"attnum":5,"description":"Number of requested restartpoints","description_zh":"","documented":true,"documented_name":"restartpoints_req","hidden":false,"name":"restartpoints_req","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20},{"array_dimensions":0,"attnum":6,"description":"Number of restartpoints that have been performed","description_zh":"","documented":true,"documented_name":"restartpoints_done","hidden":false,"name":"restartpoints_done","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20},{"array_dimensions":0,"attnum":7,"description":"Total amount of time that has been spent in the portion of processing checkpoints and restartpoints where files are written to disk, in milliseconds","description_zh":"","documented":true,"documented_name":"write_time","hidden":false,"name":"write_time","not_null":false,"references":"","type":"double precision","type_modifier":-1,"type_oid":701},{"array_dimensions":0,"attnum":8,"description":"Total amount of time that has been spent in the portion of processing checkpoints and restartpoints where files are synchronized to disk, in milliseconds","description_zh":"","documented":true,"documented_name":"sync_time","hidden":false,"name":"sync_time","not_null":false,"references":"","type":"double precision","type_modifier":-1,"type_oid":701},{"array_dimensions":0,"attnum":9,"description":"Number of shared buffers written during checkpoints and restartpoints","description_zh":"","documented":true,"documented_name":"buffers_written","hidden":false,"name":"buffers_written","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20},{"array_dimensions":0,"attnum":10,"description":"Number of SLRU buffers written during checkpoints and restartpoints","description_zh":"","documented":true,"documented_name":"slru_written","hidden":false,"name":"slru_written","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20},{"array_dimensions":0,"attnum":11,"description":"Time at which these statistics were last reset","description_zh":"","documented":true,"documented_name":"stats_reset","hidden":false,"name":"stats_reset","not_null":false,"references":"","type":"timestamp with time zone","type_modifier":-1,"type_oid":1184}],"description":"The pg_stat_checkpointer view will always have a single row, containing data about the checkpointer process of the cluster.","description_zh":"","doc":{"anchor":"PG-STAT-CHECKPOINTER-VIEW","file":"monitoring-stats.html","lang":"en","sha256":"aa979eed08627fbf715a9d792094a162a73671db5af810f3ab2aad3e073d5722","slug":"18"},"kind":"statistics","lang":"en","measured_attributes":true,"metadata_release":"18.6","runtime_columns":["num_timed","num_requested","num_done","restartpoints_timed","restartpoints_req","restartpoints_done","write_time","sync_time","buffers_written","slru_written","stats_reset"],"runtime_verified":false,"source":"english-manual"},"ManualEvidence":{"doc":{"anchor":"PG-STAT-CHECKPOINTER-VIEW","file":"monitoring-stats.html","lang":"en","sha256":"aa979eed08627fbf715a9d792094a162a73671db5af810f3ab2aad3e073d5722","slug":"18"}},"MeasuredEvidence":{"measured_attributes":true,"metadata_release":"18.6","runtime_columns":["num_timed","num_requested","num_done","restartpoints_timed","restartpoints_req","restartpoints_done","write_time","sync_time","buffers_written","slru_written","stats_reset"],"runtime_verified":false}},"Text":{"Collection":"catalog","Key":"pg_stat_checkpointer","SourceDatabase":"pgweb","Version":"18","Locale":"zh-Hans","Title":"pg_stat_checkpointer","Summary":"pg_stat_checkpointer 视图始终只有一行，包含有关集簇检查点进程的数据。","BodyHTML":"\u003cp\u003epg_stat_checkpointer 视图始终只有一行，包含有关集簇检查点进程的数据。\u003c/p\u003e","SourceRevision":"2026-09-27@419045e","ContentHash":"c1b59e21da94b699ee91af0bb7a0c55e5b4d29ac3d505f5db39b3d0499bab13f","Payload":{"columns":[{"description_zh":"因超时而安排的检查点数量","name":"num_timed","type":"bigint","zh_from":"doc"},{"description_zh":"被请求执行的检查点数量","name":"num_requested","type":"bigint","zh_from":"doc"},{"description_zh":"已执行的检查点数量","name":"num_done","type":"bigint","zh_from":"doc"},{"description_zh":"因超时或在上次尝试执行失败后安排的重启点数量","name":"restartpoints_timed","type":"bigint","zh_from":"doc"},{"description_zh":"被请求执行的重启点数量","name":"restartpoints_req","type":"bigint","zh_from":"doc"},{"description_zh":"已执行的重启点数量","name":"restartpoints_done","type":"bigint","zh_from":"doc"},{"description_zh":"处理检查点和重启点时，将文件写入磁盘阶段所花费的总时间，以毫秒计","name":"write_time","type":"double precision","zh_from":"doc"},{"description_zh":"处理检查点和重启点时，将文件同步到磁盘阶段所花费的总时间，以毫秒计","name":"sync_time","type":"double precision","zh_from":"doc"},{"description_zh":"在检查点和重启点期间写入的共享缓冲区数量","name":"buffers_written","type":"bigint","zh_from":"doc"},{"description_zh":"在检查点和重启点期间写入的 SLRU 缓冲区数量","name":"slru_written","type":"bigint","zh_from":"doc"},{"description_zh":"这些统计信息上次被重置的时间","name":"stats_reset","type":"timestamp with time zone","zh_from":"doc"}],"description_zh":"pg_stat_checkpointer 视图始终只有一行，包含有关集簇检查点进程的数据。","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}