Packages

ecto_psql_extras

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

lib/queries/outliers.ex 

defmodule EctoPSQLExtras.Outliers do

  def title do

    "10 queries that have longest execution time in aggregate"

  end



  def query do

"""

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



SELECT interval '1 millisecond' * total_time AS total_exec_time,

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

to_char(calls, 'FM999G999G999G990') AS ncalls,

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

query AS query

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

ORDER BY total_time DESC

LIMIT 10;

"""

  end

end