Are you an LLM? You can read better optimized documentation at /en/docs/7.0.0/sql_reference/pg_indexes_verbose.md for this page in Markdown format
PG_INDEXES_VERBOSE
PG_INDEXES_VERBOSE view can be used to query whether an index is covered by other indexes.
表 1 PG_INDEXES_VERBOSE columns
Name | Type | Description |
|---|
indrelid | oid | Table oid |
indexrelid | oid | Index oid |
tablename | text | Table name |
schemaname | text | Schema name |
indexname | text | Index name |
amname | text | Index type |
idx_scan | bigint | Statistical information obtained from pg_stat_all_indexes |
idx_tup_read | bigint | Statistical information obtained from pg_stat_all_indexes |
idx_tup_fetch | bigint | Statistical information obtained from pg_stat_all_indexes |
overlap_indexes | []json | Information about indexes that cover the current index |