Packages

ecto_psql_extras

0.2.0
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
2 Dependencies
Dependants
Files
Activity
ecto_psql_extras lib queries calls.ex
Raw

lib/queries/calls.ex 

defmodule EctoPSQLExtras.Calls do

  @behaviour EctoPSQLExtras



  def info do

    %{

      title: "10 queries that have the highest frequency of execution",

      limit: 10,

      order_by: [ncalls: :desc],

      columns: [

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

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

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

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

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

      ]

    }

  end



  def query do

    """

    /* 10 queries that have the highest frequency of execution */



    SELECT query AS qry,

    interval '1 millisecond' * total_time AS exec_time,

    to_char((total_time/sum(total_time) OVER()) * 100, 'FM90D0') || '%'  AS prop_exec_time,

    to_char(calls, 'FM999G999G990') AS ncalls,

    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)

    ORDER BY calls DESC

    LIMIT 10;

    """

  end

end