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

lib/queries/long_running_queries.ex 

defmodule EctoPSQLExtras.LongRunningQueries do

  @behaviour EctoPSQLExtras



  def info do

    %{

      title: "All queries longer than five minutes by descending duration",

      columns: [

        %{name: :pid, type: :int},

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

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

      ]

    }

  end



  def query do

    """

    /* All queries longer than five minutes by descending duration */



    SELECT

      pid,

      now() - pg_stat_activity.query_start AS duration,

      query AS query

    FROM

      pg_stat_activity

    WHERE

      pg_stat_activity.query <> ''::text

      AND state <> 'idle'

      AND now() - pg_stat_activity.query_start > interval '5 minutes'

    ORDER BY

      now() - pg_stat_activity.query_start DESC;

    """

  end

end