Sha256: 853c1cc561999f9a12820e74831d6a62bce9ff7ebda5ee9fb033225076ec8966
Contents?: true
Size: 679 Bytes
Versions: 22
Compression:
Stored size: 679 Bytes
Contents
module PgHero
module Methods
module Kill
def kill(pid)
select_one("SELECT pg_terminate_backend(#{pid.to_i})")
end
def kill_long_running_queries(min_duration: nil)
running_queries(min_duration: min_duration || long_running_query_sec).each { |query| kill(query[:pid]) }
true
end
def kill_all
select_all <<-SQL
SELECT
pg_terminate_backend(pid)
FROM
pg_stat_activity
WHERE
pid <> pg_backend_pid()
AND query <> '<insufficient privilege>'
AND datname = current_database()
SQL
true
end
end
end
end
Version data entries
22 entries across 22 versions & 2 rubygems