Packages

ecto_psql_extras

0.2.0
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
2 Dependencies
Dependants
Files
Activity
ecto_psql_extras lib queries extensions.ex
Raw

lib/queries/extensions.ex 

defmodule EctoPSQLExtras.Extensions do

  @behaviour EctoPSQLExtras



  def info do

    %{

      title: "Available and installed extensions",

      order_by: [:installed_version],

      columns: [

        %{name: :name, type: :string},

        %{name: :default_version, type: :string},

        %{name: :installed_version, type: :string},

        %{name: :comment, type: :string}

      ]

    }

  end



  def query do

    """

    /* Available and installed extensions */



    SELECT name, default_version, installed_version, comment

    FROM pg_available_extensions

    ORDER BY installed_version;

    """

  end

end