{"Entry":{"collection":"catalog","key":"pg_stat_user_tables","name":"pg_stat_user_tables","aliases":[],"metadata":{"changed_in":["9.1","9.4","13","16","18","19"],"changes":[{"added":[],"attributes":[],"description_changed":false,"descriptions":[],"from":"8.4","order":false,"removed":[],"status":"coverage","to":"9.0","types":[]},{"added":["vacuum_count","autovacuum_count","analyze_count","autoanalyze_count"],"attributes":[],"description_changed":false,"descriptions":[],"from":"9.0","listing":[],"order":false,"removed":[],"status":"changed","to":"9.1","types":[],"unlisted":[]},{"added":["n_mod_since_analyze"],"attributes":[],"description_changed":false,"descriptions":[],"from":"9.3","listing":[],"order":false,"removed":[],"status":"changed","to":"9.4","types":[],"unlisted":[]},{"added":[],"attributes":[],"description_changed":false,"descriptions":[{"from":"Number of rows updated","name":"n_tup_upd","to":"Number of rows updated (includes HOT updated rows)"}],"from":"9.4","listing":[],"order":false,"removed":[],"status":"reworded","to":"9.5","types":[],"unlisted":[]},{"added":["n_ins_since_vacuum"],"attributes":[],"description_changed":false,"descriptions":[],"from":"12","listing":[],"order":false,"removed":[],"status":"changed","to":"13","types":[],"unlisted":[]},{"added":["last_seq_scan","last_idx_scan","n_tup_newpage_upd"],"attributes":[],"description_changed":false,"descriptions":[{"from":"Number of rows deleted","name":"n_tup_del","to":"Total number of rows deleted"},{"from":"Number of rows HOT updated (i.e., with no separate index update required)","name":"n_tup_hot_upd","to":"Number of rows HOT updated. These are updates where no successor versions are required in indexes."},{"from":"Number of rows inserted","name":"n_tup_ins","to":"Total number of rows inserted"},{"from":"Number of rows updated (includes HOT updated rows)","name":"n_tup_upd","to":"Total number of rows updated. (This includes row updates counted in n_tup_hot_upd and n_tup_newpage_upd, and remaining non-HOT updates.)"}],"from":"15","listing":[],"order":false,"removed":[],"status":"changed","to":"16","types":[],"unlisted":[]},{"added":["total_vacuum_time","total_autovacuum_time","total_analyze_time","total_autoanalyze_time"],"attributes":[],"description_changed":false,"descriptions":[{"from":"Estimated number of rows inserted since this table was last vacuumed","name":"n_ins_since_vacuum","to":"Estimated number of rows inserted since this table was last vacuumed (not counting VACUUM FULL)"}],"from":"17","listing":[],"order":false,"removed":[],"status":"changed","to":"18","types":[],"unlisted":[]},{"added":["stats_reset"],"attributes":[],"description_changed":false,"descriptions":[],"from":"18","listing":[],"order":false,"removed":[],"status":"changed","to":"19","types":[],"unlisted":[]}],"column_count":31,"content_hash":"68632a75c969c765f0d102f44d067a807863a7e0ae49f72ca2f2868646ccad5f","derived_content_hash":"b1d3eb29a4f87b5daff923c41ed0c1b81dc9073eddb39815ed5d2b676ce66594","first_version":"7.4","imported_at":"2026-09-30T00:40:56.032377+08:00","kind":"statistics","last_version":"20","name":"pg_stat_user_tables","position":114,"present_in":["7.4","8.0","8.1","8.2","8.3","8.4","9.0","9.1","9.2","9.3","9.4","9.5","9.6","10","11","12","13","14","15","16","17","18","19","20"],"relation_oid":null,"relkind":"v","shared":false,"source_rev":"catalog-bilingual-repair:b3a68a6192134073b0e136325c3fdb65692a6198403226256d21b20ac1f372e0","summary":"Same as pg_stat_all_tables, except that only user tables are shown.","summary_zh":"和 pg_stat_all_tables 一样，但只显示用户表。"}},"Definition":{"Collection":"catalog","Key":"pg_stat_user_tables","SourceDatabase":"center","Version":"18","SourceTable":"catalog","SourceKey":"pg_stat_user_tables","SourceRevision":"catalog-bilingual-repair:b3a68a6192134073b0e136325c3fdb65692a6198403226256d21b20ac1f372e0","Facts":{"columns":[{"array_dimensions":0,"attnum":1,"description":"OID of a table","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":2,"description":"Name of the schema that this table is in","description_zh":"该表所在的模式的名称","documented":true,"documented_name":"schemaname","hidden":false,"name":"schemaname","not_null":false,"references":"","type":"name","type_modifier":-1,"type_oid":19,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":3,"description":"Name of this table","description_zh":"这个表的名称","documented":true,"documented_name":"relname","hidden":false,"name":"relname","not_null":false,"references":"","type":"name","type_modifier":-1,"type_oid":19,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":4,"description":"Number of sequential scans initiated on this table","description_zh":"在此表上启动的顺序扫描数","documented":true,"documented_name":"seq_scan","hidden":false,"name":"seq_scan","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":5,"description":"The time of the last sequential scan on this table, based on the most recent transaction stop time","description_zh":"此表上最后一次顺序扫描的时间，基于最近的事务停止时间","documented":true,"documented_name":"last_seq_scan","hidden":false,"name":"last_seq_scan","not_null":false,"references":"","type":"timestamp with time zone","type_modifier":-1,"type_oid":1184,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":6,"description":"Number of live rows fetched by sequential scans","description_zh":"顺序扫描获取的存活行数","documented":true,"documented_name":"seq_tup_read","hidden":false,"name":"seq_tup_read","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":7,"description":"Number of index scans initiated on this table","description_zh":"对这个表发起的索引扫描数","documented":true,"documented_name":"idx_scan","hidden":false,"name":"idx_scan","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":8,"description":"The time of the last index scan on this table, based on the most recent transaction stop time","description_zh":"此表上最后一次索引扫描的时间，基于最近的事务停止时间","documented":true,"documented_name":"last_idx_scan","hidden":false,"name":"last_idx_scan","not_null":false,"references":"","type":"timestamp with time zone","type_modifier":-1,"type_oid":1184,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":9,"description":"Number of live rows fetched by index scans","description_zh":"索引扫描获取的存活行数","documented":true,"documented_name":"idx_tup_fetch","hidden":false,"name":"idx_tup_fetch","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":10,"description":"Total number of rows inserted","description_zh":"插入的行数","documented":true,"documented_name":"n_tup_ins","hidden":false,"name":"n_tup_ins","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 rows updated. (This includes row updates counted in n_tup_hot_upd and n_tup_newpage_upd, and remaining non-HOT updates.)","description_zh":"更新的总行数。（包括计入 n_tup_hot_upd 和 n_tup_newpage_upd 的行更新，以及其余非 HOT 更新。）","documented":true,"documented_name":"n_tup_upd","hidden":false,"name":"n_tup_upd","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":12,"description":"Total number of rows deleted","description_zh":"删除的行数","documented":true,"documented_name":"n_tup_del","hidden":false,"name":"n_tup_del","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":13,"description":"Number of rows HOT updated. These are updates where no successor versions are required in indexes.","description_zh":"进行 HOT 更新的行数。这些更新不需要在索引中存储后继版本。","documented":true,"documented_name":"n_tup_hot_upd","hidden":false,"name":"n_tup_hot_upd","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 rows updated where the successor version goes onto a new heap page, leaving behind an original version with a t_ctid field that points to a different heap page. These are always non-HOT updates.","description_zh":"更新的行数，其中后继版本转到新的堆页，留下一个原始版本，其 t_ctid 字段指向不同的堆页。这些始终是非 HOT 更新。","documented":true,"documented_name":"n_tup_newpage_upd","hidden":false,"name":"n_tup_newpage_upd","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":15,"description":"Estimated number of live rows","description_zh":"活的行的估计数量","documented":true,"documented_name":"n_live_tup","hidden":false,"name":"n_live_tup","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":16,"description":"Estimated number of dead rows","description_zh":"死行的估计数量","documented":true,"documented_name":"n_dead_tup","hidden":false,"name":"n_dead_tup","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":17,"description":"Estimated number of rows modified since this table was last analyzed","description_zh":"自上次分析此表以来修改的行的估计数量","documented":true,"documented_name":"n_mod_since_analyze","hidden":false,"name":"n_mod_since_analyze","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":18,"description":"Estimated number of rows inserted since this table was last vacuumed (not counting VACUUM FULL)","description_zh":"自上次清理此表以来插入的行的估计数量（不计 VACUUM FULL）","documented":true,"documented_name":"n_ins_since_vacuum","hidden":false,"name":"n_ins_since_vacuum","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":19,"description":"Last time at which this table was manually vacuumed (not counting VACUUM FULL)","description_zh":"最后一次手动清理这个表的时间（不包括 VACUUM FULL）","documented":true,"documented_name":"last_vacuum","hidden":false,"name":"last_vacuum","not_null":false,"references":"","type":"timestamp with time zone","type_modifier":-1,"type_oid":1184,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":20,"description":"Last time at which this table was vacuumed by the autovacuum daemon","description_zh":"这个表最后一次被自动清理守护进程清理的时间","documented":true,"documented_name":"last_autovacuum","hidden":false,"name":"last_autovacuum","not_null":false,"references":"","type":"timestamp with time zone","type_modifier":-1,"type_oid":1184,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":21,"description":"Last time at which this table was manually analyzed","description_zh":"上一次手动分析这个表的时间","documented":true,"documented_name":"last_analyze","hidden":false,"name":"last_analyze","not_null":false,"references":"","type":"timestamp with time zone","type_modifier":-1,"type_oid":1184,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":22,"description":"Last time at which this table was analyzed by the autovacuum daemon","description_zh":"自动清理守护进程最后一次分析这个表的时间","documented":true,"documented_name":"last_autoanalyze","hidden":false,"name":"last_autoanalyze","not_null":false,"references":"","type":"timestamp with time zone","type_modifier":-1,"type_oid":1184,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":23,"description":"Number of times this table has been manually vacuumed (not counting VACUUM FULL)","description_zh":"这个表被手动清理的次数（VACUUM FULL 不计数）","documented":true,"documented_name":"vacuum_count","hidden":false,"name":"vacuum_count","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":24,"description":"Number of times this table has been vacuumed by the autovacuum daemon","description_zh":"这个表被自动清理守护进程清理的次数","documented":true,"documented_name":"autovacuum_count","hidden":false,"name":"autovacuum_count","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":25,"description":"Number of times this table has been manually analyzed","description_zh":"手动分析这个表的次数","documented":true,"documented_name":"analyze_count","hidden":false,"name":"analyze_count","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":26,"description":"Number of times this table has been analyzed by the autovacuum daemon","description_zh":"这个表被自动清理守护进程分析的次数","documented":true,"documented_name":"autoanalyze_count","hidden":false,"name":"autoanalyze_count","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":27,"description":"Total time this table has been manually vacuumed, in milliseconds (not counting VACUUM FULL). (This includes the time spent sleeping due to cost-based delays.)","description_zh":"手动清理此表所花费的总时间，以毫秒计（不包括 VACUUM FULL）。（这包括由于基于代价的延迟而睡眠的时间。）","documented":true,"documented_name":"total_vacuum_time","hidden":false,"name":"total_vacuum_time","not_null":false,"references":"","type":"double precision","type_modifier":-1,"type_oid":701,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":28,"description":"Total time this table has been vacuumed by the autovacuum daemon, in milliseconds. (This includes the time spent sleeping due to cost-based delays.)","description_zh":"自动清理守护进程清理该表所花费的总时间，以毫秒计。（这包括由于基于代价的延迟而睡眠的时间。）","documented":true,"documented_name":"total_autovacuum_time","hidden":false,"name":"total_autovacuum_time","not_null":false,"references":"","type":"double precision","type_modifier":-1,"type_oid":701,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":29,"description":"Total time this table has been manually analyzed, in milliseconds. (This includes the time spent sleeping due to cost-based delays.)","description_zh":"手动分析该表所花费的总时间，以毫秒计。（这包括由于基于代价的延迟而睡眠的时间。）","documented":true,"documented_name":"total_analyze_time","hidden":false,"name":"total_analyze_time","not_null":false,"references":"","type":"double precision","type_modifier":-1,"type_oid":701,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":30,"description":"Total time this table has been analyzed by the autovacuum daemon, in milliseconds. (This includes the time spent sleeping due to cost-based delays.)","description_zh":"自动清理守护进程分析该表所花费的总时间，以毫秒计。（这包括由于基于代价的延迟而睡眠的时间。）","documented":true,"documented_name":"total_autoanalyze_time","hidden":false,"name":"total_autoanalyze_time","not_null":false,"references":"","type":"double precision","type_modifier":-1,"type_oid":701,"zh_from":"same-version-manual"}],"columns_not_enumerated":false,"derived_from":"pg_stat_all_tables","description":"Same as pg_stat_all_tables, except that only user tables are shown.","description_zh":"和 pg_stat_all_tables 一样，但只显示用户表。","description_zh_html":"\u003cp\u003e和 pg_stat_all_tables 一样，但只显示用户表。\u003c/p\u003e","doc":{"anchor":"id-1.6.14.7.6.8.2.2.13.1.2","file":"monitoring-stats.html","lang":"en","sha256":"aa979eed08627fbf715a9d792094a162a73671db5af810f3ab2aad3e073d5722","slug":"18"},"kind":"statistics","lang":"en","measured_attributes":false,"metadata_release":"","runtime_columns":["relid","schemaname","relname","seq_scan","last_seq_scan","seq_tup_read","idx_scan","last_idx_scan","idx_tup_fetch","n_tup_ins","n_tup_upd","n_tup_del","n_tup_hot_upd","n_tup_newpage_upd","n_live_tup","n_dead_tup","n_mod_since_analyze","n_ins_since_vacuum","last_vacuum","last_autovacuum","last_analyze","last_autoanalyze","vacuum_count","autovacuum_count","analyze_count","autoanalyze_count","total_vacuum_time","total_autovacuum_time","total_analyze_time","total_autoanalyze_time"],"runtime_verified":false,"source":"english-manual","sources":[{"evidence":[{"build_id":107,"kind":"same-version-manual","locale":"zh-Hans","page":"monitoring-stats.html","sha256":"0274aac7991450316bcf7be44635653b6d896fb00e321242c1b6674cb05c2e53","source_revision":"unknown:rendered-translation-baseline","translation_revision":"git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:08e987a66af27b98444a8057c256314eafa13611a3fb9e888214fc436824244b","version":"18"}],"kind":"catalog-bilingual-repair","prior_source_revision":"english-manuals:b78643bf5647a94643469d04b46d3d11e0082445c926279f417a295a1278a86d","version":"18"}],"zh_from":"same-version-manual"},"ManualEvidence":{"doc":{"anchor":"id-1.6.14.7.6.8.2.2.13.1.2","file":"monitoring-stats.html","lang":"en","sha256":"aa979eed08627fbf715a9d792094a162a73671db5af810f3ab2aad3e073d5722","slug":"18"},"sources":[{"evidence":[{"build_id":107,"kind":"same-version-manual","locale":"zh-Hans","page":"monitoring-stats.html","sha256":"0274aac7991450316bcf7be44635653b6d896fb00e321242c1b6674cb05c2e53","source_revision":"unknown:rendered-translation-baseline","translation_revision":"git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:08e987a66af27b98444a8057c256314eafa13611a3fb9e888214fc436824244b","version":"18"}],"kind":"catalog-bilingual-repair","prior_source_revision":"english-manuals:b78643bf5647a94643469d04b46d3d11e0082445c926279f417a295a1278a86d","version":"18"}]},"MeasuredEvidence":{"measured_attributes":false,"metadata_release":"","runtime_columns":["relid","schemaname","relname","seq_scan","last_seq_scan","seq_tup_read","idx_scan","last_idx_scan","idx_tup_fetch","n_tup_ins","n_tup_upd","n_tup_del","n_tup_hot_upd","n_tup_newpage_upd","n_live_tup","n_dead_tup","n_mod_since_analyze","n_ins_since_vacuum","last_vacuum","last_autovacuum","last_analyze","last_autoanalyze","vacuum_count","autovacuum_count","analyze_count","autoanalyze_count","total_vacuum_time","total_autovacuum_time","total_analyze_time","total_autoanalyze_time"],"runtime_verified":false}},"Text":{"Collection":"catalog","Key":"pg_stat_user_tables","SourceDatabase":"center","Version":"18","Locale":"en","Title":"pg_stat_user_tables","Summary":"Same as pg_stat_all_tables, except that only user tables are shown.","BodyHTML":"\u003cp\u003eSame as pg_stat_all_tables, except that only user tables are shown.\u003c/p\u003e","SourceRevision":"catalog-bilingual-repair:b3a68a6192134073b0e136325c3fdb65692a6198403226256d21b20ac1f372e0","ContentHash":"a188be6b56b794083e6d4e13dcbc6fef53cd9a8fa592b6812d30bb90c505f859","Payload":{"columns":[{"array_dimensions":0,"attnum":1,"description":"OID of a table","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":2,"description":"Name of the schema that this table is in","description_zh":"该表所在的模式的名称","documented":true,"documented_name":"schemaname","hidden":false,"name":"schemaname","not_null":false,"references":"","type":"name","type_modifier":-1,"type_oid":19,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":3,"description":"Name of this table","description_zh":"这个表的名称","documented":true,"documented_name":"relname","hidden":false,"name":"relname","not_null":false,"references":"","type":"name","type_modifier":-1,"type_oid":19,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":4,"description":"Number of sequential scans initiated on this table","description_zh":"在此表上启动的顺序扫描数","documented":true,"documented_name":"seq_scan","hidden":false,"name":"seq_scan","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":5,"description":"The time of the last sequential scan on this table, based on the most recent transaction stop time","description_zh":"此表上最后一次顺序扫描的时间，基于最近的事务停止时间","documented":true,"documented_name":"last_seq_scan","hidden":false,"name":"last_seq_scan","not_null":false,"references":"","type":"timestamp with time zone","type_modifier":-1,"type_oid":1184,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":6,"description":"Number of live rows fetched by sequential scans","description_zh":"顺序扫描获取的存活行数","documented":true,"documented_name":"seq_tup_read","hidden":false,"name":"seq_tup_read","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":7,"description":"Number of index scans initiated on this table","description_zh":"对这个表发起的索引扫描数","documented":true,"documented_name":"idx_scan","hidden":false,"name":"idx_scan","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":8,"description":"The time of the last index scan on this table, based on the most recent transaction stop time","description_zh":"此表上最后一次索引扫描的时间，基于最近的事务停止时间","documented":true,"documented_name":"last_idx_scan","hidden":false,"name":"last_idx_scan","not_null":false,"references":"","type":"timestamp with time zone","type_modifier":-1,"type_oid":1184,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":9,"description":"Number of live rows fetched by index scans","description_zh":"索引扫描获取的存活行数","documented":true,"documented_name":"idx_tup_fetch","hidden":false,"name":"idx_tup_fetch","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":10,"description":"Total number of rows inserted","description_zh":"插入的行数","documented":true,"documented_name":"n_tup_ins","hidden":false,"name":"n_tup_ins","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 rows updated. (This includes row updates counted in n_tup_hot_upd and n_tup_newpage_upd, and remaining non-HOT updates.)","description_zh":"更新的总行数。（包括计入 n_tup_hot_upd 和 n_tup_newpage_upd 的行更新，以及其余非 HOT 更新。）","documented":true,"documented_name":"n_tup_upd","hidden":false,"name":"n_tup_upd","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":12,"description":"Total number of rows deleted","description_zh":"删除的行数","documented":true,"documented_name":"n_tup_del","hidden":false,"name":"n_tup_del","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":13,"description":"Number of rows HOT updated. These are updates where no successor versions are required in indexes.","description_zh":"进行 HOT 更新的行数。这些更新不需要在索引中存储后继版本。","documented":true,"documented_name":"n_tup_hot_upd","hidden":false,"name":"n_tup_hot_upd","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 rows updated where the successor version goes onto a new heap page, leaving behind an original version with a t_ctid field that points to a different heap page. These are always non-HOT updates.","description_zh":"更新的行数，其中后继版本转到新的堆页，留下一个原始版本，其 t_ctid 字段指向不同的堆页。这些始终是非 HOT 更新。","documented":true,"documented_name":"n_tup_newpage_upd","hidden":false,"name":"n_tup_newpage_upd","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":15,"description":"Estimated number of live rows","description_zh":"活的行的估计数量","documented":true,"documented_name":"n_live_tup","hidden":false,"name":"n_live_tup","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":16,"description":"Estimated number of dead rows","description_zh":"死行的估计数量","documented":true,"documented_name":"n_dead_tup","hidden":false,"name":"n_dead_tup","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":17,"description":"Estimated number of rows modified since this table was last analyzed","description_zh":"自上次分析此表以来修改的行的估计数量","documented":true,"documented_name":"n_mod_since_analyze","hidden":false,"name":"n_mod_since_analyze","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":18,"description":"Estimated number of rows inserted since this table was last vacuumed (not counting VACUUM FULL)","description_zh":"自上次清理此表以来插入的行的估计数量（不计 VACUUM FULL）","documented":true,"documented_name":"n_ins_since_vacuum","hidden":false,"name":"n_ins_since_vacuum","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":19,"description":"Last time at which this table was manually vacuumed (not counting VACUUM FULL)","description_zh":"最后一次手动清理这个表的时间（不包括 VACUUM FULL）","documented":true,"documented_name":"last_vacuum","hidden":false,"name":"last_vacuum","not_null":false,"references":"","type":"timestamp with time zone","type_modifier":-1,"type_oid":1184,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":20,"description":"Last time at which this table was vacuumed by the autovacuum daemon","description_zh":"这个表最后一次被自动清理守护进程清理的时间","documented":true,"documented_name":"last_autovacuum","hidden":false,"name":"last_autovacuum","not_null":false,"references":"","type":"timestamp with time zone","type_modifier":-1,"type_oid":1184,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":21,"description":"Last time at which this table was manually analyzed","description_zh":"上一次手动分析这个表的时间","documented":true,"documented_name":"last_analyze","hidden":false,"name":"last_analyze","not_null":false,"references":"","type":"timestamp with time zone","type_modifier":-1,"type_oid":1184,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":22,"description":"Last time at which this table was analyzed by the autovacuum daemon","description_zh":"自动清理守护进程最后一次分析这个表的时间","documented":true,"documented_name":"last_autoanalyze","hidden":false,"name":"last_autoanalyze","not_null":false,"references":"","type":"timestamp with time zone","type_modifier":-1,"type_oid":1184,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":23,"description":"Number of times this table has been manually vacuumed (not counting VACUUM FULL)","description_zh":"这个表被手动清理的次数（VACUUM FULL 不计数）","documented":true,"documented_name":"vacuum_count","hidden":false,"name":"vacuum_count","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":24,"description":"Number of times this table has been vacuumed by the autovacuum daemon","description_zh":"这个表被自动清理守护进程清理的次数","documented":true,"documented_name":"autovacuum_count","hidden":false,"name":"autovacuum_count","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":25,"description":"Number of times this table has been manually analyzed","description_zh":"手动分析这个表的次数","documented":true,"documented_name":"analyze_count","hidden":false,"name":"analyze_count","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":26,"description":"Number of times this table has been analyzed by the autovacuum daemon","description_zh":"这个表被自动清理守护进程分析的次数","documented":true,"documented_name":"autoanalyze_count","hidden":false,"name":"autoanalyze_count","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":27,"description":"Total time this table has been manually vacuumed, in milliseconds (not counting VACUUM FULL). (This includes the time spent sleeping due to cost-based delays.)","description_zh":"手动清理此表所花费的总时间，以毫秒计（不包括 VACUUM FULL）。（这包括由于基于代价的延迟而睡眠的时间。）","documented":true,"documented_name":"total_vacuum_time","hidden":false,"name":"total_vacuum_time","not_null":false,"references":"","type":"double precision","type_modifier":-1,"type_oid":701,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":28,"description":"Total time this table has been vacuumed by the autovacuum daemon, in milliseconds. (This includes the time spent sleeping due to cost-based delays.)","description_zh":"自动清理守护进程清理该表所花费的总时间，以毫秒计。（这包括由于基于代价的延迟而睡眠的时间。）","documented":true,"documented_name":"total_autovacuum_time","hidden":false,"name":"total_autovacuum_time","not_null":false,"references":"","type":"double precision","type_modifier":-1,"type_oid":701,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":29,"description":"Total time this table has been manually analyzed, in milliseconds. (This includes the time spent sleeping due to cost-based delays.)","description_zh":"手动分析该表所花费的总时间，以毫秒计。（这包括由于基于代价的延迟而睡眠的时间。）","documented":true,"documented_name":"total_analyze_time","hidden":false,"name":"total_analyze_time","not_null":false,"references":"","type":"double precision","type_modifier":-1,"type_oid":701,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":30,"description":"Total time this table has been analyzed by the autovacuum daemon, in milliseconds. (This includes the time spent sleeping due to cost-based delays.)","description_zh":"自动清理守护进程分析该表所花费的总时间，以毫秒计。（这包括由于基于代价的延迟而睡眠的时间。）","documented":true,"documented_name":"total_autoanalyze_time","hidden":false,"name":"total_autoanalyze_time","not_null":false,"references":"","type":"double precision","type_modifier":-1,"type_oid":701,"zh_from":"same-version-manual"}],"description":"Same as pg_stat_all_tables, except that only user tables are shown."}},"RequestedLocale":"en","Fallback":false,"Versions":["10","11","12","13","14","15","16","17","18","19","20","7.4","8.0","8.1","8.2","8.3","8.4","9.0","9.1","9.2","9.3","9.4","9.5","9.6"],"Locales":["en","zh-Hans"],"Signatures":null,"Spellings":null,"SQLState":null,"Evidence":null}