{"Entry":{"collection":"catalog","key":"pg_statio_sys_indexes","name":"pg_statio_sys_indexes","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":["stats_reset"],"attributes":[],"description_changed":false,"descriptions":[],"from":"18","listing":[],"order":false,"removed":[],"status":"changed","to":"19","types":[],"unlisted":[]}],"column_count":8,"content_hash":"d7d59e48149edc8d50bc430f978b04f9fa9e90e920c24d8a3b1cac26a8a90da0","derived_content_hash":"f8ddeb4b3ffa9049a54459b81f7e54465ac25cd3bd4772820fa536a3bbb75beb","first_version":"7.4","imported_at":"2026-09-30T00:40:56.101629+08:00","kind":"statistics","last_version":"20","name":"pg_statio_sys_indexes","position":124,"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:bfc01213cac9b7faa7e00fe87a90c9e9de24691f24fc8f97fa812820759013ef","summary":"Same as pg_statio_all_indexes, except that only indexes on system tables are shown.","summary_zh":"和 pg_statio_all_indexes 一样，但只显示系统表上的索引。"}},"Definition":{"Collection":"catalog","Key":"pg_statio_sys_indexes","SourceDatabase":"center","Version":"18","SourceTable":"catalog","SourceKey":"pg_statio_sys_indexes","SourceRevision":"catalog-bilingual-repair:bfc01213cac9b7faa7e00fe87a90c9e9de24691f24fc8f97fa812820759013ef","Facts":{"columns":[{"array_dimensions":0,"attnum":1,"description":"OID of the table for this index","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":"OID of this index","description_zh":"这个索引的 OID","documented":true,"documented_name":"indexrelid","hidden":false,"name":"indexrelid","not_null":false,"references":"","type":"oid","type_modifier":-1,"type_oid":26,"zh_from":"same-version-manual"},{"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,"zh_from":"same-version-manual"},{"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,"zh_from":"same-version-manual"},{"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,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":6,"description":"Number of disk blocks read from this index","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 this index","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"}],"columns_not_enumerated":false,"derived_from":"pg_statio_all_indexes","description":"Same as pg_statio_all_indexes, except that only indexes on system tables are shown.","description_zh":"和 pg_statio_all_indexes 一样，但只显示系统表上的索引。","description_zh_html":"\u003cp\u003e和 pg_statio_all_indexes 一样，但只显示系统表上的索引。\u003c/p\u003e","doc":{"anchor":"id-1.6.14.7.6.8.2.2.26.1.2","file":"monitoring-stats.html","lang":"en","sha256":"aa979eed08627fbf715a9d792094a162a73671db5af810f3ab2aad3e073d5722","slug":"18"},"kind":"statistics","lang":"en","measured_attributes":false,"metadata_release":"","runtime_columns":["relid","indexrelid","schemaname","relname","indexrelname","idx_blks_read","idx_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:a2c30f27d8780f6d2fdf10f540152eaa34a6e66cd6e68b513fd55029cbd58608","version":"18"}],"zh_from":"same-version-manual"},"ManualEvidence":{"doc":{"anchor":"id-1.6.14.7.6.8.2.2.26.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:a2c30f27d8780f6d2fdf10f540152eaa34a6e66cd6e68b513fd55029cbd58608","version":"18"}]},"MeasuredEvidence":{"measured_attributes":false,"metadata_release":"","runtime_columns":["relid","indexrelid","schemaname","relname","indexrelname","idx_blks_read","idx_blks_hit"],"runtime_verified":false}},"Text":{"Collection":"catalog","Key":"pg_statio_sys_indexes","SourceDatabase":"center","Version":"18","Locale":"en","Title":"pg_statio_sys_indexes","Summary":"Same as pg_statio_all_indexes, except that only indexes on system tables are shown.","BodyHTML":"\u003cp\u003eSame as pg_statio_all_indexes, except that only indexes on system tables are shown.\u003c/p\u003e","SourceRevision":"catalog-bilingual-repair:bfc01213cac9b7faa7e00fe87a90c9e9de24691f24fc8f97fa812820759013ef","ContentHash":"ac75bcece192b94350b3e60fdea2690c46924ecab60e9db2863a7ce7a992c651","Payload":{"columns":[{"array_dimensions":0,"attnum":1,"description":"OID of the table for this index","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":"OID of this index","description_zh":"这个索引的 OID","documented":true,"documented_name":"indexrelid","hidden":false,"name":"indexrelid","not_null":false,"references":"","type":"oid","type_modifier":-1,"type_oid":26,"zh_from":"same-version-manual"},{"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,"zh_from":"same-version-manual"},{"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,"zh_from":"same-version-manual"},{"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,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":6,"description":"Number of disk blocks read from this index","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 this index","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"}],"description":"Same as pg_statio_all_indexes, except that only indexes on system 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}