[PPAS / Postgresql]해당 Instance 내의 INDEX 확인.

SELECT i.relname AS indname,

       i.relowner AS indowner,

       idx.indrelid::regclass,

       am.amname AS indam,

       idx.indkey,

       ARRAY(

       SELECT pg_get_indexdef(idx.indexrelid, k + 1, TRUE)

       FROM generate_subscripts(idx.indkey, 1) AS k

       ORDER BY k

       ) AS indkey_names,

       idx.indexprs IS NOT NULL AS indexprs,

       idx.indpred IS NOT NULL AS indpred

FROM   pg_index AS idx

JOIN   pg_class AS i

ON     i.oid = idx.indexrelid

JOIN   pg_am AS am

ON     i.relam = am.oid

AND i.relname NOT LIKE 'pg%';