pg_stat
| От | Litao Wu |
|---|---|
| Тема | pg_stat |
| Дата | |
| Msg-id | 20040504184416.11114.qmail@web13121.mail.yahoo.com обсуждение |
| Список | 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
В списке pgsql-performance по дате отправления: