Packages

ecto_psql_extras

0.3.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
3 Dependencies
Dependants
Files
Activity
ecto_psql_extras lib queries index_cache_hit.ex
Raw

lib/queries/index_cache_hit.ex 

defmodule EctoPSQLExtras.IndexCacheHit do

  @behaviour EctoPSQLExtras



  def info do

    %{

      title: "Calculates your cache hit rate for reading indexes",

      order_by: [ratio: :desc],

      columns: [

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

        %{name: :buffer_hits, type: :integer},

        %{name: :block_reads, type: :integer},

        %{name: :total_read, type: :integer},

        %{name: :ratio, type: :numeric}

      ]

    }

  end



  def query do

    """

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



    SELECT

      relname AS name,

      idx_blks_hit AS buffer_hits,

      idx_blks_read AS block_reads,

      idx_blks_hit + idx_blks_read AS total_read,

      CASE (idx_blks_hit + idx_blks_read)::float

        WHEN 0 THEN NULL

        ELSE (idx_blks_hit / (idx_blks_hit + idx_blks_read)::float)

      END ratio

    FROM

      pg_statio_user_tables

    ORDER BY

      idx_blks_hit / (idx_blks_hit + idx_blks_read + 1)::float DESC;

    """

  end

end