Show if you are using your indexes on postgres databases

index_usage.sql

SELECT
  relname,
  seq_scan - idx_scan AS too_much_seq,
  CASE WHEN seq_scan - idx_scan > 0
    THEN 'Missing Index?'
  ELSE 'OK' END,
  pg_relation_size(relname :: REGCLASS) AS rel_size,
  seq_scan,
  idx_scan
FROM pg_stat_all_tables
WHERE schemaname = 'public' AND pg_relation_size(relname :: REGCLASS) > 80000
ORDER BY too_much_seq DESC;