CODE EXAMPLE FOR SQL

Get all index postgres

-- This will also return use the hidden index that automatically created by primary key and unique....
SELECT relname, relkind
FROM pg_class
WHERE relkind = 'i';