Module: PgHero::Methods::Kill

Included in:
Database
Defined in:
lib/pghero/methods/kill.rb

Instance Method Summary collapse

Instance Method Details

#kill(pid) ⇒ Object 



4
5
6
 
# File 'lib/pghero/methods/kill.rb', line 4

def kill(pid)
  PgHero.truthy? execute("SELECT pg_terminate_backend(#{pid.to_i})").first["pg_terminate_backend"]
end

#kill_all ⇒ Object 



13
14
15
16
17
18
19
20
21
22
23
24
25
 
# File 'lib/pghero/methods/kill.rb', line 13

def kill_all
  select_all "    SELECT\n      pg_terminate_backend(pid)\n    FROM\n      pg_stat_activity\n    WHERE\n      pid <> pg_backend_pid()\n      AND query <> '<insufficient privilege>'\n      AND datname = current_database()\n  SQL\n  true\nend\n"

#kill_long_running_queries ⇒ Object 



8
9
10
11
 
# File 'lib/pghero/methods/kill.rb', line 8

def kill_long_running_queries
  long_running_queries.each { |query| kill(query["pid"]) }
  true
end