From: Litao Wu <litaowu@yahoo.com>
To: Litao Wu <litaowu@yahoo.com>
To: pgsql-performance@postgresql.org
Subject: Re: pg_stat
Date: Thu, 6 May 2004 08:44:43 -0700 (PDT)
Message-ID: <20040506154443.82425.qmail@web13125.mail.yahoo.com> (raw)
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 <litaowu@yahoo.com> 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
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: <20040506154443.82425.qmail@web13125.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