{"Entry":{"collection":"catalog","key":"pg_statio_all_tables","name":"pg_statio_all_tables","aliases":[],"metadata":{"changed_in":["19"],"changes":[{"added":[],"attributes":[],"description_changed":true,"descriptions":[],"from":"8.0","order":false,"removed":[],"status":"reworded","to":"8.1","types":[]},{"added":[],"attributes":[],"description_changed":false,"descriptions":[],"from":"8.4","order":false,"removed":[],"status":"coverage","to":"9.0","types":[]},{"added":[],"attributes":[],"description_changed":true,"descriptions":[],"from":"9.1","listing":[],"order":false,"removed":[],"status":"reworded","to":"9.2","types":[],"unlisted":[]},{"added":[],"attributes":[],"description_changed":false,"descriptions":[{"from":"Number of buffer hits in this table's TOAST table index (if any)","name":"tidx_blks_hit","to":"Number of buffer hits in this table's TOAST table indexes (if any)"},{"from":"Number of disk blocks read from this table's TOAST table index (if any)","name":"tidx_blks_read","to":"Number of disk blocks read from this table's TOAST table indexes (if any)"}],"from":"9.3","listing":[],"order":false,"removed":[],"status":"reworded","to":"9.4","types":[],"unlisted":[]},{"added":[],"attributes":[],"description_changed":true,"descriptions":[],"from":"12","listing":[],"order":false,"removed":[],"status":"reworded","to":"13","types":[],"unlisted":[]},{"added":["stats_reset"],"attributes":[],"description_changed":false,"descriptions":[],"from":"18","listing":[],"order":false,"removed":[],"status":"changed","to":"19","types":[],"unlisted":[]}],"column_count":12,"content_hash":"894248a9c47d7b19136a1e1541bcf21b1cc5a7f7d201f53b0ccd70dd015c0514","derived_content_hash":"7666b26aede58b6421e3dec9238e56796506b2fbc659c307b5c16f2f34d52e00","documentation_refresh":{"batch":"20261113","original_source_rev":"catalog-bilingual-repair:2b1bb5ddf19a3a78c38e8eac860166554c484d56825f4da372a52c01ddb4fa7e","versions":{"14":"14.25","15":"15.20","16":"16.16","17":"17.12","18":"18.7","19":"19rc2"}},"first_version":"7.4","imported_at":"2026-09-30T00:40:56.093255+08:00","kind":"statistics","last_version":"20","name":"pg_statio_all_tables","position":123,"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:2b1bb5ddf19a3a78c38e8eac860166554c484d56825f4da372a52c01ddb4fa7e","summary":"The pg_statio_all_tables view will contain one row for each table in the current database (including TOAST tables), showing statistics about I/O on that specific table.","summary_zh":"pg_statio_all_tables 视图将为当前数据库中的每个表（包括 TOAST 表）包含一行，该行显示指定表上有关 I/O 的统计信息。pg_statio_user_tables 和 pg_statio_sys_tables 视图包含相同的信息，但经过过滤，分别只显示用户表和系统表。"}},"Definition":{"Collection":"catalog","Key":"pg_statio_all_tables","SourceDatabase":"center","Version":"18","SourceTable":"catalog","SourceKey":"pg_statio_all_tables","SourceRevision":"catalog-bilingual-repair:2b1bb5ddf19a3a78c38e8eac860166554c484d56825f4da372a52c01ddb4fa7e","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 disk blocks read from this table","description_zh":"从该表中读取的磁盘块的数量","documented":true,"documented_name":"heap_blks_read","hidden":false,"name":"heap_blks_read","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":5,"description":"Number of buffer hits in this table","description_zh":"该表中的缓冲区命中数","documented":true,"documented_name":"heap_blks_hit","hidden":false,"name":"heap_blks_hit","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":6,"description":"Number of disk blocks read from all indexes on this table","description_zh":"从这个表上所有索引读取的磁盘块数","documented":true,"documented_name":"idx_blks_read","hidden":false,"name":"idx_blks_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 buffer hits in all indexes on this table","description_zh":"这个表上所有索引中的缓冲区命中数","documented":true,"documented_name":"idx_blks_hit","hidden":false,"name":"idx_blks_hit","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":8,"description":"Number of disk blocks read from this table's TOAST table (if any)","description_zh":"从这个表的 TOAST 表中读取的磁盘块的数量（如果有的话）","documented":true,"documented_name":"toast_blks_read","hidden":false,"name":"toast_blks_read","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":9,"description":"Number of buffer hits in this table's TOAST table (if any)","description_zh":"这个表的 TOAST 表中的缓冲区命中数（如果有的话）","documented":true,"documented_name":"toast_blks_hit","hidden":false,"name":"toast_blks_hit","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":10,"description":"Number of disk blocks read from this table's TOAST table indexes (if any)","description_zh":"从这个表的 TOAST 表索引中读取的磁盘块的数量（如果有的话）","documented":true,"documented_name":"tidx_blks_read","hidden":false,"name":"tidx_blks_read","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":11,"description":"Number of buffer hits in this table's TOAST table indexes (if any)","description_zh":"这个表的 TOAST 表索引中的缓冲区命中数（如果有的话）","documented":true,"documented_name":"tidx_blks_hit","hidden":false,"name":"tidx_blks_hit","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20,"zh_from":"same-version-manual"}],"description":"The pg_statio_all_tables view will contain one row for each table in the current database (including TOAST tables), showing statistics about I/O on that specific table. The pg_statio_user_tables and pg_statio_sys_tables views contain the same information, but filtered to only show user and system tables respectively.","description_zh":"pg_statio_all_tables 视图将为当前数据库中的每个表（包括 TOAST 表）包含一行，该行显示指定表上有关 I/O 的统计信息。pg_statio_user_tables 和 pg_statio_sys_tables 视图包含相同的信息，但经过过滤，分别只显示用户表和系统表。","description_zh_html":"\u003cp\u003epg_statio_all_tables 视图将为当前数据库中的每个表（包括 TOAST 表）包含一行，该行显示指定表上有关 I/O 的统计信息。pg_statio_user_tables 和 pg_statio_sys_tables 视图包含相同的信息，但经过过滤，分别只显示用户表和系统表。\u003c/p\u003e\u003cdiv class=\"table\" id=\"PG-STATIO-ALL-TABLES-VIEW\"\u003e\u003cp class=\"title\"\u003e\u003cstrong\u003e表 27.31. \u003ccode class=\"structname\"\u003epg_statio_all_tables\u003c/code\u003e 视图\u003c/strong\u003e\u003c/p\u003e\u003cdiv class=\"table-contents\"\u003e\u003ctable border=\"1\" class=\"table\" summary=\"pg_statio_all_tables 视图\"\u003e\u003ccolgroup\u003e\u003ccol/\u003e\u003c/colgroup\u003e\u003cthead\u003e\u003ctr\u003e\u003cth class=\"catalog_table_entry\"\u003e\u003cp class=\"column_definition\"\u003e\n       列类型\n      \u003c/p\u003e\n\u003cp\u003e\n       描述\n      \u003c/p\u003e\u003c/th\u003e\u003c/tr\u003e\u003c/thead\u003e\u003ctbody\u003e\u003ctr\u003e\u003ctd class=\"catalog_table_entry\"\u003e\u003cp class=\"column_definition\"\u003e\n\u003ccode class=\"structfield\"\u003erelid\u003c/code\u003e \u003ccode class=\"type\"\u003eoid\u003c/code\u003e\n\u003c/p\u003e\n\u003cp\u003e\n       表的 OID\n      \u003c/p\u003e\u003c/td\u003e\u003c/tr\u003e\u003ctr\u003e\u003ctd class=\"catalog_table_entry\"\u003e\u003cp class=\"column_definition\"\u003e\n\u003ccode class=\"structfield\"\u003eschemaname\u003c/code\u003e \u003ccode class=\"type\"\u003ename\u003c/code\u003e\n\u003c/p\u003e\n\u003cp\u003e\n       该表所在的模式的名称\n      \u003c/p\u003e\u003c/td\u003e\u003c/tr\u003e\u003ctr\u003e\u003ctd class=\"catalog_table_entry\"\u003e\u003cp class=\"column_definition\"\u003e\n\u003ccode class=\"structfield\"\u003erelname\u003c/code\u003e \u003ccode class=\"type\"\u003ename\u003c/code\u003e\n\u003c/p\u003e\n\u003cp\u003e\n       这个表的名称\n      \u003c/p\u003e\u003c/td\u003e\u003c/tr\u003e\u003ctr\u003e\u003ctd class=\"catalog_table_entry\"\u003e\u003cp class=\"column_definition\"\u003e\n\u003ccode class=\"structfield\"\u003eheap_blks_read\u003c/code\u003e \u003ccode class=\"type\"\u003ebigint\u003c/code\u003e\n\u003c/p\u003e\n\u003cp\u003e\n       从该表中读取的磁盘块的数量\n      \u003c/p\u003e\u003c/td\u003e\u003c/tr\u003e\u003ctr\u003e\u003ctd class=\"catalog_table_entry\"\u003e\u003cp class=\"column_definition\"\u003e\n\u003ccode class=\"structfield\"\u003eheap_blks_hit\u003c/code\u003e \u003ccode class=\"type\"\u003ebigint\u003c/code\u003e\n\u003c/p\u003e\n\u003cp\u003e\n       该表中的缓冲区命中数\n      \u003c/p\u003e\u003c/td\u003e\u003c/tr\u003e\u003ctr\u003e\u003ctd class=\"catalog_table_entry\"\u003e\u003cp class=\"column_definition\"\u003e\n\u003ccode class=\"structfield\"\u003eidx_blks_read\u003c/code\u003e \u003ccode class=\"type\"\u003ebigint\u003c/code\u003e\n\u003c/p\u003e\n\u003cp\u003e\n       从这个表上所有索引读取的磁盘块数\n      \u003c/p\u003e\u003c/td\u003e\u003c/tr\u003e\u003ctr\u003e\u003ctd class=\"catalog_table_entry\"\u003e\u003cp class=\"column_definition\"\u003e\n\u003ccode class=\"structfield\"\u003eidx_blks_hit\u003c/code\u003e \u003ccode class=\"type\"\u003ebigint\u003c/code\u003e\n\u003c/p\u003e\n\u003cp\u003e\n       这个表上所有索引中的缓冲区命中数\n      \u003c/p\u003e\u003c/td\u003e\u003c/tr\u003e\u003ctr\u003e\u003ctd class=\"catalog_table_entry\"\u003e\u003cp class=\"column_definition\"\u003e\n\u003ccode class=\"structfield\"\u003etoast_blks_read\u003c/code\u003e \u003ccode class=\"type\"\u003ebigint\u003c/code\u003e\n\u003c/p\u003e\n\u003cp\u003e\n       从这个表的 TOAST 表中读取的磁盘块的数量（如果有的话）\n      \u003c/p\u003e\u003c/td\u003e\u003c/tr\u003e\u003ctr\u003e\u003ctd class=\"catalog_table_entry\"\u003e\u003cp class=\"column_definition\"\u003e\n\u003ccode class=\"structfield\"\u003etoast_blks_hit\u003c/code\u003e \u003ccode class=\"type\"\u003ebigint\u003c/code\u003e\n\u003c/p\u003e\n\u003cp\u003e\n       这个表的 TOAST 表中的缓冲区命中数（如果有的话）\n      \u003c/p\u003e\u003c/td\u003e\u003c/tr\u003e\u003ctr\u003e\u003ctd class=\"catalog_table_entry\"\u003e\u003cp class=\"column_definition\"\u003e\n\u003ccode class=\"structfield\"\u003etidx_blks_read\u003c/code\u003e \u003ccode class=\"type\"\u003ebigint\u003c/code\u003e\n\u003c/p\u003e\n\u003cp\u003e\n       从这个表的 TOAST 表索引中读取的磁盘块的数量（如果有的话）\n      \u003c/p\u003e\u003c/td\u003e\u003c/tr\u003e\u003ctr\u003e\u003ctd class=\"catalog_table_entry\"\u003e\u003cp class=\"column_definition\"\u003e\n\u003ccode class=\"structfield\"\u003etidx_blks_hit\u003c/code\u003e \u003ccode class=\"type\"\u003ebigint\u003c/code\u003e\n\u003c/p\u003e\n\u003cp\u003e\n       这个表的 TOAST 表索引中的缓冲区命中数（如果有的话）\n      \u003c/p\u003e\u003c/td\u003e\u003c/tr\u003e\u003c/tbody\u003e\u003c/table\u003e\u003c/div\u003e\u003c/div\u003e","doc":{"anchor":"PG-STATIO-ALL-TABLES-VIEW","file":"monitoring-stats.html","lang":"en","sha256":"a97e4aa05484b41cec1f4c9b0b9c5a083596a056982e5d5ba0db1dd8d49961fb","slug":"18"},"documentation_revision":{"inputs":[{"file":"monitoring-stats.html","kind":"same-version-reviewed-manual","locale":"en","sha256":"a97e4aa05484b41cec1f4c9b0b9c5a083596a056982e5d5ba0db1dd8d49961fb","version":"18.7"},{"file":"monitoring-stats.html","kind":"same-version-reviewed-manual","locale":"zh-Hans","sha256":"1ddb6576fe569e029a1c776c82e7add6be8e4f41705bcd8f66f4347fe23372b6","version":"18.7"}],"release":"18.7","runtime_remeasured":false,"source_revision":"pgdoc:b9f0e7232f60f380d642ac9b99226606c254b552"},"kind":"statistics","lang":"en","measured_attributes":true,"metadata_release":"18.6","runtime_columns":["relid","schemaname","relname","heap_blks_read","heap_blks_hit","idx_blks_read","idx_blks_hit","toast_blks_read","toast_blks_hit","tidx_blks_read","tidx_blks_hit"],"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:f2d1199ce3a3db585d48c47ca1c4b6f901810249f2870bb731a755326a6b3823","version":"18"}],"zh_from":"same-version-manual"},"ManualEvidence":{"doc":{"anchor":"PG-STATIO-ALL-TABLES-VIEW","file":"monitoring-stats.html","lang":"en","sha256":"a97e4aa05484b41cec1f4c9b0b9c5a083596a056982e5d5ba0db1dd8d49961fb","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:f2d1199ce3a3db585d48c47ca1c4b6f901810249f2870bb731a755326a6b3823","version":"18"}]},"MeasuredEvidence":{"measured_attributes":true,"metadata_release":"18.6","runtime_columns":["relid","schemaname","relname","heap_blks_read","heap_blks_hit","idx_blks_read","idx_blks_hit","toast_blks_read","toast_blks_hit","tidx_blks_read","tidx_blks_hit"],"runtime_verified":false}},"Text":{"Collection":"catalog","Key":"pg_statio_all_tables","SourceDatabase":"center","Version":"18","Locale":"en","Title":"pg_statio_all_tables","Summary":"The pg_statio_all_tables view will contain one row for each table in the current database (including TOAST tables), showing statistics about I/O on that specific table. The pg_statio_user_tables and pg_statio_sys_tables views contain the same information, but filtered to only show user and system tables respectively.","BodyHTML":"\u003cp\u003eThe pg_statio_all_tables view will contain one row for each table in the current database (including TOAST tables), showing statistics about I/O on that specific table. The pg_statio_user_tables and pg_statio_sys_tables views contain the same information, but filtered to only show user and system tables respectively.\u003c/p\u003e","SourceRevision":"catalog-bilingual-repair:2b1bb5ddf19a3a78c38e8eac860166554c484d56825f4da372a52c01ddb4fa7e","ContentHash":"ea10299d47692639d5a01481e042b6a7436f8a97a29883a0040c139625c16375","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 disk blocks read from this table","description_zh":"从该表中读取的磁盘块的数量","documented":true,"documented_name":"heap_blks_read","hidden":false,"name":"heap_blks_read","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":5,"description":"Number of buffer hits in this table","description_zh":"该表中的缓冲区命中数","documented":true,"documented_name":"heap_blks_hit","hidden":false,"name":"heap_blks_hit","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":6,"description":"Number of disk blocks read from all indexes on this table","description_zh":"从这个表上所有索引读取的磁盘块数","documented":true,"documented_name":"idx_blks_read","hidden":false,"name":"idx_blks_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 buffer hits in all indexes on this table","description_zh":"这个表上所有索引中的缓冲区命中数","documented":true,"documented_name":"idx_blks_hit","hidden":false,"name":"idx_blks_hit","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":8,"description":"Number of disk blocks read from this table's TOAST table (if any)","description_zh":"从这个表的 TOAST 表中读取的磁盘块的数量（如果有的话）","documented":true,"documented_name":"toast_blks_read","hidden":false,"name":"toast_blks_read","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":9,"description":"Number of buffer hits in this table's TOAST table (if any)","description_zh":"这个表的 TOAST 表中的缓冲区命中数（如果有的话）","documented":true,"documented_name":"toast_blks_hit","hidden":false,"name":"toast_blks_hit","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":10,"description":"Number of disk blocks read from this table's TOAST table indexes (if any)","description_zh":"从这个表的 TOAST 表索引中读取的磁盘块的数量（如果有的话）","documented":true,"documented_name":"tidx_blks_read","hidden":false,"name":"tidx_blks_read","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":11,"description":"Number of buffer hits in this table's TOAST table indexes (if any)","description_zh":"这个表的 TOAST 表索引中的缓冲区命中数（如果有的话）","documented":true,"documented_name":"tidx_blks_hit","hidden":false,"name":"tidx_blks_hit","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20,"zh_from":"same-version-manual"}],"description":"The pg_statio_all_tables view will contain one row for each table in the current database (including TOAST tables), showing statistics about I/O on that specific table. The pg_statio_user_tables and pg_statio_sys_tables views contain the same information, but filtered to only show user and system tables respectively."}},"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}