CODE EXAMPLE FOR SQL

postgres find missing indexes

SELECT relname,
       seq_scan,
       seq_tup_read / seq_scan AS tup_per_scan
FROM pg_stat_user_tables
WHERE seq_scan > 0;

# An index is missing if both the second and third column are big.