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

lib/queries/cache_hit.ex 

defmodule EctoPSQLExtras.CacheHit do

  def title do

    "Index and table hit rate"

  end



  def query do

"""

/* Index and table hit rate */



SELECT

  'index hit rate' AS name,

  (sum(idx_blks_hit)) / nullif(sum(idx_blks_hit + idx_blks_read),0) AS ratio

FROM pg_statio_user_indexes

UNION ALL

SELECT

 'table hit rate' AS name,

  sum(heap_blks_hit) / nullif(sum(heap_blks_hit) + sum(heap_blks_read),0) AS ratio

FROM pg_statio_user_tables;

"""

  end

end