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%';
1.4m articles
1.4m replys
5 comments
57.0k users