pg_stat

From: Litao Wu <litaowu(at)yahoo(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: pg_stat
Date: 2004-05-04 18:44:16
Message-ID: 20040504184416.11114.qmail@web13121.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hi,

I have query:
select pg_stat_get_numscans(76529669),
pg_stat_get_blocks_fetched(76529669),
pg_stat_get_blocks_hit(76529669);

The result is:
pg_stat_get_numscans | pg_stat_get_blocks_fetched |
pg_stat_get_blocks_hit
----------------------+----------------------------+------------------------
0 | 23617 |
23595
(1 row)

My questions are:
1. How can index disk blocks be requested (either
from disk or cache) without index scan?
2. If I want to check if an index is used after
pg_stat_reset(), how can I get it? By number of scans
or block requests, or some other ways?

Thanks,



__________________________________
Do you Yahoo!?
Win a $20,000 Career Makeover at Yahoo! HotJobs
http://hotjobs.sweepstakes.yahoo.com/careermakeover

Browse pgsql-performance by date

  From Date Subject
Next Message James Thornton 2004-05-04 19:34:02 Adapting Oracle S.A.M.E. Methodology for Postgres
Previous Message Greg Stark 2004-05-04 18:14:15 Re: cache table