pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedpg_stat
2+ messages / 1 participants
[nested] [flat]
* pg_stat
@ 2004-05-04 18:44 Litao Wu <litaowu@yahoo.com>
0 siblings, 0 replies; 2+ messages in thread
From: Litao Wu @ 2004-05-04 18:44 UTC (permalink / raw)
To: 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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: pg_stat
@ 2004-05-06 15:44 Litao Wu <litaowu@yahoo.com>
0 siblings, 0 replies; 2+ messages in thread
From: Litao Wu @ 2004-05-06 15:44 UTC (permalink / raw)
To: Litao Wu <litaowu@yahoo.com>; pgsql-performance
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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2004-05-06 15:44 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-05-04 18:44 pg_stat Litao Wu <litaowu@yahoo.com>
2004-05-06 15:44 Re: pg_stat Litao Wu <litaowu@yahoo.com>
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