{"Entry":{"collection":"catalog","key":"pg_statio_user_tables","name":"pg_statio_user_tables","aliases":[],"metadata":{"changed_in":["19"],"changes":[{"added":[],"attributes":[],"description_changed":false,"descriptions":[],"from":"8.4","order":false,"removed":[],"status":"coverage","to":"9.0","types":[]},{"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":["stats_reset"],"attributes":[],"description_changed":false,"descriptions":[],"from":"18","listing":[],"order":false,"removed":[],"status":"changed","to":"19","types":[],"unlisted":[]}],"column_count":12,"content_hash":"b3cc889e912af8c84e7c9b476b39d92b535d5022cd5b81e267404a18d1638239","first_version":"7.4","imported_at":"2026-09-30T00:40:56.137198+08:00","kind":"statistics","last_version":"20","name":"pg_statio_user_tables","position":129,"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":"english-manuals:7e6f8034e48ae61b5f76721c18368b2eadc5f2e8830067f7c15c710d2497d3e1","summary":"Same as pg_statio_all_tables, except that only user tables are shown.","summary_zh":""}},"Definition":{"Collection":"catalog","Key":"pg_statio_user_tables","SourceDatabase":"center","Version":"18","SourceTable":"catalog","SourceKey":"pg_statio_user_tables","SourceRevision":"english-manuals:7e6f8034e48ae61b5f76721c18368b2eadc5f2e8830067f7c15c710d2497d3e1","Facts":{"columns":[{"array_dimensions":0,"attnum":1,"description":"OID of a table","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":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},{"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},{"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},{"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},{"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},{"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},{"array_dimensions":0,"attnum":8,"description":"Number of disk blocks read from this table's TOAST table (if any)","description_zh":"","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},{"array_dimensions":0,"attnum":9,"description":"Number of buffer hits in this table's TOAST table (if any)","description_zh":"","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},{"array_dimensions":0,"attnum":10,"description":"Number of disk blocks read from this table's TOAST table indexes (if any)","description_zh":"","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},{"array_dimensions":0,"attnum":11,"description":"Number of buffer hits in this table's TOAST table indexes (if any)","description_zh":"","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}],"columns_not_enumerated":false,"derived_from":"pg_statio_all_tables","description":"Same as pg_statio_all_tables, except that only user tables are shown.","description_zh":"","doc":{"anchor":"id-1.6.14.7.6.8.2.2.24.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","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"},"ManualEvidence":{"doc":{"anchor":"id-1.6.14.7.6.8.2.2.24.1.2","file":"monitoring-stats.html","lang":"en","sha256":"aa979eed08627fbf715a9d792094a162a73671db5af810f3ab2aad3e073d5722","slug":"18"}},"MeasuredEvidence":{"measured_attributes":false,"metadata_release":"","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_user_tables","SourceDatabase":"pgweb","Version":"18","Locale":"zh-Hans","Title":"pg_statio_user_tables","Summary":"","BodyHTML":"\u003cp\u003e\u003c/p\u003e","SourceRevision":"2026-09-27@419045e","ContentHash":"19cfafadbe474bcb483d72e368d363978320f2be180fc6b9bdf410902095c409","Payload":{"columns":[{"description_zh":"表的OID","name":"relid","type":"oid","zh_from":"inherited"},{"description_zh":"该表所在的模式的名称","name":"schemaname","type":"name","zh_from":"inherited"},{"description_zh":"这个表的名称","name":"relname","type":"name","zh_from":"inherited"},{"description_zh":"从该表中读取的磁盘块的数量","name":"heap_blks_read","type":"bigint","zh_from":"inherited"},{"description_zh":"该表中的缓冲区命中数","name":"heap_blks_hit","type":"bigint","zh_from":"inherited"},{"description_zh":"从这个表上所有索引读取的磁盘块数","name":"idx_blks_read","type":"bigint","zh_from":"inherited"},{"description_zh":"这个表上所有索引中的缓冲区命中数","name":"idx_blks_hit","type":"bigint","zh_from":"inherited"},{"description_zh":"从这个表的TOAST表中读取的磁盘块的数量（如果有的话）","name":"toast_blks_read","type":"bigint","zh_from":"inherited"},{"description_zh":"这个表的TOAST表中的缓冲区命中数（如果有的话）","name":"toast_blks_hit","type":"bigint","zh_from":"inherited"},{"description_zh":"从这个表的TOAST表索引中读取的磁盘块的数量（如果有的话）","name":"tidx_blks_read","type":"bigint","zh_from":"inherited"},{"description_zh":"这个表的TOAST表索引中的缓冲区命中数（如果有的话）","name":"tidx_blks_hit","type":"bigint","zh_from":"inherited"}],"description_zh":"","zh_from":""}},"RequestedLocale":"zh-Hans","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}