Could you tell me how to check which indexes are created for any table in postgresql?
The pg_indexes view provides access to useful information about each index in the database, for example.
select * from pg_indexes where tablename not like 'pg%';
if you are in psql then:
\d tablename
show indexes, foreign keys and links ...