Skip to content

Instantly share code, notes, and snippets.

@jhjwind

jhjwind/gist:c3ee55a38fc90cd953c2

Created April 1, 2015 20:05
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save jhjwind/c3ee55a38fc90cd953c2 to your computer and use it in GitHub Desktop.
Save jhjwind/c3ee55a38fc90cd953c2 to your computer and use it in GitHub Desktop.
Download ZIP
postgres finding missing index
Raw
gistfile1.txt
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;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment