{"Entry":{"collection":"catalog","key":"pg_stat_progress_cluster","name":"pg_stat_progress_cluster","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. See Table 27.27.","name":"phase","to":"Current processing phase. See Table 27.39."}],"from":"12","listing":[],"order":false,"removed":[],"status":"reworded","to":"13","types":[],"unlisted":[]},{"added":[],"attributes":[],"description_changed":false,"descriptions":[{"from":"Current processing phase. See Table 27.39.","name":"phase","to":"Current processing phase. See Table 28.41."}],"from":"13","listing":[],"order":false,"removed":[],"status":"reworded","to":"14","types":[],"unlisted":[]},{"added":[],"attributes":[],"description_changed":false,"descriptions":[{"from":"Current processing phase. See Table 28.41.","name":"phase","to":"Current processing phase. See Table 28.43."}],"from":"14","listing":[],"order":false,"removed":[],"status":"reworded","to":"15","types":[],"unlisted":[]},{"added":[],"attributes":[],"description_changed":false,"descriptions":[{"from":"Current processing phase. See Table 28.43.","name":"phase","to":"Current processing phase. See Table 28.40."}],"from":"15","listing":[],"order":false,"removed":[],"status":"reworded","to":"16","types":[],"unlisted":[]},{"added":[],"attributes":[],"description_changed":false,"descriptions":[{"from":"Current processing phase. See Table 28.40.","name":"phase","to":"Current processing phase. See Table 27.41."}],"from":"16","listing":[],"order":false,"removed":[],"status":"reworded","to":"17","types":[],"unlisted":[]},{"added":[],"attributes":[],"description_changed":true,"descriptions":[{"from":"If the table is being scanned using an index, this is the OID of the index being used; otherwise, it is zero.","name":"cluster_index_relid","to":"OID of the index defining the order of the rewritten table, or zero if no index ordering is requested."},{"from":"The command that is running. Either CLUSTER or VACUUM FULL.","name":"command","to":"The command that is running. Either CLUSTER or VACUUM FULL. Because this view exists for backwards-compatibility purposes only, it will translate a REPACK command into CLUSTER if index ordering is requested, or VACUUM FULL otherwise."},{"from":"Current processing phase. See Table 27.41.","name":"phase","to":"Current processing phase. See Table 27.44."}],"from":"18","listing":[],"order":false,"removed":[],"status":"reworded","to":"19","types":[],"unlisted":[]},{"added":[],"attributes":[],"description_changed":false,"descriptions":[{"from":"Current processing phase. See Table 27.44.","name":"phase","to":"Current processing phase. See Table 27.45."}],"from":"19","listing":[],"order":false,"removed":[],"status":"reworded","to":"20","types":[],"unlisted":[]}],"column_count":12,"content_hash":"0508c603434ac21042f9557df3029341ca60edbc2721bfcda41920723e567a67","first_version":"12","imported_at":"2026-09-30T00:40:55.93665+08:00","kind":"progress","last_version":"20","name":"pg_stat_progress_cluster","position":96,"present_in":["12","13","14","15","16","17","18","19","20"],"relation_oid":null,"relkind":"v","shared":false,"source_rev":"english-manuals:e3d0cebb2e6bffc7ad3f5fc5df2b14ee845fdd2aa1d52be53c22d6a7aa099856","summary":"Whenever CLUSTER or VACUUM FULL is running, the pg_stat_progress_cluster view will contain a row for each backend that is currently running either command.","summary_zh":""}},"Definition":{"Collection":"catalog","Key":"pg_stat_progress_cluster","SourceDatabase":"center","Version":"18","SourceTable":"catalog","SourceKey":"pg_stat_progress_cluster","SourceRevision":"english-manuals:e3d0cebb2e6bffc7ad3f5fc5df2b14ee845fdd2aa1d52be53c22d6a7aa099856","Facts":{"columns":[{"array_dimensions":0,"attnum":1,"description":"Process ID of backend.","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 being clustered.","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":"The command that is running. Either CLUSTER or VACUUM FULL.","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":6,"description":"Current processing phase. See Table 27.41.","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":7,"description":"If the table is being scanned using an index, this is the OID of the index being used; otherwise, it is zero.","description_zh":"","documented":true,"documented_name":"cluster_index_relid","hidden":false,"name":"cluster_index_relid","not_null":false,"references":"","type":"oid","type_modifier":-1,"type_oid":26},{"array_dimensions":0,"attnum":8,"description":"Number of heap tuples scanned. This counter only advances when the phase is seq scanning heap, index scanning heap or writing new heap.","description_zh":"","documented":true,"documented_name":"heap_tuples_scanned","hidden":false,"name":"heap_tuples_scanned","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20},{"array_dimensions":0,"attnum":9,"description":"Number of heap tuples written. This counter only advances when the phase is seq scanning heap, index scanning heap or writing new heap.","description_zh":"","documented":true,"documented_name":"heap_tuples_written","hidden":false,"name":"heap_tuples_written","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20},{"array_dimensions":0,"attnum":10,"description":"Total number of heap blocks in the table. This number is reported as of the beginning of seq scanning heap.","description_zh":"","documented":true,"documented_name":"heap_blks_total","hidden":false,"name":"heap_blks_total","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20},{"array_dimensions":0,"attnum":11,"description":"Number of heap blocks scanned. This counter only advances when the phase is seq scanning heap.","description_zh":"","documented":true,"documented_name":"heap_blks_scanned","hidden":false,"name":"heap_blks_scanned","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20},{"array_dimensions":0,"attnum":12,"description":"Number of indexes rebuilt. This counter only advances when the phase is rebuilding index.","description_zh":"","documented":true,"documented_name":"index_rebuild_count","hidden":false,"name":"index_rebuild_count","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20}],"description":"Whenever CLUSTER or VACUUM FULL is running, the pg_stat_progress_cluster view will contain a row for each backend that is currently running either command. 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-CLUSTER-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","command","phase","cluster_index_relid","heap_tuples_scanned","heap_tuples_written","heap_blks_total","heap_blks_scanned","index_rebuild_count"],"runtime_verified":false,"source":"english-manual"},"ManualEvidence":{"doc":{"anchor":"PG-STAT-PROGRESS-CLUSTER-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","command","phase","cluster_index_relid","heap_tuples_scanned","heap_tuples_written","heap_blks_total","heap_blks_scanned","index_rebuild_count"],"runtime_verified":false}},"Text":{"Collection":"catalog","Key":"pg_stat_progress_cluster","SourceDatabase":"pgweb","Version":"18","Locale":"zh-Hans","Title":"pg_stat_progress_cluster","Summary":"每当CLUSTER或VACUUM FULL运行时，pg_stat_progress_cluster视图将为每个当前正在运行这两种命令之一的后端包含一行。下面的表格描述了将被报告的信息，并提供了关于如何解释这些信息的信息。","BodyHTML":"\u003cp\u003e每当CLUSTER或VACUUM FULL运行时，pg_stat_progress_cluster视图将为每个当前正在运行这两种命令之一的后端包含一行。下面的表格描述了将被报告的信息，并提供了关于如何解释这些信息的信息。\u003c/p\u003e","SourceRevision":"2026-09-27@419045e","ContentHash":"9b78596f9c012d62b2fe56d6e95bef4fe494d8c79b9cc2d9bb4f7b6f102bfda9","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":"正在运行的命令。CLUSTER或VACUUM FULL。","name":"command","type":"text","zh_from":"doc"},{"description_zh":"当前处理阶段。参见表 27.41。","name":"phase","type":"text","zh_from":"doc"},{"description_zh":"如果正在使用索引对表进行扫描，这就是正在使用的索引的OID；否则为0。","name":"cluster_index_relid","type":"oid","zh_from":"doc"},{"description_zh":"扫描的堆元组数。该计数器仅在阶段为seq scanning heap、index scanning heap 或 writing new heap 时才会递增。","name":"heap_tuples_scanned","type":"bigint","zh_from":"doc"},{"description_zh":"写入的堆元组的数量。这个计数器只有在阶段为seq scanning heap、index scanning heap 或 writing new heap时才会递增。","name":"heap_tuples_written","type":"bigint","zh_from":"doc"},{"description_zh":"表中的堆块总数。这个数字以seq scanning heap开始时的数量为准。","name":"heap_blks_total","type":"bigint","zh_from":"doc"},{"description_zh":"扫描的堆块数量。该计数器仅在阶段为seq scanning heap时才会递增。","name":"heap_blks_scanned","type":"bigint","zh_from":"doc"},{"description_zh":"已重建的索引数。该计数器仅在rebuilding index阶段时才会递增。","name":"index_rebuild_count","type":"bigint","zh_from":"doc"}],"description_zh":"每当CLUSTER或VACUUM FULL运行时，pg_stat_progress_cluster视图将为每个当前正在运行这两种命令之一的后端包含一行。下面的表格描述了将被报告的信息，并提供了关于如何解释这些信息的信息。","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}