{"Entry":{"collection":"catalog","key":"pg_stat_progress_analyze","name":"pg_stat_progress_analyze","aliases":[],"metadata":{"changed_in":["18","19"],"changes":[{"added":[],"attributes":[],"description_changed":false,"descriptions":[],"from":"12","order":false,"removed":[],"status":"added","to":"13","types":[]},{"added":[],"attributes":[],"description_changed":false,"descriptions":[{"from":"Current processing phase. See Table 27.33.","name":"phase","to":"Current processing phase. See Table 28.35."}],"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.35.","name":"phase","to":"Current processing phase. See Table 28.37."}],"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.37.","name":"phase","to":"Current processing phase. See Table 28.38."}],"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.38.","name":"phase","to":"Current processing phase. See Table 27.39."}],"from":"16","listing":[],"order":false,"removed":[],"status":"reworded","to":"17","types":[],"unlisted":[]},{"added":["delay_time"],"attributes":[],"description_changed":false,"descriptions":[],"from":"17","listing":[],"order":false,"removed":[],"status":"changed","to":"18","types":[],"unlisted":[]},{"added":["started_by"],"attributes":[],"description_changed":false,"descriptions":[{"from":"Current processing phase. See Table 27.39.","name":"phase","to":"Current processing phase. See Table 27.42."}],"from":"18","listing":[],"order":false,"removed":[],"status":"changed","to":"19","types":[],"unlisted":[]},{"added":[],"attributes":[],"description_changed":false,"descriptions":[{"from":"Current processing phase. See Table 27.42.","name":"phase","to":"Current processing phase. See Table 27.43."}],"from":"19","listing":[],"order":false,"removed":[],"status":"reworded","to":"20","types":[],"unlisted":[]}],"column_count":14,"content_hash":"5c7f0d6fb8a4b4830566b76c1061436cf3fb5261e82baa1a3becdd92bc762917","first_version":"13","imported_at":"2026-09-30T00:40:55.929278+08:00","kind":"progress","last_version":"20","name":"pg_stat_progress_analyze","position":94,"present_in":["13","14","15","16","17","18","19","20"],"relation_oid":null,"relkind":"v","shared":false,"source_rev":"english-manuals:a5ae72875cbe2f04b551bd244d6eb8a9334a97fa866c1fb9a3fdbc5389457c52","summary":"Whenever ANALYZE is running, the pg_stat_progress_analyze view will contain a row for each backend that is currently running that command.","summary_zh":""}},"Definition":{"Collection":"catalog","Key":"pg_stat_progress_analyze","SourceDatabase":"center","Version":"18","SourceTable":"catalog","SourceKey":"pg_stat_progress_analyze","SourceRevision":"english-manuals:a5ae72875cbe2f04b551bd244d6eb8a9334a97fa866c1fb9a3fdbc5389457c52","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 analyzed.","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":"Current processing phase. See Table 27.39.","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":6,"description":"Total number of heap blocks that will be sampled.","description_zh":"","documented":true,"documented_name":"sample_blks_total","hidden":false,"name":"sample_blks_total","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20},{"array_dimensions":0,"attnum":7,"description":"Number of heap blocks scanned.","description_zh":"","documented":true,"documented_name":"sample_blks_scanned","hidden":false,"name":"sample_blks_scanned","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20},{"array_dimensions":0,"attnum":8,"description":"Number of extended statistics.","description_zh":"","documented":true,"documented_name":"ext_stats_total","hidden":false,"name":"ext_stats_total","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20},{"array_dimensions":0,"attnum":9,"description":"Number of extended statistics computed. This counter only advances when the phase is computing extended statistics.","description_zh":"","documented":true,"documented_name":"ext_stats_computed","hidden":false,"name":"ext_stats_computed","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20},{"array_dimensions":0,"attnum":10,"description":"Number of child tables.","description_zh":"","documented":true,"documented_name":"child_tables_total","hidden":false,"name":"child_tables_total","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20},{"array_dimensions":0,"attnum":11,"description":"Number of child tables scanned. This counter only advances when the phase is acquiring inherited sample rows.","description_zh":"","documented":true,"documented_name":"child_tables_done","hidden":false,"name":"child_tables_done","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20},{"array_dimensions":0,"attnum":12,"description":"OID of the child table currently being scanned. This field is only valid when the phase is acquiring inherited sample rows.","description_zh":"","documented":true,"documented_name":"current_child_table_relid","hidden":false,"name":"current_child_table_relid","not_null":false,"references":"","type":"oid","type_modifier":-1,"type_oid":26},{"array_dimensions":0,"attnum":13,"description":"Total time spent sleeping due to cost-based delay (see Section 19.10.2), in milliseconds (if track_cost_delay_timing is enabled, otherwise zero).","description_zh":"","documented":true,"documented_name":"delay_time","hidden":false,"name":"delay_time","not_null":false,"references":"","type":"double precision","type_modifier":-1,"type_oid":701}],"description":"Whenever ANALYZE is running, the pg_stat_progress_analyze view will contain a row for each backend that is currently running that 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-ANALYZE-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","phase","sample_blks_total","sample_blks_scanned","ext_stats_total","ext_stats_computed","child_tables_total","child_tables_done","current_child_table_relid","delay_time"],"runtime_verified":false,"source":"english-manual"},"ManualEvidence":{"doc":{"anchor":"PG-STAT-PROGRESS-ANALYZE-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","phase","sample_blks_total","sample_blks_scanned","ext_stats_total","ext_stats_computed","child_tables_total","child_tables_done","current_child_table_relid","delay_time"],"runtime_verified":false}},"Text":{"Collection":"catalog","Key":"pg_stat_progress_analyze","SourceDatabase":"pgweb","Version":"18","Locale":"zh-Hans","Title":"pg_stat_progress_analyze","Summary":"每当ANALYZE运行时，pg_stat_progress_analyze视图将包含当前运行该命令的每个后端的一行。下面的表描述了将要报告的信息，并提供了关于如何解释它们的信息。","BodyHTML":"\u003cp\u003e每当ANALYZE运行时，pg_stat_progress_analyze视图将包含当前运行该命令的每个后端的一行。下面的表描述了将要报告的信息，并提供了关于如何解释它们的信息。\u003c/p\u003e","SourceRevision":"2026-09-27@419045e","ContentHash":"dc40777553c1c0a77bd36a59487265618920ec697fd74837e765bba18d597246","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":"当前处理阶段。参见表 27.39。","name":"phase","type":"text","zh_from":"doc"},{"description_zh":"将被采样的堆块的总数。","name":"sample_blks_total","type":"bigint","zh_from":"doc"},{"description_zh":"扫描的堆块数量。","name":"sample_blks_scanned","type":"bigint","zh_from":"doc"},{"description_zh":"扩展统计信息的数量。","name":"ext_stats_total","type":"bigint","zh_from":"doc"},{"description_zh":"已经计算的扩展统计信息数量。此计数器仅在 computing extended statistics 阶段递增。","name":"ext_stats_computed","type":"bigint","zh_from":"doc"},{"description_zh":"子表的数量。","name":"child_tables_total","type":"bigint","zh_from":"doc"},{"description_zh":"扫描的子表数量。此计数器仅在acquiring inherited sample rows阶段递增。","name":"child_tables_done","type":"bigint","zh_from":"doc"},{"description_zh":"当前正在扫描的子表的OID。此字段仅在acquiring inherited sample rows时有效。","name":"current_child_table_relid","type":"oid","zh_from":"doc"},{"description_zh":"因基于代价的延迟而睡眠的总时间（参见第 19.10.2 节），以毫秒计（如果启用了track_cost_delay_timing，否则为零）。","name":"delay_time","type":"double precision","zh_from":"doc"}],"description_zh":"每当ANALYZE运行时，pg_stat_progress_analyze视图将包含当前运行该命令的每个后端的一行。下面的表描述了将要报告的信息，并提供了关于如何解释它们的信息。","zh_from":"doc"}},"RequestedLocale":"zh-Hans","Fallback":false,"Versions":["13","14","15","16","17","18","19","20"],"Locales":["en","zh-Hans"],"Signatures":null,"Spellings":null,"SQLState":null,"Evidence":null}