SELECT 
    relname,
    seq_scan,
    seq_tup_read,
    idx_scan,
    idx_tup_fetch,
    CASE 
        WHEN idx_scan > seq_scan THEN 'INDEX OPTIMIZED'
        WHEN idx_scan > 0 THEN 'MIXED ACCESS'
        ELSE 'NEEDS INDEXES'
    END as performance_status
FROM pg_stat_all_tables
WHERE schemaname = 'schemaname'
ORDER BY seq_scan + idx_scan DESC;