{"kind": "metric", "major": "18", "item": {"slug": "pg_stat_progress_data_checksums-phase", "name": "pg_stat_progress_data_checksums.phase", "name_zh": "", "category": "pg_stat_progress_data_checksums", "summary": "Not recorded in the selected version.", "aliases": ["phase", "pg_stat_progress_data_checksums"], "content_hash": "0f7ce14eef656c4e1c870f9f289017882e5334d83330aa621472b4c749fd9656", "versions": {"20": {"view": "pg_stat_progress_data_checksums", "facts": [{"label": "View", "value": "pg_stat_progress_data_checksums"}, {"label": "Field", "value": "phase"}, {"label": "SQL type", "value": "text"}, {"label": "Units named in the field definition", "value": "Not specified"}, {"label": "Reset observation", "value": "No stats_reset field is documented for this view"}], "field": "phase", "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 phase 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": "text", "signature": "SELECT phase FROM pg_catalog.pg_stat_progress_data_checksums;", "documented": true, "description": ["Current processing phase, see Table 27.56 for description of the phases."], "manual_html": "", "manual_path": "/docs/devel/progress-reporting.html", "source_only": false, "comparison_data": {"view": "pg_stat_progress_data_checksums", "field": "phase", "sql_type": "text", "units_mentioned": []}, "comparison_hash": "194ec8a0124739df3d46183075561a9f74afc45a3e9fa481a2953bcd82da2a0d", "units_mentioned": []}}}, "snapshot": null, "comparison": {"left": "19", "right": "20", "status": "added", "diff": "--- PostgreSQL 19\n+++ PostgreSQL 20\n@@ -1 +1,6 @@\n-Not recorded in this version\n+{\n+  \"field\": \"phase\",\n+  \"sql_type\": \"text\",\n+  \"units_mentioned\": [],\n+  \"view\": \"pg_stat_progress_data_checksums\"\n+}"}}