Difference between revisions of "Cache hit ratio"

From wikieduonline
Jump to navigation Jump to search
 
(3 intermediate revisions by the same user not shown)
Line 3: Line 3:
  
 
[[PostgreSQL]]:
 
[[PostgreSQL]]:
  SELECT  
+
  [[SELECT]]
 
   sum(heap_blks_read) as heap_read,
 
   sum(heap_blks_read) as heap_read,
 
   sum(heap_blks_hit)  as heap_hit,
 
   sum(heap_blks_hit)  as heap_hit,
Line 9: Line 9:
 
  FROM  
 
  FROM  
 
   [[pg_statio_user_tables]];
 
   [[pg_statio_user_tables]];
 +
 +
heap_read  |  heap_hit  |        ratio
 +
-------------+--------------+------------------------
 +
37201451186 | 256244644067 | 0.87322560501639635699
 +
(1 row)
  
 
  heap_read | heap_hit | ratio
 
  heap_read | heap_hit | ratio
Line 23: 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: