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 

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to [EMAIL PROTECTED] so that your
      message can get through to the mailing list cleanly

Reply via email to