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
|