PostgreSQL – Missing Index Script

PostgreSQL de eksik indexleri bulmka için kullanabileceğiniz güzel bir scriptimi paylaşıyorum arkadaşlar.

SELECT
  relname,
  seq_scan - idx_scan AS too_much_seq,
  CASE
    WHEN
      seq_scan - coalesce(idx_scan, 0) > 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;

Kolay Gelsin.

Leave a Reply

Your email address will not be published. Required fields are marked *