【openGauss】openGauss查询索引

---

一、查询openGauss表上有哪些全局索引

select t3.relname as tablename
      ,t1.relname as index_name 
  from pg_class t1
  join pg_index t2 on (t1.oid=t2.indexrelid)
  join pg_class t3 on (t3.oid = t2.indrelid)
 where 1=1
   and t3.relname = 'tzq_log_t' 
   and t1.relkind = 'I';

二、查看表上有哪些索引（除去全局索引其他都是本地索引）

select schemaname
      ,tablename
      ,indexname 
  from pg_indexes 
 where tablename = 'tzq_log_t';