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
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 |