Packages

ecto_psql_extras

0.4.3
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 records_rank.ex
Raw

lib/queries/records_rank.ex 

defmodule EctoPSQLExtras.RecordsRank do

  @behaviour EctoPSQLExtras



  def info do

    %{

      title: "All tables and the number of rows in each ordered by number of rows descending",

      order_by: [estimated_count: :desc],

      columns: [

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

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

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

      ]

    }

  end



  def query do

    """

    /* All tables and the number of rows in each ordered by number of rows descending */



    SELECT

      schemaname AS schema, relname AS name,

      n_live_tup AS estimated_count

    FROM

      pg_stat_user_tables

    ORDER BY

      n_live_tup DESC;

    """

  end

end