From: Litao Wu <litaowu@yahoo.com>
To: pgsql-performance@postgresql.org
Subject: pg_stat
Date: Tue, 4 May 2004 11:44:16 -0700 (PDT)
Message-ID: <20040504184416.11114.qmail@web13121.mail.yahoo.com> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: litaowu@yahoo.com
Subject: Re: pg_stat
In-Reply-To: <20040504184416.11114.qmail@web13121.mail.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox