{"Entry":{"collection":"catalog","key":"pg_stat_progress_data_checksums","name":"pg_stat_progress_data_checksums","aliases":[],"metadata":{"changed_in":[],"changes":[{"added":[],"attributes":[],"description_changed":false,"descriptions":[],"from":"19","order":false,"removed":[],"status":"added","to":"20","types":[]}],"column_count":10,"content_hash":"ca01a89ac8141fba721c249bcc4ef89068ad2a83c5147a8284549490eb935273","first_version":"20","imported_at":"2026-09-30T00:40:55.949443+08:00","kind":"progress","last_version":"20","name":"pg_stat_progress_data_checksums","position":99,"present_in":["20"],"relation_oid":null,"relkind":"v","shared":false,"source_rev":"english-manuals:cfbcc821431e14189f8c15e8100a9bc7acd85f24d568a0b5c0c8357bc4eeadc0","summary":"When data checksums are being enabled or disabled on a running cluster, the pg_stat_progress_data_checksums view will contain a row for the launcher process.","summary_zh":""}},"Definition":{"Collection":"catalog","Key":"pg_stat_progress_data_checksums","SourceDatabase":"center","Version":"20","SourceTable":"catalog","SourceKey":"pg_stat_progress_data_checksums","SourceRevision":"english-manuals:cfbcc821431e14189f8c15e8100a9bc7acd85f24d568a0b5c0c8357bc4eeadc0","Facts":{"columns":[{"description":"Process ID of the data checksum process, launcher or worker.","description_zh":"","documented":true,"documented_name":"pid","hidden":false,"name":"pid","references":"","type":"integer"},{"description":"OID of this database, or 0 for the launcher process.","description_zh":"","documented":true,"documented_name":"datid","hidden":false,"name":"datid","references":"","type":"oid"},{"description":"Name of this database, or NULL for the launcher process.","description_zh":"","documented":true,"documented_name":"datname","hidden":false,"name":"datname","references":"","type":"name"},{"description":"Current processing phase, see Table 27.56 for description of the phases.","description_zh":"","documented":true,"documented_name":"phase","hidden":false,"name":"phase","references":"","type":"text"},{"description":"The total number of databases which will be processed. Only the launcher process has this value set when enabling data checksums; otherwise this is set to NULL.","description_zh":"","documented":true,"documented_name":"databases_total","hidden":false,"name":"databases_total","references":"","type":"bigint"},{"description":"The number of databases which have been processed. Only the launcher process has this value set when enabling data checksums; otherwise this is set to NULL.","description_zh":"","documented":true,"documented_name":"databases_done","hidden":false,"name":"databases_done","references":"","type":"bigint"},{"description":"The total number of relations which will be processed, or NULL if the worker process hasn't calculated the number of relations yet. The launcher process has this set to NULL since it isn't responsible for processing relations, only launching worker processes.","description_zh":"","documented":true,"documented_name":"relations_total","hidden":false,"name":"relations_total","references":"","type":"bigint"},{"description":"The number of relations which have been processed. The launcher process has this set to NULL.","description_zh":"","documented":true,"documented_name":"relations_done","hidden":false,"name":"relations_done","references":"","type":"bigint"},{"description":"The number of blocks in the current relation fork which will be processed, or NULL if the worker process hasn't calculated the number of blocks yet. The launcher process has this set to NULL.","description_zh":"","documented":true,"documented_name":"blocks_total","hidden":false,"name":"blocks_total","references":"","type":"bigint"},{"description":"The number of blocks in the current relation fork which have been processed. The launcher process has this set to NULL.","description_zh":"","documented":true,"documented_name":"blocks_done","hidden":false,"name":"blocks_done","references":"","type":"bigint"}],"description":"When data checksums are being enabled or disabled on a running cluster, the pg_stat_progress_data_checksums view will contain a row for the launcher process. When enabling data checksums, the view will also contain one row for each worker process which is currently calculating and writing checksums for the data pages in a database. The launcher provides an overview of the overall progress, such as how many databases have been processed and how many remain, while the workers track progress for currently processed databases.","description_zh":"","doc":{"anchor":"PG-STAT-PROGRESS-DATA-CHECKSUMS-VIEW","file":"progress-reporting.html","lang":"en","sha256":"a692c859d24d77ff71231c72596243a279325b5436ece3dad58945b55688646e","slug":"devel"},"kind":"progress","lang":"en","measured_attributes":false,"metadata_release":"","runtime_verified":false,"source":"english-manual"},"ManualEvidence":{"doc":{"anchor":"PG-STAT-PROGRESS-DATA-CHECKSUMS-VIEW","file":"progress-reporting.html","lang":"en","sha256":"a692c859d24d77ff71231c72596243a279325b5436ece3dad58945b55688646e","slug":"devel"}},"MeasuredEvidence":{"measured_attributes":false,"metadata_release":"","runtime_verified":false}},"Text":{"Collection":"catalog","Key":"pg_stat_progress_data_checksums","SourceDatabase":"pgweb","Version":"20","Locale":"zh-Hans","Title":"pg_stat_progress_data_checksums","Summary":"当在运行中的集簇上启用或禁用数据校验和时，pg_stat_progress_data_checksums视图将包含数据校验和启动器进程的一行。启用数据校验和时，该视图还会为每个当前正在为某个数据库中的数据页计算并写入校验和的工作进程提供一行。启动器提供整体进度概览，例如已处理多少个数据库、还剩多少个，而工作进程跟踪当前正在处理的数据库的进度。","BodyHTML":"\u003cp\u003e当在运行中的集簇上启用或禁用数据校验和时，pg_stat_progress_data_checksums视图将包含数据校验和启动器进程的一行。启用数据校验和时，该视图还会为每个当前正在为某个数据库中的数据页计算并写入校验和的工作进程提供一行。启动器提供整体进度概览，例如已处理多少个数据库、还剩多少个，而工作进程跟踪当前正在处理的数据库的进度。\u003c/p\u003e","SourceRevision":"2026-09-27@419045e","ContentHash":"6a681a7f2e5caa53eea8171a3ef76ded3dd1f05c6db0213913d22de38d186fb5","Payload":{"columns":[{"description_zh":"数据校验和进程（启动器进程或工作进程）的进程 ID。","name":"pid","type":"integer","zh_from":"doc"},{"description_zh":"这个数据库的 OID，或者对于启动器进程为 0。","name":"datid","type":"oid","zh_from":"doc"},{"description_zh":"这个数据库的名称，或者对于启动器进程为 NULL。","name":"datname","type":"name","zh_from":"doc"},{"description_zh":"当前处理阶段，参见表 27.56了解各阶段的说明。","name":"phase","type":"text","zh_from":"doc"},{"description_zh":"将要处理的数据库总数。启用数据校验和时，只有启动器进程的这个值会被设置；否则该值为 NULL。","name":"databases_total","type":"bigint","zh_from":"doc"},{"description_zh":"已处理的数据库数量。启用数据校验和时，只有启动器进程的这个值会被设置；否则该值为 NULL。","name":"databases_done","type":"bigint","zh_from":"doc"},{"description_zh":"将要处理的关系总数，或者如果工作进程还没有计算出关系数量，则为 NULL。启动器进程将该值设为 NULL，因为它不负责处理关系，只负责启动工作进程。","name":"relations_total","type":"bigint","zh_from":"doc"},{"description_zh":"已处理的关系数量。启动器进程将该值设为 NULL。","name":"relations_done","type":"bigint","zh_from":"doc"},{"description_zh":"当前关系分支中将要处理的块数，或者如果工作进程还没有计算出块数，则为 NULL。启动器进程将该值设为 NULL。","name":"blocks_total","type":"bigint","zh_from":"doc"},{"description_zh":"当前关系分支中已经处理的块数。启动器进程将该值设为 NULL。","name":"blocks_done","type":"bigint","zh_from":"doc"}],"description_zh":"当在运行中的集簇上启用或禁用数据校验和时，pg_stat_progress_data_checksums视图将包含数据校验和启动器进程的一行。启用数据校验和时，该视图还会为每个当前正在为某个数据库中的数据页计算并写入校验和的工作进程提供一行。启动器提供整体进度概览，例如已处理多少个数据库、还剩多少个，而工作进程跟踪当前正在处理的数据库的进度。","zh_from":"doc"}},"RequestedLocale":"zh-Hans","Fallback":false,"Versions":["20"],"Locales":["en","zh-Hans"],"Signatures":null,"Spellings":null,"SQLState":null,"Evidence":null}