Postgres: Determine table/index size

Postgres Index Usage.sql

        SELECT idx.relname as table,
               idx.indexrelname as index,
               pg_size_pretty(pg_relation_size( idx.indexrelname::text )) as bytes,
               cls.relpages as pages,
               cls.reltuples as tuples,
               idx.idx_scan as scanned,
               idx.idx_tup_read as read,
               idx.idx_tup_fetch as fetched
          FROM pg_stat_user_indexes idx,
               pg_class cls ,
               pg_index
         WHERE cls.relname = idx.relname
           AND idx.indexrelid = pg_index.indexrelid
           AND pg_index.indisunique is not true
           AND pg_index.indisprimary is not true
           AND idx.indexrelname not ilike '%slony%'
           AND idx.indexrelname not like 'sl\_%'
      ORDER BY pg_relation_size( idx.indexrelname::text ) DESC
      LIMIT 10;

Postgres long running queries.sql

 select procpid, 
        query_start, 
        client_addr, 
        client_port,
        current_query 
from    pg_stat_activity 
where   current_query not like '%IDLE%' 
    and current_query not like '%autova%' 
    and query_start < current_timestamp - interval '5 minutes'  
order by query_start asc;



select  procpid 
from    pg_stat_activity 
where   current_query not like '%IDLE%' 
    and current_query not like '%autova%' 
    and query_start < current_timestamp - interval '5 minutes'  
order by query_start asc;