All,

Since I have not seen any follow up post,
I am wondering if my question is not clear or
what.

Anyway, my postgres version is 7.3.2, and I
want to know:
1. How to determine if some of indexes are used by
any queries, like Oracle's:
alter index my_index monitoring usage
2. The relationship between 
"number of index scans done" and 
"Number of disk block fetch requests for index"
as shown in the query.

Thank you!
 
--- Litao Wu <[EMAIL PROTECTED]> wrote:
> 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 
> 



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

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Reply via email to