{"Entry":{"collection":"metric","key":"pg_stat_progress_data_checksums-pid","name":"pg_stat_progress_data_checksums.pid","aliases":["pid","pg_stat_progress_data_checksums"],"metadata":{"aliases":["pid","pg_stat_progress_data_checksums"],"category":"pg_stat_progress_data_checksums","content_hash":"9d902c6cd6db29f3706ec23e8b5b7ea38c9c5f90c4eccd5568c31df6f0a719be","imported_at":"2026-09-30T00:40:45.924653+08:00","name":"pg_stat_progress_data_checksums.pid","name_zh":"","slug":"pg_stat_progress_data_checksums-pid","summary":"Process ID of the data checksum process, launcher or worker."}},"Definition":{"Collection":"metric","Key":"pg_stat_progress_data_checksums-pid","SourceDatabase":"center","Version":"20","SourceTable":"statistics_metric","SourceKey":"pg_stat_progress_data_checksums-pid","SourceRevision":"4d3346909b201ac1648232cf290462a7070c119326f56196f1f0253ed80fae41","Facts":{"comparison_data":{"field":"pid","sql_type":"integer","units_mentioned":[],"view":"pg_stat_progress_data_checksums"},"comparison_hash":"fd31eee571134e8e820781fdbb66f0c461ebf60e0011e33d6975b8c76fb0c82d","description":["Process ID of the data checksum process, launcher or worker."],"documented":true,"facts":[{"label":"View","value":"pg_stat_progress_data_checksums"},{"label":"Field","value":"pid"},{"label":"SQL type","value":"integer"},{"label":"Units named in the field definition","value":"Not specified"},{"label":"Reset observation","value":"No stats_reset field is documented for this view"}],"field":"pid","manual_html":"","manual_path":"/docs/devel/progress-reporting.html","related":[{"label":"pg_stat_progress_data_checksums columns","url":"/wiki/catalog/pg_stat_progress_data_checksums/?v=20"},{"label":"Statistics collection and reset functions","url":"/docs/devel/monitoring-stats.html"}],"release":{"channel":"devel","label":"20devel","major":"20","ref":"https://ftp.postgresql.org/pub/snapshot/dev/postgresql-snapshot.tar.bz2","revision":"4d3346909b201ac1648232cf290462a7070c119326f56196f1f0253ed80fae41"},"sections":[{"paragraphs":["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."],"title":"View semantics"},{"paragraphs":["Read the same-version statistics collection and view documentation below for reset scope and visibility. No per-field reset rule is inferred from the field name."],"title":"Collection and reset context"},{"code":"SELECT pid FROM pg_catalog.pg_stat_progress_data_checksums;","paragraphs":["Example query; no execution result or measured value is asserted."],"title":"Inspect this field"}],"signature":"SELECT pid FROM pg_catalog.pg_stat_progress_data_checksums;","source_only":false,"sources":[{"label":"PostgreSQL 20 English manual","path":"progress-reporting.html","sha256":"a692c859d24d77ff71231c72596243a279325b5436ece3dad58945b55688646e","url":"/docs/devel/progress-reporting.html#PG-STAT-PROGRESS-DATA-CHECKSUMS-VIEW"}],"sql_type":"integer","tables":[],"units_mentioned":[],"view":"pg_stat_progress_data_checksums"},"ManualEvidence":{"manual_path":"/docs/devel/progress-reporting.html","release":{"channel":"devel","label":"20devel","major":"20","ref":"https://ftp.postgresql.org/pub/snapshot/dev/postgresql-snapshot.tar.bz2","revision":"4d3346909b201ac1648232cf290462a7070c119326f56196f1f0253ed80fae41"},"sources":[{"label":"PostgreSQL 20 English manual","path":"progress-reporting.html","sha256":"a692c859d24d77ff71231c72596243a279325b5436ece3dad58945b55688646e","url":"/docs/devel/progress-reporting.html#PG-STAT-PROGRESS-DATA-CHECKSUMS-VIEW"}]},"MeasuredEvidence":{}},"Text":{"Collection":"metric","Key":"pg_stat_progress_data_checksums-pid","SourceDatabase":"center","Version":"20","Locale":"en","Title":"pg_stat_progress_data_checksums.pid","Summary":"Process ID of the data checksum process, launcher or worker.","BodyHTML":"\u003cp\u003eProcess ID of the data checksum process, launcher or worker.\u003c/p\u003e","SourceRevision":"4d3346909b201ac1648232cf290462a7070c119326f56196f1f0253ed80fae41","ContentHash":"789d2c2e58e2f5b3edf9d37a42ec33d2d0d5d47ad9118078990a3891b674aae6","Payload":{"description":["Process ID of the data checksum process, launcher or worker."],"manual_html":"","related":[{"label":"pg_stat_progress_data_checksums columns","url":"/wiki/catalog/pg_stat_progress_data_checksums/?v=20"},{"label":"Statistics collection and reset functions","url":"/docs/devel/monitoring-stats.html"}],"sections":[{"paragraphs":["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."],"title":"View semantics"},{"paragraphs":["Read the same-version statistics collection and view documentation below for reset scope and visibility. No per-field reset rule is inferred from the field name."],"title":"Collection and reset context"},{"code":"SELECT pid FROM pg_catalog.pg_stat_progress_data_checksums;","paragraphs":["Example query; no execution result or measured value is asserted."],"title":"Inspect this field"}],"tables":[]}},"RequestedLocale":"zh-Hans","Fallback":true,"Versions":["20"],"Locales":["en"],"Signatures":null,"Spellings":null,"SQLState":null,"Evidence":null}