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

lib/queries/calls.ex 

defmodule EctoPSQLExtras.Calls do

  def title do

    "10 queries that have the highest frequency of execution"

  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