PostgreSQL建立索引相关记录

主键、unique自动建立索引，无需额外创建索引

添加btree索引

create index index_tsbe_feedback_fb_type on tsbe_feedback using btree (fb_type)

查看某表的所有索引

select
A.SCHEMANAME,
A.TABLENAME,
A.INDEXNAME,
A.TABLESPACE,
A.INDEXDEF,
B.AMNAME,
C.INDEXRELID,
C.INDNATTS,
C.INDISUNIQUE,
C.INDISPRIMARY,
C.INDISCLUSTERED,
D.DESCRIPTION
from
PG_AM B left join PG_CLASS F on
B.OID = F.RELAM left join PG_STAT_ALL_INDEXES E on
F.OID = E.INDEXRELID left join PG_INDEX C on
E.INDEXRELID = C.INDEXRELID left outer join PG_DESCRIPTION D on
C.INDEXRELID = D.OBJOID,
PG_INDEXES A
where
A.SCHEMANAME = E.SCHEMANAME
and A.TABLENAME = E.RELNAME
and A.INDEXNAME = E.INDEXRELNAME
and E.SCHEMANAME = 'tsbe'
and E.RELNAME = 'tsbe_feedback';

或

select * from pg_indexes where tablename='tsbe_feedback'

删除索引

DROP INDEX index_tsbe_feedback_read_record_for_user;