vacuum_analyze_all_table.rb

sql = <<~SQL
SELECT n.nspname || '.' || c.relname as "name"
FROM pg_catalog.pg_class c
     LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace
WHERE c.relkind IN ('r','')
      AND n.nspname <> 'pg_catalog'
      AND n.nspname <> 'information_schema'
      AND n.nspname !~ '^pg_toast'
  AND pg_catalog.pg_table_is_visible(c.oid)
SQL


ActiveRecord::Base.connection.execute(sql).each do |r| 
  ActiveRecord::Base.connection.execute("vacuum analyze #{r['name']}")
end