show indexes mysql
snippet in sql

show indexes mysql

user5560

SHOW INDEX FROM yourtable;

how to see which columns are indexxed mysql

user8068

SHOW INDEXES FROM table_name;

check all indexes on table

user572

SELECT
    tablename,
    indexname,
    indexdef
FROM
    pg_indexes
WHERE
    schemaname = 'yourschema' and tablename='yourtable'
ORDER BY
    tablename,
    indexname;
(POSTRGRESQL)