Sha256: ce3a6c8fcce80581ce9582e70e9219020891b101edc14e2cae25678b1af2b8ae
Contents?: true
Size: 611 Bytes
Versions: 12
Compression:
Stored size: 611 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
long_running_queries.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
12 entries across 12 versions & 1 rubygems