finding needed indexes -- early draft

gistfile1.txt

SELECT schemaname, relname,
       seq_scan as table_scans,
       idx_scan as index_scans,
       pg_size_pretty(pg_relation_size(relid)) as table_size,
       n_tup_ins + n_tup_del + n_tup_upd + n_tup_hot_upd as write_activty
FROM pg_stat_user_tables
WHERE seq_scan > 1000 
AND seq_scan > ( idx_scan / 10 )
AND pg_relation_size(relid) > ( 16000000 )
ORDER BY pg_relation_size(relid) desc;