pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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 



view thread (2+ messages)

Message-ID: <20040506154443.82425.qmail@web13125.mail.yahoo.com>
Permalink:  ../20040506154443.82425.qmail@web13125.mail.yahoo.com/
Also on:    postgresql.org/message-id/20040506154443.82425.qmail@web13125.mail.yahoo.com

 · 

reply

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