Packages

ecto_psql_extras

0.8.8
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 indexes.ex
Raw

lib/queries/indexes.ex 

defmodule EctoPSQLExtras.Indexes do

  @behaviour EctoPSQLExtras



  def info do

    %{

      title: "List all the indexes with their corresponding tables and columns",

      index: 4,

      columns: [

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

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

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

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

      ]

    }

  end



  def query(_args \\ []) do

    """

    /* ECTO_PSQL_EXTRAS: List all the indexes with their corresponding tables and columns */

    SELECT

    schemaname,

    indexname,

    tablename,

    rtrim(split_part(indexdef, '(', 2), ')') as columns

    FROM pg_indexes

    where tablename in (select relname from pg_statio_user_tables);

    """

  end

end