1. 사용되지 않는 인덱스 찾기아래 쿼리는 PostgreSQL의 pg_stat_user_indexes 뷰를 사용하여 최근 사용되지 않은 인덱스를 찾습니다.SELECT schemaname || '.' || relname AS table_name, indexrelname AS index_name, idx_scan AS index_scans, pg_size_pretty(pg_relation_size(indexrelid)) AS index_sizeFROM pg_stat_user_indexesJOIN pg_index USING (indexrelid)WHERE idx_scan = 0ORDER BY pg_relation_size(indexrelid) DESC;📌 설명:idx_scan = 0 ..