2004-12-01 hit rate postgres select relname,100* heap_blks_hit::real / (heap_blks_read + heap_blks_hit) from pg_statio_all_tables where heap_blks_hit > 0 and schemaname='public';