Packages

ecto_psql_extras

0.6.2
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 seq_scans.ex
Raw

lib/queries/seq_scans.ex 

defmodule EctoPSQLExtras.SeqScans do

  @behaviour EctoPSQLExtras



  def info do

    %{

      title: "Count of sequential scans by table descending by order",

      order_by: [count: :desc],

      columns: [

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

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

        %{name: :count, type: :integer}

      ]

    }

  end



  def query(_args \\ []) do

    """

    /* ECTO_PSQL_EXTRAS: Count of sequential scans by table descending by order */



    SELECT schemaname AS schema, relname AS name,

           seq_scan as count

    FROM

      pg_stat_user_tables

    ORDER BY seq_scan DESC;

    """

  end

end