{"Entry":{"collection":"catalog","key":"pg_indexes","name":"pg_indexes","aliases":[],"metadata":{"changed_in":["8.0"],"changes":[{"added":["tablespace"],"attributes":[],"description_changed":false,"descriptions":[],"from":"7.4","listing":[],"order":false,"removed":[],"status":"changed","to":"8.0","types":[],"unlisted":[]},{"added":[],"attributes":[],"description_changed":false,"descriptions":[{"from":"index definition (a reconstructed creation command)","name":"indexdef","to":"Index definition (a reconstructed CREATE INDEX command)"},{"from":"name of index","name":"indexname","to":"Name of index"},{"from":"name of schema containing table and index","name":"schemaname","to":"Name of schema containing table and index"},{"from":"name of table the index is for","name":"tablename","to":"Name of table the index is for"},{"from":"name of tablespace containing index (NULL if default for database)","name":"tablespace","to":"Name of tablespace containing index (NULL if default for database)"}],"from":"8.1","listing":[],"order":false,"removed":[],"status":"reworded","to":"8.2","types":[],"unlisted":[]},{"added":[],"attributes":[],"description_changed":false,"descriptions":[{"from":"Name of tablespace containing index (NULL if default for database)","name":"tablespace","to":"Name of tablespace containing index (null if default for database)"}],"from":"8.4","listing":[],"order":false,"removed":[],"status":"reworded","to":"9.0","types":[],"unlisted":[]}],"column_count":5,"content_hash":"06ce95c1f7ee67615ef8f1b0b93b8dbbed23b7f8003cec99bc5b387ac0a9b9e7","derived_content_hash":"e5b650f491556a322ebc8364f92c3dd6749c6370e222a6b93de0828979f0e227","first_version":"7.4","imported_at":"2026-09-30T00:40:55.578302+08:00","kind":"view","last_version":"20","name":"pg_indexes","position":37,"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:cd6dc2aa0b35b7a1c717ac6846211ecd26306e41b7d64404970609d862728c7a","summary":"The view pg_indexes provides access to useful information about each index in the database.","summary_zh":"视图 pg_indexes 提供了有关数据库中每个索引的有用信息。"}},"Definition":{"Collection":"catalog","Key":"pg_indexes","SourceDatabase":"center","Version":"18","SourceTable":"catalog","SourceKey":"pg_indexes","SourceRevision":"catalog-bilingual-repair:cd6dc2aa0b35b7a1c717ac6846211ecd26306e41b7d64404970609d862728c7a","Facts":{"columns":[{"array_dimensions":0,"attnum":1,"description":"Name of schema containing table and index","description_zh":"包含表和索引的模式名","documented":true,"documented_name":"schemaname","hidden":false,"name":"schemaname","not_null":false,"references":"pg_namespace.nspname","type":"name","type_modifier":-1,"type_oid":19,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":2,"description":"Name of table the index is for","description_zh":"此索引的基表名称","documented":true,"documented_name":"tablename","hidden":false,"name":"tablename","not_null":false,"references":"pg_class.relname","type":"name","type_modifier":-1,"type_oid":19,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":3,"description":"Name of index","description_zh":"索引名","documented":true,"documented_name":"indexname","hidden":false,"name":"indexname","not_null":false,"references":"pg_class.relname","type":"name","type_modifier":-1,"type_oid":19,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":4,"description":"Name of tablespace containing index (null if default for database)","description_zh":"包含索引的表空间名（如使用数据库默认表空间，则为 NULL）","documented":true,"documented_name":"tablespace","hidden":false,"name":"tablespace","not_null":false,"references":"pg_tablespace.spcname","type":"name","type_modifier":-1,"type_oid":19,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":5,"description":"Index definition (a reconstructed CREATE INDEX command)","description_zh":"索引定义（重建出的 CREATE INDEX 命令）","documented":true,"documented_name":"indexdef","hidden":false,"name":"indexdef","not_null":false,"references":"","type":"text","type_modifier":-1,"type_oid":25,"zh_from":"same-version-manual"}],"description":"The view pg_indexes provides access to useful information about each index in the database.","description_zh":"视图 pg_indexes 提供了有关数据库中每个索引的有用信息。","description_zh_html":"\u003cp\u003e视图 pg_indexes 提供了有关数据库中每个索引的有用信息。\u003c/p\u003e","doc":{"anchor":"id-1.10.5.16.4","file":"view-pg-indexes.html","lang":"en","sha256":"4738de9cb38922976368ff17d8f2eb58546dbdfcf4b2ec0bdcc6f67657ee0c6d","slug":"18"},"kind":"view","lang":"en","measured_attributes":true,"metadata_release":"18.6","runtime_columns":["schemaname","tablename","indexname","tablespace","indexdef"],"runtime_verified":false,"source":"english-manual","sources":[{"evidence":[{"build_id":107,"kind":"same-version-manual","locale":"zh-Hans","page":"view-pg-indexes.html","sha256":"016b4d75bb703073073a2b9ae7e6d74fbd63466ad2e65549fc1a530ef59f2a49","source_revision":"unknown:rendered-translation-baseline","translation_revision":"git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:08e987a66af27b98444a8057c256314eafa13611a3fb9e888214fc436824244b","version":"18"}],"kind":"catalog-bilingual-repair","prior_source_revision":"english-manuals:0c8efaf15b0d91378fdaca5b6a8e8aa1ea9f71f0d722352c7716c86bf2af5b98","version":"18"}],"zh_from":"same-version-manual"},"ManualEvidence":{"doc":{"anchor":"id-1.10.5.16.4","file":"view-pg-indexes.html","lang":"en","sha256":"4738de9cb38922976368ff17d8f2eb58546dbdfcf4b2ec0bdcc6f67657ee0c6d","slug":"18"},"sources":[{"evidence":[{"build_id":107,"kind":"same-version-manual","locale":"zh-Hans","page":"view-pg-indexes.html","sha256":"016b4d75bb703073073a2b9ae7e6d74fbd63466ad2e65549fc1a530ef59f2a49","source_revision":"unknown:rendered-translation-baseline","translation_revision":"git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:08e987a66af27b98444a8057c256314eafa13611a3fb9e888214fc436824244b","version":"18"}],"kind":"catalog-bilingual-repair","prior_source_revision":"english-manuals:0c8efaf15b0d91378fdaca5b6a8e8aa1ea9f71f0d722352c7716c86bf2af5b98","version":"18"}]},"MeasuredEvidence":{"measured_attributes":true,"metadata_release":"18.6","runtime_columns":["schemaname","tablename","indexname","tablespace","indexdef"],"runtime_verified":false}},"Text":{"Collection":"catalog","Key":"pg_indexes","SourceDatabase":"center","Version":"18","Locale":"en","Title":"pg_indexes","Summary":"The view pg_indexes provides access to useful information about each index in the database.","BodyHTML":"\u003cp\u003eThe view pg_indexes provides access to useful information about each index in the database.\u003c/p\u003e","SourceRevision":"catalog-bilingual-repair:cd6dc2aa0b35b7a1c717ac6846211ecd26306e41b7d64404970609d862728c7a","ContentHash":"2ed5c87efb7c8077eeaa41e79ea41c64a42ba2692aecc3810d45ea42beefc727","Payload":{"columns":[{"array_dimensions":0,"attnum":1,"description":"Name of schema containing table and index","description_zh":"包含表和索引的模式名","documented":true,"documented_name":"schemaname","hidden":false,"name":"schemaname","not_null":false,"references":"pg_namespace.nspname","type":"name","type_modifier":-1,"type_oid":19,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":2,"description":"Name of table the index is for","description_zh":"此索引的基表名称","documented":true,"documented_name":"tablename","hidden":false,"name":"tablename","not_null":false,"references":"pg_class.relname","type":"name","type_modifier":-1,"type_oid":19,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":3,"description":"Name of index","description_zh":"索引名","documented":true,"documented_name":"indexname","hidden":false,"name":"indexname","not_null":false,"references":"pg_class.relname","type":"name","type_modifier":-1,"type_oid":19,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":4,"description":"Name of tablespace containing index (null if default for database)","description_zh":"包含索引的表空间名（如使用数据库默认表空间，则为 NULL）","documented":true,"documented_name":"tablespace","hidden":false,"name":"tablespace","not_null":false,"references":"pg_tablespace.spcname","type":"name","type_modifier":-1,"type_oid":19,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":5,"description":"Index definition (a reconstructed CREATE INDEX command)","description_zh":"索引定义（重建出的 CREATE INDEX 命令）","documented":true,"documented_name":"indexdef","hidden":false,"name":"indexdef","not_null":false,"references":"","type":"text","type_modifier":-1,"type_oid":25,"zh_from":"same-version-manual"}],"description":"The view pg_indexes provides access to useful information about each index in the database."}},"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}