Postgresql 查询表索引情况脚本

--/*将红色字体部分替换成要查询的表名即可*/

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 = 'public'

and E.RELNAME = 't_fdc_costaccount';

查看表与索引的统计信息：

Select * from pg_stat_user_tables 

Select * from pg_stat_user_indexes