Useful rake task for maintain PostgreSQL databases

db.rake

# lib/tasks/db.rake
namespace :db do

  desc 'Maintains database by running command as ANALYZE, VACUUM and REINDEX'
  task maintain: :environment do
    verbose = ENV['VERBOSE'].present?
    connection = ActiveRecord::Base.connection

    puts "Maintaining database #{connection.current_database} ..."
    connection.execute("VACUUM FULL #{'VERBOSE' if verbose}")
    connection.execute("ANALYZE #{'VERBOSE' if verbose}")
    connection.execute("REINDEX DATABASE #{connection.current_database}")
    puts "DONE."
  end
  
end