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

lib/queries/table_cache_hit.ex 

defmodule EctoPSQLExtras.TableCacheHit do

  def title do

    "Calculates your cache hit rate for reading tables"

  end



  def query do

"""

/* Calculates your cache hit rate for reading tables */



SELECT

  relname AS name,

  heap_blks_hit AS buffer_hits,

  heap_blks_read AS block_reads,

  heap_blks_hit + heap_blks_read AS total_read,

  CASE (heap_blks_hit + heap_blks_read)::float

    WHEN 0 THEN 'Insufficient data'

    ELSE (heap_blks_hit / (heap_blks_hit + heap_blks_read)::float)::text

  END ratio

FROM

  pg_statio_user_tables

ORDER BY

  heap_blks_hit / (heap_blks_hit + heap_blks_read + 1)::float DESC;

"""

  end

end