{"Entry":{"collection":"catalog","key":"pg_stat_all_indexes","name":"pg_stat_all_indexes","aliases":[],"metadata":{"changed_in":["16","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":true,"descriptions":[],"from":"12","listing":[],"order":false,"removed":[],"status":"reworded","to":"13","types":[],"unlisted":[]},{"added":["last_idx_scan"],"attributes":[],"description_changed":false,"descriptions":[],"from":"15","listing":[],"order":false,"removed":[],"status":"changed","to":"16","types":[],"unlisted":[]},{"added":["stats_reset"],"attributes":[],"description_changed":false,"descriptions":[],"from":"18","listing":[],"order":false,"removed":[],"status":"changed","to":"19","types":[],"unlisted":[]}],"column_count":10,"content_hash":"64056ad04d474acd5d1ec4e49e80189a32022542de96e72f8dc0598c2487eede","first_version":"7.4","imported_at":"2026-09-30T00:40:55.856585+08:00","kind":"statistics","last_version":"20","name":"pg_stat_all_indexes","position":82,"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:45eb18cf266687e4d541347cfda7d8546486f6623aa69bf04a6afcab20d24c79","summary":"The pg_stat_all_indexes view will contain one row for each index in the current database, showing statistics about accesses to that specific index.","summary_zh":""}},"Definition":{"Collection":"catalog","Key":"pg_stat_all_indexes","SourceDatabase":"center","Version":"18","SourceTable":"catalog","SourceKey":"pg_stat_all_indexes","SourceRevision":"english-manuals:45eb18cf266687e4d541347cfda7d8546486f6623aa69bf04a6afcab20d24c79","Facts":{"columns":[{"array_dimensions":0,"attnum":1,"description":"OID of the table for this index","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":"OID of this index","description_zh":"","documented":true,"documented_name":"indexrelid","hidden":false,"name":"indexrelid","not_null":false,"references":"","type":"oid","type_modifier":-1,"type_oid":26},{"array_dimensions":0,"attnum":3,"description":"Name of the schema this index 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":4,"description":"Name of the table for this index","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":5,"description":"Name of this index","description_zh":"","documented":true,"documented_name":"indexrelname","hidden":false,"name":"indexrelname","not_null":false,"references":"","type":"name","type_modifier":-1,"type_oid":19},{"array_dimensions":0,"attnum":6,"description":"Number of index scans initiated on this index","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},{"array_dimensions":0,"attnum":7,"description":"The time of the last scan on this index, 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},{"array_dimensions":0,"attnum":8,"description":"Number of index entries returned by scans on this index","description_zh":"","documented":true,"documented_name":"idx_tup_read","hidden":false,"name":"idx_tup_read","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20},{"array_dimensions":0,"attnum":9,"description":"Number of live table rows fetched by simple index scans using this index","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}],"description":"The pg_stat_all_indexes view will contain one row for each index in the current database, showing statistics about accesses to that specific index. The pg_stat_user_indexes and pg_stat_sys_indexes views contain the same information, but filtered to only show user and system indexes respectively.","description_zh":"","doc":{"anchor":"PG-STAT-ALL-INDEXES-VIEW","file":"monitoring-stats.html","lang":"en","sha256":"aa979eed08627fbf715a9d792094a162a73671db5af810f3ab2aad3e073d5722","slug":"18"},"kind":"statistics","lang":"en","measured_attributes":true,"metadata_release":"18.6","runtime_columns":["relid","indexrelid","schemaname","relname","indexrelname","idx_scan","last_idx_scan","idx_tup_read","idx_tup_fetch"],"runtime_verified":false,"source":"english-manual"},"ManualEvidence":{"doc":{"anchor":"PG-STAT-ALL-INDEXES-VIEW","file":"monitoring-stats.html","lang":"en","sha256":"aa979eed08627fbf715a9d792094a162a73671db5af810f3ab2aad3e073d5722","slug":"18"}},"MeasuredEvidence":{"measured_attributes":true,"metadata_release":"18.6","runtime_columns":["relid","indexrelid","schemaname","relname","indexrelname","idx_scan","last_idx_scan","idx_tup_read","idx_tup_fetch"],"runtime_verified":false}},"Text":{"Collection":"catalog","Key":"pg_stat_all_indexes","SourceDatabase":"pgweb","Version":"18","Locale":"zh-Hans","Title":"pg_stat_all_indexes","Summary":"pg_stat_all_indexes视图将为当前数据库中的每个索引包含一行，该行显示关于对该索引访问的统计信息。pg_stat_user_indexes和pg_stat_sys_indexes视图包含相同的信息，但经过过滤，分别只显示用户和系统索引。","BodyHTML":"\u003cp\u003epg_stat_all_indexes视图将为当前数据库中的每个索引包含一行，该行显示关于对该索引访问的统计信息。pg_stat_user_indexes和pg_stat_sys_indexes视图包含相同的信息，但经过过滤，分别只显示用户和系统索引。\u003c/p\u003e","SourceRevision":"2026-09-27@419045e","ContentHash":"b74e9fdf096c06984c01ba04fddca1fd487fdcfd3bad850c0a213fbb7622dae6","Payload":{"columns":[{"description_zh":"此索引所在表的OID","name":"relid","type":"oid","zh_from":"doc"},{"description_zh":"这个索引的OID","name":"indexrelid","type":"oid","zh_from":"doc"},{"description_zh":"这个索引所在的模式名称","name":"schemaname","type":"name","zh_from":"doc"},{"description_zh":"这个索引的表的名称","name":"relname","type":"name","zh_from":"doc"},{"description_zh":"这个索引的名称","name":"indexrelname","type":"name","zh_from":"doc"},{"description_zh":"在这个索引上开启的索引扫描的数量","name":"idx_scan","type":"bigint","zh_from":"doc"},{"description_zh":"此索引上最后一次扫描的时间，基于最近的事务停止时间","name":"last_idx_scan","type":"timestamp with time zone","zh_from":"doc"},{"description_zh":"扫描此索引返回的索引项数","name":"idx_tup_read","type":"bigint","zh_from":"doc"},{"description_zh":"使用此索引进行简单索引扫描获取的存活表行数","name":"idx_tup_fetch","type":"bigint","zh_from":"doc"}],"description_zh":"pg_stat_all_indexes视图将为当前数据库中的每个索引包含一行，该行显示关于对该索引访问的统计信息。pg_stat_user_indexes和pg_stat_sys_indexes视图包含相同的信息，但经过过滤，分别只显示用户和系统索引。","zh_from":"doc"}},"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}