How to list indexes created for table in postgres
if you're in psql, then:
\d tablename
show Indexes, Foreign Keys and references...
The view pg_indexes provides access to useful information about each index in the database, eg.
select *
from pg_indexes
where tablename not like 'pg%';