Could you tell me how to check what indexes are created for some table in postgresql ?
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%';
2.1m questions
2.1m answers
60 comments
57.0k users