{"kind": "metric", "major": "18", "item": {"slug": "pg_stat_progress_create_index-tuples_done", "name": "pg_stat_progress_create_index.tuples_done", "name_zh": "", "category": "pg_stat_progress_create_index", "summary": "\u5728\u5f53\u524d\u9636\u6bb5\u5df2\u7ecf\u5904\u7406\u7684\u5143\u7ec4\u6570\u91cf\u3002", "aliases": ["tuples_done", "pg_stat_progress_create_index"], "content_hash": "cc0eb86f0db499ecd47e1f0b5da2b94e67ad4e4b3e0250f9dd9eea90d7e7c7b6", "versions": {"12": {"view": "pg_stat_progress_create_index", "facts": [{"label": "\u89c6\u56fe", "value": "pg_stat_progress_create_index"}, {"label": "\u5b57\u6bb5", "value": "tuples_done"}, {"label": "SQL \u7c7b\u578b", "value": "bigint"}, {"label": "\u5b57\u6bb5\u5b9a\u4e49\u8bb0\u8f7d\u7684\u5355\u4f4d", "value": "tuples"}, {"label": "\u91cd\u7f6e\u6761\u4ef6", "value": "\u624b\u518c\u672a\u4e3a\u6b64\u89c6\u56fe\u8bb0\u8f7d stats_reset \u5b57\u6bb5"}], "field": "tuples_done", "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 tuples_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", "signature": "SELECT tuples_done FROM pg_catalog.pg_stat_progress_create_index;", "documented": true, "description": ["\u5728\u5f53\u524d\u9636\u6bb5\u5df2\u7ecf\u5904\u7406\u7684\u5143\u7ec4\u6570\u91cf\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[13]/td[2]", "#PROGRESS-REPORTING/div[3]/p[1]"]}], "language": "zh", "original_text": {"/versions/12/description/0": "Number of tuples 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": "daa4643b5497bf16809e9b2e7c00dd34490db45d5802e72adbd4f21c6f810d16"}, "comparison_data": {"view": "pg_stat_progress_create_index", "field": "tuples_done", "sql_type": "bigint", "units_mentioned": ["tuples"]}, "comparison_hash": "c286f0ca4b4f1e45d5fda33ddf7e22d5643a20a1d85d027b4a8bb0ad92508936", "units_mentioned": ["tuples"]}, "13": {"view": "pg_stat_progress_create_index", "facts": [{"label": "\u89c6\u56fe", "value": "pg_stat_progress_create_index"}, {"label": "\u5b57\u6bb5", "value": "tuples_done"}, {"label": "SQL \u7c7b\u578b", "value": "bigint"}, {"label": "\u5b57\u6bb5\u5b9a\u4e49\u8bb0\u8f7d\u7684\u5355\u4f4d", "value": "tuples"}, {"label": "\u91cd\u7f6e\u6761\u4ef6", "value": "\u624b\u518c\u672a\u4e3a\u6b64\u89c6\u56fe\u8bb0\u8f7d stats_reset \u5b57\u6bb5"}], "field": "tuples_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": "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 tuples_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", "signature": "SELECT tuples_done FROM pg_catalog.pg_stat_progress_create_index;", "documented": true, "description": ["\u5728\u5f53\u524d\u9636\u6bb5\u5df2\u7ecf\u5904\u7406\u7684\u5143\u7ec4\u6570\u91cf\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[13]/td[0]/p[1]", "#PROGRESS-REPORTING/div[4]/p[1]"]}], "language": "zh", "original_text": {"/versions/13/description/0": "Number of tuples 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": "476ea7664d4399d635febf7bb59b9baaec8c37078b66577cd3e71aaa098cc200"}, "comparison_data": {"view": "pg_stat_progress_create_index", "field": "tuples_done", "sql_type": "bigint", "units_mentioned": ["tuples"]}, "comparison_hash": "c286f0ca4b4f1e45d5fda33ddf7e22d5643a20a1d85d027b4a8bb0ad92508936", "units_mentioned": ["tuples"]}, "14": {"view": "pg_stat_progress_create_index", "facts": [{"label": "\u89c6\u56fe", "value": "pg_stat_progress_create_index"}, {"label": "\u5b57\u6bb5", "value": "tuples_done"}, {"label": "SQL \u7c7b\u578b", "value": "bigint"}, {"label": "\u5b57\u6bb5\u5b9a\u4e49\u8bb0\u8f7d\u7684\u5355\u4f4d", "value": "tuples"}, {"label": "\u91cd\u7f6e\u6761\u4ef6", "value": "\u624b\u518c\u672a\u4e3a\u6b64\u89c6\u56fe\u8bb0\u8f7d stats_reset \u5b57\u6bb5"}], "field": "tuples_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": "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 tuples_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", "signature": "SELECT tuples_done FROM pg_catalog.pg_stat_progress_create_index;", "documented": true, "description": ["\u5728\u5f53\u524d\u9636\u6bb5\u5df2\u7ecf\u5904\u7406\u7684\u5143\u7ec4\u6570\u91cf\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[13]/td[0]/p[1]", "#PROGRESS-REPORTING/div[4]/p[2]"]}], "language": "zh", "original_text": {"/versions/14/description/0": "Number of tuples 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": "71f7c6060272a0e56ebd79b45533075436ee7a1b74bc2169ab8aaa510279fe4a"}, "comparison_data": {"view": "pg_stat_progress_create_index", "field": "tuples_done", "sql_type": "bigint", "units_mentioned": ["tuples"]}, "comparison_hash": "c286f0ca4b4f1e45d5fda33ddf7e22d5643a20a1d85d027b4a8bb0ad92508936", "units_mentioned": ["tuples"]}, "15": {"view": "pg_stat_progress_create_index", "facts": [{"label": "\u89c6\u56fe", "value": "pg_stat_progress_create_index"}, {"label": "\u5b57\u6bb5", "value": "tuples_done"}, {"label": "SQL \u7c7b\u578b", "value": "bigint"}, {"label": "\u5b57\u6bb5\u5b9a\u4e49\u8bb0\u8f7d\u7684\u5355\u4f4d", "value": "tuples"}, {"label": "\u91cd\u7f6e\u6761\u4ef6", "value": "\u624b\u518c\u672a\u4e3a\u6b64\u89c6\u56fe\u8bb0\u8f7d stats_reset \u5b57\u6bb5"}], "field": "tuples_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": "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 tuples_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", "signature": "SELECT tuples_done FROM pg_catalog.pg_stat_progress_create_index;", "documented": true, "description": ["\u5728\u5f53\u524d\u9636\u6bb5\u5df2\u7ecf\u5904\u7406\u7684\u5143\u7ec4\u6570\u91cf\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[13]/td[0]/p[1]", "#PROGRESS-REPORTING/div[4]/p[2]"]}], "language": "zh", "original_text": {"/versions/15/description/0": "Number of tuples 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": "aeb17b0d93ccea8af111896c9a4b5845c562082363ba6e4eb163913e6081fa46"}, "comparison_data": {"view": "pg_stat_progress_create_index", "field": "tuples_done", "sql_type": "bigint", "units_mentioned": ["tuples"]}, "comparison_hash": "c286f0ca4b4f1e45d5fda33ddf7e22d5643a20a1d85d027b4a8bb0ad92508936", "units_mentioned": ["tuples"]}, "16": {"view": "pg_stat_progress_create_index", "facts": [{"label": "\u89c6\u56fe", "value": "pg_stat_progress_create_index"}, {"label": "\u5b57\u6bb5", "value": "tuples_done"}, {"label": "SQL \u7c7b\u578b", "value": "bigint"}, {"label": "\u5b57\u6bb5\u5b9a\u4e49\u8bb0\u8f7d\u7684\u5355\u4f4d", "value": "tuples"}, {"label": "\u91cd\u7f6e\u6761\u4ef6", "value": "\u624b\u518c\u672a\u4e3a\u6b64\u89c6\u56fe\u8bb0\u8f7d stats_reset \u5b57\u6bb5"}], "field": "tuples_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": "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 tuples_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", "signature": "SELECT tuples_done FROM pg_catalog.pg_stat_progress_create_index;", "documented": true, "description": ["\u5728\u5f53\u524d\u9636\u6bb5\u5df2\u7ecf\u5904\u7406\u7684\u5143\u7ec4\u6570\u91cf\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[13]/td[0]/p[1]", "#PROGRESS-REPORTING/div[6]/p[2]"]}], "language": "zh", "original_text": {"/versions/16/description/0": "Number of tuples 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": "59c94911a199635cd0b365e479a7cc0f901a82b2d8eae8b12f14ae80cbb6538c"}, "comparison_data": {"view": "pg_stat_progress_create_index", "field": "tuples_done", "sql_type": "bigint", "units_mentioned": ["tuples"]}, "comparison_hash": "c286f0ca4b4f1e45d5fda33ddf7e22d5643a20a1d85d027b4a8bb0ad92508936", "units_mentioned": ["tuples"]}, "17": {"view": "pg_stat_progress_create_index", "facts": [{"label": "\u89c6\u56fe", "value": "pg_stat_progress_create_index"}, {"label": "\u5b57\u6bb5", "value": "tuples_done"}, {"label": "SQL \u7c7b\u578b", "value": "bigint"}, {"label": "\u5b57\u6bb5\u5b9a\u4e49\u8bb0\u8f7d\u7684\u5355\u4f4d", "value": "tuples"}, {"label": "\u91cd\u7f6e\u6761\u4ef6", "value": "\u624b\u518c\u672a\u4e3a\u6b64\u89c6\u56fe\u8bb0\u8f7d stats_reset \u5b57\u6bb5"}], "field": "tuples_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": "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 tuples_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", "signature": "SELECT tuples_done FROM pg_catalog.pg_stat_progress_create_index;", "documented": true, "description": ["\u5728\u5f53\u524d\u9636\u6bb5\u5df2\u7ecf\u5904\u7406\u7684\u5143\u7ec4\u6570\u91cf\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[13]/td[0]/p[1]", "#PROGRESS-REPORTING/div[6]/p[2]"]}], "language": "zh", "original_text": {"/versions/17/description/0": "Number of tuples 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": "fe5a221c1ac691fc5b2b4e0cb42f58644d6fafa9669a590652e7f7e82e7a16ee"}, "comparison_data": {"view": "pg_stat_progress_create_index", "field": "tuples_done", "sql_type": "bigint", "units_mentioned": ["tuples"]}, "comparison_hash": "c286f0ca4b4f1e45d5fda33ddf7e22d5643a20a1d85d027b4a8bb0ad92508936", "units_mentioned": ["tuples"]}, "18": {"view": "pg_stat_progress_create_index", "facts": [{"label": "\u89c6\u56fe", "value": "pg_stat_progress_create_index"}, {"label": "\u5b57\u6bb5", "value": "tuples_done"}, {"label": "SQL \u7c7b\u578b", "value": "bigint"}, {"label": "\u5b57\u6bb5\u5b9a\u4e49\u8bb0\u8f7d\u7684\u5355\u4f4d", "value": "tuples"}, {"label": "\u91cd\u7f6e\u6761\u4ef6", "value": "\u624b\u518c\u672a\u4e3a\u6b64\u89c6\u56fe\u8bb0\u8f7d stats_reset \u5b57\u6bb5"}], "field": "tuples_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": "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 tuples_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", "signature": "SELECT tuples_done FROM pg_catalog.pg_stat_progress_create_index;", "documented": true, "description": ["\u5728\u5f53\u524d\u9636\u6bb5\u5df2\u7ecf\u5904\u7406\u7684\u5143\u7ec4\u6570\u91cf\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[13]/td[0]/p[1]", "#PROGRESS-REPORTING/div[6]/p[2]"]}], "language": "zh", "original_text": {"/versions/18/description/0": "Number of tuples 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": "dc39a89753c89c044921b2ab44828efc1b107197b3da0cf79ba9e0c753da9f1b"}, "comparison_data": {"view": "pg_stat_progress_create_index", "field": "tuples_done", "sql_type": "bigint", "units_mentioned": ["tuples"]}, "comparison_hash": "c286f0ca4b4f1e45d5fda33ddf7e22d5643a20a1d85d027b4a8bb0ad92508936", "units_mentioned": ["tuples"]}, "19": {"view": "pg_stat_progress_create_index", "facts": [{"label": "\u89c6\u56fe", "value": "pg_stat_progress_create_index"}, {"label": "\u5b57\u6bb5", "value": "tuples_done"}, {"label": "SQL \u7c7b\u578b", "value": "bigint"}, {"label": "\u5b57\u6bb5\u5b9a\u4e49\u8bb0\u8f7d\u7684\u5355\u4f4d", "value": "tuples"}, {"label": "\u91cd\u7f6e\u6761\u4ef6", "value": "\u624b\u518c\u672a\u4e3a\u6b64\u89c6\u56fe\u8bb0\u8f7d stats_reset \u5b57\u6bb5"}], "field": "tuples_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/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 tuples_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", "signature": "SELECT tuples_done FROM pg_catalog.pg_stat_progress_create_index;", "documented": true, "description": ["\u5728\u5f53\u524d\u9636\u6bb5\u5df2\u7ecf\u5904\u7406\u7684\u5143\u7ec4\u6570\u91cf\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[13]/td[0]/p[1]", "#PROGRESS-REPORTING/div[6]/p[2]"]}], "language": "zh", "original_text": {"/versions/19/description/0": "Number of tuples 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": "10c45a5d172ccabb2b9b1275770231c868a37d5f696e6d9d87c8feada379eef2"}, "comparison_data": {"view": "pg_stat_progress_create_index", "field": "tuples_done", "sql_type": "bigint", "units_mentioned": ["tuples"]}, "comparison_hash": "c286f0ca4b4f1e45d5fda33ddf7e22d5643a20a1d85d027b4a8bb0ad92508936", "units_mentioned": ["tuples"]}, "20": {"view": "pg_stat_progress_create_index", "facts": [{"label": "\u89c6\u56fe", "value": "pg_stat_progress_create_index"}, {"label": "\u5b57\u6bb5", "value": "tuples_done"}, {"label": "SQL \u7c7b\u578b", "value": "bigint"}, {"label": "\u5b57\u6bb5\u5b9a\u4e49\u8bb0\u8f7d\u7684\u5355\u4f4d", "value": "tuples"}, {"label": "\u91cd\u7f6e\u6761\u4ef6", "value": "\u624b\u518c\u672a\u4e3a\u6b64\u89c6\u56fe\u8bb0\u8f7d stats_reset \u5b57\u6bb5"}], "field": "tuples_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": "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 tuples_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", "signature": "SELECT tuples_done FROM pg_catalog.pg_stat_progress_create_index;", "documented": true, "description": ["\u5728\u5f53\u524d\u9636\u6bb5\u5df2\u7ecf\u5904\u7406\u7684\u5143\u7ec4\u6570\u91cf\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[13]/td[0]/p[1]", "#PROGRESS-REPORTING/div[6]/p[2]"]}], "language": "zh", "original_text": {"/summary": "Number of tuples already processed in the current phase.", "/versions/20/description/0": "Number of tuples 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": "d78992f333d8e14d8e11510fe8808f1bff6cfebda9b2078d07ee33d9714cdaf3"}, "comparison_data": {"view": "pg_stat_progress_create_index", "field": "tuples_done", "sql_type": "bigint", "units_mentioned": ["tuples"]}, "comparison_hash": "c286f0ca4b4f1e45d5fda33ddf7e22d5643a20a1d85d027b4a8bb0ad92508936", "units_mentioned": ["tuples"]}}}, "snapshot": {"view": "pg_stat_progress_create_index", "facts": [{"label": "\u89c6\u56fe", "value": "pg_stat_progress_create_index"}, {"label": "\u5b57\u6bb5", "value": "tuples_done"}, {"label": "SQL \u7c7b\u578b", "value": "bigint"}, {"label": "\u5b57\u6bb5\u5b9a\u4e49\u8bb0\u8f7d\u7684\u5355\u4f4d", "value": "tuples"}, {"label": "\u91cd\u7f6e\u6761\u4ef6", "value": "\u624b\u518c\u672a\u4e3a\u6b64\u89c6\u56fe\u8bb0\u8f7d stats_reset \u5b57\u6bb5"}], "field": "tuples_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": "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 tuples_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", "signature": "SELECT tuples_done FROM pg_catalog.pg_stat_progress_create_index;", "documented": true, "description": ["\u5728\u5f53\u524d\u9636\u6bb5\u5df2\u7ecf\u5904\u7406\u7684\u5143\u7ec4\u6570\u91cf\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[13]/td[0]/p[1]", "#PROGRESS-REPORTING/div[6]/p[2]"]}], "language": "zh", "original_text": {"/versions/18/description/0": "Number of tuples 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": "dc39a89753c89c044921b2ab44828efc1b107197b3da0cf79ba9e0c753da9f1b"}, "comparison_data": {"view": "pg_stat_progress_create_index", "field": "tuples_done", "sql_type": "bigint", "units_mentioned": ["tuples"]}, "comparison_hash": "c286f0ca4b4f1e45d5fda33ddf7e22d5643a20a1d85d027b4a8bb0ad92508936", "units_mentioned": ["tuples"]}, "comparison": {"left": "11", "right": "12", "status": "added", "diff": "--- PostgreSQL 11\n+++ PostgreSQL 12\n@@ -1 +1,8 @@\n-\u8be5\u7248\u672a\u6536\u5f55\n+{\n+  \"field\": \"tuples_done\",\n+  \"sql_type\": \"bigint\",\n+  \"units_mentioned\": [\n+    \"tuples\"\n+  ],\n+  \"view\": \"pg_stat_progress_create_index\"\n+}"}}