{"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":"56f6c046b151fbc8ed2634c153e6c9ab9815346b01633b6509c05767a9661b50","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":"english-manuals:1a16c55ab0e1e6d7afd0b05a0074709afeb155cabf38c6fb200bcc9e3a8ae01f","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":""}},"Definition":{"Collection":"catalog","Key":"pg_stat_progress_create_index","SourceDatabase":"center","Version":"18","SourceTable":"catalog","SourceKey":"pg_stat_progress_create_index","SourceRevision":"english-manuals:1a16c55ab0e1e6d7afd0b05a0074709afeb155cabf38c6fb200bcc9e3a8ae01f","Facts":{"columns":[{"array_dimensions":0,"attnum":1,"description":"Process ID of the backend creating indexes.","description_zh":"","documented":true,"documented_name":"pid","hidden":false,"name":"pid","not_null":false,"references":"","type":"integer","type_modifier":-1,"type_oid":23},{"array_dimensions":0,"attnum":2,"description":"OID of the database to which this backend is connected.","description_zh":"","documented":true,"documented_name":"datid","hidden":false,"name":"datid","not_null":false,"references":"","type":"oid","type_modifier":-1,"type_oid":26},{"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},{"array_dimensions":0,"attnum":4,"description":"OID of the table on which the index is being created.","description_zh":"","documented":true,"documented_name":"relid","hidden":false,"name":"relid","not_null":false,"references":"","type":"oid","type_modifier":-1,"type_oid":26},{"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":"","documented":true,"documented_name":"index_relid","hidden":false,"name":"index_relid","not_null":false,"references":"","type":"oid","type_modifier":-1,"type_oid":26},{"array_dimensions":0,"attnum":6,"description":"Specific command type: CREATE INDEX, CREATE INDEX CONCURRENTLY, REINDEX, or REINDEX CONCURRENTLY.","description_zh":"","documented":true,"documented_name":"command","hidden":false,"name":"command","not_null":false,"references":"","type":"text","type_modifier":-1,"type_oid":25},{"array_dimensions":0,"attnum":7,"description":"Current processing phase of index creation. See Table 27.44.","description_zh":"","documented":true,"documented_name":"phase","hidden":false,"name":"phase","not_null":false,"references":"","type":"text","type_modifier":-1,"type_oid":25},{"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},{"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},{"array_dimensions":0,"attnum":10,"description":"Process ID of the locker currently being waited for.","description_zh":"","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},{"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},{"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},{"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},{"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},{"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":"","documented":true,"documented_name":"partitions_total","hidden":false,"name":"partitions_total","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20},{"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":"","documented":true,"documented_name":"partitions_done","hidden":false,"name":"partitions_done","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20}],"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":"","doc":{"anchor":"PG-STAT-PROGRESS-CREATE-INDEX-VIEW","file":"progress-reporting.html","lang":"en","sha256":"a1f46d2b670502bfe75f1cf5192050ef2ef68202a8f928c4915abea0f4f71ae6","slug":"18"},"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"},"ManualEvidence":{"doc":{"anchor":"PG-STAT-PROGRESS-CREATE-INDEX-VIEW","file":"progress-reporting.html","lang":"en","sha256":"a1f46d2b670502bfe75f1cf5192050ef2ef68202a8f928c4915abea0f4f71ae6","slug":"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":"pgweb","Version":"18","Locale":"zh-Hans","Title":"pg_stat_progress_create_index","Summary":"每当运行CREATE INDEX或REINDEX时，pg_stat_progress_create_index视图将包含当前正在创建索引的每个后端的一行。下面的表描述了将要报告的信息，并提供了关于如何解释它的信息。","BodyHTML":"\u003cp\u003e每当运行CREATE INDEX或REINDEX时，pg_stat_progress_create_index视图将包含当前正在创建索引的每个后端的一行。下面的表描述了将要报告的信息，并提供了关于如何解释它的信息。\u003c/p\u003e","SourceRevision":"2026-09-27@419045e","ContentHash":"beeade96a1624e8f71efacee858b476d8839e7916b8cf9459bc6b596d6845874","Payload":{"columns":[{"description_zh":"正在创建索引的后端的进程 ID。","name":"pid","type":"integer","zh_from":"doc"},{"description_zh":"后端连接到的数据库的OID。","name":"datid","type":"oid","zh_from":"doc"},{"description_zh":"后端连接到的数据库的名称。","name":"datname","type":"name","zh_from":"doc"},{"description_zh":"正在创建索引的表的OID。","name":"relid","type":"oid","zh_from":"doc"},{"description_zh":"正在创建或重建索引的OID。在非并发 CREATE INDEX的时候，此为 0。","name":"index_relid","type":"oid","zh_from":"doc"},{"description_zh":"具体命令类型：CREATE INDEX、CREATE INDEX CONCURRENTLY、REINDEX或REINDEX CONCURRENTLY。","name":"command","type":"text","zh_from":"doc"},{"description_zh":"索引创建的当前处理阶段。参见表 27.44。","name":"phase","type":"text","zh_from":"doc"},{"description_zh":"在适用的情况下，需要等待的持锁进程总数。","name":"lockers_total","type":"bigint","zh_from":"doc"},{"description_zh":"已完成等待的持锁进程数量。","name":"lockers_done","type":"bigint","zh_from":"doc"},{"description_zh":"当前正被等待的持锁进程的进程 ID。","name":"current_locker_pid","type":"bigint","zh_from":"doc"},{"description_zh":"本阶段要处理的块总数。","name":"blocks_total","type":"bigint","zh_from":"doc"},{"description_zh":"当前阶段已经处理的块数量。","name":"blocks_done","type":"bigint","zh_from":"doc"},{"description_zh":"当前阶段要处理的元组总数。","name":"tuples_total","type":"bigint","zh_from":"doc"},{"description_zh":"在当前阶段已经处理的元组数量。","name":"tuples_done","type":"bigint","zh_from":"doc"},{"description_zh":"要创建或附加索引的分区总数，包括直接分区和间接分区。在REINDEX期间，或索引未分区时，此值为0。","name":"partitions_total","type":"bigint","zh_from":"doc"},{"description_zh":"已创建或附加索引的分区数量，包括直接分区和间接分区。在REINDEX期间，或索引未分区时，此值为0。","name":"partitions_done","type":"bigint","zh_from":"doc"}],"description_zh":"每当运行CREATE INDEX或REINDEX时，pg_stat_progress_create_index视图将包含当前正在创建索引的每个后端的一行。下面的表描述了将要报告的信息，并提供了关于如何解释它的信息。","zh_from":"doc"}},"RequestedLocale":"zh-Hans","Fallback":false,"Versions":["12","13","14","15","16","17","18","19","20"],"Locales":["en","zh-Hans"],"Signatures":null,"Spellings":null,"SQLState":null,"Evidence":null}