Packages

ecto_psql_extras

0.4.4
0.8.8 0.8.7 0.8.6 0.8.5 0.8.4 0.8.3 0.8.2 0.8.1 0.8.0 0.7.15 0.7.14 0.7.13 0.7.12 0.7.11 0.7.10 0.7.9 0.7.8 0.7.7 0.7.6 0.7.5 0.7.4 0.7.3 0.7.2 0.7.1 0.7.0 0.6.5 0.6.4 0.6.3 0.6.2 0.6.1 0.6.0 0.4.4 0.4.3 0.4.2 0.4.1 0.4.0 0.3.4 0.3.3 0.3.2 0.3.1 0.3.0 0.2.0 0.1.4 0.1.3 0.1.2 0.0.2 0.0.1

Ecto PostgreSQL database performance insights. Locks, index usage, buffer cache hit ratios, vacuum stats and more.

HexDocs

Current section

Files

Jump to
Readme
47 Versions
3 Dependencies
Dependants
Files
Activity
ecto_psql_extras lib queries kill_all.ex
Raw

lib/queries/kill_all.ex 

defmodule EctoPSQLExtras.KillAll do

  @behaviour EctoPSQLExtras



  def info do

    %{

      title: "Kill all the active database connections",

      columns: [

        %{name: :killed, type: :boolean}

      ]

    }

  end



  def query do

    """

    /* ECTO_PSQL_EXTRAS: Kill all the active database connections */



    SELECT pg_terminate_backend(pid) AS killed FROM pg_stat_activity

      WHERE pid <> pg_backend_pid()

      AND query <> '<insufficient privilege>'

      AND datname = current_database();

    """

  end

end