■ CACHE HIT 비율을 조회하는 방법을 보여준다.
▶ 예제 코드 (SQL)
1 2 3 4 5 6 7 |
SELECT SUM(HEAP_BLKS_READ) AS HEAP_READ ,SUM(HEAP_BLKS_HIT) AS HEAP_HIT ,(SUM(HEAP_BLKS_HIT) - SUM(HEAP_BLKS_READ)) / SUM(HEAP_BLKS_HIT) AS RATIO FROM PG_STATIO_USER_TABLES; |