{"Entry":{"collection":"catalog","key":"pg_stat_xact_all_tables","name":"pg_stat_xact_all_tables","aliases":[],"metadata":{"changed_in":["16"],"changes":[{"added":[],"attributes":[],"description_changed":false,"descriptions":[],"from":"9.0","order":false,"removed":[],"status":"added","to":"9.1","types":[]},{"added":["n_tup_newpage_upd"],"attributes":[],"description_changed":false,"descriptions":[],"from":"15","listing":[],"order":false,"removed":[],"status":"changed","to":"16","types":[],"unlisted":[]},{"added":[],"attributes":[],"description_changed":false,"descriptions":[],"from":"19","order":false,"removed":[],"status":"coverage","to":"20","types":[]}],"column_count":0,"content_hash":"271cc0e1439d649e5be6e89812ea40624c71b4a3387ce2b0962d512bcd917210","derived_content_hash":"a41d714b0fc19d349f795e04f8c22a658d3aaebb352aa23739ede468f974fd2d","first_version":"9.1","imported_at":"2026-09-30T00:40:56.051707+08:00","kind":"statistics","last_version":"20","name":"pg_stat_xact_all_tables","position":117,"present_in":["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:7526a83209d7c73689bbd2446a5f27baabe09b120bf7e15787e3015426a95ad9","summary":"Similar to pg_stat_all_tables, but counts actions taken so far within the current transaction (which are not yet included in pg_stat_all_tables and related views).","summary_zh":"与 pg_stat_all_tables 相似，但只统计当前事务中截至目前执行的操作（这些操作尚未计入 pg_stat_all_tables 及相关视图）。此视图不包含存活行和死行数量以及清理、分析操作的列。"}},"Definition":{"Collection":"catalog","Key":"pg_stat_xact_all_tables","SourceDatabase":"center","Version":"18","SourceTable":"catalog","SourceKey":"pg_stat_xact_all_tables","SourceRevision":"catalog-bilingual-repair:7526a83209d7c73689bbd2446a5f27baabe09b120bf7e15787e3015426a95ad9","Facts":{"columns":[{"array_dimensions":0,"attnum":1,"description":"OID of a table","description_zh":"表的 OID","documented":false,"hidden":false,"name":"relid","not_null":false,"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":false,"hidden":false,"name":"schemaname","not_null":false,"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":false,"hidden":false,"name":"relname","not_null":false,"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 This view reports counters for the current transaction.","description_zh":"在此表上启动的顺序扫描数\n\n与 pg_stat_all_tables 相似，但只统计当前事务中截至目前执行的操作（这些操作尚未计入 pg_stat_all_tables 及相关视图）。此视图不包含存活行和死行数量以及清理、分析操作的列。","documented":false,"hidden":false,"name":"seq_scan","not_null":false,"type":"bigint","type_modifier":-1,"type_oid":20,"zh_from":"same-version-derived-view-with-scope"},{"array_dimensions":0,"attnum":5,"description":"Number of live rows fetched by sequential scans This view reports counters for the current transaction.","description_zh":"顺序扫描获取的存活行数\n\n与 pg_stat_all_tables 相似，但只统计当前事务中截至目前执行的操作（这些操作尚未计入 pg_stat_all_tables 及相关视图）。此视图不包含存活行和死行数量以及清理、分析操作的列。","documented":false,"hidden":false,"name":"seq_tup_read","not_null":false,"type":"bigint","type_modifier":-1,"type_oid":20,"zh_from":"same-version-derived-view-with-scope"},{"array_dimensions":0,"attnum":6,"description":"Number of index scans initiated on this table This view reports counters for the current transaction.","description_zh":"对这个表发起的索引扫描数\n\n与 pg_stat_all_tables 相似，但只统计当前事务中截至目前执行的操作（这些操作尚未计入 pg_stat_all_tables 及相关视图）。此视图不包含存活行和死行数量以及清理、分析操作的列。","documented":false,"hidden":false,"name":"idx_scan","not_null":false,"type":"bigint","type_modifier":-1,"type_oid":20,"zh_from":"same-version-derived-view-with-scope"},{"array_dimensions":0,"attnum":7,"description":"Number of live rows fetched by index scans This view reports counters for the current transaction.","description_zh":"索引扫描获取的存活行数\n\n与 pg_stat_all_tables 相似，但只统计当前事务中截至目前执行的操作（这些操作尚未计入 pg_stat_all_tables 及相关视图）。此视图不包含存活行和死行数量以及清理、分析操作的列。","documented":false,"hidden":false,"name":"idx_tup_fetch","not_null":false,"type":"bigint","type_modifier":-1,"type_oid":20,"zh_from":"same-version-derived-view-with-scope"},{"array_dimensions":0,"attnum":8,"description":"Total number of rows inserted This view reports counters for the current transaction.","description_zh":"插入的行数\n\n与 pg_stat_all_tables 相似，但只统计当前事务中截至目前执行的操作（这些操作尚未计入 pg_stat_all_tables 及相关视图）。此视图不包含存活行和死行数量以及清理、分析操作的列。","documented":false,"hidden":false,"name":"n_tup_ins","not_null":false,"type":"bigint","type_modifier":-1,"type_oid":20,"zh_from":"same-version-derived-view-with-scope"},{"array_dimensions":0,"attnum":9,"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.) This view reports counters for the current transaction.","description_zh":"更新的总行数。（包括计入 n_tup_hot_upd 和 n_tup_newpage_upd 的行更新，以及其余非 HOT 更新。）\n\n与 pg_stat_all_tables 相似，但只统计当前事务中截至目前执行的操作（这些操作尚未计入 pg_stat_all_tables 及相关视图）。此视图不包含存活行和死行数量以及清理、分析操作的列。","documented":false,"hidden":false,"name":"n_tup_upd","not_null":false,"type":"bigint","type_modifier":-1,"type_oid":20,"zh_from":"same-version-derived-view-with-scope"},{"array_dimensions":0,"attnum":10,"description":"Total number of rows deleted This view reports counters for the current transaction.","description_zh":"删除的行数\n\n与 pg_stat_all_tables 相似，但只统计当前事务中截至目前执行的操作（这些操作尚未计入 pg_stat_all_tables 及相关视图）。此视图不包含存活行和死行数量以及清理、分析操作的列。","documented":false,"hidden":false,"name":"n_tup_del","not_null":false,"type":"bigint","type_modifier":-1,"type_oid":20,"zh_from":"same-version-derived-view-with-scope"},{"array_dimensions":0,"attnum":11,"description":"Number of rows HOT updated. These are updates where no successor versions are required in indexes. This view reports counters for the current transaction.","description_zh":"进行 HOT 更新的行数。这些更新不需要在索引中存储后继版本。\n\n与 pg_stat_all_tables 相似，但只统计当前事务中截至目前执行的操作（这些操作尚未计入 pg_stat_all_tables 及相关视图）。此视图不包含存活行和死行数量以及清理、分析操作的列。","documented":false,"hidden":false,"name":"n_tup_hot_upd","not_null":false,"type":"bigint","type_modifier":-1,"type_oid":20,"zh_from":"same-version-derived-view-with-scope"},{"array_dimensions":0,"attnum":12,"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. This view reports counters for the current transaction.","description_zh":"更新的行数，其中后继版本转到新的堆页，留下一个原始版本，其 t_ctid 字段指向不同的堆页。这些始终是非 HOT 更新。\n\n与 pg_stat_all_tables 相似，但只统计当前事务中截至目前执行的操作（这些操作尚未计入 pg_stat_all_tables 及相关视图）。此视图不包含存活行和死行数量以及清理、分析操作的列。","documented":false,"hidden":false,"name":"n_tup_newpage_upd","not_null":false,"type":"bigint","type_modifier":-1,"type_oid":20,"zh_from":"same-version-derived-view-with-scope"}],"columns_not_enumerated":true,"derived_from":"pg_stat_all_tables","description":"Similar to pg_stat_all_tables, but counts actions taken so far within the current transaction (which are not yet included in pg_stat_all_tables and related views). The columns for numbers of live and dead rows and vacuum and analyze actions are not present in this view.","description_zh":"与 pg_stat_all_tables 相似，但只统计当前事务中截至目前执行的操作（这些操作尚未计入 pg_stat_all_tables 及相关视图）。此视图不包含存活行和死行数量以及清理、分析操作的列。","description_zh_html":"\u003cp\u003e与 pg_stat_all_tables 相似，但只统计当前事务中截至目前执行的操作（这些操作尚未计入 pg_stat_all_tables 及相关视图）。此视图不包含存活行和死行数量以及清理、分析操作的列。\u003c/p\u003e","doc":{"anchor":"id-1.6.14.7.6.8.2.2.14.1.2","file":"monitoring-stats.html","lang":"en","sha256":"aa979eed08627fbf715a9d792094a162a73671db5af810f3ab2aad3e073d5722","slug":"18"},"kind":"statistics","lang":"en","measured_attributes":true,"metadata_release":"18.6","runtime_columns":["relid","schemaname","relname","seq_scan","seq_tup_read","idx_scan","idx_tup_fetch","n_tup_ins","n_tup_upd","n_tup_del","n_tup_hot_upd","n_tup_newpage_upd"],"runtime_verified":false,"source":"english-manual","sources":[{"evidence":[{"base_relation":"pg_stat_all_tables","base_translation":{"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":"same-version-derived-view-with-scope","scope_source":{"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"}},{"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:297bb048ec7a19a225c5cc06c11c47af2744d9230f40fcfd973d9ddfad33861f","version":"18"}],"zh_from":"same-version-manual"},"ManualEvidence":{"doc":{"anchor":"id-1.6.14.7.6.8.2.2.14.1.2","file":"monitoring-stats.html","lang":"en","sha256":"aa979eed08627fbf715a9d792094a162a73671db5af810f3ab2aad3e073d5722","slug":"18"},"sources":[{"evidence":[{"base_relation":"pg_stat_all_tables","base_translation":{"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":"same-version-derived-view-with-scope","scope_source":{"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"}},{"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:297bb048ec7a19a225c5cc06c11c47af2744d9230f40fcfd973d9ddfad33861f","version":"18"}]},"MeasuredEvidence":{"measured_attributes":true,"metadata_release":"18.6","runtime_columns":["relid","schemaname","relname","seq_scan","seq_tup_read","idx_scan","idx_tup_fetch","n_tup_ins","n_tup_upd","n_tup_del","n_tup_hot_upd","n_tup_newpage_upd"],"runtime_verified":false}},"Text":{"Collection":"catalog","Key":"pg_stat_xact_all_tables","SourceDatabase":"center","Version":"18","Locale":"en","Title":"pg_stat_xact_all_tables","Summary":"Similar to pg_stat_all_tables, but counts actions taken so far within the current transaction (which are not yet included in pg_stat_all_tables and related views). The columns for numbers of live and dead rows and vacuum and analyze actions are not present in this view.","BodyHTML":"\u003cp\u003eSimilar to pg_stat_all_tables, but counts actions taken so far within the current transaction (which are not yet included in pg_stat_all_tables and related views). The columns for numbers of live and dead rows and vacuum and analyze actions are not present in this view.\u003c/p\u003e","SourceRevision":"catalog-bilingual-repair:7526a83209d7c73689bbd2446a5f27baabe09b120bf7e15787e3015426a95ad9","ContentHash":"99c1cefda0c66716f5f2c425cd8f7dfa9c4189b9781944e4823a79dbfb7024c3","Payload":{"columns":[{"array_dimensions":0,"attnum":1,"description":"OID of a table","description_zh":"表的 OID","documented":false,"hidden":false,"name":"relid","not_null":false,"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":false,"hidden":false,"name":"schemaname","not_null":false,"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":false,"hidden":false,"name":"relname","not_null":false,"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 This view reports counters for the current transaction.","description_zh":"在此表上启动的顺序扫描数\n\n与 pg_stat_all_tables 相似，但只统计当前事务中截至目前执行的操作（这些操作尚未计入 pg_stat_all_tables 及相关视图）。此视图不包含存活行和死行数量以及清理、分析操作的列。","documented":false,"hidden":false,"name":"seq_scan","not_null":false,"type":"bigint","type_modifier":-1,"type_oid":20,"zh_from":"same-version-derived-view-with-scope"},{"array_dimensions":0,"attnum":5,"description":"Number of live rows fetched by sequential scans This view reports counters for the current transaction.","description_zh":"顺序扫描获取的存活行数\n\n与 pg_stat_all_tables 相似，但只统计当前事务中截至目前执行的操作（这些操作尚未计入 pg_stat_all_tables 及相关视图）。此视图不包含存活行和死行数量以及清理、分析操作的列。","documented":false,"hidden":false,"name":"seq_tup_read","not_null":false,"type":"bigint","type_modifier":-1,"type_oid":20,"zh_from":"same-version-derived-view-with-scope"},{"array_dimensions":0,"attnum":6,"description":"Number of index scans initiated on this table This view reports counters for the current transaction.","description_zh":"对这个表发起的索引扫描数\n\n与 pg_stat_all_tables 相似，但只统计当前事务中截至目前执行的操作（这些操作尚未计入 pg_stat_all_tables 及相关视图）。此视图不包含存活行和死行数量以及清理、分析操作的列。","documented":false,"hidden":false,"name":"idx_scan","not_null":false,"type":"bigint","type_modifier":-1,"type_oid":20,"zh_from":"same-version-derived-view-with-scope"},{"array_dimensions":0,"attnum":7,"description":"Number of live rows fetched by index scans This view reports counters for the current transaction.","description_zh":"索引扫描获取的存活行数\n\n与 pg_stat_all_tables 相似，但只统计当前事务中截至目前执行的操作（这些操作尚未计入 pg_stat_all_tables 及相关视图）。此视图不包含存活行和死行数量以及清理、分析操作的列。","documented":false,"hidden":false,"name":"idx_tup_fetch","not_null":false,"type":"bigint","type_modifier":-1,"type_oid":20,"zh_from":"same-version-derived-view-with-scope"},{"array_dimensions":0,"attnum":8,"description":"Total number of rows inserted This view reports counters for the current transaction.","description_zh":"插入的行数\n\n与 pg_stat_all_tables 相似，但只统计当前事务中截至目前执行的操作（这些操作尚未计入 pg_stat_all_tables 及相关视图）。此视图不包含存活行和死行数量以及清理、分析操作的列。","documented":false,"hidden":false,"name":"n_tup_ins","not_null":false,"type":"bigint","type_modifier":-1,"type_oid":20,"zh_from":"same-version-derived-view-with-scope"},{"array_dimensions":0,"attnum":9,"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.) This view reports counters for the current transaction.","description_zh":"更新的总行数。（包括计入 n_tup_hot_upd 和 n_tup_newpage_upd 的行更新，以及其余非 HOT 更新。）\n\n与 pg_stat_all_tables 相似，但只统计当前事务中截至目前执行的操作（这些操作尚未计入 pg_stat_all_tables 及相关视图）。此视图不包含存活行和死行数量以及清理、分析操作的列。","documented":false,"hidden":false,"name":"n_tup_upd","not_null":false,"type":"bigint","type_modifier":-1,"type_oid":20,"zh_from":"same-version-derived-view-with-scope"},{"array_dimensions":0,"attnum":10,"description":"Total number of rows deleted This view reports counters for the current transaction.","description_zh":"删除的行数\n\n与 pg_stat_all_tables 相似，但只统计当前事务中截至目前执行的操作（这些操作尚未计入 pg_stat_all_tables 及相关视图）。此视图不包含存活行和死行数量以及清理、分析操作的列。","documented":false,"hidden":false,"name":"n_tup_del","not_null":false,"type":"bigint","type_modifier":-1,"type_oid":20,"zh_from":"same-version-derived-view-with-scope"},{"array_dimensions":0,"attnum":11,"description":"Number of rows HOT updated. These are updates where no successor versions are required in indexes. This view reports counters for the current transaction.","description_zh":"进行 HOT 更新的行数。这些更新不需要在索引中存储后继版本。\n\n与 pg_stat_all_tables 相似，但只统计当前事务中截至目前执行的操作（这些操作尚未计入 pg_stat_all_tables 及相关视图）。此视图不包含存活行和死行数量以及清理、分析操作的列。","documented":false,"hidden":false,"name":"n_tup_hot_upd","not_null":false,"type":"bigint","type_modifier":-1,"type_oid":20,"zh_from":"same-version-derived-view-with-scope"},{"array_dimensions":0,"attnum":12,"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. This view reports counters for the current transaction.","description_zh":"更新的行数，其中后继版本转到新的堆页，留下一个原始版本，其 t_ctid 字段指向不同的堆页。这些始终是非 HOT 更新。\n\n与 pg_stat_all_tables 相似，但只统计当前事务中截至目前执行的操作（这些操作尚未计入 pg_stat_all_tables 及相关视图）。此视图不包含存活行和死行数量以及清理、分析操作的列。","documented":false,"hidden":false,"name":"n_tup_newpage_upd","not_null":false,"type":"bigint","type_modifier":-1,"type_oid":20,"zh_from":"same-version-derived-view-with-scope"}],"description":"Similar to pg_stat_all_tables, but counts actions taken so far within the current transaction (which are not yet included in pg_stat_all_tables and related views). The columns for numbers of live and dead rows and vacuum and analyze actions are not present in this view."}},"RequestedLocale":"en","Fallback":false,"Versions":["10","11","12","13","14","15","16","17","18","19","20","9.1","9.2","9.3","9.4","9.5","9.6"],"Locales":["en","zh-Hans"],"Signatures":null,"Spellings":null,"SQLState":null,"Evidence":null}