Difference between revisions of "Cache hit ratio"

From wikieduonline
Jump to navigation Jump to search
 
Line 28: Line 28:
 
* {{SQL}}
 
* {{SQL}}
 
* {{DBs}}
 
* {{DBs}}
 +
* {{PostgreSQL}}
  
 
[[Category:Databases]]
 
[[Category:Databases]]

Latest revision as of 08:41, 10 August 2021


PostgreSQL:

SELECT 
  sum(heap_blks_read) as heap_read,
  sum(heap_blks_hit)  as heap_hit,
  sum(heap_blks_hit) / (sum(heap_blks_hit) + sum(heap_blks_read)) as ratio
FROM 
  pg_statio_user_tables;
heap_read  |   heap_hit   |         ratio
-------------+--------------+------------------------
37201451186 | 256244644067 | 0.87322560501639635699
(1 row)
heap_read | heap_hit | ratio
-----------+----------+-------
           |          |
(1 row)

Related terms[edit]

See also[edit]

Advertising: