which tables have lowest cache hits?

Hi, our buffer rate increased (to about 6) and it seems it is because low write cache hit (about 93%). We have now 130 MB of buffers and I do not want to increase it ... yet. What I'd like to know now is, which tables have lowest cache hit? Is it possible to find it? How? Thanks, Michal

Hi Michal, use the following select: --#header=database tabname pagreads pagwrites pagops bufreads bufwrites seqscans lockreqs --#format=%15.15s %18.18s %10d %10d %10d %10d %10d %10d %10d select dbsname , tabname , sum(pagreads) pagreads , sum(pagwrites) pagwrites , sum(pagreads + pagwrites) pagops , sum(bufreads) bufreads , sum(bufwrites) bufwrites , sum(seqscans) seqscans , sum(lockreqs) lockreqs from sysptprof group by 1, 2 order by 1, 2; Hope it helps. hajek@nspuh.cz (Michal Hajek) wrote in message news:<6743d070.0311070143.1bfc0725@posting.google.com>... > Hi, > > our buffer rate increased (to about 6) and it seems it is because low > write cache hit (about 93%). We have now 130 MB of buffers and I do > not want to increase it ... yet. What I'd like to know now is, which > tables have lowest cache hit? Is it possible to find it? How? > > Thanks, > Michal