Unused indexes

1SELECT s.schemaname, s.relname AS table_name,2       s.indexrelname AS index_name,3       pg_size_pretty(pg_relation_size(s.indexrelid)) AS index_size,4       s.idx_scan5FROM pg_stat_user_indexes s6JOIN pg_index i ON i.indexrelid = s.indexrelid7WHERE s.idx_scan = 08  AND NOT i.indisunique9  AND NOT i.indisprimary10ORDER BY pg_relation_size(s.indexrelid) DESC;