Slow postgress queries

tables_without_index.sql

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;

top_slow_queries.sql

CREATE EXTENSION pg_stat_statements;

SELECT 
	pd.datname
	,pss.query AS SQLQuery
	,pss.rows AS TotalRowCount
	,(pss.total_time / 1000 / 60) AS TotalMinute 
	,((pss.total_time / 1000 / 60)/calls) as TotalAverageTime		
FROM pg_stat_statements AS pss
INNER JOIN pg_database AS pd
	ON pss.dbid=pd.oid
ORDER BY 1 DESC 
LIMIT 10;