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

lib/queries/outliers.ex 

defmodule EctoPSQLExtras.Outliers do

  @behaviour EctoPSQLExtras



  def info do

    %{

      title: "10 queries that have longest execution time in aggregate",

      order_by: [exec_time: :desc],

      limit: 10,

      columns: [

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

        %{name: :exec_time, type: :interval},

        %{name: :prop_exec_time, type: :percent},

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

        %{name: :sync_io_time, type: :interval}

      ]

    }

  end



  def query do

    """

    /* ECTO_PSQL_EXTRAS: 10 queries that have longest execution time in aggregate */



    SELECT query AS query,

    interval '1 millisecond' * total_exec_time AS exec_time,

    (total_exec_time/sum(total_exec_time) OVER()) AS prop_exec_time,

    calls,

    interval '1 millisecond' * (blk_read_time + blk_write_time) AS sync_io_time

    FROM pg_stat_statements WHERE userid = (SELECT usesysid FROM pg_user WHERE usename = current_user LIMIT 1)

    AND query NOT LIKE '/* ECTO_PSQL_EXTRAS:%'

    ORDER BY total_exec_time DESC

    LIMIT 10;

    """

  end

end