{"kind": "metric", "major": "18", "item": {"slug": "pg_stat_progress_data_checksums-blocks_done", "name": "pg_stat_progress_data_checksums.blocks_done", "name_zh": "", "category": "pg_stat_progress_data_checksums", "summary": "Not recorded in the selected version.", "aliases": ["blocks_done", "pg_stat_progress_data_checksums"], "content_hash": "e85b6f6e6b477064d909bd1273a4a6b057d00efd23a0df6ea0e81e8833e5b41a", "versions": {"20": {"view": "pg_stat_progress_data_checksums", "facts": [{"label": "View", "value": "pg_stat_progress_data_checksums"}, {"label": "Field", "value": "blocks_done"}, {"label": "SQL type", "value": "bigint"}, {"label": "Units named in the field definition", "value": "blocks"}, {"label": "Reset observation", "value": "No stats_reset field is documented for this view"}], "field": "blocks_done", "tables": [], "related": [{"url": "/wiki/catalog/pg_stat_progress_data_checksums/?v=20", "label": "pg_stat_progress_data_checksums columns"}, {"url": "/docs/devel/monitoring-stats.html", "label": "Statistics collection and reset functions"}], "release": {"ref": "https://ftp.postgresql.org/pub/snapshot/dev/postgresql-snapshot.tar.bz2", "label": "20devel", "major": "20", "channel": "devel", "revision": "4d3346909b201ac1648232cf290462a7070c119326f56196f1f0253ed80fae41"}, "sources": [{"url": "/docs/devel/progress-reporting.html#PG-STAT-PROGRESS-DATA-CHECKSUMS-VIEW", "path": "progress-reporting.html", "label": "PostgreSQL 20 English manual", "sha256": "a692c859d24d77ff71231c72596243a279325b5436ece3dad58945b55688646e"}], "sections": [{"title": "View semantics", "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": "Collection and reset context", "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."]}, {"code": "SELECT blocks_done FROM pg_catalog.pg_stat_progress_data_checksums;", "title": "Inspect this field", "paragraphs": ["Example query; no execution result or measured value is asserted."]}], "sql_type": "bigint", "signature": "SELECT blocks_done FROM pg_catalog.pg_stat_progress_data_checksums;", "documented": true, "description": ["The number of blocks in the current relation fork which have been processed. The launcher process has this set to NULL."], "manual_html": "", "manual_path": "/docs/devel/progress-reporting.html", "source_only": false, "comparison_data": {"view": "pg_stat_progress_data_checksums", "field": "blocks_done", "sql_type": "bigint", "units_mentioned": ["blocks"]}, "comparison_hash": "5e8365b1106ce784821c36caa06763562eb3063044b6d466e75dfd3fb8395a8d", "units_mentioned": ["blocks"]}}}, "snapshot": null, "comparison": {"left": "19", "right": "20", "status": "added", "diff": "--- PostgreSQL 19\n+++ PostgreSQL 20\n@@ -1 +1,8 @@\n-Not recorded in this version\n+{\n+  \"field\": \"blocks_done\",\n+  \"sql_type\": \"bigint\",\n+  \"units_mentioned\": [\n+    \"blocks\"\n+  ],\n+  \"view\": \"pg_stat_progress_data_checksums\"\n+}"}}