{"Entry":{"collection":"catalog","key":"pg_stat_progress_repack","name":"pg_stat_progress_repack","aliases":[],"metadata":{"changed_in":[],"changes":[{"added":[],"attributes":[],"description_changed":false,"descriptions":[],"from":"18","order":false,"removed":[],"status":"added","to":"19","types":[]},{"added":[],"attributes":[],"description_changed":false,"descriptions":[{"from":"Current processing phase. See Table 27.49.","name":"phase","to":"Current processing phase. See Table 27.50."}],"from":"19","listing":[],"order":false,"removed":[],"status":"reworded","to":"20","types":[],"unlisted":[]}],"column_count":14,"content_hash":"10cc8cd17abbbbdfbbe637f203e768bb32715999fc92d445b5da00ec375d8fd8","first_version":"19","imported_at":"2026-09-30T00:40:55.951328+08:00","kind":"progress","last_version":"20","name":"pg_stat_progress_repack","position":100,"present_in":["19","20"],"relation_oid":null,"relkind":"v","shared":false,"source_rev":"english-manuals:557554cd3e88c12d807a0db5319c26be69737637395ae54d5dbeececa89f3553","summary":"Whenever REPACK, CLUSTER, or VACUUM FULL is running, the pg_stat_progress_repack view will contain a row for each backend that is currently running one of these commands.","summary_zh":""}},"Definition":{"Collection":"catalog","Key":"pg_stat_progress_repack","SourceDatabase":"center","Version":"20","SourceTable":"catalog","SourceKey":"pg_stat_progress_repack","SourceRevision":"english-manuals:557554cd3e88c12d807a0db5319c26be69737637395ae54d5dbeececa89f3553","Facts":{"columns":[{"description":"Process ID of backend.","description_zh":"","documented":true,"documented_name":"pid","hidden":false,"name":"pid","references":"","type":"integer"},{"description":"OID of the database to which this backend is connected.","description_zh":"","documented":true,"documented_name":"datid","hidden":false,"name":"datid","references":"","type":"oid"},{"description":"Name of the database to which this backend is connected.","description_zh":"","documented":true,"documented_name":"datname","hidden":false,"name":"datname","references":"","type":"name"},{"description":"OID of the table being processed.","description_zh":"","documented":true,"documented_name":"relid","hidden":false,"name":"relid","references":"","type":"oid"},{"description":"The command that is running. One of CLUSTER, REPACK, or VACUUM FULL.","description_zh":"","documented":true,"documented_name":"command","hidden":false,"name":"command","references":"","type":"text"},{"description":"Current processing phase. See Table 27.50.","description_zh":"","documented":true,"documented_name":"phase","hidden":false,"name":"phase","references":"","type":"text"},{"description":"OID of the index defining the order of the rewritten table, or zero if no index ordering is requested.","description_zh":"","documented":true,"documented_name":"repack_index_relid","hidden":false,"name":"repack_index_relid","references":"","type":"oid"},{"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","references":"","type":"bigint"},{"description":"Number of heap tuples inserted. This counter only advances when the phase is seq scanning heap, index scanning heap, writing new heap or catch-up.","description_zh":"","documented":true,"documented_name":"heap_tuples_inserted","hidden":false,"name":"heap_tuples_inserted","references":"","type":"bigint"},{"description":"Number of heap tuples updated. This counter only advances when the phase is catch-up.","description_zh":"","documented":true,"documented_name":"heap_tuples_updated","hidden":false,"name":"heap_tuples_updated","references":"","type":"bigint"},{"description":"Number of heap tuples deleted. This counter only advances when the phase is catch-up.","description_zh":"","documented":true,"documented_name":"heap_tuples_deleted","hidden":false,"name":"heap_tuples_deleted","references":"","type":"bigint"},{"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","references":"","type":"bigint"},{"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","references":"","type":"bigint"},{"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","references":"","type":"bigint"}],"description":"Whenever REPACK, CLUSTER, or VACUUM FULL is running, the pg_stat_progress_repack view will contain a row for each backend that is currently running one of these commands. 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-REPACK-VIEW","file":"progress-reporting.html","lang":"en","sha256":"a692c859d24d77ff71231c72596243a279325b5436ece3dad58945b55688646e","slug":"devel"},"kind":"progress","lang":"en","measured_attributes":false,"metadata_release":"","runtime_verified":false,"source":"english-manual"},"ManualEvidence":{"doc":{"anchor":"PG-STAT-PROGRESS-REPACK-VIEW","file":"progress-reporting.html","lang":"en","sha256":"a692c859d24d77ff71231c72596243a279325b5436ece3dad58945b55688646e","slug":"devel"}},"MeasuredEvidence":{"measured_attributes":false,"metadata_release":"","runtime_verified":false}},"Text":{"Collection":"catalog","Key":"pg_stat_progress_repack","SourceDatabase":"pgweb","Version":"20","Locale":"zh-Hans","Title":"pg_stat_progress_repack","Summary":"每当REPACK、CLUSTER或VACUUM FULL运行时，pg_stat_progress_repack视图将为每个当前正在运行这些命令之一的后端包含一行。下面的表格描述了将要报告的信息，并提供了关于如何解释这些信息的信息。","BodyHTML":"\u003cp\u003e每当REPACK、CLUSTER或VACUUM FULL运行时，pg_stat_progress_repack视图将为每个当前正在运行这些命令之一的后端包含一行。下面的表格描述了将要报告的信息，并提供了关于如何解释这些信息的信息。\u003c/p\u003e","SourceRevision":"2026-09-27@419045e","ContentHash":"ba8b35d686ab21e5f0bbb768296b68631f6d69b02bbd636c28be2671844ac764","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、REPACK 或 VACUUM FULL。","name":"command","type":"text","zh_from":"doc"},{"description_zh":"当前处理阶段。参见表 27.50。","name":"phase","type":"text","zh_from":"doc"},{"description_zh":"定义重写后表的行顺序的索引 OID；如果未要求按索引排序，则为零。","name":"repack_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 或 catch-up 阶段递增。","name":"heap_tuples_inserted","type":"bigint","zh_from":"doc"},{"description_zh":"更新的堆元组数。该计数器仅在 catch-up 阶段递增。","name":"heap_tuples_updated","type":"bigint","zh_from":"doc"},{"description_zh":"删除的堆元组数。该计数器仅在 catch-up 阶段递增。","name":"heap_tuples_deleted","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":"每当REPACK、CLUSTER或VACUUM FULL运行时，pg_stat_progress_repack视图将为每个当前正在运行这些命令之一的后端包含一行。下面的表格描述了将要报告的信息，并提供了关于如何解释这些信息的信息。","zh_from":"doc"}},"RequestedLocale":"zh-Hans","Fallback":false,"Versions":["19","20"],"Locales":["en","zh-Hans"],"Signatures":null,"Spellings":null,"SQLState":null,"Evidence":null}