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 index_size.ex
Raw

lib/queries/index_size.ex 

defmodule EctoPSQLExtras.IndexSize do

  @behaviour EctoPSQLExtras



  def info do

    %{

      title: "The size of indexes, descending by size",

      order_by: [size: :desc],

      columns: [

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

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

        %{name: :size, type: :bytes}

      ]

    }

  end



  def query do

    """

    /* ECTO_PSQL_EXTRAS: The size of indexes, descending by size */



    SELECT n.nspname AS schema, c.relname AS name, sum(c.relpages::bigint*8192)::bigint AS size

    FROM pg_class c

    LEFT JOIN pg_namespace n ON (n.oid = c.relnamespace)

    WHERE n.nspname NOT IN ('pg_catalog', 'information_schema')

    AND n.nspname !~ '^pg_toast'

    AND c.relkind='i'

    GROUP BY (n.nspname, c.relname)

    ORDER BY sum(c.relpages) DESC;

    """

  end

end