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

Version Path
pghero-2.2.0 lib/pghero/methods/kill.rb
pghero-2.1.1 lib/pghero/methods/kill.rb
pghero-2.1.0 lib/pghero/methods/kill.rb
pghero-2.0.8 lib/pghero/methods/kill.rb
pghero-2.0.7 lib/pghero/methods/kill.rb
pghero-2.0.6 lib/pghero/methods/kill.rb
pghero-2.0.5 lib/pghero/methods/kill.rb
pghero-2.0.4 lib/pghero/methods/kill.rb
pghero-2.0.3 lib/pghero/methods/kill.rb
pghero-2.0.2 lib/pghero/methods/kill.rb
pghero-2.0.1 lib/pghero/methods/kill.rb
pghero-2.0.0 lib/pghero/methods/kill.rb