ajsharp · March 16, 2011 05:03
diff --git a/index_size.rb b/index_size.rb
 namespace :db do
  desc "Display the aggregate size of all database indexes"
  task :index_size => :environment do
    results = ActiveRecord::Base.connection.select_all("show table status;")
    puts "Total Database Index Size: #{results.sum { |row| row['Index_length'].to_i / 1048576 }} MB"
  end
 end
	namespace :db do
	desc "Display the aggregate size of all database indexes"
	task :index_size => :environment do
	results = ActiveRecord::Base.connection.select_all("show table status;")
	puts "Total Database Index Size: #{results.sum { \|row\| row['Index_length'].to_i / 1048576 }} MB"
	end
	end