pg_stat_progress_create_index.blocks_done \u7edf\u8ba1\u5b57\u6bb5\u3002
pg_stat_progress_create_indexblocks_donebigint\u5f53\u524d\u9636\u6bb5\u5df2\u7ecf\u5904\u7406\u7684\u5757\u6570\u91cf\u3002
\u67e5\u770b\u5b8c\u6574\u4e2d\u6587\u624b\u518c\u4e0e\u4e0a\u4e0b\u6587\u3002
"}, "summary": "\u5f53\u524d\u9636\u6bb5\u5df2\u7ecf\u5904\u7406\u7684\u5757\u6570\u91cf\u3002", "version": "12", "link_map": {"/zh/docs/12/progress-reporting.html": "/docs/12/progress-reporting.html"}, "body_html": "pg_stat_progress_create_index.blocks_done \u7edf\u8ba1\u5b57\u6bb5\u3002
pg_stat_progress_create_indexblocks_donebigint\u5f53\u524d\u9636\u6bb5\u5df2\u7ecf\u5904\u7406\u7684\u5757\u6570\u91cf\u3002
\u67e5\u770b\u5b8c\u6574\u4e2d\u6587\u624b\u518c\u4e0e\u4e0a\u4e0b\u6587\u3002
", "body_sha256": "9cf05ff8c60faa06a4c62fab5410b0c5e6a9bf329afbe29b12b341b4546f4731", "content_hash": "2b2e7469355f3c4669006101598cc8a0b567cfe5ad72183ad0a7ab10365ec372", "source_database": "center", "source_revision": "8df3c0474782589d3c6f374b5133b1bd14d168086edbc13c6e72e67dd4527a3b"}, "signature": "SELECT blocks_done FROM pg_catalog.pg_stat_progress_create_index;", "tables_zh": [], "documented": true, "description": ["\u5f53\u524d\u9636\u6bb5\u5df2\u7ecf\u5904\u7406\u7684\u5757\u6570\u91cf\u3002"], "manual_html": "", "manual_path": "/docs/12/progress-reporting.html", "sections_zh": [{"title": "\u89c6\u56fe\u8bed\u4e49", "paragraphs": ["\u6bcf\u5f53\u8fd0\u884c CREATE INDEX \u6216 REINDEX \u65f6\uff0c pg_stat_progress_create_index \u89c6\u56fe\u5c06\u5305\u542b\u5f53\u524d\u6b63\u5728\u521b\u5efa\u7d22\u5f15\u7684\u6bcf\u4e2a\u540e\u7aef\u7684\u4e00\u884c\u3002\u4e0b\u9762\u7684\u8868\u63cf\u8ff0\u4e86\u5c06\u8981\u62a5\u544a\u7684\u4fe1\u606f\uff0c\u5e76\u63d0\u4f9b\u4e86\u5173\u4e8e\u5982\u4f55\u89e3\u91ca\u5b83\u7684\u4fe1\u606f\u3002"]}, {"title": "\u91c7\u96c6\u4e0e\u91cd\u7f6e\u8bed\u4e49", "paragraphs": ["\u91cd\u7f6e\u8303\u56f4\u548c\u53ef\u89c1\u6027\u8bf7\u53c2\u9605\u4e0b\u65b9\u540c\u7248\u672c\u7684\u7edf\u8ba1\u4fe1\u606f\u6536\u96c6\u4e0e\u89c6\u56fe\u6587\u6863\u3002\u4e0d\u6839\u636e\u5b57\u6bb5\u540d\u79f0\u63a8\u65ad\u5404\u5b57\u6bb5\u7684\u91cd\u7f6e\u89c4\u5219\u3002"]}, {"code": "SELECT blocks_done FROM pg_catalog.pg_stat_progress_create_index;", "title": "\u67e5\u770b\u6b64\u5b57\u6bb5", "paragraphs": ["\u793a\u4f8b\u67e5\u8be2\uff1b\u4e0d\u8868\u793a\u5df2\u6267\u884c\uff0c\u4e5f\u4e0d\u63d0\u4f9b\u5b9e\u6d4b\u503c\u3002"]}], "source_only": false, "localization": {"status": "complete", "sources": [{"url": "/docs/12/progress-reporting.html", "method": "same-major semantic node", "sha256": "be145dfbf52ac8d0cc62a1c46bc20be743dbf691f25f37c176712ada4a50d99a", "language": "zh", "matched_nodes": ["#PROGRESS-REPORTING/div[3]/div[2]/div[1]/table[0]/tbody[2]/tr[11]/td[2]", "#PROGRESS-REPORTING/div[3]/p[1]"]}], "language": "zh", "original_text": {"/versions/12/description/0": "Number of blocks already processed in the current phase.", "/versions/12/facts/0/label": "View", "/versions/12/facts/1/label": "Field", "/versions/12/facts/2/label": "SQL type", "/versions/12/facts/3/label": "Units named in the field definition", "/versions/12/facts/4/label": "Reset observation", "/versions/12/facts/4/value": "No stats_reset field is documented for this view", "/versions/12/related/0/label": "pg_stat_progress_create_index columns", "/versions/12/related/1/label": "Statistics collection and reset functions", "/versions/12/sections/0/title": "View semantics", "/versions/12/sections/1/title": "Collection and reset context", "/versions/12/sections/2/title": "Inspect this field", "/versions/12/sections/0/paragraphs/0": "Whenever CREATE INDEX or REINDEX is running, the pg_stat_progress_create_index view will contain one row for each backend that is currently creating indexes. The tables below describe the information that will be reported and provide information about how to interpret it.", "/versions/12/sections/1/paragraphs/0": "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.", "/versions/12/sections/2/paragraphs/0": "Example query; no execution result or measured value is asserted."}, "fallback_fields": [], "source_language": "en", "original_snapshot_sha256": "6906771dfe6395067f149105469796ff63acfd960a6f5f2520e600b928bad0e6", "canonical_center_text_hash": "2b2e7469355f3c4669006101598cc8a0b567cfe5ad72183ad0a7ab10365ec372"}, "description_zh": "\u5f53\u524d\u9636\u6bb5\u5df2\u7ecf\u5904\u7406\u7684\u5757\u6570\u91cf\u3002", "comparison_data": {"view": "pg_stat_progress_create_index", "field": "blocks_done", "sql_type": "bigint", "units_mentioned": ["blocks"]}, "comparison_hash": "d2aa38d3839903b88fd0f5ab16015167de8f74a86068ea91d874c18a9ee2ac5a", "manual_language": "zh", "units_mentioned": ["blocks"], "description_zh_html": "pg_stat_progress_create_index.blocks_done \u7edf\u8ba1\u5b57\u6bb5\u3002
pg_stat_progress_create_indexblocks_donebigint\u5f53\u524d\u9636\u6bb5\u5df2\u7ecf\u5904\u7406\u7684\u5757\u6570\u91cf\u3002
\u67e5\u770b\u5b8c\u6574\u4e2d\u6587\u624b\u518c\u4e0e\u4e0a\u4e0b\u6587\u3002
"}, "13": {"view": "pg_stat_progress_create_index", "facts": [{"label": "\u89c6\u56fe", "value": "pg_stat_progress_create_index"}, {"label": "\u5b57\u6bb5", "value": "blocks_done"}, {"label": "SQL \u7c7b\u578b", "value": "bigint"}, {"label": "\u5b57\u6bb5\u5b9a\u4e49\u8bb0\u8f7d\u7684\u5355\u4f4d", "value": "blocks"}, {"label": "\u91cd\u7f6e\u6761\u4ef6", "value": "\u624b\u518c\u672a\u4e3a\u6b64\u89c6\u56fe\u8bb0\u8f7d stats_reset \u5b57\u6bb5"}], "field": "blocks_done", "tables": [], "related": [{"url": "/wiki/catalog/pg_stat_progress_create_index/?v=13", "label": "pg_stat_progress_create_index \u5b57\u6bb5"}, {"url": "/docs/13/monitoring-stats.html", "label": "\u7edf\u8ba1\u6536\u96c6\u4e0e\u91cd\u7f6e\u51fd\u6570"}], "release": {"ref": "https://ftp.postgresql.org/pub/source/v13.23/postgresql-13.23.tar.bz2", "label": "13.23", "major": "13", "channel": "stable", "revision": "6ec3c82726af92b7dec873fa1cdf881eca92a4219787dfad05acb6b10e041fd6"}, "sources": [{"url": "/docs/13/progress-reporting.html#PG-STAT-PROGRESS-CREATE-INDEX-VIEW", "path": "progress-reporting.html", "label": "PostgreSQL 13 English manual", "sha256": "1b5b17cbaf6a5e83cf5460db9d56a8fb88fabbfca57f7b5aa810e6bf9bba83a7"}], "zh_from": {"kind": "same-version-chinese-manual-with-source-derived-structured-summary", "manual": {"url": "/zh/docs/13/progress-reporting.html#", "anchor": "", "column": "blocks_done", "locale": "zh-Hans", "version": "13", "build_id": 66, "page_key": "progress-reporting.html", "extraction": "exact-catalog-field", "source_hash": "32662d865b5be2b1e2ec7c9524173ac4ec628ced2643a33d0a5ca63314d96bbc", "source_revision": "unknown:rendered-translation-baseline", "translation_revision": "snapshot:sha256:a13a825c39f0268ef1cfe9137e283e38d0da73b2d7894f0733c7b26372a4f6a4"}, "body_sha256": "783de01ce977140a954fe85cd328aaa4db47e4a629c7d4c0a4b63d996ec9ddf2", "runtime_rerun": false, "authored_translation": "source-derived-structured-summary", "source_facts_revision": "6ec3c82726af92b7dec873fa1cdf881eca92a4219787dfad05acb6b10e041fd6"}, "facts_zh": [{"label": "\u89c6\u56fe", "value": "pg_stat_progress_create_index"}, {"label": "\u5b57\u6bb5", "value": "blocks_done"}, {"label": "SQL \u7c7b\u578b", "value": "bigint"}, {"label": "\u5b57\u6bb5\u5b9a\u4e49\u8bb0\u8f7d\u7684\u5355\u4f4d", "value": "blocks"}, {"label": "\u91cd\u7f6e\u6761\u4ef6", "value": "\u624b\u518c\u672a\u4e3a\u6b64\u89c6\u56fe\u8bb0\u8f7d stats_reset \u5b57\u6bb5"}], "sections": [{"title": "\u89c6\u56fe\u8bed\u4e49", "paragraphs": ["\u6bcf\u5f53\u8fd0\u884c CREATE INDEX \u6216 REINDEX \u65f6\uff0c pg_stat_progress_create_index \u89c6\u56fe\u5c06\u5305\u542b\u5f53\u524d\u6b63\u5728\u521b\u5efa\u7d22\u5f15\u7684\u6bcf\u4e2a\u540e\u7aef\u7684\u4e00\u884c\u3002\u4e0b\u9762\u7684\u8868\u63cf\u8ff0\u4e86\u5c06\u8981\u62a5\u544a\u7684\u4fe1\u606f\uff0c\u5e76\u63d0\u4f9b\u4e86\u5173\u4e8e\u5982\u4f55\u89e3\u91ca\u5b83\u7684\u4fe1\u606f\u3002"]}, {"title": "\u91c7\u96c6\u4e0e\u91cd\u7f6e\u8bed\u4e49", "paragraphs": ["\u91cd\u7f6e\u8303\u56f4\u548c\u53ef\u89c1\u6027\u8bf7\u53c2\u9605\u4e0b\u65b9\u540c\u7248\u672c\u7684\u7edf\u8ba1\u4fe1\u606f\u6536\u96c6\u4e0e\u89c6\u56fe\u6587\u6863\u3002\u4e0d\u6839\u636e\u5b57\u6bb5\u540d\u79f0\u63a8\u65ad\u5404\u5b57\u6bb5\u7684\u91cd\u7f6e\u89c4\u5219\u3002"]}, {"code": "SELECT blocks_done FROM pg_catalog.pg_stat_progress_create_index;", "title": "\u67e5\u770b\u6b64\u5b57\u6bb5", "paragraphs": ["\u793a\u4f8b\u67e5\u8be2\uff1b\u4e0d\u8868\u793a\u5df2\u6267\u884c\uff0c\u4e5f\u4e0d\u63d0\u4f9b\u5b9e\u6d4b\u503c\u3002"]}], "sql_type": "bigint", "center_zh": {"title": "pg_stat_progress_create_index.blocks_done", "locale": "zh-Hans", "source": {"key": "pg_stat_progress_create_index-blocks_done", "locale": "zh-Hans", "version": "13", "text_hash": "ef6f699409c47c85824c8d2c95834bed9a6533691d67e4f6f0ead03f2793a6f5", "collection": "metric", "dataset_hash": "7c31b524dfe136022d39a6ae8dcfac6b3bbd5f8fdaf422536599981252aff0c9", "source_database": "center", "source_revision": "6ec3c82726af92b7dec873fa1cdf881eca92a4219787dfad05acb6b10e041fd6"}, "payload": {"facts": [{"label": "\u89c6\u56fe", "value": "pg_stat_progress_create_index"}, {"label": "\u5b57\u6bb5", "value": "blocks_done"}, {"label": "SQL \u7c7b\u578b", "value": "bigint"}, {"label": "\u5b57\u6bb5\u5b9a\u4e49\u8bb0\u8f7d\u7684\u5355\u4f4d", "value": "blocks"}, {"label": "\u91cd\u7f6e\u6761\u4ef6", "value": "\u624b\u518c\u672a\u4e3a\u6b64\u89c6\u56fe\u8bb0\u8f7d stats_reset \u5b57\u6bb5"}], "tables": [], "zh_from": {"kind": "same-version-chinese-manual-with-source-derived-structured-summary", "manual": {"url": "/zh/docs/13/progress-reporting.html#", "anchor": "", "column": "blocks_done", "locale": "zh-Hans", "version": "13", "build_id": 66, "page_key": "progress-reporting.html", "extraction": "exact-catalog-field", "source_hash": "32662d865b5be2b1e2ec7c9524173ac4ec628ced2643a33d0a5ca63314d96bbc", "source_revision": "unknown:rendered-translation-baseline", "translation_revision": "snapshot:sha256:a13a825c39f0268ef1cfe9137e283e38d0da73b2d7894f0733c7b26372a4f6a4"}, "body_sha256": "783de01ce977140a954fe85cd328aaa4db47e4a629c7d4c0a4b63d996ec9ddf2", "runtime_rerun": false, "authored_translation": "source-derived-structured-summary", "source_facts_revision": "6ec3c82726af92b7dec873fa1cdf881eca92a4219787dfad05acb6b10e041fd6"}, "sections": [{"title": "\u89c6\u56fe\u8bed\u4e49", "paragraphs": ["\u6bcf\u5f53\u8fd0\u884c CREATE INDEX \u6216 REINDEX \u65f6\uff0c pg_stat_progress_create_index \u89c6\u56fe\u5c06\u5305\u542b\u5f53\u524d\u6b63\u5728\u521b\u5efa\u7d22\u5f15\u7684\u6bcf\u4e2a\u540e\u7aef\u7684\u4e00\u884c\u3002\u4e0b\u9762\u7684\u8868\u63cf\u8ff0\u4e86\u5c06\u8981\u62a5\u544a\u7684\u4fe1\u606f\uff0c\u5e76\u63d0\u4f9b\u4e86\u5173\u4e8e\u5982\u4f55\u89e3\u91ca\u5b83\u7684\u4fe1\u606f\u3002"]}, {"title": "\u91c7\u96c6\u4e0e\u91cd\u7f6e\u8bed\u4e49", "paragraphs": ["\u91cd\u7f6e\u8303\u56f4\u548c\u53ef\u89c1\u6027\u8bf7\u53c2\u9605\u4e0b\u65b9\u540c\u7248\u672c\u7684\u7edf\u8ba1\u4fe1\u606f\u6536\u96c6\u4e0e\u89c6\u56fe\u6587\u6863\u3002\u4e0d\u6839\u636e\u5b57\u6bb5\u540d\u79f0\u63a8\u65ad\u5404\u5b57\u6bb5\u7684\u91cd\u7f6e\u89c4\u5219\u3002"]}, {"code": "SELECT blocks_done FROM pg_catalog.pg_stat_progress_create_index;", "title": "\u67e5\u770b\u6b64\u5b57\u6bb5", "paragraphs": ["\u793a\u4f8b\u67e5\u8be2\uff1b\u4e0d\u8868\u793a\u5df2\u6267\u884c\uff0c\u4e5f\u4e0d\u63d0\u4f9b\u5b9e\u6d4b\u503c\u3002"]}], "description_zh": "\u5f53\u524d\u9636\u6bb5\u5df2\u7ecf\u5904\u7406\u7684\u5757\u6570\u91cf\u3002", "description_zh_html": "pg_stat_progress_create_index.blocks_done \u7edf\u8ba1\u5b57\u6bb5\u3002
pg_stat_progress_create_indexblocks_donebigint\u5f53\u524d\u9636\u6bb5\u5df2\u7ecf\u5904\u7406\u7684\u5757\u6570\u91cf\u3002
\u67e5\u770b\u5b8c\u6574\u4e2d\u6587\u624b\u518c\u4e0e\u4e0a\u4e0b\u6587\u3002
"}, "summary": "\u5f53\u524d\u9636\u6bb5\u5df2\u7ecf\u5904\u7406\u7684\u5757\u6570\u91cf\u3002", "version": "13", "link_map": {"/zh/docs/13/progress-reporting.html": "/docs/13/progress-reporting.html"}, "body_html": "pg_stat_progress_create_index.blocks_done \u7edf\u8ba1\u5b57\u6bb5\u3002
pg_stat_progress_create_indexblocks_donebigint\u5f53\u524d\u9636\u6bb5\u5df2\u7ecf\u5904\u7406\u7684\u5757\u6570\u91cf\u3002
\u67e5\u770b\u5b8c\u6574\u4e2d\u6587\u624b\u518c\u4e0e\u4e0a\u4e0b\u6587\u3002
", "body_sha256": "c41846e246f0513009c52a56f9f689f7ed225f1280015e66f5fcdde747eb8489", "content_hash": "ef6f699409c47c85824c8d2c95834bed9a6533691d67e4f6f0ead03f2793a6f5", "source_database": "center", "source_revision": "6ec3c82726af92b7dec873fa1cdf881eca92a4219787dfad05acb6b10e041fd6"}, "signature": "SELECT blocks_done FROM pg_catalog.pg_stat_progress_create_index;", "tables_zh": [], "documented": true, "description": ["\u5f53\u524d\u9636\u6bb5\u5df2\u7ecf\u5904\u7406\u7684\u5757\u6570\u91cf\u3002"], "manual_html": "", "manual_path": "/docs/13/progress-reporting.html", "sections_zh": [{"title": "\u89c6\u56fe\u8bed\u4e49", "paragraphs": ["\u6bcf\u5f53\u8fd0\u884c CREATE INDEX \u6216 REINDEX \u65f6\uff0c pg_stat_progress_create_index \u89c6\u56fe\u5c06\u5305\u542b\u5f53\u524d\u6b63\u5728\u521b\u5efa\u7d22\u5f15\u7684\u6bcf\u4e2a\u540e\u7aef\u7684\u4e00\u884c\u3002\u4e0b\u9762\u7684\u8868\u63cf\u8ff0\u4e86\u5c06\u8981\u62a5\u544a\u7684\u4fe1\u606f\uff0c\u5e76\u63d0\u4f9b\u4e86\u5173\u4e8e\u5982\u4f55\u89e3\u91ca\u5b83\u7684\u4fe1\u606f\u3002"]}, {"title": "\u91c7\u96c6\u4e0e\u91cd\u7f6e\u8bed\u4e49", "paragraphs": ["\u91cd\u7f6e\u8303\u56f4\u548c\u53ef\u89c1\u6027\u8bf7\u53c2\u9605\u4e0b\u65b9\u540c\u7248\u672c\u7684\u7edf\u8ba1\u4fe1\u606f\u6536\u96c6\u4e0e\u89c6\u56fe\u6587\u6863\u3002\u4e0d\u6839\u636e\u5b57\u6bb5\u540d\u79f0\u63a8\u65ad\u5404\u5b57\u6bb5\u7684\u91cd\u7f6e\u89c4\u5219\u3002"]}, {"code": "SELECT blocks_done FROM pg_catalog.pg_stat_progress_create_index;", "title": "\u67e5\u770b\u6b64\u5b57\u6bb5", "paragraphs": ["\u793a\u4f8b\u67e5\u8be2\uff1b\u4e0d\u8868\u793a\u5df2\u6267\u884c\uff0c\u4e5f\u4e0d\u63d0\u4f9b\u5b9e\u6d4b\u503c\u3002"]}], "source_only": false, "localization": {"status": "complete", "sources": [{"url": "/docs/13/progress-reporting.html", "method": "same-major semantic node", "sha256": "180d5585ebe301914d468bde967ccebbb2332945e28618e9647ac43166d8995d", "language": "zh", "matched_nodes": ["#PROGRESS-REPORTING/div[4]/div[2]/div[1]/table[0]/tbody[2]/tr[11]/td[0]/p[1]", "#PROGRESS-REPORTING/div[4]/p[1]"]}], "language": "zh", "original_text": {"/versions/13/description/0": "Number of blocks already processed in the current phase.", "/versions/13/facts/0/label": "View", "/versions/13/facts/1/label": "Field", "/versions/13/facts/2/label": "SQL type", "/versions/13/facts/3/label": "Units named in the field definition", "/versions/13/facts/4/label": "Reset observation", "/versions/13/facts/4/value": "No stats_reset field is documented for this view", "/versions/13/related/0/label": "pg_stat_progress_create_index columns", "/versions/13/related/1/label": "Statistics collection and reset functions", "/versions/13/sections/0/title": "View semantics", "/versions/13/sections/1/title": "Collection and reset context", "/versions/13/sections/2/title": "Inspect this field", "/versions/13/sections/0/paragraphs/0": "Whenever CREATE INDEX or REINDEX is running, the pg_stat_progress_create_index view will contain one row for each backend that is currently creating indexes. The tables below describe the information that will be reported and provide information about how to interpret it.", "/versions/13/sections/1/paragraphs/0": "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.", "/versions/13/sections/2/paragraphs/0": "Example query; no execution result or measured value is asserted."}, "fallback_fields": [], "source_language": "en", "original_snapshot_sha256": "618ead7bc42bc67be850bcd5952895a48b42ef0378a764ae62f262c2593e17e3", "canonical_center_text_hash": "ef6f699409c47c85824c8d2c95834bed9a6533691d67e4f6f0ead03f2793a6f5"}, "description_zh": "\u5f53\u524d\u9636\u6bb5\u5df2\u7ecf\u5904\u7406\u7684\u5757\u6570\u91cf\u3002", "comparison_data": {"view": "pg_stat_progress_create_index", "field": "blocks_done", "sql_type": "bigint", "units_mentioned": ["blocks"]}, "comparison_hash": "d2aa38d3839903b88fd0f5ab16015167de8f74a86068ea91d874c18a9ee2ac5a", "manual_language": "zh", "units_mentioned": ["blocks"], "description_zh_html": "pg_stat_progress_create_index.blocks_done \u7edf\u8ba1\u5b57\u6bb5\u3002
pg_stat_progress_create_indexblocks_donebigint\u5f53\u524d\u9636\u6bb5\u5df2\u7ecf\u5904\u7406\u7684\u5757\u6570\u91cf\u3002
\u67e5\u770b\u5b8c\u6574\u4e2d\u6587\u624b\u518c\u4e0e\u4e0a\u4e0b\u6587\u3002
"}, "14": {"view": "pg_stat_progress_create_index", "facts": [{"label": "\u89c6\u56fe", "value": "pg_stat_progress_create_index"}, {"label": "\u5b57\u6bb5", "value": "blocks_done"}, {"label": "SQL \u7c7b\u578b", "value": "bigint"}, {"label": "\u5b57\u6bb5\u5b9a\u4e49\u8bb0\u8f7d\u7684\u5355\u4f4d", "value": "blocks"}, {"label": "\u91cd\u7f6e\u6761\u4ef6", "value": "\u624b\u518c\u672a\u4e3a\u6b64\u89c6\u56fe\u8bb0\u8f7d stats_reset \u5b57\u6bb5"}], "field": "blocks_done", "tables": [], "related": [{"url": "/wiki/catalog/pg_stat_progress_create_index/?v=14", "label": "pg_stat_progress_create_index \u5b57\u6bb5"}, {"url": "/docs/14/monitoring-stats.html", "label": "\u7edf\u8ba1\u6536\u96c6\u4e0e\u91cd\u7f6e\u51fd\u6570"}], "release": {"ref": "https://ftp.postgresql.org/pub/source/v14.24/postgresql-14.24.tar.bz2", "label": "14.24", "major": "14", "channel": "stable", "revision": "a7fa7ed3d558172355f51406097a7bd4f6b473be80f311ef7cda96bf383d8897"}, "sources": [{"url": "/docs/14/progress-reporting.html#PG-STAT-PROGRESS-CREATE-INDEX-VIEW", "path": "progress-reporting.html", "label": "PostgreSQL 14 English manual", "sha256": "00410a8905d1f88736ab079620059c9f9e334c1b159b4d9a739042d994f851ce"}], "zh_from": {"kind": "same-version-chinese-manual-with-source-derived-structured-summary", "manual": {"url": "/zh/docs/14/progress-reporting.html#", "anchor": "", "column": "blocks_done", "locale": "zh-Hans", "version": "14", "build_id": 99, "page_key": "progress-reporting.html", "extraction": "exact-catalog-field", "source_hash": "2aa6177a3c8c4c17b481e25014b9d702905e6b079eed9f9ad876be6e72e96c1c", "source_revision": "unknown:rendered-translation-baseline", "translation_revision": "git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:87e6aa4fd6e1ec85c5f4a6de4f5647cfd9e5de734ca2c266d32b6d6192c662ef"}, "body_sha256": "1e7ca7fabfdd0f12e535edc87b53d5c436e3ad0f87fb05500af5c3ca38fd5cc3", "runtime_rerun": false, "authored_translation": "source-derived-structured-summary", "source_facts_revision": "a7fa7ed3d558172355f51406097a7bd4f6b473be80f311ef7cda96bf383d8897"}, "facts_zh": [{"label": "\u89c6\u56fe", "value": "pg_stat_progress_create_index"}, {"label": "\u5b57\u6bb5", "value": "blocks_done"}, {"label": "SQL \u7c7b\u578b", "value": "bigint"}, {"label": "\u5b57\u6bb5\u5b9a\u4e49\u8bb0\u8f7d\u7684\u5355\u4f4d", "value": "blocks"}, {"label": "\u91cd\u7f6e\u6761\u4ef6", "value": "\u624b\u518c\u672a\u4e3a\u6b64\u89c6\u56fe\u8bb0\u8f7d stats_reset \u5b57\u6bb5"}], "sections": [{"title": "\u89c6\u56fe\u8bed\u4e49", "paragraphs": ["\u6bcf\u5f53\u8fd0\u884c CREATE INDEX \u6216 REINDEX \u65f6\uff0c pg_stat_progress_create_index \u89c6\u56fe\u5c06\u5305\u542b\u5f53\u524d\u6b63\u5728\u521b\u5efa\u7d22\u5f15\u7684\u6bcf\u4e2a\u540e\u7aef\u7684\u4e00\u884c\u3002\u4e0b\u9762\u7684\u8868\u63cf\u8ff0\u4e86\u5c06\u8981\u62a5\u544a\u7684\u4fe1\u606f\uff0c\u5e76\u63d0\u4f9b\u4e86\u5173\u4e8e\u5982\u4f55\u89e3\u91ca\u5b83\u7684\u4fe1\u606f\u3002"]}, {"title": "\u91c7\u96c6\u4e0e\u91cd\u7f6e\u8bed\u4e49", "paragraphs": ["\u91cd\u7f6e\u8303\u56f4\u548c\u53ef\u89c1\u6027\u8bf7\u53c2\u9605\u4e0b\u65b9\u540c\u7248\u672c\u7684\u7edf\u8ba1\u4fe1\u606f\u6536\u96c6\u4e0e\u89c6\u56fe\u6587\u6863\u3002\u4e0d\u6839\u636e\u5b57\u6bb5\u540d\u79f0\u63a8\u65ad\u5404\u5b57\u6bb5\u7684\u91cd\u7f6e\u89c4\u5219\u3002"]}, {"code": "SELECT blocks_done FROM pg_catalog.pg_stat_progress_create_index;", "title": "\u67e5\u770b\u6b64\u5b57\u6bb5", "paragraphs": ["\u793a\u4f8b\u67e5\u8be2\uff1b\u4e0d\u8868\u793a\u5df2\u6267\u884c\uff0c\u4e5f\u4e0d\u63d0\u4f9b\u5b9e\u6d4b\u503c\u3002"]}], "sql_type": "bigint", "center_zh": {"title": "pg_stat_progress_create_index.blocks_done", "locale": "zh-Hans", "source": {"key": "pg_stat_progress_create_index-blocks_done", "locale": "zh-Hans", "version": "14", "text_hash": "0082b6faf365fa10896640a3ad3abe6002fbdf32061cac4d34a9dee51707d8aa", "collection": "metric", "dataset_hash": "7c31b524dfe136022d39a6ae8dcfac6b3bbd5f8fdaf422536599981252aff0c9", "source_database": "center", "source_revision": "a7fa7ed3d558172355f51406097a7bd4f6b473be80f311ef7cda96bf383d8897"}, "payload": {"facts": [{"label": "\u89c6\u56fe", "value": "pg_stat_progress_create_index"}, {"label": "\u5b57\u6bb5", "value": "blocks_done"}, {"label": "SQL \u7c7b\u578b", "value": "bigint"}, {"label": "\u5b57\u6bb5\u5b9a\u4e49\u8bb0\u8f7d\u7684\u5355\u4f4d", "value": "blocks"}, {"label": "\u91cd\u7f6e\u6761\u4ef6", "value": "\u624b\u518c\u672a\u4e3a\u6b64\u89c6\u56fe\u8bb0\u8f7d stats_reset \u5b57\u6bb5"}], "tables": [], "zh_from": {"kind": "same-version-chinese-manual-with-source-derived-structured-summary", "manual": {"url": "/zh/docs/14/progress-reporting.html#", "anchor": "", "column": "blocks_done", "locale": "zh-Hans", "version": "14", "build_id": 99, "page_key": "progress-reporting.html", "extraction": "exact-catalog-field", "source_hash": "2aa6177a3c8c4c17b481e25014b9d702905e6b079eed9f9ad876be6e72e96c1c", "source_revision": "unknown:rendered-translation-baseline", "translation_revision": "git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:87e6aa4fd6e1ec85c5f4a6de4f5647cfd9e5de734ca2c266d32b6d6192c662ef"}, "body_sha256": "1e7ca7fabfdd0f12e535edc87b53d5c436e3ad0f87fb05500af5c3ca38fd5cc3", "runtime_rerun": false, "authored_translation": "source-derived-structured-summary", "source_facts_revision": "a7fa7ed3d558172355f51406097a7bd4f6b473be80f311ef7cda96bf383d8897"}, "sections": [{"title": "\u89c6\u56fe\u8bed\u4e49", "paragraphs": ["\u6bcf\u5f53\u8fd0\u884c CREATE INDEX \u6216 REINDEX \u65f6\uff0c pg_stat_progress_create_index \u89c6\u56fe\u5c06\u5305\u542b\u5f53\u524d\u6b63\u5728\u521b\u5efa\u7d22\u5f15\u7684\u6bcf\u4e2a\u540e\u7aef\u7684\u4e00\u884c\u3002\u4e0b\u9762\u7684\u8868\u63cf\u8ff0\u4e86\u5c06\u8981\u62a5\u544a\u7684\u4fe1\u606f\uff0c\u5e76\u63d0\u4f9b\u4e86\u5173\u4e8e\u5982\u4f55\u89e3\u91ca\u5b83\u7684\u4fe1\u606f\u3002"]}, {"title": "\u91c7\u96c6\u4e0e\u91cd\u7f6e\u8bed\u4e49", "paragraphs": ["\u91cd\u7f6e\u8303\u56f4\u548c\u53ef\u89c1\u6027\u8bf7\u53c2\u9605\u4e0b\u65b9\u540c\u7248\u672c\u7684\u7edf\u8ba1\u4fe1\u606f\u6536\u96c6\u4e0e\u89c6\u56fe\u6587\u6863\u3002\u4e0d\u6839\u636e\u5b57\u6bb5\u540d\u79f0\u63a8\u65ad\u5404\u5b57\u6bb5\u7684\u91cd\u7f6e\u89c4\u5219\u3002"]}, {"code": "SELECT blocks_done FROM pg_catalog.pg_stat_progress_create_index;", "title": "\u67e5\u770b\u6b64\u5b57\u6bb5", "paragraphs": ["\u793a\u4f8b\u67e5\u8be2\uff1b\u4e0d\u8868\u793a\u5df2\u6267\u884c\uff0c\u4e5f\u4e0d\u63d0\u4f9b\u5b9e\u6d4b\u503c\u3002"]}], "description_zh": "\u5f53\u524d\u9636\u6bb5\u5df2\u7ecf\u5904\u7406\u7684\u5757\u6570\u91cf\u3002", "description_zh_html": "pg_stat_progress_create_index.blocks_done \u7edf\u8ba1\u5b57\u6bb5\u3002
pg_stat_progress_create_indexblocks_donebigint\u5f53\u524d\u9636\u6bb5\u5df2\u7ecf\u5904\u7406\u7684\u5757\u6570\u91cf\u3002
\u67e5\u770b\u5b8c\u6574\u4e2d\u6587\u624b\u518c\u4e0e\u4e0a\u4e0b\u6587\u3002
"}, "summary": "\u5f53\u524d\u9636\u6bb5\u5df2\u7ecf\u5904\u7406\u7684\u5757\u6570\u91cf\u3002", "version": "14", "link_map": {"/zh/docs/14/progress-reporting.html": "/docs/14/progress-reporting.html"}, "body_html": "pg_stat_progress_create_index.blocks_done \u7edf\u8ba1\u5b57\u6bb5\u3002
pg_stat_progress_create_indexblocks_donebigint\u5f53\u524d\u9636\u6bb5\u5df2\u7ecf\u5904\u7406\u7684\u5757\u6570\u91cf\u3002
\u67e5\u770b\u5b8c\u6574\u4e2d\u6587\u624b\u518c\u4e0e\u4e0a\u4e0b\u6587\u3002
", "body_sha256": "764e93172238cf8812afd96386d18cfac9942a54be0e1be96edd967fe4bf8393", "content_hash": "0082b6faf365fa10896640a3ad3abe6002fbdf32061cac4d34a9dee51707d8aa", "source_database": "center", "source_revision": "a7fa7ed3d558172355f51406097a7bd4f6b473be80f311ef7cda96bf383d8897"}, "signature": "SELECT blocks_done FROM pg_catalog.pg_stat_progress_create_index;", "tables_zh": [], "documented": true, "description": ["\u5f53\u524d\u9636\u6bb5\u5df2\u7ecf\u5904\u7406\u7684\u5757\u6570\u91cf\u3002"], "manual_html": "", "manual_path": "/docs/14/progress-reporting.html", "sections_zh": [{"title": "\u89c6\u56fe\u8bed\u4e49", "paragraphs": ["\u6bcf\u5f53\u8fd0\u884c CREATE INDEX \u6216 REINDEX \u65f6\uff0c pg_stat_progress_create_index \u89c6\u56fe\u5c06\u5305\u542b\u5f53\u524d\u6b63\u5728\u521b\u5efa\u7d22\u5f15\u7684\u6bcf\u4e2a\u540e\u7aef\u7684\u4e00\u884c\u3002\u4e0b\u9762\u7684\u8868\u63cf\u8ff0\u4e86\u5c06\u8981\u62a5\u544a\u7684\u4fe1\u606f\uff0c\u5e76\u63d0\u4f9b\u4e86\u5173\u4e8e\u5982\u4f55\u89e3\u91ca\u5b83\u7684\u4fe1\u606f\u3002"]}, {"title": "\u91c7\u96c6\u4e0e\u91cd\u7f6e\u8bed\u4e49", "paragraphs": ["\u91cd\u7f6e\u8303\u56f4\u548c\u53ef\u89c1\u6027\u8bf7\u53c2\u9605\u4e0b\u65b9\u540c\u7248\u672c\u7684\u7edf\u8ba1\u4fe1\u606f\u6536\u96c6\u4e0e\u89c6\u56fe\u6587\u6863\u3002\u4e0d\u6839\u636e\u5b57\u6bb5\u540d\u79f0\u63a8\u65ad\u5404\u5b57\u6bb5\u7684\u91cd\u7f6e\u89c4\u5219\u3002"]}, {"code": "SELECT blocks_done FROM pg_catalog.pg_stat_progress_create_index;", "title": "\u67e5\u770b\u6b64\u5b57\u6bb5", "paragraphs": ["\u793a\u4f8b\u67e5\u8be2\uff1b\u4e0d\u8868\u793a\u5df2\u6267\u884c\uff0c\u4e5f\u4e0d\u63d0\u4f9b\u5b9e\u6d4b\u503c\u3002"]}], "source_only": false, "localization": {"status": "complete", "sources": [{"url": "/docs/14/progress-reporting.html", "method": "same-major semantic node", "sha256": "e2b6e9139a0372680de517d38f8ef1023216c57a14cbdc067a82b0e184be0fbd", "language": "zh", "matched_nodes": ["#PROGRESS-REPORTING/div[4]/div[3]/div[1]/table[0]/tbody[2]/tr[11]/td[0]/p[1]", "#PROGRESS-REPORTING/div[4]/p[2]"]}], "language": "zh", "original_text": {"/versions/14/description/0": "Number of blocks already processed in the current phase.", "/versions/14/facts/0/label": "View", "/versions/14/facts/1/label": "Field", "/versions/14/facts/2/label": "SQL type", "/versions/14/facts/3/label": "Units named in the field definition", "/versions/14/facts/4/label": "Reset observation", "/versions/14/facts/4/value": "No stats_reset field is documented for this view", "/versions/14/related/0/label": "pg_stat_progress_create_index columns", "/versions/14/related/1/label": "Statistics collection and reset functions", "/versions/14/sections/0/title": "View semantics", "/versions/14/sections/1/title": "Collection and reset context", "/versions/14/sections/2/title": "Inspect this field", "/versions/14/sections/0/paragraphs/0": "Whenever CREATE INDEX or REINDEX is running, the pg_stat_progress_create_index view will contain one row for each backend that is currently creating indexes. The tables below describe the information that will be reported and provide information about how to interpret it.", "/versions/14/sections/1/paragraphs/0": "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.", "/versions/14/sections/2/paragraphs/0": "Example query; no execution result or measured value is asserted."}, "fallback_fields": [], "source_language": "en", "original_snapshot_sha256": "f1899ee04b068a48a6df142878d37f52297830f5469b2145ce0df2fe4bd91542", "canonical_center_text_hash": "0082b6faf365fa10896640a3ad3abe6002fbdf32061cac4d34a9dee51707d8aa"}, "description_zh": "\u5f53\u524d\u9636\u6bb5\u5df2\u7ecf\u5904\u7406\u7684\u5757\u6570\u91cf\u3002", "comparison_data": {"view": "pg_stat_progress_create_index", "field": "blocks_done", "sql_type": "bigint", "units_mentioned": ["blocks"]}, "comparison_hash": "d2aa38d3839903b88fd0f5ab16015167de8f74a86068ea91d874c18a9ee2ac5a", "manual_language": "zh", "units_mentioned": ["blocks"], "description_zh_html": "pg_stat_progress_create_index.blocks_done \u7edf\u8ba1\u5b57\u6bb5\u3002
pg_stat_progress_create_indexblocks_donebigint\u5f53\u524d\u9636\u6bb5\u5df2\u7ecf\u5904\u7406\u7684\u5757\u6570\u91cf\u3002
\u67e5\u770b\u5b8c\u6574\u4e2d\u6587\u624b\u518c\u4e0e\u4e0a\u4e0b\u6587\u3002
"}, "15": {"view": "pg_stat_progress_create_index", "facts": [{"label": "\u89c6\u56fe", "value": "pg_stat_progress_create_index"}, {"label": "\u5b57\u6bb5", "value": "blocks_done"}, {"label": "SQL \u7c7b\u578b", "value": "bigint"}, {"label": "\u5b57\u6bb5\u5b9a\u4e49\u8bb0\u8f7d\u7684\u5355\u4f4d", "value": "blocks"}, {"label": "\u91cd\u7f6e\u6761\u4ef6", "value": "\u624b\u518c\u672a\u4e3a\u6b64\u89c6\u56fe\u8bb0\u8f7d stats_reset \u5b57\u6bb5"}], "field": "blocks_done", "tables": [], "related": [{"url": "/wiki/catalog/pg_stat_progress_create_index/?v=15", "label": "pg_stat_progress_create_index \u5b57\u6bb5"}, {"url": "/docs/15/monitoring-stats.html", "label": "\u7edf\u8ba1\u6536\u96c6\u4e0e\u91cd\u7f6e\u51fd\u6570"}], "release": {"ref": "https://ftp.postgresql.org/pub/source/v15.19/postgresql-15.19.tar.bz2", "label": "15.19", "major": "15", "channel": "stable", "revision": "e1a64a87a46b825b88c082e4518161a47aab53c45694964f8ba1df28f7859f89"}, "sources": [{"url": "/docs/15/progress-reporting.html#PG-STAT-PROGRESS-CREATE-INDEX-VIEW", "path": "progress-reporting.html", "label": "PostgreSQL 15 English manual", "sha256": "97422d3113978e145d4a71fa1daf467b8dbd573372a88dfb1a767be0b96105fa"}], "zh_from": {"kind": "same-version-chinese-manual-with-source-derived-structured-summary", "manual": {"url": "/zh/docs/15/progress-reporting.html#", "anchor": "", "column": "blocks_done", "locale": "zh-Hans", "version": "15", "build_id": 101, "page_key": "progress-reporting.html", "extraction": "exact-catalog-field", "source_hash": "16ba0d3e81bb238248792276f51b4f5ac984335aad79f2e822cbf6367b1fb2f8", "source_revision": "unknown:rendered-translation-baseline", "translation_revision": "git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:6bce1a2df9170cb1146a1411c5547190856638221a6539e618ee1016c9f493ad"}, "body_sha256": "fd23e879ae824448bc7477ddb0175e5baf17fa1dfa801d1379da8ec525288630", "runtime_rerun": false, "authored_translation": "source-derived-structured-summary", "source_facts_revision": "e1a64a87a46b825b88c082e4518161a47aab53c45694964f8ba1df28f7859f89"}, "facts_zh": [{"label": "\u89c6\u56fe", "value": "pg_stat_progress_create_index"}, {"label": "\u5b57\u6bb5", "value": "blocks_done"}, {"label": "SQL \u7c7b\u578b", "value": "bigint"}, {"label": "\u5b57\u6bb5\u5b9a\u4e49\u8bb0\u8f7d\u7684\u5355\u4f4d", "value": "blocks"}, {"label": "\u91cd\u7f6e\u6761\u4ef6", "value": "\u624b\u518c\u672a\u4e3a\u6b64\u89c6\u56fe\u8bb0\u8f7d stats_reset \u5b57\u6bb5"}], "sections": [{"title": "\u89c6\u56fe\u8bed\u4e49", "paragraphs": ["\u6bcf\u5f53\u8fd0\u884c CREATE INDEX \u6216 REINDEX \u65f6\uff0c pg_stat_progress_create_index \u89c6\u56fe\u5c06\u5305\u542b\u5f53\u524d\u6b63\u5728\u521b\u5efa\u7d22\u5f15\u7684\u6bcf\u4e2a\u540e\u7aef\u7684\u4e00\u884c\u3002\u4e0b\u9762\u7684\u8868\u63cf\u8ff0\u4e86\u5c06\u8981\u62a5\u544a\u7684\u4fe1\u606f\uff0c\u5e76\u63d0\u4f9b\u4e86\u5173\u4e8e\u5982\u4f55\u89e3\u91ca\u5b83\u7684\u4fe1\u606f\u3002"]}, {"title": "\u91c7\u96c6\u4e0e\u91cd\u7f6e\u8bed\u4e49", "paragraphs": ["\u91cd\u7f6e\u8303\u56f4\u548c\u53ef\u89c1\u6027\u8bf7\u53c2\u9605\u4e0b\u65b9\u540c\u7248\u672c\u7684\u7edf\u8ba1\u4fe1\u606f\u6536\u96c6\u4e0e\u89c6\u56fe\u6587\u6863\u3002\u4e0d\u6839\u636e\u5b57\u6bb5\u540d\u79f0\u63a8\u65ad\u5404\u5b57\u6bb5\u7684\u91cd\u7f6e\u89c4\u5219\u3002"]}, {"code": "SELECT blocks_done FROM pg_catalog.pg_stat_progress_create_index;", "title": "\u67e5\u770b\u6b64\u5b57\u6bb5", "paragraphs": ["\u793a\u4f8b\u67e5\u8be2\uff1b\u4e0d\u8868\u793a\u5df2\u6267\u884c\uff0c\u4e5f\u4e0d\u63d0\u4f9b\u5b9e\u6d4b\u503c\u3002"]}], "sql_type": "bigint", "center_zh": {"title": "pg_stat_progress_create_index.blocks_done", "locale": "zh-Hans", "source": {"key": "pg_stat_progress_create_index-blocks_done", "locale": "zh-Hans", "version": "15", "text_hash": "2028f38ccc71e631542d210f864ce24102bce2df53522312d3cc4773624feb49", "collection": "metric", "dataset_hash": "7c31b524dfe136022d39a6ae8dcfac6b3bbd5f8fdaf422536599981252aff0c9", "source_database": "center", "source_revision": "e1a64a87a46b825b88c082e4518161a47aab53c45694964f8ba1df28f7859f89"}, "payload": {"facts": [{"label": "\u89c6\u56fe", "value": "pg_stat_progress_create_index"}, {"label": "\u5b57\u6bb5", "value": "blocks_done"}, {"label": "SQL \u7c7b\u578b", "value": "bigint"}, {"label": "\u5b57\u6bb5\u5b9a\u4e49\u8bb0\u8f7d\u7684\u5355\u4f4d", "value": "blocks"}, {"label": "\u91cd\u7f6e\u6761\u4ef6", "value": "\u624b\u518c\u672a\u4e3a\u6b64\u89c6\u56fe\u8bb0\u8f7d stats_reset \u5b57\u6bb5"}], "tables": [], "zh_from": {"kind": "same-version-chinese-manual-with-source-derived-structured-summary", "manual": {"url": "/zh/docs/15/progress-reporting.html#", "anchor": "", "column": "blocks_done", "locale": "zh-Hans", "version": "15", "build_id": 101, "page_key": "progress-reporting.html", "extraction": "exact-catalog-field", "source_hash": "16ba0d3e81bb238248792276f51b4f5ac984335aad79f2e822cbf6367b1fb2f8", "source_revision": "unknown:rendered-translation-baseline", "translation_revision": "git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:6bce1a2df9170cb1146a1411c5547190856638221a6539e618ee1016c9f493ad"}, "body_sha256": "fd23e879ae824448bc7477ddb0175e5baf17fa1dfa801d1379da8ec525288630", "runtime_rerun": false, "authored_translation": "source-derived-structured-summary", "source_facts_revision": "e1a64a87a46b825b88c082e4518161a47aab53c45694964f8ba1df28f7859f89"}, "sections": [{"title": "\u89c6\u56fe\u8bed\u4e49", "paragraphs": ["\u6bcf\u5f53\u8fd0\u884c CREATE INDEX \u6216 REINDEX \u65f6\uff0c pg_stat_progress_create_index \u89c6\u56fe\u5c06\u5305\u542b\u5f53\u524d\u6b63\u5728\u521b\u5efa\u7d22\u5f15\u7684\u6bcf\u4e2a\u540e\u7aef\u7684\u4e00\u884c\u3002\u4e0b\u9762\u7684\u8868\u63cf\u8ff0\u4e86\u5c06\u8981\u62a5\u544a\u7684\u4fe1\u606f\uff0c\u5e76\u63d0\u4f9b\u4e86\u5173\u4e8e\u5982\u4f55\u89e3\u91ca\u5b83\u7684\u4fe1\u606f\u3002"]}, {"title": "\u91c7\u96c6\u4e0e\u91cd\u7f6e\u8bed\u4e49", "paragraphs": ["\u91cd\u7f6e\u8303\u56f4\u548c\u53ef\u89c1\u6027\u8bf7\u53c2\u9605\u4e0b\u65b9\u540c\u7248\u672c\u7684\u7edf\u8ba1\u4fe1\u606f\u6536\u96c6\u4e0e\u89c6\u56fe\u6587\u6863\u3002\u4e0d\u6839\u636e\u5b57\u6bb5\u540d\u79f0\u63a8\u65ad\u5404\u5b57\u6bb5\u7684\u91cd\u7f6e\u89c4\u5219\u3002"]}, {"code": "SELECT blocks_done FROM pg_catalog.pg_stat_progress_create_index;", "title": "\u67e5\u770b\u6b64\u5b57\u6bb5", "paragraphs": ["\u793a\u4f8b\u67e5\u8be2\uff1b\u4e0d\u8868\u793a\u5df2\u6267\u884c\uff0c\u4e5f\u4e0d\u63d0\u4f9b\u5b9e\u6d4b\u503c\u3002"]}], "description_zh": "\u5f53\u524d\u9636\u6bb5\u5df2\u7ecf\u5904\u7406\u7684\u5757\u6570\u91cf\u3002", "description_zh_html": "pg_stat_progress_create_index.blocks_done \u7edf\u8ba1\u5b57\u6bb5\u3002
pg_stat_progress_create_indexblocks_donebigint\u5f53\u524d\u9636\u6bb5\u5df2\u7ecf\u5904\u7406\u7684\u5757\u6570\u91cf\u3002
\u67e5\u770b\u5b8c\u6574\u4e2d\u6587\u624b\u518c\u4e0e\u4e0a\u4e0b\u6587\u3002
"}, "summary": "\u5f53\u524d\u9636\u6bb5\u5df2\u7ecf\u5904\u7406\u7684\u5757\u6570\u91cf\u3002", "version": "15", "link_map": {"/zh/docs/15/progress-reporting.html": "/docs/15/progress-reporting.html"}, "body_html": "pg_stat_progress_create_index.blocks_done \u7edf\u8ba1\u5b57\u6bb5\u3002
pg_stat_progress_create_indexblocks_donebigint\u5f53\u524d\u9636\u6bb5\u5df2\u7ecf\u5904\u7406\u7684\u5757\u6570\u91cf\u3002
\u67e5\u770b\u5b8c\u6574\u4e2d\u6587\u624b\u518c\u4e0e\u4e0a\u4e0b\u6587\u3002
", "body_sha256": "612adac62ea11e9629cb1da3e4358d4b0a6994920cb968020152ddee38c126d7", "content_hash": "2028f38ccc71e631542d210f864ce24102bce2df53522312d3cc4773624feb49", "source_database": "center", "source_revision": "e1a64a87a46b825b88c082e4518161a47aab53c45694964f8ba1df28f7859f89"}, "signature": "SELECT blocks_done FROM pg_catalog.pg_stat_progress_create_index;", "tables_zh": [], "documented": true, "description": ["\u5f53\u524d\u9636\u6bb5\u5df2\u7ecf\u5904\u7406\u7684\u5757\u6570\u91cf\u3002"], "manual_html": "", "manual_path": "/docs/15/progress-reporting.html", "sections_zh": [{"title": "\u89c6\u56fe\u8bed\u4e49", "paragraphs": ["\u6bcf\u5f53\u8fd0\u884c CREATE INDEX \u6216 REINDEX \u65f6\uff0c pg_stat_progress_create_index \u89c6\u56fe\u5c06\u5305\u542b\u5f53\u524d\u6b63\u5728\u521b\u5efa\u7d22\u5f15\u7684\u6bcf\u4e2a\u540e\u7aef\u7684\u4e00\u884c\u3002\u4e0b\u9762\u7684\u8868\u63cf\u8ff0\u4e86\u5c06\u8981\u62a5\u544a\u7684\u4fe1\u606f\uff0c\u5e76\u63d0\u4f9b\u4e86\u5173\u4e8e\u5982\u4f55\u89e3\u91ca\u5b83\u7684\u4fe1\u606f\u3002"]}, {"title": "\u91c7\u96c6\u4e0e\u91cd\u7f6e\u8bed\u4e49", "paragraphs": ["\u91cd\u7f6e\u8303\u56f4\u548c\u53ef\u89c1\u6027\u8bf7\u53c2\u9605\u4e0b\u65b9\u540c\u7248\u672c\u7684\u7edf\u8ba1\u4fe1\u606f\u6536\u96c6\u4e0e\u89c6\u56fe\u6587\u6863\u3002\u4e0d\u6839\u636e\u5b57\u6bb5\u540d\u79f0\u63a8\u65ad\u5404\u5b57\u6bb5\u7684\u91cd\u7f6e\u89c4\u5219\u3002"]}, {"code": "SELECT blocks_done FROM pg_catalog.pg_stat_progress_create_index;", "title": "\u67e5\u770b\u6b64\u5b57\u6bb5", "paragraphs": ["\u793a\u4f8b\u67e5\u8be2\uff1b\u4e0d\u8868\u793a\u5df2\u6267\u884c\uff0c\u4e5f\u4e0d\u63d0\u4f9b\u5b9e\u6d4b\u503c\u3002"]}], "source_only": false, "localization": {"status": "complete", "sources": [{"url": "/docs/15/progress-reporting.html", "method": "same-major semantic node", "sha256": "cab98d710aba75d33548edff0361412df82799231e1a7eb6e37b6dede5f44cd9", "language": "zh", "matched_nodes": ["#PROGRESS-REPORTING/div[4]/div[3]/div[1]/table[0]/tbody[2]/tr[11]/td[0]/p[1]", "#PROGRESS-REPORTING/div[4]/p[2]"]}], "language": "zh", "original_text": {"/versions/15/description/0": "Number of blocks already processed in the current phase.", "/versions/15/facts/0/label": "View", "/versions/15/facts/1/label": "Field", "/versions/15/facts/2/label": "SQL type", "/versions/15/facts/3/label": "Units named in the field definition", "/versions/15/facts/4/label": "Reset observation", "/versions/15/facts/4/value": "No stats_reset field is documented for this view", "/versions/15/related/0/label": "pg_stat_progress_create_index columns", "/versions/15/related/1/label": "Statistics collection and reset functions", "/versions/15/sections/0/title": "View semantics", "/versions/15/sections/1/title": "Collection and reset context", "/versions/15/sections/2/title": "Inspect this field", "/versions/15/sections/0/paragraphs/0": "Whenever CREATE INDEX or REINDEX is running, the pg_stat_progress_create_index view will contain one row for each backend that is currently creating indexes. The tables below describe the information that will be reported and provide information about how to interpret it.", "/versions/15/sections/1/paragraphs/0": "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.", "/versions/15/sections/2/paragraphs/0": "Example query; no execution result or measured value is asserted."}, "fallback_fields": [], "source_language": "en", "original_snapshot_sha256": "cd6a51a15dfad435563265648147fdee5f6f868bf65b8cfd1a8309cd9f782b43", "canonical_center_text_hash": "2028f38ccc71e631542d210f864ce24102bce2df53522312d3cc4773624feb49"}, "description_zh": "\u5f53\u524d\u9636\u6bb5\u5df2\u7ecf\u5904\u7406\u7684\u5757\u6570\u91cf\u3002", "comparison_data": {"view": "pg_stat_progress_create_index", "field": "blocks_done", "sql_type": "bigint", "units_mentioned": ["blocks"]}, "comparison_hash": "d2aa38d3839903b88fd0f5ab16015167de8f74a86068ea91d874c18a9ee2ac5a", "manual_language": "zh", "units_mentioned": ["blocks"], "description_zh_html": "pg_stat_progress_create_index.blocks_done \u7edf\u8ba1\u5b57\u6bb5\u3002
pg_stat_progress_create_indexblocks_donebigint\u5f53\u524d\u9636\u6bb5\u5df2\u7ecf\u5904\u7406\u7684\u5757\u6570\u91cf\u3002
\u67e5\u770b\u5b8c\u6574\u4e2d\u6587\u624b\u518c\u4e0e\u4e0a\u4e0b\u6587\u3002
"}, "16": {"view": "pg_stat_progress_create_index", "facts": [{"label": "\u89c6\u56fe", "value": "pg_stat_progress_create_index"}, {"label": "\u5b57\u6bb5", "value": "blocks_done"}, {"label": "SQL \u7c7b\u578b", "value": "bigint"}, {"label": "\u5b57\u6bb5\u5b9a\u4e49\u8bb0\u8f7d\u7684\u5355\u4f4d", "value": "blocks"}, {"label": "\u91cd\u7f6e\u6761\u4ef6", "value": "\u624b\u518c\u672a\u4e3a\u6b64\u89c6\u56fe\u8bb0\u8f7d stats_reset \u5b57\u6bb5"}], "field": "blocks_done", "tables": [], "related": [{"url": "/wiki/catalog/pg_stat_progress_create_index/?v=16", "label": "pg_stat_progress_create_index \u5b57\u6bb5"}, {"url": "/docs/16/monitoring-stats.html", "label": "\u7edf\u8ba1\u6536\u96c6\u4e0e\u91cd\u7f6e\u51fd\u6570"}], "release": {"ref": "https://ftp.postgresql.org/pub/source/v16.15/postgresql-16.15.tar.bz2", "label": "16.15", "major": "16", "channel": "stable", "revision": "c1575341fa7bd40f5274ea465b34390f4dc64cdd0770af327005caaeb9f6b7ed"}, "sources": [{"url": "/docs/16/progress-reporting.html#PG-STAT-PROGRESS-CREATE-INDEX-VIEW", "path": "progress-reporting.html", "label": "PostgreSQL 16 English manual", "sha256": "2b460ce06a91510e6d57a1e5d51b3ffdb65426fb38d30b0ff2774af6da50cf68"}], "zh_from": {"kind": "same-version-chinese-manual-with-source-derived-structured-summary", "manual": {"url": "/zh/docs/16/progress-reporting.html#", "anchor": "", "column": "blocks_done", "locale": "zh-Hans", "version": "16", "build_id": 103, "page_key": "progress-reporting.html", "extraction": "exact-catalog-field", "source_hash": "f8a9002f7afde824021edcd1dedabfe1e833b94dd18da5a9eec15b2a74fdbae0", "source_revision": "unknown:rendered-translation-baseline", "translation_revision": "git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:80579a071736780f9c4022bb5148e1fb1256f1a33591306af67816e9e9bf3a9b"}, "body_sha256": "bd419208d7b4a7c0945c7731c7eb80603aafae997399cca540290bdbd9bc0d00", "runtime_rerun": false, "authored_translation": "source-derived-structured-summary", "source_facts_revision": "c1575341fa7bd40f5274ea465b34390f4dc64cdd0770af327005caaeb9f6b7ed"}, "facts_zh": [{"label": "\u89c6\u56fe", "value": "pg_stat_progress_create_index"}, {"label": "\u5b57\u6bb5", "value": "blocks_done"}, {"label": "SQL \u7c7b\u578b", "value": "bigint"}, {"label": "\u5b57\u6bb5\u5b9a\u4e49\u8bb0\u8f7d\u7684\u5355\u4f4d", "value": "blocks"}, {"label": "\u91cd\u7f6e\u6761\u4ef6", "value": "\u624b\u518c\u672a\u4e3a\u6b64\u89c6\u56fe\u8bb0\u8f7d stats_reset \u5b57\u6bb5"}], "sections": [{"title": "\u89c6\u56fe\u8bed\u4e49", "paragraphs": ["\u6bcf\u5f53\u8fd0\u884c CREATE INDEX \u6216 REINDEX \u65f6\uff0c pg_stat_progress_create_index \u89c6\u56fe\u5c06\u5305\u542b\u5f53\u524d\u6b63\u5728\u521b\u5efa\u7d22\u5f15\u7684\u6bcf\u4e2a\u540e\u7aef\u7684\u4e00\u884c\u3002\u4e0b\u9762\u7684\u8868\u63cf\u8ff0\u4e86\u5c06\u8981\u62a5\u544a\u7684\u4fe1\u606f\uff0c\u5e76\u63d0\u4f9b\u4e86\u5173\u4e8e\u5982\u4f55\u89e3\u91ca\u5b83\u7684\u4fe1\u606f\u3002"]}, {"title": "\u91c7\u96c6\u4e0e\u91cd\u7f6e\u8bed\u4e49", "paragraphs": ["\u91cd\u7f6e\u8303\u56f4\u548c\u53ef\u89c1\u6027\u8bf7\u53c2\u9605\u4e0b\u65b9\u540c\u7248\u672c\u7684\u7edf\u8ba1\u4fe1\u606f\u6536\u96c6\u4e0e\u89c6\u56fe\u6587\u6863\u3002\u4e0d\u6839\u636e\u5b57\u6bb5\u540d\u79f0\u63a8\u65ad\u5404\u5b57\u6bb5\u7684\u91cd\u7f6e\u89c4\u5219\u3002"]}, {"code": "SELECT blocks_done FROM pg_catalog.pg_stat_progress_create_index;", "title": "\u67e5\u770b\u6b64\u5b57\u6bb5", "paragraphs": ["\u793a\u4f8b\u67e5\u8be2\uff1b\u4e0d\u8868\u793a\u5df2\u6267\u884c\uff0c\u4e5f\u4e0d\u63d0\u4f9b\u5b9e\u6d4b\u503c\u3002"]}], "sql_type": "bigint", "center_zh": {"title": "pg_stat_progress_create_index.blocks_done", "locale": "zh-Hans", "source": {"key": "pg_stat_progress_create_index-blocks_done", "locale": "zh-Hans", "version": "16", "text_hash": "9d74ca0f3ebb62c8f1fae551a7a3c6dde495771e5fd8bb25b72ad4dd84ea8387", "collection": "metric", "dataset_hash": "7c31b524dfe136022d39a6ae8dcfac6b3bbd5f8fdaf422536599981252aff0c9", "source_database": "center", "source_revision": "c1575341fa7bd40f5274ea465b34390f4dc64cdd0770af327005caaeb9f6b7ed"}, "payload": {"facts": [{"label": "\u89c6\u56fe", "value": "pg_stat_progress_create_index"}, {"label": "\u5b57\u6bb5", "value": "blocks_done"}, {"label": "SQL \u7c7b\u578b", "value": "bigint"}, {"label": "\u5b57\u6bb5\u5b9a\u4e49\u8bb0\u8f7d\u7684\u5355\u4f4d", "value": "blocks"}, {"label": "\u91cd\u7f6e\u6761\u4ef6", "value": "\u624b\u518c\u672a\u4e3a\u6b64\u89c6\u56fe\u8bb0\u8f7d stats_reset \u5b57\u6bb5"}], "tables": [], "zh_from": {"kind": "same-version-chinese-manual-with-source-derived-structured-summary", "manual": {"url": "/zh/docs/16/progress-reporting.html#", "anchor": "", "column": "blocks_done", "locale": "zh-Hans", "version": "16", "build_id": 103, "page_key": "progress-reporting.html", "extraction": "exact-catalog-field", "source_hash": "f8a9002f7afde824021edcd1dedabfe1e833b94dd18da5a9eec15b2a74fdbae0", "source_revision": "unknown:rendered-translation-baseline", "translation_revision": "git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:80579a071736780f9c4022bb5148e1fb1256f1a33591306af67816e9e9bf3a9b"}, "body_sha256": "bd419208d7b4a7c0945c7731c7eb80603aafae997399cca540290bdbd9bc0d00", "runtime_rerun": false, "authored_translation": "source-derived-structured-summary", "source_facts_revision": "c1575341fa7bd40f5274ea465b34390f4dc64cdd0770af327005caaeb9f6b7ed"}, "sections": [{"title": "\u89c6\u56fe\u8bed\u4e49", "paragraphs": ["\u6bcf\u5f53\u8fd0\u884c CREATE INDEX \u6216 REINDEX \u65f6\uff0c pg_stat_progress_create_index \u89c6\u56fe\u5c06\u5305\u542b\u5f53\u524d\u6b63\u5728\u521b\u5efa\u7d22\u5f15\u7684\u6bcf\u4e2a\u540e\u7aef\u7684\u4e00\u884c\u3002\u4e0b\u9762\u7684\u8868\u63cf\u8ff0\u4e86\u5c06\u8981\u62a5\u544a\u7684\u4fe1\u606f\uff0c\u5e76\u63d0\u4f9b\u4e86\u5173\u4e8e\u5982\u4f55\u89e3\u91ca\u5b83\u7684\u4fe1\u606f\u3002"]}, {"title": "\u91c7\u96c6\u4e0e\u91cd\u7f6e\u8bed\u4e49", "paragraphs": ["\u91cd\u7f6e\u8303\u56f4\u548c\u53ef\u89c1\u6027\u8bf7\u53c2\u9605\u4e0b\u65b9\u540c\u7248\u672c\u7684\u7edf\u8ba1\u4fe1\u606f\u6536\u96c6\u4e0e\u89c6\u56fe\u6587\u6863\u3002\u4e0d\u6839\u636e\u5b57\u6bb5\u540d\u79f0\u63a8\u65ad\u5404\u5b57\u6bb5\u7684\u91cd\u7f6e\u89c4\u5219\u3002"]}, {"code": "SELECT blocks_done FROM pg_catalog.pg_stat_progress_create_index;", "title": "\u67e5\u770b\u6b64\u5b57\u6bb5", "paragraphs": ["\u793a\u4f8b\u67e5\u8be2\uff1b\u4e0d\u8868\u793a\u5df2\u6267\u884c\uff0c\u4e5f\u4e0d\u63d0\u4f9b\u5b9e\u6d4b\u503c\u3002"]}], "description_zh": "\u5f53\u524d\u9636\u6bb5\u5df2\u7ecf\u5904\u7406\u7684\u5757\u6570\u91cf\u3002", "description_zh_html": "pg_stat_progress_create_index.blocks_done \u7edf\u8ba1\u5b57\u6bb5\u3002
pg_stat_progress_create_indexblocks_donebigint\u5f53\u524d\u9636\u6bb5\u5df2\u7ecf\u5904\u7406\u7684\u5757\u6570\u91cf\u3002
\u67e5\u770b\u5b8c\u6574\u4e2d\u6587\u624b\u518c\u4e0e\u4e0a\u4e0b\u6587\u3002
"}, "summary": "\u5f53\u524d\u9636\u6bb5\u5df2\u7ecf\u5904\u7406\u7684\u5757\u6570\u91cf\u3002", "version": "16", "link_map": {"/zh/docs/16/progress-reporting.html": "/docs/16/progress-reporting.html"}, "body_html": "pg_stat_progress_create_index.blocks_done \u7edf\u8ba1\u5b57\u6bb5\u3002
pg_stat_progress_create_indexblocks_donebigint\u5f53\u524d\u9636\u6bb5\u5df2\u7ecf\u5904\u7406\u7684\u5757\u6570\u91cf\u3002
\u67e5\u770b\u5b8c\u6574\u4e2d\u6587\u624b\u518c\u4e0e\u4e0a\u4e0b\u6587\u3002
", "body_sha256": "766e065885fd2ce076994e4e782e35d368b1d1f17b2c17cf78d7e3fb48df2e3b", "content_hash": "9d74ca0f3ebb62c8f1fae551a7a3c6dde495771e5fd8bb25b72ad4dd84ea8387", "source_database": "center", "source_revision": "c1575341fa7bd40f5274ea465b34390f4dc64cdd0770af327005caaeb9f6b7ed"}, "signature": "SELECT blocks_done FROM pg_catalog.pg_stat_progress_create_index;", "tables_zh": [], "documented": true, "description": ["\u5f53\u524d\u9636\u6bb5\u5df2\u7ecf\u5904\u7406\u7684\u5757\u6570\u91cf\u3002"], "manual_html": "", "manual_path": "/docs/16/progress-reporting.html", "sections_zh": [{"title": "\u89c6\u56fe\u8bed\u4e49", "paragraphs": ["\u6bcf\u5f53\u8fd0\u884c CREATE INDEX \u6216 REINDEX \u65f6\uff0c pg_stat_progress_create_index \u89c6\u56fe\u5c06\u5305\u542b\u5f53\u524d\u6b63\u5728\u521b\u5efa\u7d22\u5f15\u7684\u6bcf\u4e2a\u540e\u7aef\u7684\u4e00\u884c\u3002\u4e0b\u9762\u7684\u8868\u63cf\u8ff0\u4e86\u5c06\u8981\u62a5\u544a\u7684\u4fe1\u606f\uff0c\u5e76\u63d0\u4f9b\u4e86\u5173\u4e8e\u5982\u4f55\u89e3\u91ca\u5b83\u7684\u4fe1\u606f\u3002"]}, {"title": "\u91c7\u96c6\u4e0e\u91cd\u7f6e\u8bed\u4e49", "paragraphs": ["\u91cd\u7f6e\u8303\u56f4\u548c\u53ef\u89c1\u6027\u8bf7\u53c2\u9605\u4e0b\u65b9\u540c\u7248\u672c\u7684\u7edf\u8ba1\u4fe1\u606f\u6536\u96c6\u4e0e\u89c6\u56fe\u6587\u6863\u3002\u4e0d\u6839\u636e\u5b57\u6bb5\u540d\u79f0\u63a8\u65ad\u5404\u5b57\u6bb5\u7684\u91cd\u7f6e\u89c4\u5219\u3002"]}, {"code": "SELECT blocks_done FROM pg_catalog.pg_stat_progress_create_index;", "title": "\u67e5\u770b\u6b64\u5b57\u6bb5", "paragraphs": ["\u793a\u4f8b\u67e5\u8be2\uff1b\u4e0d\u8868\u793a\u5df2\u6267\u884c\uff0c\u4e5f\u4e0d\u63d0\u4f9b\u5b9e\u6d4b\u503c\u3002"]}], "source_only": false, "localization": {"status": "complete", "sources": [{"url": "/docs/16/progress-reporting.html", "method": "same-major semantic node", "sha256": "75ccd2489140d7c39bc3f563be8befa9fe947222fff0fa251b109b6715a58bb8", "language": "zh", "matched_nodes": ["#PROGRESS-REPORTING/div[6]/div[3]/div[1]/table[0]/tbody[2]/tr[11]/td[0]/p[1]", "#PROGRESS-REPORTING/div[6]/p[2]"]}], "language": "zh", "original_text": {"/versions/16/description/0": "Number of blocks already processed in the current phase.", "/versions/16/facts/0/label": "View", "/versions/16/facts/1/label": "Field", "/versions/16/facts/2/label": "SQL type", "/versions/16/facts/3/label": "Units named in the field definition", "/versions/16/facts/4/label": "Reset observation", "/versions/16/facts/4/value": "No stats_reset field is documented for this view", "/versions/16/related/0/label": "pg_stat_progress_create_index columns", "/versions/16/related/1/label": "Statistics collection and reset functions", "/versions/16/sections/0/title": "View semantics", "/versions/16/sections/1/title": "Collection and reset context", "/versions/16/sections/2/title": "Inspect this field", "/versions/16/sections/0/paragraphs/0": "Whenever CREATE INDEX or REINDEX is running, the pg_stat_progress_create_index view will contain one row for each backend that is currently creating indexes. The tables below describe the information that will be reported and provide information about how to interpret it.", "/versions/16/sections/1/paragraphs/0": "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.", "/versions/16/sections/2/paragraphs/0": "Example query; no execution result or measured value is asserted."}, "fallback_fields": [], "source_language": "en", "original_snapshot_sha256": "df39d1fdbee5249ce9f5caa007c560d509fa615757aef9c04d1533409acbaf21", "canonical_center_text_hash": "9d74ca0f3ebb62c8f1fae551a7a3c6dde495771e5fd8bb25b72ad4dd84ea8387"}, "description_zh": "\u5f53\u524d\u9636\u6bb5\u5df2\u7ecf\u5904\u7406\u7684\u5757\u6570\u91cf\u3002", "comparison_data": {"view": "pg_stat_progress_create_index", "field": "blocks_done", "sql_type": "bigint", "units_mentioned": ["blocks"]}, "comparison_hash": "d2aa38d3839903b88fd0f5ab16015167de8f74a86068ea91d874c18a9ee2ac5a", "manual_language": "zh", "units_mentioned": ["blocks"], "description_zh_html": "pg_stat_progress_create_index.blocks_done \u7edf\u8ba1\u5b57\u6bb5\u3002
pg_stat_progress_create_indexblocks_donebigint\u5f53\u524d\u9636\u6bb5\u5df2\u7ecf\u5904\u7406\u7684\u5757\u6570\u91cf\u3002
\u67e5\u770b\u5b8c\u6574\u4e2d\u6587\u624b\u518c\u4e0e\u4e0a\u4e0b\u6587\u3002
"}, "17": {"view": "pg_stat_progress_create_index", "facts": [{"label": "\u89c6\u56fe", "value": "pg_stat_progress_create_index"}, {"label": "\u5b57\u6bb5", "value": "blocks_done"}, {"label": "SQL \u7c7b\u578b", "value": "bigint"}, {"label": "\u5b57\u6bb5\u5b9a\u4e49\u8bb0\u8f7d\u7684\u5355\u4f4d", "value": "blocks"}, {"label": "\u91cd\u7f6e\u6761\u4ef6", "value": "\u624b\u518c\u672a\u4e3a\u6b64\u89c6\u56fe\u8bb0\u8f7d stats_reset \u5b57\u6bb5"}], "field": "blocks_done", "tables": [], "related": [{"url": "/wiki/catalog/pg_stat_progress_create_index/?v=17", "label": "pg_stat_progress_create_index \u5b57\u6bb5"}, {"url": "/docs/17/monitoring-stats.html", "label": "\u7edf\u8ba1\u6536\u96c6\u4e0e\u91cd\u7f6e\u51fd\u6570"}], "release": {"ref": "https://ftp.postgresql.org/pub/source/v17.11/postgresql-17.11.tar.bz2", "label": "17.11", "major": "17", "channel": "stable", "revision": "dd27f2b3c59e73ed14aa3324901242bf69a032a6347805f274e6260322d42979"}, "sources": [{"url": "/docs/17/progress-reporting.html#PG-STAT-PROGRESS-CREATE-INDEX-VIEW", "path": "progress-reporting.html", "label": "PostgreSQL 17 English manual", "sha256": "94edb2f133e511fb3bac06d21e8b55f1519df3d59536746d67de3768c94df607"}], "zh_from": {"kind": "same-version-chinese-manual-with-source-derived-structured-summary", "manual": {"url": "/zh/docs/17/progress-reporting.html#", "anchor": "", "column": "blocks_done", "locale": "zh-Hans", "version": "17", "build_id": 105, "page_key": "progress-reporting.html", "extraction": "exact-catalog-field", "source_hash": "f7c1b49817402ea3422f879d5b9a210f4d1940ac2d57303a24dd8e8a5a309a95", "source_revision": "unknown:rendered-translation-baseline", "translation_revision": "git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:7340767258d21c21b36f373f1fff6bab2be18e0daca13a865129db6105c09efd"}, "body_sha256": "5685a7846f6450626272bffb32c61d3b5e4c95caf27ddf10b241824d2234e328", "runtime_rerun": false, "authored_translation": "source-derived-structured-summary", "source_facts_revision": "dd27f2b3c59e73ed14aa3324901242bf69a032a6347805f274e6260322d42979"}, "facts_zh": [{"label": "\u89c6\u56fe", "value": "pg_stat_progress_create_index"}, {"label": "\u5b57\u6bb5", "value": "blocks_done"}, {"label": "SQL \u7c7b\u578b", "value": "bigint"}, {"label": "\u5b57\u6bb5\u5b9a\u4e49\u8bb0\u8f7d\u7684\u5355\u4f4d", "value": "blocks"}, {"label": "\u91cd\u7f6e\u6761\u4ef6", "value": "\u624b\u518c\u672a\u4e3a\u6b64\u89c6\u56fe\u8bb0\u8f7d stats_reset \u5b57\u6bb5"}], "sections": [{"title": "\u89c6\u56fe\u8bed\u4e49", "paragraphs": ["\u6bcf\u5f53\u8fd0\u884c CREATE INDEX \u6216 REINDEX \u65f6\uff0c pg_stat_progress_create_index \u89c6\u56fe\u5c06\u5305\u542b\u5f53\u524d\u6b63\u5728\u521b\u5efa\u7d22\u5f15\u7684\u6bcf\u4e2a\u540e\u7aef\u7684\u4e00\u884c\u3002\u4e0b\u9762\u7684\u8868\u63cf\u8ff0\u4e86\u5c06\u8981\u62a5\u544a\u7684\u4fe1\u606f\uff0c\u5e76\u63d0\u4f9b\u4e86\u5173\u4e8e\u5982\u4f55\u89e3\u91ca\u5b83\u7684\u4fe1\u606f\u3002"]}, {"title": "\u91c7\u96c6\u4e0e\u91cd\u7f6e\u8bed\u4e49", "paragraphs": ["\u91cd\u7f6e\u8303\u56f4\u548c\u53ef\u89c1\u6027\u8bf7\u53c2\u9605\u4e0b\u65b9\u540c\u7248\u672c\u7684\u7edf\u8ba1\u4fe1\u606f\u6536\u96c6\u4e0e\u89c6\u56fe\u6587\u6863\u3002\u4e0d\u6839\u636e\u5b57\u6bb5\u540d\u79f0\u63a8\u65ad\u5404\u5b57\u6bb5\u7684\u91cd\u7f6e\u89c4\u5219\u3002"]}, {"code": "SELECT blocks_done FROM pg_catalog.pg_stat_progress_create_index;", "title": "\u67e5\u770b\u6b64\u5b57\u6bb5", "paragraphs": ["\u793a\u4f8b\u67e5\u8be2\uff1b\u4e0d\u8868\u793a\u5df2\u6267\u884c\uff0c\u4e5f\u4e0d\u63d0\u4f9b\u5b9e\u6d4b\u503c\u3002"]}], "sql_type": "bigint", "center_zh": {"title": "pg_stat_progress_create_index.blocks_done", "locale": "zh-Hans", "source": {"key": "pg_stat_progress_create_index-blocks_done", "locale": "zh-Hans", "version": "17", "text_hash": "124671ad5e2617b3326b2f39ba2f421772b7af9061a9ce66a956c253bc215966", "collection": "metric", "dataset_hash": "7c31b524dfe136022d39a6ae8dcfac6b3bbd5f8fdaf422536599981252aff0c9", "source_database": "center", "source_revision": "dd27f2b3c59e73ed14aa3324901242bf69a032a6347805f274e6260322d42979"}, "payload": {"facts": [{"label": "\u89c6\u56fe", "value": "pg_stat_progress_create_index"}, {"label": "\u5b57\u6bb5", "value": "blocks_done"}, {"label": "SQL \u7c7b\u578b", "value": "bigint"}, {"label": "\u5b57\u6bb5\u5b9a\u4e49\u8bb0\u8f7d\u7684\u5355\u4f4d", "value": "blocks"}, {"label": "\u91cd\u7f6e\u6761\u4ef6", "value": "\u624b\u518c\u672a\u4e3a\u6b64\u89c6\u56fe\u8bb0\u8f7d stats_reset \u5b57\u6bb5"}], "tables": [], "zh_from": {"kind": "same-version-chinese-manual-with-source-derived-structured-summary", "manual": {"url": "/zh/docs/17/progress-reporting.html#", "anchor": "", "column": "blocks_done", "locale": "zh-Hans", "version": "17", "build_id": 105, "page_key": "progress-reporting.html", "extraction": "exact-catalog-field", "source_hash": "f7c1b49817402ea3422f879d5b9a210f4d1940ac2d57303a24dd8e8a5a309a95", "source_revision": "unknown:rendered-translation-baseline", "translation_revision": "git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:7340767258d21c21b36f373f1fff6bab2be18e0daca13a865129db6105c09efd"}, "body_sha256": "5685a7846f6450626272bffb32c61d3b5e4c95caf27ddf10b241824d2234e328", "runtime_rerun": false, "authored_translation": "source-derived-structured-summary", "source_facts_revision": "dd27f2b3c59e73ed14aa3324901242bf69a032a6347805f274e6260322d42979"}, "sections": [{"title": "\u89c6\u56fe\u8bed\u4e49", "paragraphs": ["\u6bcf\u5f53\u8fd0\u884c CREATE INDEX \u6216 REINDEX \u65f6\uff0c pg_stat_progress_create_index \u89c6\u56fe\u5c06\u5305\u542b\u5f53\u524d\u6b63\u5728\u521b\u5efa\u7d22\u5f15\u7684\u6bcf\u4e2a\u540e\u7aef\u7684\u4e00\u884c\u3002\u4e0b\u9762\u7684\u8868\u63cf\u8ff0\u4e86\u5c06\u8981\u62a5\u544a\u7684\u4fe1\u606f\uff0c\u5e76\u63d0\u4f9b\u4e86\u5173\u4e8e\u5982\u4f55\u89e3\u91ca\u5b83\u7684\u4fe1\u606f\u3002"]}, {"title": "\u91c7\u96c6\u4e0e\u91cd\u7f6e\u8bed\u4e49", "paragraphs": ["\u91cd\u7f6e\u8303\u56f4\u548c\u53ef\u89c1\u6027\u8bf7\u53c2\u9605\u4e0b\u65b9\u540c\u7248\u672c\u7684\u7edf\u8ba1\u4fe1\u606f\u6536\u96c6\u4e0e\u89c6\u56fe\u6587\u6863\u3002\u4e0d\u6839\u636e\u5b57\u6bb5\u540d\u79f0\u63a8\u65ad\u5404\u5b57\u6bb5\u7684\u91cd\u7f6e\u89c4\u5219\u3002"]}, {"code": "SELECT blocks_done FROM pg_catalog.pg_stat_progress_create_index;", "title": "\u67e5\u770b\u6b64\u5b57\u6bb5", "paragraphs": ["\u793a\u4f8b\u67e5\u8be2\uff1b\u4e0d\u8868\u793a\u5df2\u6267\u884c\uff0c\u4e5f\u4e0d\u63d0\u4f9b\u5b9e\u6d4b\u503c\u3002"]}], "description_zh": "\u5f53\u524d\u9636\u6bb5\u5df2\u7ecf\u5904\u7406\u7684\u5757\u6570\u91cf\u3002", "description_zh_html": "pg_stat_progress_create_index.blocks_done \u7edf\u8ba1\u5b57\u6bb5\u3002
pg_stat_progress_create_indexblocks_donebigint\u5f53\u524d\u9636\u6bb5\u5df2\u7ecf\u5904\u7406\u7684\u5757\u6570\u91cf\u3002
\u67e5\u770b\u5b8c\u6574\u4e2d\u6587\u624b\u518c\u4e0e\u4e0a\u4e0b\u6587\u3002
"}, "summary": "\u5f53\u524d\u9636\u6bb5\u5df2\u7ecf\u5904\u7406\u7684\u5757\u6570\u91cf\u3002", "version": "17", "link_map": {"/zh/docs/17/progress-reporting.html": "/docs/17/progress-reporting.html"}, "body_html": "pg_stat_progress_create_index.blocks_done \u7edf\u8ba1\u5b57\u6bb5\u3002
pg_stat_progress_create_indexblocks_donebigint\u5f53\u524d\u9636\u6bb5\u5df2\u7ecf\u5904\u7406\u7684\u5757\u6570\u91cf\u3002
\u67e5\u770b\u5b8c\u6574\u4e2d\u6587\u624b\u518c\u4e0e\u4e0a\u4e0b\u6587\u3002
", "body_sha256": "41760ce8c1a5a843ac951df116f2bdf9ba6dd5214f07b97a69193d2f274d0d3a", "content_hash": "124671ad5e2617b3326b2f39ba2f421772b7af9061a9ce66a956c253bc215966", "source_database": "center", "source_revision": "dd27f2b3c59e73ed14aa3324901242bf69a032a6347805f274e6260322d42979"}, "signature": "SELECT blocks_done FROM pg_catalog.pg_stat_progress_create_index;", "tables_zh": [], "documented": true, "description": ["\u5f53\u524d\u9636\u6bb5\u5df2\u7ecf\u5904\u7406\u7684\u5757\u6570\u91cf\u3002"], "manual_html": "", "manual_path": "/docs/17/progress-reporting.html", "sections_zh": [{"title": "\u89c6\u56fe\u8bed\u4e49", "paragraphs": ["\u6bcf\u5f53\u8fd0\u884c CREATE INDEX \u6216 REINDEX \u65f6\uff0c pg_stat_progress_create_index \u89c6\u56fe\u5c06\u5305\u542b\u5f53\u524d\u6b63\u5728\u521b\u5efa\u7d22\u5f15\u7684\u6bcf\u4e2a\u540e\u7aef\u7684\u4e00\u884c\u3002\u4e0b\u9762\u7684\u8868\u63cf\u8ff0\u4e86\u5c06\u8981\u62a5\u544a\u7684\u4fe1\u606f\uff0c\u5e76\u63d0\u4f9b\u4e86\u5173\u4e8e\u5982\u4f55\u89e3\u91ca\u5b83\u7684\u4fe1\u606f\u3002"]}, {"title": "\u91c7\u96c6\u4e0e\u91cd\u7f6e\u8bed\u4e49", "paragraphs": ["\u91cd\u7f6e\u8303\u56f4\u548c\u53ef\u89c1\u6027\u8bf7\u53c2\u9605\u4e0b\u65b9\u540c\u7248\u672c\u7684\u7edf\u8ba1\u4fe1\u606f\u6536\u96c6\u4e0e\u89c6\u56fe\u6587\u6863\u3002\u4e0d\u6839\u636e\u5b57\u6bb5\u540d\u79f0\u63a8\u65ad\u5404\u5b57\u6bb5\u7684\u91cd\u7f6e\u89c4\u5219\u3002"]}, {"code": "SELECT blocks_done FROM pg_catalog.pg_stat_progress_create_index;", "title": "\u67e5\u770b\u6b64\u5b57\u6bb5", "paragraphs": ["\u793a\u4f8b\u67e5\u8be2\uff1b\u4e0d\u8868\u793a\u5df2\u6267\u884c\uff0c\u4e5f\u4e0d\u63d0\u4f9b\u5b9e\u6d4b\u503c\u3002"]}], "source_only": false, "localization": {"status": "complete", "sources": [{"url": "/docs/17/progress-reporting.html", "method": "same-major semantic node", "sha256": "0862f80ecc511db94c79ff555f4aee1d500d75648c4654f5aedc0679ffb978f9", "language": "zh", "matched_nodes": ["#PROGRESS-REPORTING/div[6]/div[3]/div[1]/table[0]/tbody[2]/tr[11]/td[0]/p[1]", "#PROGRESS-REPORTING/div[6]/p[2]"]}], "language": "zh", "original_text": {"/versions/17/description/0": "Number of blocks already processed in the current phase.", "/versions/17/facts/0/label": "View", "/versions/17/facts/1/label": "Field", "/versions/17/facts/2/label": "SQL type", "/versions/17/facts/3/label": "Units named in the field definition", "/versions/17/facts/4/label": "Reset observation", "/versions/17/facts/4/value": "No stats_reset field is documented for this view", "/versions/17/related/0/label": "pg_stat_progress_create_index columns", "/versions/17/related/1/label": "Statistics collection and reset functions", "/versions/17/sections/0/title": "View semantics", "/versions/17/sections/1/title": "Collection and reset context", "/versions/17/sections/2/title": "Inspect this field", "/versions/17/sections/0/paragraphs/0": "Whenever CREATE INDEX or REINDEX is running, the pg_stat_progress_create_index view will contain one row for each backend that is currently creating indexes. The tables below describe the information that will be reported and provide information about how to interpret it.", "/versions/17/sections/1/paragraphs/0": "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.", "/versions/17/sections/2/paragraphs/0": "Example query; no execution result or measured value is asserted."}, "fallback_fields": [], "source_language": "en", "original_snapshot_sha256": "1d47da09d5ec9ed73e8c439d46ea6698690dfb720238ed40118a4fd29b1d0cbc", "canonical_center_text_hash": "124671ad5e2617b3326b2f39ba2f421772b7af9061a9ce66a956c253bc215966"}, "description_zh": "\u5f53\u524d\u9636\u6bb5\u5df2\u7ecf\u5904\u7406\u7684\u5757\u6570\u91cf\u3002", "comparison_data": {"view": "pg_stat_progress_create_index", "field": "blocks_done", "sql_type": "bigint", "units_mentioned": ["blocks"]}, "comparison_hash": "d2aa38d3839903b88fd0f5ab16015167de8f74a86068ea91d874c18a9ee2ac5a", "manual_language": "zh", "units_mentioned": ["blocks"], "description_zh_html": "pg_stat_progress_create_index.blocks_done \u7edf\u8ba1\u5b57\u6bb5\u3002
pg_stat_progress_create_indexblocks_donebigint\u5f53\u524d\u9636\u6bb5\u5df2\u7ecf\u5904\u7406\u7684\u5757\u6570\u91cf\u3002
\u67e5\u770b\u5b8c\u6574\u4e2d\u6587\u624b\u518c\u4e0e\u4e0a\u4e0b\u6587\u3002
"}, "18": {"view": "pg_stat_progress_create_index", "facts": [{"label": "\u89c6\u56fe", "value": "pg_stat_progress_create_index"}, {"label": "\u5b57\u6bb5", "value": "blocks_done"}, {"label": "SQL \u7c7b\u578b", "value": "bigint"}, {"label": "\u5b57\u6bb5\u5b9a\u4e49\u8bb0\u8f7d\u7684\u5355\u4f4d", "value": "blocks"}, {"label": "\u91cd\u7f6e\u6761\u4ef6", "value": "\u624b\u518c\u672a\u4e3a\u6b64\u89c6\u56fe\u8bb0\u8f7d stats_reset \u5b57\u6bb5"}], "field": "blocks_done", "tables": [], "related": [{"url": "/wiki/catalog/pg_stat_progress_create_index/?v=18", "label": "pg_stat_progress_create_index \u5b57\u6bb5"}, {"url": "/docs/18/monitoring-stats.html", "label": "\u7edf\u8ba1\u6536\u96c6\u4e0e\u91cd\u7f6e\u51fd\u6570"}], "release": {"ref": "https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2", "label": "18.6", "major": "18", "channel": "stable", "revision": "555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f"}, "sources": [{"url": "/docs/18/progress-reporting.html#PG-STAT-PROGRESS-CREATE-INDEX-VIEW", "path": "progress-reporting.html", "label": "PostgreSQL 18 English manual", "sha256": "a1f46d2b670502bfe75f1cf5192050ef2ef68202a8f928c4915abea0f4f71ae6"}], "zh_from": {"kind": "same-version-chinese-manual-with-source-derived-structured-summary", "manual": {"url": "/zh/docs/18/progress-reporting.html#", "anchor": "", "column": "blocks_done", "locale": "zh-Hans", "version": "18", "build_id": 107, "page_key": "progress-reporting.html", "extraction": "exact-catalog-field", "source_hash": "59d508f5be60d650bf0ed9ec10531162651c9eb030752aec3874544e10c879e2", "source_revision": "unknown:rendered-translation-baseline", "translation_revision": "git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:08e987a66af27b98444a8057c256314eafa13611a3fb9e888214fc436824244b"}, "body_sha256": "410738e63017a2441b996f3e0ca96cd2b315b2237c8566bfe9055fa14318ca93", "runtime_rerun": false, "authored_translation": "source-derived-structured-summary", "source_facts_revision": "555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f"}, "facts_zh": [{"label": "\u89c6\u56fe", "value": "pg_stat_progress_create_index"}, {"label": "\u5b57\u6bb5", "value": "blocks_done"}, {"label": "SQL \u7c7b\u578b", "value": "bigint"}, {"label": "\u5b57\u6bb5\u5b9a\u4e49\u8bb0\u8f7d\u7684\u5355\u4f4d", "value": "blocks"}, {"label": "\u91cd\u7f6e\u6761\u4ef6", "value": "\u624b\u518c\u672a\u4e3a\u6b64\u89c6\u56fe\u8bb0\u8f7d stats_reset \u5b57\u6bb5"}], "sections": [{"title": "\u89c6\u56fe\u8bed\u4e49", "paragraphs": ["\u6bcf\u5f53\u8fd0\u884c CREATE INDEX \u6216 REINDEX \u65f6\uff0c pg_stat_progress_create_index \u89c6\u56fe\u5c06\u5305\u542b\u5f53\u524d\u6b63\u5728\u521b\u5efa\u7d22\u5f15\u7684\u6bcf\u4e2a\u540e\u7aef\u7684\u4e00\u884c\u3002\u4e0b\u9762\u7684\u8868\u63cf\u8ff0\u4e86\u5c06\u8981\u62a5\u544a\u7684\u4fe1\u606f\uff0c\u5e76\u63d0\u4f9b\u4e86\u5173\u4e8e\u5982\u4f55\u89e3\u91ca\u5b83\u7684\u4fe1\u606f\u3002"]}, {"title": "\u91c7\u96c6\u4e0e\u91cd\u7f6e\u8bed\u4e49", "paragraphs": ["\u91cd\u7f6e\u8303\u56f4\u548c\u53ef\u89c1\u6027\u8bf7\u53c2\u9605\u4e0b\u65b9\u540c\u7248\u672c\u7684\u7edf\u8ba1\u4fe1\u606f\u6536\u96c6\u4e0e\u89c6\u56fe\u6587\u6863\u3002\u4e0d\u6839\u636e\u5b57\u6bb5\u540d\u79f0\u63a8\u65ad\u5404\u5b57\u6bb5\u7684\u91cd\u7f6e\u89c4\u5219\u3002"]}, {"code": "SELECT blocks_done FROM pg_catalog.pg_stat_progress_create_index;", "title": "\u67e5\u770b\u6b64\u5b57\u6bb5", "paragraphs": ["\u793a\u4f8b\u67e5\u8be2\uff1b\u4e0d\u8868\u793a\u5df2\u6267\u884c\uff0c\u4e5f\u4e0d\u63d0\u4f9b\u5b9e\u6d4b\u503c\u3002"]}], "sql_type": "bigint", "center_zh": {"title": "pg_stat_progress_create_index.blocks_done", "locale": "zh-Hans", "source": {"key": "pg_stat_progress_create_index-blocks_done", "locale": "zh-Hans", "version": "18", "text_hash": "ff756f0728b39cc573fc2659039e9b59d3e59344c395d2cfe59096ae0f311957", "collection": "metric", "dataset_hash": "7c31b524dfe136022d39a6ae8dcfac6b3bbd5f8fdaf422536599981252aff0c9", "source_database": "center", "source_revision": "555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f"}, "payload": {"facts": [{"label": "\u89c6\u56fe", "value": "pg_stat_progress_create_index"}, {"label": "\u5b57\u6bb5", "value": "blocks_done"}, {"label": "SQL \u7c7b\u578b", "value": "bigint"}, {"label": "\u5b57\u6bb5\u5b9a\u4e49\u8bb0\u8f7d\u7684\u5355\u4f4d", "value": "blocks"}, {"label": "\u91cd\u7f6e\u6761\u4ef6", "value": "\u624b\u518c\u672a\u4e3a\u6b64\u89c6\u56fe\u8bb0\u8f7d stats_reset \u5b57\u6bb5"}], "tables": [], "zh_from": {"kind": "same-version-chinese-manual-with-source-derived-structured-summary", "manual": {"url": "/zh/docs/18/progress-reporting.html#", "anchor": "", "column": "blocks_done", "locale": "zh-Hans", "version": "18", "build_id": 107, "page_key": "progress-reporting.html", "extraction": "exact-catalog-field", "source_hash": "59d508f5be60d650bf0ed9ec10531162651c9eb030752aec3874544e10c879e2", "source_revision": "unknown:rendered-translation-baseline", "translation_revision": "git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:08e987a66af27b98444a8057c256314eafa13611a3fb9e888214fc436824244b"}, "body_sha256": "410738e63017a2441b996f3e0ca96cd2b315b2237c8566bfe9055fa14318ca93", "runtime_rerun": false, "authored_translation": "source-derived-structured-summary", "source_facts_revision": "555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f"}, "sections": [{"title": "\u89c6\u56fe\u8bed\u4e49", "paragraphs": ["\u6bcf\u5f53\u8fd0\u884c CREATE INDEX \u6216 REINDEX \u65f6\uff0c pg_stat_progress_create_index \u89c6\u56fe\u5c06\u5305\u542b\u5f53\u524d\u6b63\u5728\u521b\u5efa\u7d22\u5f15\u7684\u6bcf\u4e2a\u540e\u7aef\u7684\u4e00\u884c\u3002\u4e0b\u9762\u7684\u8868\u63cf\u8ff0\u4e86\u5c06\u8981\u62a5\u544a\u7684\u4fe1\u606f\uff0c\u5e76\u63d0\u4f9b\u4e86\u5173\u4e8e\u5982\u4f55\u89e3\u91ca\u5b83\u7684\u4fe1\u606f\u3002"]}, {"title": "\u91c7\u96c6\u4e0e\u91cd\u7f6e\u8bed\u4e49", "paragraphs": ["\u91cd\u7f6e\u8303\u56f4\u548c\u53ef\u89c1\u6027\u8bf7\u53c2\u9605\u4e0b\u65b9\u540c\u7248\u672c\u7684\u7edf\u8ba1\u4fe1\u606f\u6536\u96c6\u4e0e\u89c6\u56fe\u6587\u6863\u3002\u4e0d\u6839\u636e\u5b57\u6bb5\u540d\u79f0\u63a8\u65ad\u5404\u5b57\u6bb5\u7684\u91cd\u7f6e\u89c4\u5219\u3002"]}, {"code": "SELECT blocks_done FROM pg_catalog.pg_stat_progress_create_index;", "title": "\u67e5\u770b\u6b64\u5b57\u6bb5", "paragraphs": ["\u793a\u4f8b\u67e5\u8be2\uff1b\u4e0d\u8868\u793a\u5df2\u6267\u884c\uff0c\u4e5f\u4e0d\u63d0\u4f9b\u5b9e\u6d4b\u503c\u3002"]}], "description_zh": "\u5f53\u524d\u9636\u6bb5\u5df2\u7ecf\u5904\u7406\u7684\u5757\u6570\u91cf\u3002", "description_zh_html": "pg_stat_progress_create_index.blocks_done \u7edf\u8ba1\u5b57\u6bb5\u3002
pg_stat_progress_create_indexblocks_donebigint\u5f53\u524d\u9636\u6bb5\u5df2\u7ecf\u5904\u7406\u7684\u5757\u6570\u91cf\u3002
\u67e5\u770b\u5b8c\u6574\u4e2d\u6587\u624b\u518c\u4e0e\u4e0a\u4e0b\u6587\u3002
"}, "summary": "\u5f53\u524d\u9636\u6bb5\u5df2\u7ecf\u5904\u7406\u7684\u5757\u6570\u91cf\u3002", "version": "18", "link_map": {"/zh/docs/18/progress-reporting.html": "/docs/18/progress-reporting.html"}, "body_html": "pg_stat_progress_create_index.blocks_done \u7edf\u8ba1\u5b57\u6bb5\u3002
pg_stat_progress_create_indexblocks_donebigint\u5f53\u524d\u9636\u6bb5\u5df2\u7ecf\u5904\u7406\u7684\u5757\u6570\u91cf\u3002
\u67e5\u770b\u5b8c\u6574\u4e2d\u6587\u624b\u518c\u4e0e\u4e0a\u4e0b\u6587\u3002
", "body_sha256": "0eb19ebc28714de0f7627eedf6c4459307e5171518253039951e3a53321bf05f", "content_hash": "ff756f0728b39cc573fc2659039e9b59d3e59344c395d2cfe59096ae0f311957", "source_database": "center", "source_revision": "555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f"}, "signature": "SELECT blocks_done FROM pg_catalog.pg_stat_progress_create_index;", "tables_zh": [], "documented": true, "description": ["\u5f53\u524d\u9636\u6bb5\u5df2\u7ecf\u5904\u7406\u7684\u5757\u6570\u91cf\u3002"], "manual_html": "", "manual_path": "/docs/18/progress-reporting.html", "sections_zh": [{"title": "\u89c6\u56fe\u8bed\u4e49", "paragraphs": ["\u6bcf\u5f53\u8fd0\u884c CREATE INDEX \u6216 REINDEX \u65f6\uff0c pg_stat_progress_create_index \u89c6\u56fe\u5c06\u5305\u542b\u5f53\u524d\u6b63\u5728\u521b\u5efa\u7d22\u5f15\u7684\u6bcf\u4e2a\u540e\u7aef\u7684\u4e00\u884c\u3002\u4e0b\u9762\u7684\u8868\u63cf\u8ff0\u4e86\u5c06\u8981\u62a5\u544a\u7684\u4fe1\u606f\uff0c\u5e76\u63d0\u4f9b\u4e86\u5173\u4e8e\u5982\u4f55\u89e3\u91ca\u5b83\u7684\u4fe1\u606f\u3002"]}, {"title": "\u91c7\u96c6\u4e0e\u91cd\u7f6e\u8bed\u4e49", "paragraphs": ["\u91cd\u7f6e\u8303\u56f4\u548c\u53ef\u89c1\u6027\u8bf7\u53c2\u9605\u4e0b\u65b9\u540c\u7248\u672c\u7684\u7edf\u8ba1\u4fe1\u606f\u6536\u96c6\u4e0e\u89c6\u56fe\u6587\u6863\u3002\u4e0d\u6839\u636e\u5b57\u6bb5\u540d\u79f0\u63a8\u65ad\u5404\u5b57\u6bb5\u7684\u91cd\u7f6e\u89c4\u5219\u3002"]}, {"code": "SELECT blocks_done FROM pg_catalog.pg_stat_progress_create_index;", "title": "\u67e5\u770b\u6b64\u5b57\u6bb5", "paragraphs": ["\u793a\u4f8b\u67e5\u8be2\uff1b\u4e0d\u8868\u793a\u5df2\u6267\u884c\uff0c\u4e5f\u4e0d\u63d0\u4f9b\u5b9e\u6d4b\u503c\u3002"]}], "source_only": false, "localization": {"status": "complete", "sources": [{"url": "/docs/18/progress-reporting.html", "method": "same-major semantic node", "sha256": "e048c6f8e5f62a236a2f447167452c4109b22828b67f6b22560940ea000cd007", "language": "zh", "matched_nodes": ["#PROGRESS-REPORTING/div[6]/div[3]/div[1]/table[0]/tbody[2]/tr[11]/td[0]/p[1]", "#PROGRESS-REPORTING/div[6]/p[2]"]}], "language": "zh", "original_text": {"/versions/18/description/0": "Number of blocks already processed in the current phase.", "/versions/18/facts/0/label": "View", "/versions/18/facts/1/label": "Field", "/versions/18/facts/2/label": "SQL type", "/versions/18/facts/3/label": "Units named in the field definition", "/versions/18/facts/4/label": "Reset observation", "/versions/18/facts/4/value": "No stats_reset field is documented for this view", "/versions/18/related/0/label": "pg_stat_progress_create_index columns", "/versions/18/related/1/label": "Statistics collection and reset functions", "/versions/18/sections/0/title": "View semantics", "/versions/18/sections/1/title": "Collection and reset context", "/versions/18/sections/2/title": "Inspect this field", "/versions/18/sections/0/paragraphs/0": "Whenever CREATE INDEX or REINDEX is running, the pg_stat_progress_create_index view will contain one row for each backend that is currently creating indexes. The tables below describe the information that will be reported and provide information about how to interpret it.", "/versions/18/sections/1/paragraphs/0": "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.", "/versions/18/sections/2/paragraphs/0": "Example query; no execution result or measured value is asserted."}, "fallback_fields": [], "source_language": "en", "original_snapshot_sha256": "dd5e59bb71b079d312e64e4f466f64d82e92a0d43070df68cb316e846e9f5a0c", "canonical_center_text_hash": "ff756f0728b39cc573fc2659039e9b59d3e59344c395d2cfe59096ae0f311957"}, "description_zh": "\u5f53\u524d\u9636\u6bb5\u5df2\u7ecf\u5904\u7406\u7684\u5757\u6570\u91cf\u3002", "comparison_data": {"view": "pg_stat_progress_create_index", "field": "blocks_done", "sql_type": "bigint", "units_mentioned": ["blocks"]}, "comparison_hash": "d2aa38d3839903b88fd0f5ab16015167de8f74a86068ea91d874c18a9ee2ac5a", "manual_language": "zh", "units_mentioned": ["blocks"], "description_zh_html": "pg_stat_progress_create_index.blocks_done \u7edf\u8ba1\u5b57\u6bb5\u3002
pg_stat_progress_create_indexblocks_donebigint\u5f53\u524d\u9636\u6bb5\u5df2\u7ecf\u5904\u7406\u7684\u5757\u6570\u91cf\u3002
\u67e5\u770b\u5b8c\u6574\u4e2d\u6587\u624b\u518c\u4e0e\u4e0a\u4e0b\u6587\u3002
", "center_zh_rendered": "pg_stat_progress_create_index.blocks_done \u7edf\u8ba1\u5b57\u6bb5\u3002
pg_stat_progress_create_indexblocks_donebigint\u5f53\u524d\u9636\u6bb5\u5df2\u7ecf\u5904\u7406\u7684\u5757\u6570\u91cf\u3002
\u67e5\u770b\u5b8c\u6574\u4e2d\u6587\u624b\u518c\u4e0e\u4e0a\u4e0b\u6587\u3002
"}, "19": {"view": "pg_stat_progress_create_index", "facts": [{"label": "\u89c6\u56fe", "value": "pg_stat_progress_create_index"}, {"label": "\u5b57\u6bb5", "value": "blocks_done"}, {"label": "SQL \u7c7b\u578b", "value": "bigint"}, {"label": "\u5b57\u6bb5\u5b9a\u4e49\u8bb0\u8f7d\u7684\u5355\u4f4d", "value": "blocks"}, {"label": "\u91cd\u7f6e\u6761\u4ef6", "value": "\u624b\u518c\u672a\u4e3a\u6b64\u89c6\u56fe\u8bb0\u8f7d stats_reset \u5b57\u6bb5"}], "field": "blocks_done", "tables": [], "related": [{"url": "/wiki/catalog/pg_stat_progress_create_index/?v=19", "label": "pg_stat_progress_create_index \u5b57\u6bb5"}, {"url": "/docs/19/monitoring-stats.html", "label": "\u7edf\u8ba1\u6536\u96c6\u4e0e\u91cd\u7f6e\u51fd\u6570"}], "release": {"ref": "https://ftp.postgresql.org/pub/source/v19rc1/postgresql-19rc1.tar.bz2", "label": "19rc1", "major": "19", "channel": "preview", "revision": "af105fc8e960fc836a09fc2cd7f582b49fd17675d9d36631abe3a565bfd7d701", "source_sha256": "af105fc8e960fc836a09fc2cd7f582b49fd17675d9d36631abe3a565bfd7d701", "manual_fingerprint": "63afc6091780ed5e52920ff9ef5adb6aa7dfcc82f8f413ed36ad46095788488d", "catalog_fingerprint": "da7a8a4e03b72cd120b91ffdff4265e065ccad9eab9964fc3eb1279a58464eb8"}, "sources": [{"url": "/docs/19/progress-reporting.html#PG-STAT-PROGRESS-CREATE-INDEX-VIEW", "path": "progress-reporting.html", "label": "PostgreSQL 19 English manual", "sha256": "a3e8a5f0d495be9d98a6dde9e97f33d6fa6c6234cbd07a84adbe5db9e17cc325"}], "zh_from": {"kind": "same-version-chinese-manual-with-source-derived-structured-summary", "manual": {"url": "/zh/docs/19/progress-reporting.html#", "anchor": "", "column": "blocks_done", "locale": "zh-Hans", "version": "19", "build_id": 109, "page_key": "progress-reporting.html", "extraction": "exact-catalog-field", "source_hash": "68f57fbe44224848e975180977217d3ffd646ab8610b899c1fb4615b189e2c13", "source_revision": "sha256:af105fc8e960fc836a09fc2cd7f582b49fd17675d9d36631abe3a565bfd7d701", "translation_revision": "git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:65fda1f1b62a89992b84014c9157e61b67dbe8190e93945826efec668fad038c"}, "body_sha256": "0a4c6d4d802839ae97343cbfe87ba84381a974a7bec3b9a589e4dd6fc6c9ebdc", "runtime_rerun": false, "authored_translation": "source-derived-structured-summary", "source_facts_revision": "af105fc8e960fc836a09fc2cd7f582b49fd17675d9d36631abe3a565bfd7d701"}, "facts_zh": [{"label": "\u89c6\u56fe", "value": "pg_stat_progress_create_index"}, {"label": "\u5b57\u6bb5", "value": "blocks_done"}, {"label": "SQL \u7c7b\u578b", "value": "bigint"}, {"label": "\u5b57\u6bb5\u5b9a\u4e49\u8bb0\u8f7d\u7684\u5355\u4f4d", "value": "blocks"}, {"label": "\u91cd\u7f6e\u6761\u4ef6", "value": "\u624b\u518c\u672a\u4e3a\u6b64\u89c6\u56fe\u8bb0\u8f7d stats_reset \u5b57\u6bb5"}], "sections": [{"title": "\u89c6\u56fe\u8bed\u4e49", "paragraphs": ["\u6bcf\u5f53\u8fd0\u884c CREATE INDEX \u6216 REINDEX \u65f6\uff0c pg_stat_progress_create_index \u89c6\u56fe\u5c06\u5305\u542b\u5f53\u524d\u6b63\u5728\u521b\u5efa\u7d22\u5f15\u7684\u6bcf\u4e2a\u540e\u7aef\u7684\u4e00\u884c\u3002\u4e0b\u9762\u7684\u8868\u63cf\u8ff0\u4e86\u5c06\u8981\u62a5\u544a\u7684\u4fe1\u606f\uff0c\u5e76\u63d0\u4f9b\u4e86\u5173\u4e8e\u5982\u4f55\u89e3\u91ca\u5b83\u7684\u4fe1\u606f\u3002"]}, {"title": "\u91c7\u96c6\u4e0e\u91cd\u7f6e\u8bed\u4e49", "paragraphs": ["\u91cd\u7f6e\u8303\u56f4\u548c\u53ef\u89c1\u6027\u8bf7\u53c2\u9605\u4e0b\u65b9\u540c\u7248\u672c\u7684\u7edf\u8ba1\u4fe1\u606f\u6536\u96c6\u4e0e\u89c6\u56fe\u6587\u6863\u3002\u4e0d\u6839\u636e\u5b57\u6bb5\u540d\u79f0\u63a8\u65ad\u5404\u5b57\u6bb5\u7684\u91cd\u7f6e\u89c4\u5219\u3002"]}, {"code": "SELECT blocks_done FROM pg_catalog.pg_stat_progress_create_index;", "title": "\u67e5\u770b\u6b64\u5b57\u6bb5", "paragraphs": ["\u793a\u4f8b\u67e5\u8be2\uff1b\u4e0d\u8868\u793a\u5df2\u6267\u884c\uff0c\u4e5f\u4e0d\u63d0\u4f9b\u5b9e\u6d4b\u503c\u3002"]}], "sql_type": "bigint", "center_zh": {"title": "pg_stat_progress_create_index.blocks_done", "locale": "zh-Hans", "source": {"key": "pg_stat_progress_create_index-blocks_done", "locale": "zh-Hans", "version": "19", "text_hash": "cd3282838393d4a11056f5616fa814f52fab10f427100a06a6ec1c18e679e9c0", "collection": "metric", "dataset_hash": "7c31b524dfe136022d39a6ae8dcfac6b3bbd5f8fdaf422536599981252aff0c9", "source_database": "center", "source_revision": "af105fc8e960fc836a09fc2cd7f582b49fd17675d9d36631abe3a565bfd7d701"}, "payload": {"facts": [{"label": "\u89c6\u56fe", "value": "pg_stat_progress_create_index"}, {"label": "\u5b57\u6bb5", "value": "blocks_done"}, {"label": "SQL \u7c7b\u578b", "value": "bigint"}, {"label": "\u5b57\u6bb5\u5b9a\u4e49\u8bb0\u8f7d\u7684\u5355\u4f4d", "value": "blocks"}, {"label": "\u91cd\u7f6e\u6761\u4ef6", "value": "\u624b\u518c\u672a\u4e3a\u6b64\u89c6\u56fe\u8bb0\u8f7d stats_reset \u5b57\u6bb5"}], "tables": [], "zh_from": {"kind": "same-version-chinese-manual-with-source-derived-structured-summary", "manual": {"url": "/zh/docs/19/progress-reporting.html#", "anchor": "", "column": "blocks_done", "locale": "zh-Hans", "version": "19", "build_id": 109, "page_key": "progress-reporting.html", "extraction": "exact-catalog-field", "source_hash": "68f57fbe44224848e975180977217d3ffd646ab8610b899c1fb4615b189e2c13", "source_revision": "sha256:af105fc8e960fc836a09fc2cd7f582b49fd17675d9d36631abe3a565bfd7d701", "translation_revision": "git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:65fda1f1b62a89992b84014c9157e61b67dbe8190e93945826efec668fad038c"}, "body_sha256": "0a4c6d4d802839ae97343cbfe87ba84381a974a7bec3b9a589e4dd6fc6c9ebdc", "runtime_rerun": false, "authored_translation": "source-derived-structured-summary", "source_facts_revision": "af105fc8e960fc836a09fc2cd7f582b49fd17675d9d36631abe3a565bfd7d701"}, "sections": [{"title": "\u89c6\u56fe\u8bed\u4e49", "paragraphs": ["\u6bcf\u5f53\u8fd0\u884c CREATE INDEX \u6216 REINDEX \u65f6\uff0c pg_stat_progress_create_index \u89c6\u56fe\u5c06\u5305\u542b\u5f53\u524d\u6b63\u5728\u521b\u5efa\u7d22\u5f15\u7684\u6bcf\u4e2a\u540e\u7aef\u7684\u4e00\u884c\u3002\u4e0b\u9762\u7684\u8868\u63cf\u8ff0\u4e86\u5c06\u8981\u62a5\u544a\u7684\u4fe1\u606f\uff0c\u5e76\u63d0\u4f9b\u4e86\u5173\u4e8e\u5982\u4f55\u89e3\u91ca\u5b83\u7684\u4fe1\u606f\u3002"]}, {"title": "\u91c7\u96c6\u4e0e\u91cd\u7f6e\u8bed\u4e49", "paragraphs": ["\u91cd\u7f6e\u8303\u56f4\u548c\u53ef\u89c1\u6027\u8bf7\u53c2\u9605\u4e0b\u65b9\u540c\u7248\u672c\u7684\u7edf\u8ba1\u4fe1\u606f\u6536\u96c6\u4e0e\u89c6\u56fe\u6587\u6863\u3002\u4e0d\u6839\u636e\u5b57\u6bb5\u540d\u79f0\u63a8\u65ad\u5404\u5b57\u6bb5\u7684\u91cd\u7f6e\u89c4\u5219\u3002"]}, {"code": "SELECT blocks_done FROM pg_catalog.pg_stat_progress_create_index;", "title": "\u67e5\u770b\u6b64\u5b57\u6bb5", "paragraphs": ["\u793a\u4f8b\u67e5\u8be2\uff1b\u4e0d\u8868\u793a\u5df2\u6267\u884c\uff0c\u4e5f\u4e0d\u63d0\u4f9b\u5b9e\u6d4b\u503c\u3002"]}], "description_zh": "\u5f53\u524d\u9636\u6bb5\u5df2\u7ecf\u5904\u7406\u7684\u5757\u6570\u91cf\u3002", "description_zh_html": "pg_stat_progress_create_index.blocks_done \u7edf\u8ba1\u5b57\u6bb5\u3002
pg_stat_progress_create_indexblocks_donebigint\u5f53\u524d\u9636\u6bb5\u5df2\u7ecf\u5904\u7406\u7684\u5757\u6570\u91cf\u3002
\u67e5\u770b\u5b8c\u6574\u4e2d\u6587\u624b\u518c\u4e0e\u4e0a\u4e0b\u6587\u3002
"}, "summary": "\u5f53\u524d\u9636\u6bb5\u5df2\u7ecf\u5904\u7406\u7684\u5757\u6570\u91cf\u3002", "version": "19", "link_map": {"/zh/docs/19/progress-reporting.html": "/docs/19/progress-reporting.html"}, "body_html": "pg_stat_progress_create_index.blocks_done \u7edf\u8ba1\u5b57\u6bb5\u3002
pg_stat_progress_create_indexblocks_donebigint\u5f53\u524d\u9636\u6bb5\u5df2\u7ecf\u5904\u7406\u7684\u5757\u6570\u91cf\u3002
\u67e5\u770b\u5b8c\u6574\u4e2d\u6587\u624b\u518c\u4e0e\u4e0a\u4e0b\u6587\u3002
", "body_sha256": "de03c6098353ee178a379a703ba3bc9959e96901c9d8667ac37ab2f9ffbf3103", "content_hash": "cd3282838393d4a11056f5616fa814f52fab10f427100a06a6ec1c18e679e9c0", "source_database": "center", "source_revision": "af105fc8e960fc836a09fc2cd7f582b49fd17675d9d36631abe3a565bfd7d701"}, "signature": "SELECT blocks_done FROM pg_catalog.pg_stat_progress_create_index;", "tables_zh": [], "documented": true, "description": ["\u5f53\u524d\u9636\u6bb5\u5df2\u7ecf\u5904\u7406\u7684\u5757\u6570\u91cf\u3002"], "manual_html": "", "manual_path": "/docs/19/progress-reporting.html", "sections_zh": [{"title": "\u89c6\u56fe\u8bed\u4e49", "paragraphs": ["\u6bcf\u5f53\u8fd0\u884c CREATE INDEX \u6216 REINDEX \u65f6\uff0c pg_stat_progress_create_index \u89c6\u56fe\u5c06\u5305\u542b\u5f53\u524d\u6b63\u5728\u521b\u5efa\u7d22\u5f15\u7684\u6bcf\u4e2a\u540e\u7aef\u7684\u4e00\u884c\u3002\u4e0b\u9762\u7684\u8868\u63cf\u8ff0\u4e86\u5c06\u8981\u62a5\u544a\u7684\u4fe1\u606f\uff0c\u5e76\u63d0\u4f9b\u4e86\u5173\u4e8e\u5982\u4f55\u89e3\u91ca\u5b83\u7684\u4fe1\u606f\u3002"]}, {"title": "\u91c7\u96c6\u4e0e\u91cd\u7f6e\u8bed\u4e49", "paragraphs": ["\u91cd\u7f6e\u8303\u56f4\u548c\u53ef\u89c1\u6027\u8bf7\u53c2\u9605\u4e0b\u65b9\u540c\u7248\u672c\u7684\u7edf\u8ba1\u4fe1\u606f\u6536\u96c6\u4e0e\u89c6\u56fe\u6587\u6863\u3002\u4e0d\u6839\u636e\u5b57\u6bb5\u540d\u79f0\u63a8\u65ad\u5404\u5b57\u6bb5\u7684\u91cd\u7f6e\u89c4\u5219\u3002"]}, {"code": "SELECT blocks_done FROM pg_catalog.pg_stat_progress_create_index;", "title": "\u67e5\u770b\u6b64\u5b57\u6bb5", "paragraphs": ["\u793a\u4f8b\u67e5\u8be2\uff1b\u4e0d\u8868\u793a\u5df2\u6267\u884c\uff0c\u4e5f\u4e0d\u63d0\u4f9b\u5b9e\u6d4b\u503c\u3002"]}], "source_only": false, "localization": {"status": "complete", "sources": [{"url": "/docs/19/progress-reporting.html", "method": "same-major semantic node", "sha256": "bd55199c5401fddaa8a8ecca7a61f5c3f4223dccd138f288be452d1fede00215", "language": "zh", "matched_nodes": ["#PROGRESS-REPORTING/div[6]/div[3]/div[1]/table[0]/tbody[2]/tr[11]/td[0]/p[1]", "#PROGRESS-REPORTING/div[6]/p[2]"]}], "language": "zh", "original_text": {"/versions/19/description/0": "Number of blocks already processed in the current phase.", "/versions/19/facts/0/label": "View", "/versions/19/facts/1/label": "Field", "/versions/19/facts/2/label": "SQL type", "/versions/19/facts/3/label": "Units named in the field definition", "/versions/19/facts/4/label": "Reset observation", "/versions/19/facts/4/value": "No stats_reset field is documented for this view", "/versions/19/related/0/label": "pg_stat_progress_create_index columns", "/versions/19/related/1/label": "Statistics collection and reset functions", "/versions/19/sections/0/title": "View semantics", "/versions/19/sections/1/title": "Collection and reset context", "/versions/19/sections/2/title": "Inspect this field", "/versions/19/sections/0/paragraphs/0": "Whenever CREATE INDEX or REINDEX is running, the pg_stat_progress_create_index view will contain one row for each backend that is currently creating indexes. The tables below describe the information that will be reported and provide information about how to interpret it.", "/versions/19/sections/1/paragraphs/0": "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.", "/versions/19/sections/2/paragraphs/0": "Example query; no execution result or measured value is asserted."}, "fallback_fields": [], "source_language": "en", "original_snapshot_sha256": "8412ece8acafe629b6f63e552f9a80e5a28a2f735dcdbf2b387ed886a2c7dc89", "canonical_center_text_hash": "cd3282838393d4a11056f5616fa814f52fab10f427100a06a6ec1c18e679e9c0"}, "description_zh": "\u5f53\u524d\u9636\u6bb5\u5df2\u7ecf\u5904\u7406\u7684\u5757\u6570\u91cf\u3002", "comparison_data": {"view": "pg_stat_progress_create_index", "field": "blocks_done", "sql_type": "bigint", "units_mentioned": ["blocks"]}, "comparison_hash": "d2aa38d3839903b88fd0f5ab16015167de8f74a86068ea91d874c18a9ee2ac5a", "manual_language": "zh", "units_mentioned": ["blocks"], "description_zh_html": "pg_stat_progress_create_index.blocks_done \u7edf\u8ba1\u5b57\u6bb5\u3002
pg_stat_progress_create_indexblocks_donebigint\u5f53\u524d\u9636\u6bb5\u5df2\u7ecf\u5904\u7406\u7684\u5757\u6570\u91cf\u3002
\u67e5\u770b\u5b8c\u6574\u4e2d\u6587\u624b\u518c\u4e0e\u4e0a\u4e0b\u6587\u3002
", "source_revalidation": {"kind": "static-same-version-source-and-manual-replay", "audit": "wiki-audit-20261023", "runtime_rerun": false, "compared_fields": "documented field type and description, source-only view expressions", "source_revision": "af105fc8e960fc836a09fc2cd7f582b49fd17675d9d36631abe3a565bfd7d701", "previous_source_revision": "83157ee9c599d03b2f7a3d73ef3a56ec24e0e79cc2b3501a64d1364f56398c86"}}, "20": {"view": "pg_stat_progress_create_index", "facts": [{"label": "\u89c6\u56fe", "value": "pg_stat_progress_create_index"}, {"label": "\u5b57\u6bb5", "value": "blocks_done"}, {"label": "SQL \u7c7b\u578b", "value": "bigint"}, {"label": "\u5b57\u6bb5\u5b9a\u4e49\u8bb0\u8f7d\u7684\u5355\u4f4d", "value": "blocks"}, {"label": "\u91cd\u7f6e\u6761\u4ef6", "value": "\u624b\u518c\u672a\u4e3a\u6b64\u89c6\u56fe\u8bb0\u8f7d stats_reset \u5b57\u6bb5"}], "field": "blocks_done", "tables": [], "related": [{"url": "/wiki/catalog/pg_stat_progress_create_index/?v=20", "label": "pg_stat_progress_create_index \u5b57\u6bb5"}, {"url": "/docs/devel/monitoring-stats.html", "label": "\u7edf\u8ba1\u6536\u96c6\u4e0e\u91cd\u7f6e\u51fd\u6570"}], "release": {"ref": "https://ftp.postgresql.org/pub/snapshot/dev/postgresql-snapshot.tar.bz2", "label": "20devel", "major": "20", "channel": "devel", "revision": "49c73aa4c9cacef8ca979276a28ac416c08e9e54c9baee4ae5fd116a35fa13ac", "source_sha256": "49c73aa4c9cacef8ca979276a28ac416c08e9e54c9baee4ae5fd116a35fa13ac", "manual_fingerprint": "4afd3a8e29953000e176877e161458a2febaeaac5a5e16986595d3acc2418c7d", "catalog_fingerprint": "e519e6916a731ce8fb9bca3edb12410227f73e01ccd43fb6f5fb98276f08985f"}, "sources": [{"url": "/docs/devel/progress-reporting.html#PG-STAT-PROGRESS-CREATE-INDEX-VIEW", "path": "progress-reporting.html", "label": "PostgreSQL 20 English manual", "sha256": "1a819e3e8cc444a8bc7ec04953ac44bdd14f7b7801975f31f966d9f393f40e89"}], "zh_from": {"kind": "same-version-chinese-manual-with-source-derived-structured-summary", "manual": {"url": "/zh/docs/devel/progress-reporting.html#", "anchor": "", "column": "blocks_done", "locale": "zh-Hans", "version": "20", "build_id": 111, "page_key": "progress-reporting.html", "extraction": "exact-catalog-field", "source_hash": "287cf97792261bc15d446c3c9b416e3bde5175b740c390c3b64f5aec64a8cc3c", "source_revision": "sha256:49c73aa4c9cacef8ca979276a28ac416c08e9e54c9baee4ae5fd116a35fa13ac", "translation_revision": "git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:98c980963b401d40bd50df72b909e7523e3148b8fdb48edd897de2efb67e5235"}, "body_sha256": "1de27068ec5561615ef7f0fb0f3eb088aec06f78b880748107511abc39769b7c", "runtime_rerun": false, "authored_translation": "source-derived-structured-summary", "source_facts_revision": "49c73aa4c9cacef8ca979276a28ac416c08e9e54c9baee4ae5fd116a35fa13ac"}, "facts_zh": [{"label": "\u89c6\u56fe", "value": "pg_stat_progress_create_index"}, {"label": "\u5b57\u6bb5", "value": "blocks_done"}, {"label": "SQL \u7c7b\u578b", "value": "bigint"}, {"label": "\u5b57\u6bb5\u5b9a\u4e49\u8bb0\u8f7d\u7684\u5355\u4f4d", "value": "blocks"}, {"label": "\u91cd\u7f6e\u6761\u4ef6", "value": "\u624b\u518c\u672a\u4e3a\u6b64\u89c6\u56fe\u8bb0\u8f7d stats_reset \u5b57\u6bb5"}], "sections": [{"title": "\u89c6\u56fe\u8bed\u4e49", "paragraphs": ["\u6bcf\u5f53\u8fd0\u884c CREATE INDEX \u6216 REINDEX \u65f6\uff0c pg_stat_progress_create_index \u89c6\u56fe\u5c06\u5305\u542b\u5f53\u524d\u6b63\u5728\u521b\u5efa\u7d22\u5f15\u7684\u6bcf\u4e2a\u540e\u7aef\u7684\u4e00\u884c\u3002\u4e0b\u9762\u7684\u8868\u63cf\u8ff0\u4e86\u5c06\u8981\u62a5\u544a\u7684\u4fe1\u606f\uff0c\u5e76\u63d0\u4f9b\u4e86\u5173\u4e8e\u5982\u4f55\u89e3\u91ca\u5b83\u7684\u4fe1\u606f\u3002"]}, {"title": "\u91c7\u96c6\u4e0e\u91cd\u7f6e\u8bed\u4e49", "paragraphs": ["\u91cd\u7f6e\u8303\u56f4\u548c\u53ef\u89c1\u6027\u8bf7\u53c2\u9605\u4e0b\u65b9\u540c\u7248\u672c\u7684\u7edf\u8ba1\u4fe1\u606f\u6536\u96c6\u4e0e\u89c6\u56fe\u6587\u6863\u3002\u4e0d\u6839\u636e\u5b57\u6bb5\u540d\u79f0\u63a8\u65ad\u5404\u5b57\u6bb5\u7684\u91cd\u7f6e\u89c4\u5219\u3002"]}, {"code": "SELECT blocks_done FROM pg_catalog.pg_stat_progress_create_index;", "title": "\u67e5\u770b\u6b64\u5b57\u6bb5", "paragraphs": ["\u793a\u4f8b\u67e5\u8be2\uff1b\u4e0d\u8868\u793a\u5df2\u6267\u884c\uff0c\u4e5f\u4e0d\u63d0\u4f9b\u5b9e\u6d4b\u503c\u3002"]}], "sql_type": "bigint", "center_zh": {"title": "pg_stat_progress_create_index.blocks_done", "locale": "zh-Hans", "source": {"key": "pg_stat_progress_create_index-blocks_done", "locale": "zh-Hans", "version": "20", "text_hash": "a46be4a4861856f7132826c7d676bec124bdf30bd97f807f5bf2ee0a1e6ac90d", "collection": "metric", "dataset_hash": "7c31b524dfe136022d39a6ae8dcfac6b3bbd5f8fdaf422536599981252aff0c9", "source_database": "center", "source_revision": "49c73aa4c9cacef8ca979276a28ac416c08e9e54c9baee4ae5fd116a35fa13ac"}, "payload": {"facts": [{"label": "\u89c6\u56fe", "value": "pg_stat_progress_create_index"}, {"label": "\u5b57\u6bb5", "value": "blocks_done"}, {"label": "SQL \u7c7b\u578b", "value": "bigint"}, {"label": "\u5b57\u6bb5\u5b9a\u4e49\u8bb0\u8f7d\u7684\u5355\u4f4d", "value": "blocks"}, {"label": "\u91cd\u7f6e\u6761\u4ef6", "value": "\u624b\u518c\u672a\u4e3a\u6b64\u89c6\u56fe\u8bb0\u8f7d stats_reset \u5b57\u6bb5"}], "tables": [], "zh_from": {"kind": "same-version-chinese-manual-with-source-derived-structured-summary", "manual": {"url": "/zh/docs/devel/progress-reporting.html#", "anchor": "", "column": "blocks_done", "locale": "zh-Hans", "version": "20", "build_id": 111, "page_key": "progress-reporting.html", "extraction": "exact-catalog-field", "source_hash": "287cf97792261bc15d446c3c9b416e3bde5175b740c390c3b64f5aec64a8cc3c", "source_revision": "sha256:49c73aa4c9cacef8ca979276a28ac416c08e9e54c9baee4ae5fd116a35fa13ac", "translation_revision": "git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:98c980963b401d40bd50df72b909e7523e3148b8fdb48edd897de2efb67e5235"}, "body_sha256": "1de27068ec5561615ef7f0fb0f3eb088aec06f78b880748107511abc39769b7c", "runtime_rerun": false, "authored_translation": "source-derived-structured-summary", "source_facts_revision": "49c73aa4c9cacef8ca979276a28ac416c08e9e54c9baee4ae5fd116a35fa13ac"}, "sections": [{"title": "\u89c6\u56fe\u8bed\u4e49", "paragraphs": ["\u6bcf\u5f53\u8fd0\u884c CREATE INDEX \u6216 REINDEX \u65f6\uff0c pg_stat_progress_create_index \u89c6\u56fe\u5c06\u5305\u542b\u5f53\u524d\u6b63\u5728\u521b\u5efa\u7d22\u5f15\u7684\u6bcf\u4e2a\u540e\u7aef\u7684\u4e00\u884c\u3002\u4e0b\u9762\u7684\u8868\u63cf\u8ff0\u4e86\u5c06\u8981\u62a5\u544a\u7684\u4fe1\u606f\uff0c\u5e76\u63d0\u4f9b\u4e86\u5173\u4e8e\u5982\u4f55\u89e3\u91ca\u5b83\u7684\u4fe1\u606f\u3002"]}, {"title": "\u91c7\u96c6\u4e0e\u91cd\u7f6e\u8bed\u4e49", "paragraphs": ["\u91cd\u7f6e\u8303\u56f4\u548c\u53ef\u89c1\u6027\u8bf7\u53c2\u9605\u4e0b\u65b9\u540c\u7248\u672c\u7684\u7edf\u8ba1\u4fe1\u606f\u6536\u96c6\u4e0e\u89c6\u56fe\u6587\u6863\u3002\u4e0d\u6839\u636e\u5b57\u6bb5\u540d\u79f0\u63a8\u65ad\u5404\u5b57\u6bb5\u7684\u91cd\u7f6e\u89c4\u5219\u3002"]}, {"code": "SELECT blocks_done FROM pg_catalog.pg_stat_progress_create_index;", "title": "\u67e5\u770b\u6b64\u5b57\u6bb5", "paragraphs": ["\u793a\u4f8b\u67e5\u8be2\uff1b\u4e0d\u8868\u793a\u5df2\u6267\u884c\uff0c\u4e5f\u4e0d\u63d0\u4f9b\u5b9e\u6d4b\u503c\u3002"]}], "description_zh": "\u5f53\u524d\u9636\u6bb5\u5df2\u7ecf\u5904\u7406\u7684\u5757\u6570\u91cf\u3002", "description_zh_html": "pg_stat_progress_create_index.blocks_done \u7edf\u8ba1\u5b57\u6bb5\u3002
pg_stat_progress_create_indexblocks_donebigint\u5f53\u524d\u9636\u6bb5\u5df2\u7ecf\u5904\u7406\u7684\u5757\u6570\u91cf\u3002
\u67e5\u770b\u5b8c\u6574\u4e2d\u6587\u624b\u518c\u4e0e\u4e0a\u4e0b\u6587\u3002
"}, "summary": "\u5f53\u524d\u9636\u6bb5\u5df2\u7ecf\u5904\u7406\u7684\u5757\u6570\u91cf\u3002", "version": "20", "link_map": {"/zh/docs/devel/progress-reporting.html": "/docs/devel/progress-reporting.html"}, "body_html": "pg_stat_progress_create_index.blocks_done \u7edf\u8ba1\u5b57\u6bb5\u3002
pg_stat_progress_create_indexblocks_donebigint\u5f53\u524d\u9636\u6bb5\u5df2\u7ecf\u5904\u7406\u7684\u5757\u6570\u91cf\u3002
\u67e5\u770b\u5b8c\u6574\u4e2d\u6587\u624b\u518c\u4e0e\u4e0a\u4e0b\u6587\u3002
", "body_sha256": "e7635ab750d922d2cf4521f2dd63b867c441e65d5979b16aaa5a51e34d567a9b", "content_hash": "a46be4a4861856f7132826c7d676bec124bdf30bd97f807f5bf2ee0a1e6ac90d", "source_database": "center", "source_revision": "49c73aa4c9cacef8ca979276a28ac416c08e9e54c9baee4ae5fd116a35fa13ac"}, "signature": "SELECT blocks_done FROM pg_catalog.pg_stat_progress_create_index;", "tables_zh": [], "documented": true, "description": ["\u5f53\u524d\u9636\u6bb5\u5df2\u7ecf\u5904\u7406\u7684\u5757\u6570\u91cf\u3002"], "manual_html": "", "manual_path": "/docs/devel/progress-reporting.html", "sections_zh": [{"title": "\u89c6\u56fe\u8bed\u4e49", "paragraphs": ["\u6bcf\u5f53\u8fd0\u884c CREATE INDEX \u6216 REINDEX \u65f6\uff0c pg_stat_progress_create_index \u89c6\u56fe\u5c06\u5305\u542b\u5f53\u524d\u6b63\u5728\u521b\u5efa\u7d22\u5f15\u7684\u6bcf\u4e2a\u540e\u7aef\u7684\u4e00\u884c\u3002\u4e0b\u9762\u7684\u8868\u63cf\u8ff0\u4e86\u5c06\u8981\u62a5\u544a\u7684\u4fe1\u606f\uff0c\u5e76\u63d0\u4f9b\u4e86\u5173\u4e8e\u5982\u4f55\u89e3\u91ca\u5b83\u7684\u4fe1\u606f\u3002"]}, {"title": "\u91c7\u96c6\u4e0e\u91cd\u7f6e\u8bed\u4e49", "paragraphs": ["\u91cd\u7f6e\u8303\u56f4\u548c\u53ef\u89c1\u6027\u8bf7\u53c2\u9605\u4e0b\u65b9\u540c\u7248\u672c\u7684\u7edf\u8ba1\u4fe1\u606f\u6536\u96c6\u4e0e\u89c6\u56fe\u6587\u6863\u3002\u4e0d\u6839\u636e\u5b57\u6bb5\u540d\u79f0\u63a8\u65ad\u5404\u5b57\u6bb5\u7684\u91cd\u7f6e\u89c4\u5219\u3002"]}, {"code": "SELECT blocks_done FROM pg_catalog.pg_stat_progress_create_index;", "title": "\u67e5\u770b\u6b64\u5b57\u6bb5", "paragraphs": ["\u793a\u4f8b\u67e5\u8be2\uff1b\u4e0d\u8868\u793a\u5df2\u6267\u884c\uff0c\u4e5f\u4e0d\u63d0\u4f9b\u5b9e\u6d4b\u503c\u3002"]}], "source_only": false, "localization": {"status": "complete", "sources": [{"url": "/docs/devel/progress-reporting.html", "method": "same-major semantic node", "sha256": "088cf2216591a2aeed6599d5194c54890c9e4d8d2a872796eca11852599f5ea3", "language": "zh", "matched_nodes": ["#PROGRESS-REPORTING/div[6]/div[3]/div[1]/table[0]/tbody[2]/tr[11]/td[0]/p[1]", "#PROGRESS-REPORTING/div[6]/p[2]"]}], "language": "zh", "original_text": {"/summary": "Number of blocks already processed in the current phase.", "/versions/20/description/0": "Number of blocks already processed in the current phase.", "/versions/20/facts/0/label": "View", "/versions/20/facts/1/label": "Field", "/versions/20/facts/2/label": "SQL type", "/versions/20/facts/3/label": "Units named in the field definition", "/versions/20/facts/4/label": "Reset observation", "/versions/20/facts/4/value": "No stats_reset field is documented for this view", "/versions/20/related/0/label": "pg_stat_progress_create_index columns", "/versions/20/related/1/label": "Statistics collection and reset functions", "/versions/20/sections/0/title": "View semantics", "/versions/20/sections/1/title": "Collection and reset context", "/versions/20/sections/2/title": "Inspect this field", "/versions/20/sections/0/paragraphs/0": "Whenever CREATE INDEX or REINDEX is running, the pg_stat_progress_create_index view will contain one row for each backend that is currently creating indexes. The tables below describe the information that will be reported and provide information about how to interpret it.", "/versions/20/sections/1/paragraphs/0": "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.", "/versions/20/sections/2/paragraphs/0": "Example query; no execution result or measured value is asserted."}, "fallback_fields": [], "source_language": "en", "original_snapshot_sha256": "280eea8d4f94ceb10dd0992cc7c898f81e1264030625e2dbd89204ede0569368", "canonical_center_text_hash": "a46be4a4861856f7132826c7d676bec124bdf30bd97f807f5bf2ee0a1e6ac90d"}, "description_zh": "\u5f53\u524d\u9636\u6bb5\u5df2\u7ecf\u5904\u7406\u7684\u5757\u6570\u91cf\u3002", "comparison_data": {"view": "pg_stat_progress_create_index", "field": "blocks_done", "sql_type": "bigint", "units_mentioned": ["blocks"]}, "comparison_hash": "d2aa38d3839903b88fd0f5ab16015167de8f74a86068ea91d874c18a9ee2ac5a", "manual_language": "zh", "units_mentioned": ["blocks"], "description_zh_html": "pg_stat_progress_create_index.blocks_done \u7edf\u8ba1\u5b57\u6bb5\u3002
pg_stat_progress_create_indexblocks_donebigint\u5f53\u524d\u9636\u6bb5\u5df2\u7ecf\u5904\u7406\u7684\u5757\u6570\u91cf\u3002
\u67e5\u770b\u5b8c\u6574\u4e2d\u6587\u624b\u518c\u4e0e\u4e0a\u4e0b\u6587\u3002
", "source_revalidation": {"kind": "static-same-version-source-and-manual-replay", "audit": "wiki-audit-20261023", "runtime_rerun": false, "compared_fields": "documented field type and description, source-only view expressions", "source_revision": "49c73aa4c9cacef8ca979276a28ac416c08e9e54c9baee4ae5fd116a35fa13ac", "previous_source_revision": "4d3346909b201ac1648232cf290462a7070c119326f56196f1f0253ed80fae41"}}}}, "snapshot": {"view": "pg_stat_progress_create_index", "facts": [{"label": "\u89c6\u56fe", "value": "pg_stat_progress_create_index"}, {"label": "\u5b57\u6bb5", "value": "blocks_done"}, {"label": "SQL \u7c7b\u578b", "value": "bigint"}, {"label": "\u5b57\u6bb5\u5b9a\u4e49\u8bb0\u8f7d\u7684\u5355\u4f4d", "value": "blocks"}, {"label": "\u91cd\u7f6e\u6761\u4ef6", "value": "\u624b\u518c\u672a\u4e3a\u6b64\u89c6\u56fe\u8bb0\u8f7d stats_reset \u5b57\u6bb5"}], "field": "blocks_done", "tables": [], "related": [{"url": "/wiki/catalog/pg_stat_progress_create_index/?v=18", "label": "pg_stat_progress_create_index \u5b57\u6bb5"}, {"url": "/docs/18/monitoring-stats.html", "label": "\u7edf\u8ba1\u6536\u96c6\u4e0e\u91cd\u7f6e\u51fd\u6570"}], "release": {"ref": "https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2", "label": "18.6", "major": "18", "channel": "stable", "revision": "555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f"}, "sources": [{"url": "/docs/18/progress-reporting.html#PG-STAT-PROGRESS-CREATE-INDEX-VIEW", "path": "progress-reporting.html", "label": "PostgreSQL 18 English manual", "sha256": "a1f46d2b670502bfe75f1cf5192050ef2ef68202a8f928c4915abea0f4f71ae6"}], "zh_from": {"kind": "same-version-chinese-manual-with-source-derived-structured-summary", "manual": {"url": "/zh/docs/18/progress-reporting.html#", "anchor": "", "column": "blocks_done", "locale": "zh-Hans", "version": "18", "build_id": 107, "page_key": "progress-reporting.html", "extraction": "exact-catalog-field", "source_hash": "59d508f5be60d650bf0ed9ec10531162651c9eb030752aec3874544e10c879e2", "source_revision": "unknown:rendered-translation-baseline", "translation_revision": "git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:08e987a66af27b98444a8057c256314eafa13611a3fb9e888214fc436824244b"}, "body_sha256": "410738e63017a2441b996f3e0ca96cd2b315b2237c8566bfe9055fa14318ca93", "runtime_rerun": false, "authored_translation": "source-derived-structured-summary", "source_facts_revision": "555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f"}, "facts_zh": [{"label": "\u89c6\u56fe", "value": "pg_stat_progress_create_index"}, {"label": "\u5b57\u6bb5", "value": "blocks_done"}, {"label": "SQL \u7c7b\u578b", "value": "bigint"}, {"label": "\u5b57\u6bb5\u5b9a\u4e49\u8bb0\u8f7d\u7684\u5355\u4f4d", "value": "blocks"}, {"label": "\u91cd\u7f6e\u6761\u4ef6", "value": "\u624b\u518c\u672a\u4e3a\u6b64\u89c6\u56fe\u8bb0\u8f7d stats_reset \u5b57\u6bb5"}], "sections": [{"title": "\u89c6\u56fe\u8bed\u4e49", "paragraphs": ["\u6bcf\u5f53\u8fd0\u884c CREATE INDEX \u6216 REINDEX \u65f6\uff0c pg_stat_progress_create_index \u89c6\u56fe\u5c06\u5305\u542b\u5f53\u524d\u6b63\u5728\u521b\u5efa\u7d22\u5f15\u7684\u6bcf\u4e2a\u540e\u7aef\u7684\u4e00\u884c\u3002\u4e0b\u9762\u7684\u8868\u63cf\u8ff0\u4e86\u5c06\u8981\u62a5\u544a\u7684\u4fe1\u606f\uff0c\u5e76\u63d0\u4f9b\u4e86\u5173\u4e8e\u5982\u4f55\u89e3\u91ca\u5b83\u7684\u4fe1\u606f\u3002"]}, {"title": "\u91c7\u96c6\u4e0e\u91cd\u7f6e\u8bed\u4e49", "paragraphs": ["\u91cd\u7f6e\u8303\u56f4\u548c\u53ef\u89c1\u6027\u8bf7\u53c2\u9605\u4e0b\u65b9\u540c\u7248\u672c\u7684\u7edf\u8ba1\u4fe1\u606f\u6536\u96c6\u4e0e\u89c6\u56fe\u6587\u6863\u3002\u4e0d\u6839\u636e\u5b57\u6bb5\u540d\u79f0\u63a8\u65ad\u5404\u5b57\u6bb5\u7684\u91cd\u7f6e\u89c4\u5219\u3002"]}, {"code": "SELECT blocks_done FROM pg_catalog.pg_stat_progress_create_index;", "title": "\u67e5\u770b\u6b64\u5b57\u6bb5", "paragraphs": ["\u793a\u4f8b\u67e5\u8be2\uff1b\u4e0d\u8868\u793a\u5df2\u6267\u884c\uff0c\u4e5f\u4e0d\u63d0\u4f9b\u5b9e\u6d4b\u503c\u3002"]}], "sql_type": "bigint", "center_zh": {"title": "pg_stat_progress_create_index.blocks_done", "locale": "zh-Hans", "source": {"key": "pg_stat_progress_create_index-blocks_done", "locale": "zh-Hans", "version": "18", "text_hash": "ff756f0728b39cc573fc2659039e9b59d3e59344c395d2cfe59096ae0f311957", "collection": "metric", "dataset_hash": "7c31b524dfe136022d39a6ae8dcfac6b3bbd5f8fdaf422536599981252aff0c9", "source_database": "center", "source_revision": "555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f"}, "payload": {"facts": [{"label": "\u89c6\u56fe", "value": "pg_stat_progress_create_index"}, {"label": "\u5b57\u6bb5", "value": "blocks_done"}, {"label": "SQL \u7c7b\u578b", "value": "bigint"}, {"label": "\u5b57\u6bb5\u5b9a\u4e49\u8bb0\u8f7d\u7684\u5355\u4f4d", "value": "blocks"}, {"label": "\u91cd\u7f6e\u6761\u4ef6", "value": "\u624b\u518c\u672a\u4e3a\u6b64\u89c6\u56fe\u8bb0\u8f7d stats_reset \u5b57\u6bb5"}], "tables": [], "zh_from": {"kind": "same-version-chinese-manual-with-source-derived-structured-summary", "manual": {"url": "/zh/docs/18/progress-reporting.html#", "anchor": "", "column": "blocks_done", "locale": "zh-Hans", "version": "18", "build_id": 107, "page_key": "progress-reporting.html", "extraction": "exact-catalog-field", "source_hash": "59d508f5be60d650bf0ed9ec10531162651c9eb030752aec3874544e10c879e2", "source_revision": "unknown:rendered-translation-baseline", "translation_revision": "git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:08e987a66af27b98444a8057c256314eafa13611a3fb9e888214fc436824244b"}, "body_sha256": "410738e63017a2441b996f3e0ca96cd2b315b2237c8566bfe9055fa14318ca93", "runtime_rerun": false, "authored_translation": "source-derived-structured-summary", "source_facts_revision": "555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f"}, "sections": [{"title": "\u89c6\u56fe\u8bed\u4e49", "paragraphs": ["\u6bcf\u5f53\u8fd0\u884c CREATE INDEX \u6216 REINDEX \u65f6\uff0c pg_stat_progress_create_index \u89c6\u56fe\u5c06\u5305\u542b\u5f53\u524d\u6b63\u5728\u521b\u5efa\u7d22\u5f15\u7684\u6bcf\u4e2a\u540e\u7aef\u7684\u4e00\u884c\u3002\u4e0b\u9762\u7684\u8868\u63cf\u8ff0\u4e86\u5c06\u8981\u62a5\u544a\u7684\u4fe1\u606f\uff0c\u5e76\u63d0\u4f9b\u4e86\u5173\u4e8e\u5982\u4f55\u89e3\u91ca\u5b83\u7684\u4fe1\u606f\u3002"]}, {"title": "\u91c7\u96c6\u4e0e\u91cd\u7f6e\u8bed\u4e49", "paragraphs": ["\u91cd\u7f6e\u8303\u56f4\u548c\u53ef\u89c1\u6027\u8bf7\u53c2\u9605\u4e0b\u65b9\u540c\u7248\u672c\u7684\u7edf\u8ba1\u4fe1\u606f\u6536\u96c6\u4e0e\u89c6\u56fe\u6587\u6863\u3002\u4e0d\u6839\u636e\u5b57\u6bb5\u540d\u79f0\u63a8\u65ad\u5404\u5b57\u6bb5\u7684\u91cd\u7f6e\u89c4\u5219\u3002"]}, {"code": "SELECT blocks_done FROM pg_catalog.pg_stat_progress_create_index;", "title": "\u67e5\u770b\u6b64\u5b57\u6bb5", "paragraphs": ["\u793a\u4f8b\u67e5\u8be2\uff1b\u4e0d\u8868\u793a\u5df2\u6267\u884c\uff0c\u4e5f\u4e0d\u63d0\u4f9b\u5b9e\u6d4b\u503c\u3002"]}], "description_zh": "\u5f53\u524d\u9636\u6bb5\u5df2\u7ecf\u5904\u7406\u7684\u5757\u6570\u91cf\u3002", "description_zh_html": "pg_stat_progress_create_index.blocks_done \u7edf\u8ba1\u5b57\u6bb5\u3002
pg_stat_progress_create_indexblocks_donebigint\u5f53\u524d\u9636\u6bb5\u5df2\u7ecf\u5904\u7406\u7684\u5757\u6570\u91cf\u3002
\u67e5\u770b\u5b8c\u6574\u4e2d\u6587\u624b\u518c\u4e0e\u4e0a\u4e0b\u6587\u3002
"}, "summary": "\u5f53\u524d\u9636\u6bb5\u5df2\u7ecf\u5904\u7406\u7684\u5757\u6570\u91cf\u3002", "version": "18", "link_map": {"/zh/docs/18/progress-reporting.html": "/docs/18/progress-reporting.html"}, "body_html": "pg_stat_progress_create_index.blocks_done \u7edf\u8ba1\u5b57\u6bb5\u3002
pg_stat_progress_create_indexblocks_donebigint\u5f53\u524d\u9636\u6bb5\u5df2\u7ecf\u5904\u7406\u7684\u5757\u6570\u91cf\u3002
\u67e5\u770b\u5b8c\u6574\u4e2d\u6587\u624b\u518c\u4e0e\u4e0a\u4e0b\u6587\u3002
", "body_sha256": "0eb19ebc28714de0f7627eedf6c4459307e5171518253039951e3a53321bf05f", "content_hash": "ff756f0728b39cc573fc2659039e9b59d3e59344c395d2cfe59096ae0f311957", "source_database": "center", "source_revision": "555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f"}, "signature": "SELECT blocks_done FROM pg_catalog.pg_stat_progress_create_index;", "tables_zh": [], "documented": true, "description": ["\u5f53\u524d\u9636\u6bb5\u5df2\u7ecf\u5904\u7406\u7684\u5757\u6570\u91cf\u3002"], "manual_html": "", "manual_path": "/docs/18/progress-reporting.html", "sections_zh": [{"title": "\u89c6\u56fe\u8bed\u4e49", "paragraphs": ["\u6bcf\u5f53\u8fd0\u884c CREATE INDEX \u6216 REINDEX \u65f6\uff0c pg_stat_progress_create_index \u89c6\u56fe\u5c06\u5305\u542b\u5f53\u524d\u6b63\u5728\u521b\u5efa\u7d22\u5f15\u7684\u6bcf\u4e2a\u540e\u7aef\u7684\u4e00\u884c\u3002\u4e0b\u9762\u7684\u8868\u63cf\u8ff0\u4e86\u5c06\u8981\u62a5\u544a\u7684\u4fe1\u606f\uff0c\u5e76\u63d0\u4f9b\u4e86\u5173\u4e8e\u5982\u4f55\u89e3\u91ca\u5b83\u7684\u4fe1\u606f\u3002"]}, {"title": "\u91c7\u96c6\u4e0e\u91cd\u7f6e\u8bed\u4e49", "paragraphs": ["\u91cd\u7f6e\u8303\u56f4\u548c\u53ef\u89c1\u6027\u8bf7\u53c2\u9605\u4e0b\u65b9\u540c\u7248\u672c\u7684\u7edf\u8ba1\u4fe1\u606f\u6536\u96c6\u4e0e\u89c6\u56fe\u6587\u6863\u3002\u4e0d\u6839\u636e\u5b57\u6bb5\u540d\u79f0\u63a8\u65ad\u5404\u5b57\u6bb5\u7684\u91cd\u7f6e\u89c4\u5219\u3002"]}, {"code": "SELECT blocks_done FROM pg_catalog.pg_stat_progress_create_index;", "title": "\u67e5\u770b\u6b64\u5b57\u6bb5", "paragraphs": ["\u793a\u4f8b\u67e5\u8be2\uff1b\u4e0d\u8868\u793a\u5df2\u6267\u884c\uff0c\u4e5f\u4e0d\u63d0\u4f9b\u5b9e\u6d4b\u503c\u3002"]}], "source_only": false, "localization": {"status": "complete", "sources": [{"url": "/docs/18/progress-reporting.html", "method": "same-major semantic node", "sha256": "e048c6f8e5f62a236a2f447167452c4109b22828b67f6b22560940ea000cd007", "language": "zh", "matched_nodes": ["#PROGRESS-REPORTING/div[6]/div[3]/div[1]/table[0]/tbody[2]/tr[11]/td[0]/p[1]", "#PROGRESS-REPORTING/div[6]/p[2]"]}], "language": "zh", "original_text": {"/versions/18/description/0": "Number of blocks already processed in the current phase.", "/versions/18/facts/0/label": "View", "/versions/18/facts/1/label": "Field", "/versions/18/facts/2/label": "SQL type", "/versions/18/facts/3/label": "Units named in the field definition", "/versions/18/facts/4/label": "Reset observation", "/versions/18/facts/4/value": "No stats_reset field is documented for this view", "/versions/18/related/0/label": "pg_stat_progress_create_index columns", "/versions/18/related/1/label": "Statistics collection and reset functions", "/versions/18/sections/0/title": "View semantics", "/versions/18/sections/1/title": "Collection and reset context", "/versions/18/sections/2/title": "Inspect this field", "/versions/18/sections/0/paragraphs/0": "Whenever CREATE INDEX or REINDEX is running, the pg_stat_progress_create_index view will contain one row for each backend that is currently creating indexes. The tables below describe the information that will be reported and provide information about how to interpret it.", "/versions/18/sections/1/paragraphs/0": "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.", "/versions/18/sections/2/paragraphs/0": "Example query; no execution result or measured value is asserted."}, "fallback_fields": [], "source_language": "en", "original_snapshot_sha256": "dd5e59bb71b079d312e64e4f466f64d82e92a0d43070df68cb316e846e9f5a0c", "canonical_center_text_hash": "ff756f0728b39cc573fc2659039e9b59d3e59344c395d2cfe59096ae0f311957"}, "description_zh": "\u5f53\u524d\u9636\u6bb5\u5df2\u7ecf\u5904\u7406\u7684\u5757\u6570\u91cf\u3002", "comparison_data": {"view": "pg_stat_progress_create_index", "field": "blocks_done", "sql_type": "bigint", "units_mentioned": ["blocks"]}, "comparison_hash": "d2aa38d3839903b88fd0f5ab16015167de8f74a86068ea91d874c18a9ee2ac5a", "manual_language": "zh", "units_mentioned": ["blocks"], "description_zh_html": "pg_stat_progress_create_index.blocks_done \u7edf\u8ba1\u5b57\u6bb5\u3002
pg_stat_progress_create_indexblocks_donebigint\u5f53\u524d\u9636\u6bb5\u5df2\u7ecf\u5904\u7406\u7684\u5757\u6570\u91cf\u3002
\u67e5\u770b\u5b8c\u6574\u4e2d\u6587\u624b\u518c\u4e0e\u4e0a\u4e0b\u6587\u3002
", "center_zh_rendered": "pg_stat_progress_create_index.blocks_done \u7edf\u8ba1\u5b57\u6bb5\u3002
pg_stat_progress_create_indexblocks_donebigint\u5f53\u524d\u9636\u6bb5\u5df2\u7ecf\u5904\u7406\u7684\u5757\u6570\u91cf\u3002
\u67e5\u770b\u5b8c\u6574\u4e2d\u6587\u624b\u518c\u4e0e\u4e0a\u4e0b\u6587\u3002
"}, "comparison": {"left": "17", "right": "18", "status": "unchanged", "diff": ""}}