{"Entry":{"collection":"catalog","key":"pg_stat_progress_create_index","name":"pg_stat_progress_create_index","aliases":[],"metadata":{"changed_in":[],"changes":[{"added":[],"attributes":[],"description_changed":false,"descriptions":[],"from":"11","order":false,"removed":[],"status":"added","to":"12","types":[]},{"added":[],"attributes":[],"description_changed":false,"descriptions":[{"from":"Current processing phase of index creation. See Table 27.23.","name":"phase","to":"Current processing phase of index creation. See Table 27.35."}],"from":"12","listing":[],"order":false,"removed":[],"status":"reworded","to":"13","types":[],"unlisted":[]},{"added":[],"attributes":[],"description_changed":false,"descriptions":[{"from":"When creating an index on a partitioned table, this column is set to the number of partitions on which the index has been completed.","name":"partitions_done","to":"When creating an index on a partitioned table, this column is set to the number of partitions on which the index has been created. This field is 0 during a REINDEX."},{"from":"When creating an index on a partitioned table, this column is set to the total number of partitions on which the index is to be created.","name":"partitions_total","to":"When creating an index on a partitioned table, this column is set to the total number of partitions on which the index is to be created. This field is 0 during a REINDEX."},{"from":"Current processing phase of index creation. See Table 27.35.","name":"phase","to":"Current processing phase of index creation. See Table 28.37."}],"from":"13","listing":[],"order":false,"removed":[],"status":"reworded","to":"14","types":[],"unlisted":[]},{"added":[],"attributes":[],"description_changed":false,"descriptions":[{"from":"Current processing phase of index creation. See Table 28.37.","name":"phase","to":"Current processing phase of index creation. See Table 28.39."}],"from":"14","listing":[],"order":false,"removed":[],"status":"reworded","to":"15","types":[],"unlisted":[]},{"added":[],"attributes":[],"description_changed":false,"descriptions":[{"from":"The command that is running: CREATE INDEX, CREATE INDEX CONCURRENTLY, REINDEX, or REINDEX CONCURRENTLY.","name":"command","to":"Specific command type: CREATE INDEX, CREATE INDEX CONCURRENTLY, REINDEX, or REINDEX CONCURRENTLY."},{"from":"When creating an index on a partitioned table, this column is set to the number of partitions on which the index has been created. This field is 0 during a REINDEX.","name":"partitions_done","to":"Number of partitions on which the index has already been created or attached, including both direct and indirect partitions. 0 during a REINDEX, or when the index is not partitioned."},{"from":"When creating an index on a partitioned table, this column is set to the total number of partitions on which the index is to be created. This field is 0 during a REINDEX.","name":"partitions_total","to":"Total number of partitions on which the index is to be created or attached, including both direct and indirect partitions. 0 during a REINDEX, or when the index is not partitioned."},{"from":"Current processing phase of index creation. See Table 28.39.","name":"phase","to":"Current processing phase of index creation. See Table 28.43."},{"from":"Process ID of backend.","name":"pid","to":"Process ID of the backend creating indexes."}],"from":"15","listing":[],"order":false,"removed":[],"status":"reworded","to":"16","types":[],"unlisted":[]},{"added":[],"attributes":[],"description_changed":false,"descriptions":[{"from":"Current processing phase of index creation. See Table 28.43.","name":"phase","to":"Current processing phase of index creation. See Table 27.44."}],"from":"16","listing":[],"order":false,"removed":[],"status":"reworded","to":"17","types":[],"unlisted":[]},{"added":[],"attributes":[],"description_changed":false,"descriptions":[{"from":"Current processing phase of index creation. See Table 27.44.","name":"phase","to":"Current processing phase of index creation. See Table 27.47."}],"from":"18","listing":[],"order":false,"removed":[],"status":"reworded","to":"19","types":[],"unlisted":[]},{"added":[],"attributes":[],"description_changed":false,"descriptions":[{"from":"Current processing phase of index creation. See Table 27.47.","name":"phase","to":"Current processing phase of index creation. See Table 27.48."}],"from":"19","listing":[],"order":false,"removed":[],"status":"reworded","to":"20","types":[],"unlisted":[]}],"column_count":16,"content_hash":"5711d7b689151f417913f50d2a3d06fae1a6071174fc192d7be4d5648721f3bc","derived_content_hash":"003ddb1865e6363093897c130a540a4d5a003f8508937bca4b766a14ab335601","documentation_refresh":{"batch":"20261113","original_source_rev":"catalog-bilingual-repair:59c2a769b76a56312b2c967c8850803e785db7689217f0eb4f9298db309f2826","versions":{"14":"14.25","15":"15.20","16":"16.16","17":"17.12","18":"18.7","19":"19rc2"}},"first_version":"12","imported_at":"2026-09-30T00:40:55.945571+08:00","kind":"progress","last_version":"20","name":"pg_stat_progress_create_index","position":98,"present_in":["12","13","14","15","16","17","18","19","20"],"relation_oid":null,"relkind":"v","shared":false,"source_rev":"catalog-bilingual-repair:59c2a769b76a56312b2c967c8850803e785db7689217f0eb4f9298db309f2826","summary":"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.","summary_zh":"每当运行 CREATE INDEX 或 REINDEX 时，pg_stat_progress_create_index 视图将包含当前正在创建索引的每个后端的一行。下面的表描述了将要报告的信息，并提供了关于如何解释它的信息。"}},"Definition":{"Collection":"catalog","Key":"pg_stat_progress_create_index","SourceDatabase":"center","Version":"18","SourceTable":"catalog","SourceKey":"pg_stat_progress_create_index","SourceRevision":"catalog-bilingual-repair:59c2a769b76a56312b2c967c8850803e785db7689217f0eb4f9298db309f2826","Facts":{"columns":[{"array_dimensions":0,"attnum":1,"description":"Process ID of the backend creating indexes.","description_zh":"正在创建索引的后端的进程 ID。","documented":true,"documented_name":"pid","hidden":false,"name":"pid","not_null":false,"references":"","type":"integer","type_modifier":-1,"type_oid":23,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":2,"description":"OID of the database to which this backend is connected.","description_zh":"后端连接到的数据库的 OID。","documented":true,"documented_name":"datid","hidden":false,"name":"datid","not_null":false,"references":"","type":"oid","type_modifier":-1,"type_oid":26,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":3,"description":"Name of the database to which this backend is connected.","description_zh":"后端连接到的数据库的名称。","documented":true,"documented_name":"datname","hidden":false,"name":"datname","not_null":false,"references":"","type":"name","type_modifier":-1,"type_oid":19,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":4,"description":"OID of the table on which the index is being created.","description_zh":"正在创建索引的表的 OID。","documented":true,"documented_name":"relid","hidden":false,"name":"relid","not_null":false,"references":"","type":"oid","type_modifier":-1,"type_oid":26,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":5,"description":"OID of the index being created or reindexed. During a non-concurrent CREATE INDEX, this is 0.","description_zh":"正在创建或重建索引的 OID。在非并发 CREATE INDEX 的时候，此为 0。","documented":true,"documented_name":"index_relid","hidden":false,"name":"index_relid","not_null":false,"references":"","type":"oid","type_modifier":-1,"type_oid":26,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":6,"description":"Specific command type: CREATE INDEX, CREATE INDEX CONCURRENTLY, REINDEX, or REINDEX CONCURRENTLY.","description_zh":"具体命令类型：CREATE INDEX、CREATE INDEX CONCURRENTLY、REINDEX 或 REINDEX CONCURRENTLY。","documented":true,"documented_name":"command","hidden":false,"name":"command","not_null":false,"references":"","type":"text","type_modifier":-1,"type_oid":25,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":7,"description":"Current processing phase of index creation. See Table 27.44.","description_zh":"索引创建的当前处理阶段。参见表 27.44。","documented":true,"documented_name":"phase","hidden":false,"name":"phase","not_null":false,"references":"","type":"text","type_modifier":-1,"type_oid":25,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":8,"description":"Total number of lockers to wait for, when applicable.","description_zh":"在适用的情况下，需要等待的持锁进程总数。","documented":true,"documented_name":"lockers_total","hidden":false,"name":"lockers_total","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":9,"description":"Number of lockers already waited for.","description_zh":"已完成等待的持锁进程数量。","documented":true,"documented_name":"lockers_done","hidden":false,"name":"lockers_done","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":10,"description":"Process ID of the locker currently being waited for.","description_zh":"当前正被等待的持锁进程的进程 ID。","documented":true,"documented_name":"current_locker_pid","hidden":false,"name":"current_locker_pid","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":11,"description":"Total number of blocks to be processed in the current phase.","description_zh":"本阶段要处理的块总数。","documented":true,"documented_name":"blocks_total","hidden":false,"name":"blocks_total","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":12,"description":"Number of blocks already processed in the current phase.","description_zh":"当前阶段已经处理的块数量。","documented":true,"documented_name":"blocks_done","hidden":false,"name":"blocks_done","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":13,"description":"Total number of tuples to be processed in the current phase.","description_zh":"当前阶段要处理的元组总数。","documented":true,"documented_name":"tuples_total","hidden":false,"name":"tuples_total","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":14,"description":"Number of tuples already processed in the current phase.","description_zh":"在当前阶段已经处理的元组数量。","documented":true,"documented_name":"tuples_done","hidden":false,"name":"tuples_done","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":15,"description":"Total number of partitions on which the index is to be created or attached, including both direct and indirect partitions. 0 during a REINDEX, or when the index is not partitioned.","description_zh":"要创建或附加索引的分区总数，包括直接分区和间接分区。在 REINDEX 期间，或索引未分区时，此值为 0。","documented":true,"documented_name":"partitions_total","hidden":false,"name":"partitions_total","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":16,"description":"Number of partitions on which the index has already been created or attached, including both direct and indirect partitions. 0 during a REINDEX, or when the index is not partitioned.","description_zh":"已创建或附加索引的分区数量，包括直接分区和间接分区。在 REINDEX 期间，或索引未分区时，此值为 0。","documented":true,"documented_name":"partitions_done","hidden":false,"name":"partitions_done","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20,"zh_from":"same-version-manual"}],"description":"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.","description_zh":"每当运行 CREATE INDEX 或 REINDEX 时，pg_stat_progress_create_index 视图将包含当前正在创建索引的每个后端的一行。下面的表描述了将要报告的信息，并提供了关于如何解释它的信息。","description_zh_html":"\u003cp\u003e每当运行 CREATE INDEX 或 REINDEX 时，pg_stat_progress_create_index 视图将包含当前正在创建索引的每个后端的一行。下面的表描述了将要报告的信息，并提供了关于如何解释它的信息。\u003c/p\u003e\u003cdiv class=\"table\" id=\"PG-STAT-PROGRESS-CREATE-INDEX-VIEW\"\u003e\u003cp class=\"title\"\u003e\u003cstrong\u003e表 27.43. \u003ccode class=\"structname\"\u003epg_stat_progress_create_index\u003c/code\u003e 视图\u003c/strong\u003e\u003c/p\u003e\u003cdiv class=\"table-contents\"\u003e\u003ctable border=\"1\" class=\"table\" summary=\"pg_stat_progress_create_index 视图\"\u003e\u003ccolgroup\u003e\u003ccol/\u003e\u003c/colgroup\u003e\u003cthead\u003e\u003ctr\u003e\u003cth class=\"catalog_table_entry\"\u003e\u003cp class=\"column_definition\"\u003e\n       列类型\n      \u003c/p\u003e\n\u003cp\u003e\n       描述\n      \u003c/p\u003e\u003c/th\u003e\u003c/tr\u003e\u003c/thead\u003e\u003ctbody\u003e\u003ctr\u003e\u003ctd class=\"catalog_table_entry\"\u003e\u003cp class=\"column_definition\"\u003e\n\u003ccode class=\"structfield\"\u003epid\u003c/code\u003e \u003ccode class=\"type\"\u003einteger\u003c/code\u003e\n\u003c/p\u003e\n\u003cp\u003e正在创建索引的后端的进程 ID。\u003c/p\u003e\u003c/td\u003e\u003c/tr\u003e\u003ctr\u003e\u003ctd class=\"catalog_table_entry\"\u003e\u003cp class=\"column_definition\"\u003e\n\u003ccode class=\"structfield\"\u003edatid\u003c/code\u003e \u003ccode class=\"type\"\u003eoid\u003c/code\u003e\n\u003c/p\u003e\n\u003cp\u003e\n       后端连接到的数据库的 OID。\n      \u003c/p\u003e\u003c/td\u003e\u003c/tr\u003e\u003ctr\u003e\u003ctd class=\"catalog_table_entry\"\u003e\u003cp class=\"column_definition\"\u003e\n\u003ccode class=\"structfield\"\u003edatname\u003c/code\u003e \u003ccode class=\"type\"\u003ename\u003c/code\u003e\n\u003c/p\u003e\n\u003cp\u003e\n       后端连接到的数据库的名称。\n      \u003c/p\u003e\u003c/td\u003e\u003c/tr\u003e\u003ctr\u003e\u003ctd class=\"catalog_table_entry\"\u003e\u003cp class=\"column_definition\"\u003e\n\u003ccode class=\"structfield\"\u003erelid\u003c/code\u003e \u003ccode class=\"type\"\u003eoid\u003c/code\u003e\n\u003c/p\u003e\n\u003cp\u003e\n       正在创建索引的表的 OID。\n      \u003c/p\u003e\u003c/td\u003e\u003c/tr\u003e\u003ctr\u003e\u003ctd class=\"catalog_table_entry\"\u003e\u003cp class=\"column_definition\"\u003e\n\u003ccode class=\"structfield\"\u003eindex_relid\u003c/code\u003e \u003ccode class=\"type\"\u003eoid\u003c/code\u003e\n\u003c/p\u003e\n\u003cp\u003e\n       正在创建或重建索引的 OID。在非并发 \u003ccode class=\"command\"\u003eCREATE INDEX\u003c/code\u003e 的时候，此为 0。\n      \u003c/p\u003e\u003c/td\u003e\u003c/tr\u003e\u003ctr\u003e\u003ctd class=\"catalog_table_entry\"\u003e\u003cp class=\"column_definition\"\u003e\n\u003ccode class=\"structfield\"\u003ecommand\u003c/code\u003e \u003ccode class=\"type\"\u003etext\u003c/code\u003e\n\u003c/p\u003e\n\u003cp\u003e\n       具体命令类型：\u003ccode class=\"literal\"\u003eCREATE INDEX\u003c/code\u003e、\u003ccode class=\"literal\"\u003eCREATE INDEX CONCURRENTLY\u003c/code\u003e、\u003ccode class=\"literal\"\u003eREINDEX\u003c/code\u003e 或 \u003ccode class=\"literal\"\u003eREINDEX CONCURRENTLY\u003c/code\u003e。\n      \u003c/p\u003e\u003c/td\u003e\u003c/tr\u003e\u003ctr\u003e\u003ctd class=\"catalog_table_entry\"\u003e\u003cp class=\"column_definition\"\u003e\n\u003ccode class=\"structfield\"\u003ephase\u003c/code\u003e \u003ccode class=\"type\"\u003etext\u003c/code\u003e\n\u003c/p\u003e\n\u003cp\u003e\n       索引创建的当前处理阶段。参见\u003ca class=\"xref\" href=\"/zh/docs/18/progress-reporting.html#CREATE-INDEX-PHASES\" title=\"表 27.44. CREATE INDEX 阶段\"\u003e表 27.44\u003c/a\u003e。\n      \u003c/p\u003e\u003c/td\u003e\u003c/tr\u003e\u003ctr\u003e\u003ctd class=\"catalog_table_entry\"\u003e\u003cp class=\"column_definition\"\u003e\n\u003ccode class=\"structfield\"\u003elockers_total\u003c/code\u003e \u003ccode class=\"type\"\u003ebigint\u003c/code\u003e\n\u003c/p\u003e\n\u003cp\u003e在适用的情况下，需要等待的持锁进程总数。\u003c/p\u003e\u003c/td\u003e\u003c/tr\u003e\u003ctr\u003e\u003ctd class=\"catalog_table_entry\"\u003e\u003cp class=\"column_definition\"\u003e\n\u003ccode class=\"structfield\"\u003elockers_done\u003c/code\u003e \u003ccode class=\"type\"\u003ebigint\u003c/code\u003e\n\u003c/p\u003e\n\u003cp\u003e已完成等待的持锁进程数量。\u003c/p\u003e\u003c/td\u003e\u003c/tr\u003e\u003ctr\u003e\u003ctd class=\"catalog_table_entry\"\u003e\u003cp class=\"column_definition\"\u003e\n\u003ccode class=\"structfield\"\u003ecurrent_locker_pid\u003c/code\u003e \u003ccode class=\"type\"\u003ebigint\u003c/code\u003e\n\u003c/p\u003e\n\u003cp\u003e当前正被等待的持锁进程的进程 ID。\u003c/p\u003e\u003c/td\u003e\u003c/tr\u003e\u003ctr\u003e\u003ctd class=\"catalog_table_entry\"\u003e\u003cp class=\"column_definition\"\u003e\n\u003ccode class=\"structfield\"\u003eblocks_total\u003c/code\u003e \u003ccode class=\"type\"\u003ebigint\u003c/code\u003e\n\u003c/p\u003e\n\u003cp\u003e\n       本阶段要处理的块总数。\n      \u003c/p\u003e\u003c/td\u003e\u003c/tr\u003e\u003ctr\u003e\u003ctd class=\"catalog_table_entry\"\u003e\u003cp class=\"column_definition\"\u003e\n\u003ccode class=\"structfield\"\u003eblocks_done\u003c/code\u003e \u003ccode class=\"type\"\u003ebigint\u003c/code\u003e\n\u003c/p\u003e\n\u003cp\u003e\n       当前阶段已经处理的块数量。\n      \u003c/p\u003e\u003c/td\u003e\u003c/tr\u003e\u003ctr\u003e\u003ctd class=\"catalog_table_entry\"\u003e\u003cp class=\"column_definition\"\u003e\n\u003ccode class=\"structfield\"\u003etuples_total\u003c/code\u003e \u003ccode class=\"type\"\u003ebigint\u003c/code\u003e\n\u003c/p\u003e\n\u003cp\u003e\n       当前阶段要处理的元组总数。\n      \u003c/p\u003e\u003c/td\u003e\u003c/tr\u003e\u003ctr\u003e\u003ctd class=\"catalog_table_entry\"\u003e\u003cp class=\"column_definition\"\u003e\n\u003ccode class=\"structfield\"\u003etuples_done\u003c/code\u003e \u003ccode class=\"type\"\u003ebigint\u003c/code\u003e\n\u003c/p\u003e\n\u003cp\u003e\n       在当前阶段已经处理的元组数量。\n      \u003c/p\u003e\u003c/td\u003e\u003c/tr\u003e\u003ctr\u003e\u003ctd class=\"catalog_table_entry\"\u003e\u003cp class=\"column_definition\"\u003e\n\u003ccode class=\"structfield\"\u003epartitions_total\u003c/code\u003e \u003ccode class=\"type\"\u003ebigint\u003c/code\u003e\n\u003c/p\u003e\n\u003cp\u003e要创建或附加索引的分区总数，包括直接分区和间接分区。在 \u003ccode class=\"literal\"\u003eREINDEX\u003c/code\u003e 期间，或索引未分区时，此值为 \u003ccode class=\"literal\"\u003e0\u003c/code\u003e。\u003c/p\u003e\u003c/td\u003e\u003c/tr\u003e\u003ctr\u003e\u003ctd class=\"catalog_table_entry\"\u003e\u003cp class=\"column_definition\"\u003e\n\u003ccode class=\"structfield\"\u003epartitions_done\u003c/code\u003e \u003ccode class=\"type\"\u003ebigint\u003c/code\u003e\n\u003c/p\u003e\n\u003cp\u003e已创建或附加索引的分区数量，包括直接分区和间接分区。在 \u003ccode class=\"literal\"\u003eREINDEX\u003c/code\u003e 期间，或索引未分区时，此值为 \u003ccode class=\"literal\"\u003e0\u003c/code\u003e。\u003c/p\u003e\u003c/td\u003e\u003c/tr\u003e\u003c/tbody\u003e\u003c/table\u003e\u003c/div\u003e\u003c/div\u003e","doc":{"anchor":"PG-STAT-PROGRESS-CREATE-INDEX-VIEW","file":"progress-reporting.html","lang":"en","sha256":"4a6cdd8228f2d858318f2056687ac4e2467e2c58e5fed10bdb583ba8eb66fec5","slug":"18"},"documentation_revision":{"inputs":[{"file":"progress-reporting.html","kind":"same-version-reviewed-manual","locale":"en","sha256":"4a6cdd8228f2d858318f2056687ac4e2467e2c58e5fed10bdb583ba8eb66fec5","version":"18.7"},{"file":"progress-reporting.html","kind":"same-version-reviewed-manual","locale":"zh-Hans","sha256":"0ab33caa1959f857312f1a866b2b0f0afde18c3fd85db5d957eefa1b7a2e441f","version":"18.7"}],"release":"18.7","runtime_remeasured":false,"source_revision":"pgdoc:b9f0e7232f60f380d642ac9b99226606c254b552"},"kind":"progress","lang":"en","measured_attributes":true,"metadata_release":"18.6","runtime_columns":["pid","datid","datname","relid","index_relid","command","phase","lockers_total","lockers_done","current_locker_pid","blocks_total","blocks_done","tuples_total","tuples_done","partitions_total","partitions_done"],"runtime_verified":false,"source":"english-manual","sources":[{"evidence":[{"build_id":107,"kind":"same-version-manual","locale":"zh-Hans","page":"progress-reporting.html","sha256":"59d508f5be60d650bf0ed9ec10531162651c9eb030752aec3874544e10c879e2","source_revision":"unknown:rendered-translation-baseline","translation_revision":"git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:08e987a66af27b98444a8057c256314eafa13611a3fb9e888214fc436824244b","version":"18"}],"kind":"catalog-bilingual-repair","prior_source_revision":"english-manuals:1a16c55ab0e1e6d7afd0b05a0074709afeb155cabf38c6fb200bcc9e3a8ae01f","version":"18"}],"zh_from":"same-version-manual"},"ManualEvidence":{"doc":{"anchor":"PG-STAT-PROGRESS-CREATE-INDEX-VIEW","file":"progress-reporting.html","lang":"en","sha256":"4a6cdd8228f2d858318f2056687ac4e2467e2c58e5fed10bdb583ba8eb66fec5","slug":"18"},"sources":[{"evidence":[{"build_id":107,"kind":"same-version-manual","locale":"zh-Hans","page":"progress-reporting.html","sha256":"59d508f5be60d650bf0ed9ec10531162651c9eb030752aec3874544e10c879e2","source_revision":"unknown:rendered-translation-baseline","translation_revision":"git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:08e987a66af27b98444a8057c256314eafa13611a3fb9e888214fc436824244b","version":"18"}],"kind":"catalog-bilingual-repair","prior_source_revision":"english-manuals:1a16c55ab0e1e6d7afd0b05a0074709afeb155cabf38c6fb200bcc9e3a8ae01f","version":"18"}]},"MeasuredEvidence":{"measured_attributes":true,"metadata_release":"18.6","runtime_columns":["pid","datid","datname","relid","index_relid","command","phase","lockers_total","lockers_done","current_locker_pid","blocks_total","blocks_done","tuples_total","tuples_done","partitions_total","partitions_done"],"runtime_verified":false}},"Text":{"Collection":"catalog","Key":"pg_stat_progress_create_index","SourceDatabase":"center","Version":"18","Locale":"en","Title":"pg_stat_progress_create_index","Summary":"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.","BodyHTML":"\u003cp\u003eWhenever 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.\u003c/p\u003e","SourceRevision":"catalog-bilingual-repair:59c2a769b76a56312b2c967c8850803e785db7689217f0eb4f9298db309f2826","ContentHash":"e47870a330c3e3ff94c342ea89adf908caa4542d5d1545da9ae9d9928eec192c","Payload":{"columns":[{"array_dimensions":0,"attnum":1,"description":"Process ID of the backend creating indexes.","description_zh":"正在创建索引的后端的进程 ID。","documented":true,"documented_name":"pid","hidden":false,"name":"pid","not_null":false,"references":"","type":"integer","type_modifier":-1,"type_oid":23,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":2,"description":"OID of the database to which this backend is connected.","description_zh":"后端连接到的数据库的 OID。","documented":true,"documented_name":"datid","hidden":false,"name":"datid","not_null":false,"references":"","type":"oid","type_modifier":-1,"type_oid":26,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":3,"description":"Name of the database to which this backend is connected.","description_zh":"后端连接到的数据库的名称。","documented":true,"documented_name":"datname","hidden":false,"name":"datname","not_null":false,"references":"","type":"name","type_modifier":-1,"type_oid":19,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":4,"description":"OID of the table on which the index is being created.","description_zh":"正在创建索引的表的 OID。","documented":true,"documented_name":"relid","hidden":false,"name":"relid","not_null":false,"references":"","type":"oid","type_modifier":-1,"type_oid":26,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":5,"description":"OID of the index being created or reindexed. During a non-concurrent CREATE INDEX, this is 0.","description_zh":"正在创建或重建索引的 OID。在非并发 CREATE INDEX 的时候，此为 0。","documented":true,"documented_name":"index_relid","hidden":false,"name":"index_relid","not_null":false,"references":"","type":"oid","type_modifier":-1,"type_oid":26,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":6,"description":"Specific command type: CREATE INDEX, CREATE INDEX CONCURRENTLY, REINDEX, or REINDEX CONCURRENTLY.","description_zh":"具体命令类型：CREATE INDEX、CREATE INDEX CONCURRENTLY、REINDEX 或 REINDEX CONCURRENTLY。","documented":true,"documented_name":"command","hidden":false,"name":"command","not_null":false,"references":"","type":"text","type_modifier":-1,"type_oid":25,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":7,"description":"Current processing phase of index creation. See Table 27.44.","description_zh":"索引创建的当前处理阶段。参见表 27.44。","documented":true,"documented_name":"phase","hidden":false,"name":"phase","not_null":false,"references":"","type":"text","type_modifier":-1,"type_oid":25,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":8,"description":"Total number of lockers to wait for, when applicable.","description_zh":"在适用的情况下，需要等待的持锁进程总数。","documented":true,"documented_name":"lockers_total","hidden":false,"name":"lockers_total","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":9,"description":"Number of lockers already waited for.","description_zh":"已完成等待的持锁进程数量。","documented":true,"documented_name":"lockers_done","hidden":false,"name":"lockers_done","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":10,"description":"Process ID of the locker currently being waited for.","description_zh":"当前正被等待的持锁进程的进程 ID。","documented":true,"documented_name":"current_locker_pid","hidden":false,"name":"current_locker_pid","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":11,"description":"Total number of blocks to be processed in the current phase.","description_zh":"本阶段要处理的块总数。","documented":true,"documented_name":"blocks_total","hidden":false,"name":"blocks_total","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":12,"description":"Number of blocks already processed in the current phase.","description_zh":"当前阶段已经处理的块数量。","documented":true,"documented_name":"blocks_done","hidden":false,"name":"blocks_done","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":13,"description":"Total number of tuples to be processed in the current phase.","description_zh":"当前阶段要处理的元组总数。","documented":true,"documented_name":"tuples_total","hidden":false,"name":"tuples_total","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":14,"description":"Number of tuples already processed in the current phase.","description_zh":"在当前阶段已经处理的元组数量。","documented":true,"documented_name":"tuples_done","hidden":false,"name":"tuples_done","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":15,"description":"Total number of partitions on which the index is to be created or attached, including both direct and indirect partitions. 0 during a REINDEX, or when the index is not partitioned.","description_zh":"要创建或附加索引的分区总数，包括直接分区和间接分区。在 REINDEX 期间，或索引未分区时，此值为 0。","documented":true,"documented_name":"partitions_total","hidden":false,"name":"partitions_total","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":16,"description":"Number of partitions on which the index has already been created or attached, including both direct and indirect partitions. 0 during a REINDEX, or when the index is not partitioned.","description_zh":"已创建或附加索引的分区数量，包括直接分区和间接分区。在 REINDEX 期间，或索引未分区时，此值为 0。","documented":true,"documented_name":"partitions_done","hidden":false,"name":"partitions_done","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20,"zh_from":"same-version-manual"}],"description":"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."}},"RequestedLocale":"en","Fallback":false,"Versions":["12","13","14","15","16","17","18","19","20"],"Locales":["en","zh-Hans"],"Signatures":null,"Spellings":null,"SQLState":null,"Evidence":null}