{"kind": "metric", "major": "18", "item": {"slug": "pg_stat_progress_create_index-blocks_total", "name": "pg_stat_progress_create_index.blocks_total", "name_zh": "", "category": "pg_stat_progress_create_index", "summary": "\u672c\u9636\u6bb5\u8981\u5904\u7406\u7684\u5757\u603b\u6570\u3002", "aliases": ["blocks_total", "pg_stat_progress_create_index"], "content_hash": "6b5cdb7a5053cbed5a89d30119ab9c5f20aa20c67da6a540e3d33d3f39c440b9", "versions": {"12": {"view": "pg_stat_progress_create_index", "facts": [{"label": "\u89c6\u56fe", "value": "pg_stat_progress_create_index"}, {"label": "\u5b57\u6bb5", "value": "blocks_total"}, {"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_total", "tables": [], "related": [{"url": "/wiki/catalog/pg_stat_progress_create_index/?v=12", "label": "pg_stat_progress_create_index \u5b57\u6bb5"}, {"url": "/docs/12/monitoring-stats.html", "label": "\u7edf\u8ba1\u6536\u96c6\u4e0e\u91cd\u7f6e\u51fd\u6570"}], "release": {"ref": "https://ftp.postgresql.org/pub/source/v12.22/postgresql-12.22.tar.bz2", "label": "12.22", "major": "12", "channel": "stable", "revision": "8df3c0474782589d3c6f374b5133b1bd14d168086edbc13c6e72e67dd4527a3b"}, "sources": [{"url": "https://pg.center/docs/12/progress-reporting.html#PG-STAT-PROGRESS-CREATE-INDEX-VIEW", "path": "progress-reporting.html", "label": "PostgreSQL 12 English manual", "sha256": "b5ba3cd7953df1c2ede6a2640eae45ffa0edc7f8e35d5f682bb65b46bd22c8fa", "language": "en", "original_url": "/docs/12/progress-reporting.html#PG-STAT-PROGRESS-CREATE-INDEX-VIEW"}], "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_total 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", "signature": "SELECT blocks_total FROM pg_catalog.pg_stat_progress_create_index;", "documented": true, "description": ["\u672c\u9636\u6bb5\u8981\u5904\u7406\u7684\u5757\u603b\u6570\u3002"], "manual_html": "", "manual_path": "/docs/12/progress-reporting.html", "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[10]/td[2]", "#PROGRESS-REPORTING/div[3]/p[1]"]}], "language": "zh", "original_text": {"/versions/12/description/0": "Total number of blocks to be 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": "f1f1e9ed36d397318fe727a9f8dd8f3e5632a94f8744a901174e4970de5591a2"}, "comparison_data": {"view": "pg_stat_progress_create_index", "field": "blocks_total", "sql_type": "bigint", "units_mentioned": ["blocks"]}, "comparison_hash": "75e54e891565c48734e4bc25732ded81d905e7e0318c746592c02afe3a24836b", "units_mentioned": ["blocks"]}, "13": {"view": "pg_stat_progress_create_index", "facts": [{"label": "\u89c6\u56fe", "value": "pg_stat_progress_create_index"}, {"label": "\u5b57\u6bb5", "value": "blocks_total"}, {"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_total", "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": "https://pg.center/docs/13/progress-reporting.html#PG-STAT-PROGRESS-CREATE-INDEX-VIEW", "path": "progress-reporting.html", "label": "PostgreSQL 13 English manual", "sha256": "1b5b17cbaf6a5e83cf5460db9d56a8fb88fabbfca57f7b5aa810e6bf9bba83a7", "language": "en", "original_url": "/docs/13/progress-reporting.html#PG-STAT-PROGRESS-CREATE-INDEX-VIEW"}], "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_total 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", "signature": "SELECT blocks_total FROM pg_catalog.pg_stat_progress_create_index;", "documented": true, "description": ["\u672c\u9636\u6bb5\u8981\u5904\u7406\u7684\u5757\u603b\u6570\u3002"], "manual_html": "", "manual_path": "/docs/13/progress-reporting.html", "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[10]/td[0]/p[1]", "#PROGRESS-REPORTING/div[4]/p[1]"]}], "language": "zh", "original_text": {"/versions/13/description/0": "Total number of blocks to be 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": "68a9059e235a42efb84df92dd4e1337caf678d9af3132952b245d3b3651bf0ac"}, "comparison_data": {"view": "pg_stat_progress_create_index", "field": "blocks_total", "sql_type": "bigint", "units_mentioned": ["blocks"]}, "comparison_hash": "75e54e891565c48734e4bc25732ded81d905e7e0318c746592c02afe3a24836b", "units_mentioned": ["blocks"]}, "14": {"view": "pg_stat_progress_create_index", "facts": [{"label": "\u89c6\u56fe", "value": "pg_stat_progress_create_index"}, {"label": "\u5b57\u6bb5", "value": "blocks_total"}, {"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_total", "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": "https://pg.center/docs/14/progress-reporting.html#PG-STAT-PROGRESS-CREATE-INDEX-VIEW", "path": "progress-reporting.html", "label": "PostgreSQL 14 English manual", "sha256": "00410a8905d1f88736ab079620059c9f9e334c1b159b4d9a739042d994f851ce", "language": "en", "original_url": "/docs/14/progress-reporting.html#PG-STAT-PROGRESS-CREATE-INDEX-VIEW"}], "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_total 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", "signature": "SELECT blocks_total FROM pg_catalog.pg_stat_progress_create_index;", "documented": true, "description": ["\u672c\u9636\u6bb5\u8981\u5904\u7406\u7684\u5757\u603b\u6570\u3002"], "manual_html": "", "manual_path": "/docs/14/progress-reporting.html", "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[10]/td[0]/p[1]", "#PROGRESS-REPORTING/div[4]/p[2]"]}], "language": "zh", "original_text": {"/versions/14/description/0": "Total number of blocks to be 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": "4b2106f40cba8724678ed6bf089394f2655ddea369a11adf29017e26b0a3b523"}, "comparison_data": {"view": "pg_stat_progress_create_index", "field": "blocks_total", "sql_type": "bigint", "units_mentioned": ["blocks"]}, "comparison_hash": "75e54e891565c48734e4bc25732ded81d905e7e0318c746592c02afe3a24836b", "units_mentioned": ["blocks"]}, "15": {"view": "pg_stat_progress_create_index", "facts": [{"label": "\u89c6\u56fe", "value": "pg_stat_progress_create_index"}, {"label": "\u5b57\u6bb5", "value": "blocks_total"}, {"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_total", "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": "https://pg.center/docs/15/progress-reporting.html#PG-STAT-PROGRESS-CREATE-INDEX-VIEW", "path": "progress-reporting.html", "label": "PostgreSQL 15 English manual", "sha256": "97422d3113978e145d4a71fa1daf467b8dbd573372a88dfb1a767be0b96105fa", "language": "en", "original_url": "/docs/15/progress-reporting.html#PG-STAT-PROGRESS-CREATE-INDEX-VIEW"}], "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_total 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", "signature": "SELECT blocks_total FROM pg_catalog.pg_stat_progress_create_index;", "documented": true, "description": ["\u672c\u9636\u6bb5\u8981\u5904\u7406\u7684\u5757\u603b\u6570\u3002"], "manual_html": "", "manual_path": "/docs/15/progress-reporting.html", "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[10]/td[0]/p[1]", "#PROGRESS-REPORTING/div[4]/p[2]"]}], "language": "zh", "original_text": {"/versions/15/description/0": "Total number of blocks to be 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": "e6cdbd38ef6fa36106713c8143d0db1aa2f6867fd80205f75b99f538a0944c37"}, "comparison_data": {"view": "pg_stat_progress_create_index", "field": "blocks_total", "sql_type": "bigint", "units_mentioned": ["blocks"]}, "comparison_hash": "75e54e891565c48734e4bc25732ded81d905e7e0318c746592c02afe3a24836b", "units_mentioned": ["blocks"]}, "16": {"view": "pg_stat_progress_create_index", "facts": [{"label": "\u89c6\u56fe", "value": "pg_stat_progress_create_index"}, {"label": "\u5b57\u6bb5", "value": "blocks_total"}, {"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_total", "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": "https://pg.center/docs/16/progress-reporting.html#PG-STAT-PROGRESS-CREATE-INDEX-VIEW", "path": "progress-reporting.html", "label": "PostgreSQL 16 English manual", "sha256": "2b460ce06a91510e6d57a1e5d51b3ffdb65426fb38d30b0ff2774af6da50cf68", "language": "en", "original_url": "/docs/16/progress-reporting.html#PG-STAT-PROGRESS-CREATE-INDEX-VIEW"}], "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_total 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", "signature": "SELECT blocks_total FROM pg_catalog.pg_stat_progress_create_index;", "documented": true, "description": ["\u672c\u9636\u6bb5\u8981\u5904\u7406\u7684\u5757\u603b\u6570\u3002"], "manual_html": "", "manual_path": "/docs/16/progress-reporting.html", "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[10]/td[0]/p[1]", "#PROGRESS-REPORTING/div[6]/p[2]"]}], "language": "zh", "original_text": {"/versions/16/description/0": "Total number of blocks to be 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": "7f3f2c785f2d3abc307b7ef06d151bfd402d4bbdc56636c2680f78083390c29f"}, "comparison_data": {"view": "pg_stat_progress_create_index", "field": "blocks_total", "sql_type": "bigint", "units_mentioned": ["blocks"]}, "comparison_hash": "75e54e891565c48734e4bc25732ded81d905e7e0318c746592c02afe3a24836b", "units_mentioned": ["blocks"]}, "17": {"view": "pg_stat_progress_create_index", "facts": [{"label": "\u89c6\u56fe", "value": "pg_stat_progress_create_index"}, {"label": "\u5b57\u6bb5", "value": "blocks_total"}, {"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_total", "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": "https://pg.center/docs/17/progress-reporting.html#PG-STAT-PROGRESS-CREATE-INDEX-VIEW", "path": "progress-reporting.html", "label": "PostgreSQL 17 English manual", "sha256": "94edb2f133e511fb3bac06d21e8b55f1519df3d59536746d67de3768c94df607", "language": "en", "original_url": "/docs/17/progress-reporting.html#PG-STAT-PROGRESS-CREATE-INDEX-VIEW"}], "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_total 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", "signature": "SELECT blocks_total FROM pg_catalog.pg_stat_progress_create_index;", "documented": true, "description": ["\u672c\u9636\u6bb5\u8981\u5904\u7406\u7684\u5757\u603b\u6570\u3002"], "manual_html": "", "manual_path": "/docs/17/progress-reporting.html", "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[10]/td[0]/p[1]", "#PROGRESS-REPORTING/div[6]/p[2]"]}], "language": "zh", "original_text": {"/versions/17/description/0": "Total number of blocks to be 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": "a9cf15f1f26aec85b3f22cf0b7bd97949bc94477d1e2e770e47d36ca37d92cab"}, "comparison_data": {"view": "pg_stat_progress_create_index", "field": "blocks_total", "sql_type": "bigint", "units_mentioned": ["blocks"]}, "comparison_hash": "75e54e891565c48734e4bc25732ded81d905e7e0318c746592c02afe3a24836b", "units_mentioned": ["blocks"]}, "18": {"view": "pg_stat_progress_create_index", "facts": [{"label": "\u89c6\u56fe", "value": "pg_stat_progress_create_index"}, {"label": "\u5b57\u6bb5", "value": "blocks_total"}, {"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_total", "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": "https://pg.center/docs/18/progress-reporting.html#PG-STAT-PROGRESS-CREATE-INDEX-VIEW", "path": "progress-reporting.html", "label": "PostgreSQL 18 English manual", "sha256": "a1f46d2b670502bfe75f1cf5192050ef2ef68202a8f928c4915abea0f4f71ae6", "language": "en", "original_url": "/docs/18/progress-reporting.html#PG-STAT-PROGRESS-CREATE-INDEX-VIEW"}], "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_total 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", "signature": "SELECT blocks_total FROM pg_catalog.pg_stat_progress_create_index;", "documented": true, "description": ["\u672c\u9636\u6bb5\u8981\u5904\u7406\u7684\u5757\u603b\u6570\u3002"], "manual_html": "", "manual_path": "/docs/18/progress-reporting.html", "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[10]/td[0]/p[1]", "#PROGRESS-REPORTING/div[6]/p[2]"]}], "language": "zh", "original_text": {"/versions/18/description/0": "Total number of blocks to be 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": "596f61098a347552c81c25e1151ae2ccdb628b3c5ff6273cc285ccb297677421"}, "comparison_data": {"view": "pg_stat_progress_create_index", "field": "blocks_total", "sql_type": "bigint", "units_mentioned": ["blocks"]}, "comparison_hash": "75e54e891565c48734e4bc25732ded81d905e7e0318c746592c02afe3a24836b", "units_mentioned": ["blocks"]}, "19": {"view": "pg_stat_progress_create_index", "facts": [{"label": "\u89c6\u56fe", "value": "pg_stat_progress_create_index"}, {"label": "\u5b57\u6bb5", "value": "blocks_total"}, {"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_total", "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/v19beta4/postgresql-19beta4.tar.bz2", "label": "19beta4", "major": "19", "channel": "preview", "revision": "83157ee9c599d03b2f7a3d73ef3a56ec24e0e79cc2b3501a64d1364f56398c86"}, "sources": [{"url": "https://pg.center/docs/19/progress-reporting.html#PG-STAT-PROGRESS-CREATE-INDEX-VIEW", "path": "progress-reporting.html", "label": "PostgreSQL 19 English manual", "sha256": "911eea089109c945679f9ac5c21a3b1b7c9186237acec4639f23861e931e24cc", "language": "en", "original_url": "/docs/19/progress-reporting.html#PG-STAT-PROGRESS-CREATE-INDEX-VIEW"}], "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_total 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", "signature": "SELECT blocks_total FROM pg_catalog.pg_stat_progress_create_index;", "documented": true, "description": ["\u672c\u9636\u6bb5\u8981\u5904\u7406\u7684\u5757\u603b\u6570\u3002"], "manual_html": "", "manual_path": "/docs/19/progress-reporting.html", "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[10]/td[0]/p[1]", "#PROGRESS-REPORTING/div[6]/p[2]"]}], "language": "zh", "original_text": {"/versions/19/description/0": "Total number of blocks to be 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": "5e368867c1583f11ffdd389c3d6c691778fce587992a9eaa59bf94075fe1f739"}, "comparison_data": {"view": "pg_stat_progress_create_index", "field": "blocks_total", "sql_type": "bigint", "units_mentioned": ["blocks"]}, "comparison_hash": "75e54e891565c48734e4bc25732ded81d905e7e0318c746592c02afe3a24836b", "units_mentioned": ["blocks"]}, "20": {"view": "pg_stat_progress_create_index", "facts": [{"label": "\u89c6\u56fe", "value": "pg_stat_progress_create_index"}, {"label": "\u5b57\u6bb5", "value": "blocks_total"}, {"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_total", "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": "4d3346909b201ac1648232cf290462a7070c119326f56196f1f0253ed80fae41"}, "sources": [{"url": "https://pg.center/docs/devel/progress-reporting.html#PG-STAT-PROGRESS-CREATE-INDEX-VIEW", "path": "progress-reporting.html", "label": "PostgreSQL 20 English manual", "sha256": "a692c859d24d77ff71231c72596243a279325b5436ece3dad58945b55688646e", "language": "en", "original_url": "/docs/devel/progress-reporting.html#PG-STAT-PROGRESS-CREATE-INDEX-VIEW"}], "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_total 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", "signature": "SELECT blocks_total FROM pg_catalog.pg_stat_progress_create_index;", "documented": true, "description": ["\u672c\u9636\u6bb5\u8981\u5904\u7406\u7684\u5757\u603b\u6570\u3002"], "manual_html": "", "manual_path": "/docs/devel/progress-reporting.html", "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[10]/td[0]/p[1]", "#PROGRESS-REPORTING/div[6]/p[2]"]}], "language": "zh", "original_text": {"/summary": "Total number of blocks to be processed in the current phase.", "/versions/20/description/0": "Total number of blocks to be 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": "853e3346c3f4b345d44706316ca9ff1101f3db9cfd60f47d5fffe45dd50ce50e"}, "comparison_data": {"view": "pg_stat_progress_create_index", "field": "blocks_total", "sql_type": "bigint", "units_mentioned": ["blocks"]}, "comparison_hash": "75e54e891565c48734e4bc25732ded81d905e7e0318c746592c02afe3a24836b", "units_mentioned": ["blocks"]}}}, "snapshot": {"view": "pg_stat_progress_create_index", "facts": [{"label": "\u89c6\u56fe", "value": "pg_stat_progress_create_index"}, {"label": "\u5b57\u6bb5", "value": "blocks_total"}, {"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_total", "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": "https://pg.center/docs/18/progress-reporting.html#PG-STAT-PROGRESS-CREATE-INDEX-VIEW", "path": "progress-reporting.html", "label": "PostgreSQL 18 English manual", "sha256": "a1f46d2b670502bfe75f1cf5192050ef2ef68202a8f928c4915abea0f4f71ae6", "language": "en", "original_url": "/docs/18/progress-reporting.html#PG-STAT-PROGRESS-CREATE-INDEX-VIEW"}], "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_total 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", "signature": "SELECT blocks_total FROM pg_catalog.pg_stat_progress_create_index;", "documented": true, "description": ["\u672c\u9636\u6bb5\u8981\u5904\u7406\u7684\u5757\u603b\u6570\u3002"], "manual_html": "", "manual_path": "/docs/18/progress-reporting.html", "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[10]/td[0]/p[1]", "#PROGRESS-REPORTING/div[6]/p[2]"]}], "language": "zh", "original_text": {"/versions/18/description/0": "Total number of blocks to be 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": "596f61098a347552c81c25e1151ae2ccdb628b3c5ff6273cc285ccb297677421"}, "comparison_data": {"view": "pg_stat_progress_create_index", "field": "blocks_total", "sql_type": "bigint", "units_mentioned": ["blocks"]}, "comparison_hash": "75e54e891565c48734e4bc25732ded81d905e7e0318c746592c02afe3a24836b", "units_mentioned": ["blocks"]}, "comparison": {"left": "17", "right": "18", "status": "unchanged", "diff": ""}}