class AbtionScripts::KillDbSessions
Public Class Methods
description()
click to toggle source
# File lib/abtion_scripts/kill_db_sessions.rb, line 2 def self.description "Kills active Postgres sessions" end
Public Instance Methods
run()
click to toggle source
# File lib/abtion_scripts/kill_db_sessions.rb, line 6 def run print "Loading Rails... " require app_root.join("./config/environment") puts "done" print "Killing DB sessions... " ActiveRecord::Base.connection.execute(<<-SQL) SELECT pg_terminate_backend(pg_stat_activity.pid) FROM pg_stat_activity WHERE datname = current_database() AND pid <> pg_backend_pid() SQL puts "done" end