{"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":"e7c9317e835d19c246acddcbe96a02bea3d371e88f056a715d387f192b31a04c","derived_content_hash":"a6d513487ef2f5da69594b4c2a48e5eeac4579bd289a13fdc960a85d9a085a3b","documentation_refresh":{"batch":"20261113","original_source_rev":"catalog-bilingual-repair:035aa0d98ac27fa738c63871a1dbc4f45c08ec87d531be74a5145d107d8346ff","versions":{"17":"17.12","18":"18.7","19":"19rc2"}},"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":"catalog-bilingual-repair:035aa0d98ac27fa738c63871a1dbc4f45c08ec87d531be74a5145d107d8346ff","summary":"The pg_stat_checkpointer view will always have a single row, containing data about the checkpointer process of the cluster.","summary_zh":"pg_stat_checkpointer 视图始终只有一行，包含有关集簇检查点进程的数据。"}},"Definition":{"Collection":"catalog","Key":"pg_stat_checkpointer","SourceDatabase":"center","Version":"18","SourceTable":"catalog","SourceKey":"pg_stat_checkpointer","SourceRevision":"catalog-bilingual-repair:035aa0d98ac27fa738c63871a1dbc4f45c08ec87d531be74a5145d107d8346ff","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,"zh_from":"same-version-manual"},{"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,"zh_from":"same-version-manual"},{"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,"zh_from":"same-version-manual"},{"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,"zh_from":"same-version-manual"},{"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,"zh_from":"same-version-manual"},{"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,"zh_from":"same-version-manual"},{"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,"zh_from":"same-version-manual"},{"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,"zh_from":"same-version-manual"},{"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,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":10,"description":"Number of SLRU buffers written during checkpoints and restartpoints","description_zh":"在检查点和重启点期间写入的 SLRU 缓冲区数量","documented":true,"documented_name":"slru_written","hidden":false,"name":"slru_written","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20,"zh_from":"same-version-manual"},{"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,"zh_from":"same-version-manual"}],"description":"The pg_stat_checkpointer view will always have a single row, containing data about the checkpointer process of the cluster.","description_zh":"pg_stat_checkpointer 视图始终只有一行，包含有关集簇检查点进程的数据。","description_zh_html":"\u003cp\u003epg_stat_checkpointer 视图始终只有一行，包含有关集簇检查点进程的数据。\u003c/p\u003e\u003cdiv class=\"table\" id=\"PG-STAT-CHECKPOINTER-VIEW\"\u003e\u003cp class=\"title\"\u003e\u003cstrong\u003e表 27.25. \u003ccode class=\"structname\"\u003epg_stat_checkpointer\u003c/code\u003e 视图\u003c/strong\u003e\u003c/p\u003e\u003cdiv class=\"table-contents\"\u003e\u003ctable border=\"1\" class=\"table\" summary=\"pg_stat_checkpointer 视图\"\u003e\u003ccolgroup\u003e\u003ccol/\u003e\u003c/colgroup\u003e\u003cthead\u003e\u003ctr\u003e\u003cth class=\"catalog_table_entry\"\u003e\u003cp class=\"column_definition\"\u003e\n       列类型\n      \u003c/p\u003e\n\u003cp\u003e\n       描述\n      \u003c/p\u003e\u003c/th\u003e\u003c/tr\u003e\u003c/thead\u003e\u003ctbody\u003e\u003ctr\u003e\u003ctd class=\"catalog_table_entry\"\u003e\u003cp class=\"column_definition\"\u003e\n\u003ccode class=\"structfield\"\u003enum_timed\u003c/code\u003e \u003ccode class=\"type\"\u003ebigint\u003c/code\u003e\n\u003c/p\u003e\n\u003cp\u003e\n       因超时而安排的检查点数量\n      \u003c/p\u003e\u003c/td\u003e\u003c/tr\u003e\u003ctr\u003e\u003ctd class=\"catalog_table_entry\"\u003e\u003cp class=\"column_definition\"\u003e\n\u003ccode class=\"structfield\"\u003enum_requested\u003c/code\u003e \u003ccode class=\"type\"\u003ebigint\u003c/code\u003e\n\u003c/p\u003e\n\u003cp\u003e\n       被请求执行的检查点数量\n      \u003c/p\u003e\u003c/td\u003e\u003c/tr\u003e\u003ctr\u003e\u003ctd class=\"catalog_table_entry\"\u003e\u003cp class=\"column_definition\"\u003e\n\u003ccode class=\"structfield\"\u003enum_done\u003c/code\u003e \u003ccode class=\"type\"\u003ebigint\u003c/code\u003e\n\u003c/p\u003e\n\u003cp\u003e\n       已执行的检查点数量\n      \u003c/p\u003e\u003c/td\u003e\u003c/tr\u003e\u003ctr\u003e\u003ctd class=\"catalog_table_entry\"\u003e\u003cp class=\"column_definition\"\u003e\n\u003ccode class=\"structfield\"\u003erestartpoints_timed\u003c/code\u003e \u003ccode class=\"type\"\u003ebigint\u003c/code\u003e\n\u003c/p\u003e\n\u003cp\u003e\n       因超时或在上次尝试执行失败后安排的重启点数量\n      \u003c/p\u003e\u003c/td\u003e\u003c/tr\u003e\u003ctr\u003e\u003ctd class=\"catalog_table_entry\"\u003e\u003cp class=\"column_definition\"\u003e\n\u003ccode class=\"structfield\"\u003erestartpoints_req\u003c/code\u003e \u003ccode class=\"type\"\u003ebigint\u003c/code\u003e\n\u003c/p\u003e\n\u003cp\u003e\n       被请求执行的重启点数量\n      \u003c/p\u003e\u003c/td\u003e\u003c/tr\u003e\u003ctr\u003e\u003ctd class=\"catalog_table_entry\"\u003e\u003cp class=\"column_definition\"\u003e\n\u003ccode class=\"structfield\"\u003erestartpoints_done\u003c/code\u003e \u003ccode class=\"type\"\u003ebigint\u003c/code\u003e\n\u003c/p\u003e\n\u003cp\u003e\n       已执行的重启点数量\n      \u003c/p\u003e\u003c/td\u003e\u003c/tr\u003e\u003ctr\u003e\u003ctd class=\"catalog_table_entry\"\u003e\u003cp class=\"column_definition\"\u003e\n\u003ccode class=\"structfield\"\u003ewrite_time\u003c/code\u003e \u003ccode class=\"type\"\u003edouble precision\u003c/code\u003e\n\u003c/p\u003e\n\u003cp\u003e\n       处理检查点和重启点时，将文件写入磁盘阶段所花费的总时间，以毫秒计\n      \u003c/p\u003e\u003c/td\u003e\u003c/tr\u003e\u003ctr\u003e\u003ctd class=\"catalog_table_entry\"\u003e\u003cp class=\"column_definition\"\u003e\n\u003ccode class=\"structfield\"\u003esync_time\u003c/code\u003e \u003ccode class=\"type\"\u003edouble precision\u003c/code\u003e\n\u003c/p\u003e\n\u003cp\u003e\n       处理检查点和重启点时，将文件同步到磁盘阶段所花费的总时间，以毫秒计\n      \u003c/p\u003e\u003c/td\u003e\u003c/tr\u003e\u003ctr\u003e\u003ctd class=\"catalog_table_entry\"\u003e\u003cp class=\"column_definition\"\u003e\n\u003ccode class=\"structfield\"\u003ebuffers_written\u003c/code\u003e \u003ccode class=\"type\"\u003ebigint\u003c/code\u003e\n\u003c/p\u003e\n\u003cp\u003e\n       在检查点和重启点期间写入的共享缓冲区数量\n      \u003c/p\u003e\u003c/td\u003e\u003c/tr\u003e\u003ctr\u003e\u003ctd class=\"catalog_table_entry\"\u003e\u003cp class=\"column_definition\"\u003e\n\u003ccode class=\"structfield\"\u003eslru_written\u003c/code\u003e \u003ccode class=\"type\"\u003ebigint\u003c/code\u003e\n\u003c/p\u003e\n\u003cp\u003e\n        在检查点和重启点期间写入的 SLRU 缓冲区数量\n      \u003c/p\u003e\u003c/td\u003e\u003c/tr\u003e\u003ctr\u003e\u003ctd class=\"catalog_table_entry\"\u003e\u003cp class=\"column_definition\"\u003e\n\u003ccode class=\"structfield\"\u003estats_reset\u003c/code\u003e \u003ccode class=\"type\"\u003etimestamp with time zone\u003c/code\u003e\n\u003c/p\u003e\n\u003cp\u003e这些统计信息上次被重置的时间\u003c/p\u003e\u003c/td\u003e\u003c/tr\u003e\u003c/tbody\u003e\u003c/table\u003e\u003c/div\u003e\u003c/div\u003e","doc":{"anchor":"PG-STAT-CHECKPOINTER-VIEW","file":"monitoring-stats.html","lang":"en","sha256":"a97e4aa05484b41cec1f4c9b0b9c5a083596a056982e5d5ba0db1dd8d49961fb","slug":"18"},"documentation_revision":{"inputs":[{"file":"monitoring-stats.html","kind":"same-version-reviewed-manual","locale":"en","sha256":"a97e4aa05484b41cec1f4c9b0b9c5a083596a056982e5d5ba0db1dd8d49961fb","version":"18.7"},{"file":"monitoring-stats.html","kind":"same-version-reviewed-manual","locale":"zh-Hans","sha256":"1ddb6576fe569e029a1c776c82e7add6be8e4f41705bcd8f66f4347fe23372b6","version":"18.7"}],"release":"18.7","runtime_remeasured":false,"source_revision":"pgdoc:b9f0e7232f60f380d642ac9b99226606c254b552"},"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","sources":[{"evidence":[{"build_id":107,"kind":"same-version-manual","locale":"zh-Hans","page":"monitoring-stats.html","sha256":"0274aac7991450316bcf7be44635653b6d896fb00e321242c1b6674cb05c2e53","source_revision":"unknown:rendered-translation-baseline","translation_revision":"git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:08e987a66af27b98444a8057c256314eafa13611a3fb9e888214fc436824244b","version":"18"}],"kind":"catalog-bilingual-repair","prior_source_revision":"english-manuals:ffaed59895c47852c39b0b818ec746bdc386a3c9fa4133dc999b3d933783d5c3","version":"18"}],"zh_from":"same-version-manual"},"ManualEvidence":{"doc":{"anchor":"PG-STAT-CHECKPOINTER-VIEW","file":"monitoring-stats.html","lang":"en","sha256":"a97e4aa05484b41cec1f4c9b0b9c5a083596a056982e5d5ba0db1dd8d49961fb","slug":"18"},"sources":[{"evidence":[{"build_id":107,"kind":"same-version-manual","locale":"zh-Hans","page":"monitoring-stats.html","sha256":"0274aac7991450316bcf7be44635653b6d896fb00e321242c1b6674cb05c2e53","source_revision":"unknown:rendered-translation-baseline","translation_revision":"git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:08e987a66af27b98444a8057c256314eafa13611a3fb9e888214fc436824244b","version":"18"}],"kind":"catalog-bilingual-repair","prior_source_revision":"english-manuals:ffaed59895c47852c39b0b818ec746bdc386a3c9fa4133dc999b3d933783d5c3","version":"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":"center","Version":"18","Locale":"en","Title":"pg_stat_checkpointer","Summary":"The pg_stat_checkpointer view will always have a single row, containing data about the checkpointer process of the cluster.","BodyHTML":"\u003cp\u003eThe pg_stat_checkpointer view will always have a single row, containing data about the checkpointer process of the cluster.\u003c/p\u003e","SourceRevision":"catalog-bilingual-repair:035aa0d98ac27fa738c63871a1dbc4f45c08ec87d531be74a5145d107d8346ff","ContentHash":"6418a2ff31eac642401b09b9df37a97c317ffb2b2410d34d2e14d8ef6f2d04c4","Payload":{"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,"zh_from":"same-version-manual"},{"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,"zh_from":"same-version-manual"},{"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,"zh_from":"same-version-manual"},{"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,"zh_from":"same-version-manual"},{"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,"zh_from":"same-version-manual"},{"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,"zh_from":"same-version-manual"},{"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,"zh_from":"same-version-manual"},{"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,"zh_from":"same-version-manual"},{"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,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":10,"description":"Number of SLRU buffers written during checkpoints and restartpoints","description_zh":"在检查点和重启点期间写入的 SLRU 缓冲区数量","documented":true,"documented_name":"slru_written","hidden":false,"name":"slru_written","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20,"zh_from":"same-version-manual"},{"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,"zh_from":"same-version-manual"}],"description":"The pg_stat_checkpointer view will always have a single row, containing data about the checkpointer process of the cluster."}},"RequestedLocale":"en","Fallback":false,"Versions":["17","18","19","20"],"Locales":["en","zh-Hans"],"Signatures":null,"Spellings":null,"SQLState":null,"Evidence":null}