From: Tom Lane <tgl@sss.pgh.pa.us>
To: George Pavlov <gpavlov@mynewplace.com>
Cc: Brad Nicholson <bnichols@ca.afilias.info>
Cc: pgsql-sql@postgresql.org
Cc: jim@contactbda.com
Subject: Re: finding unused indexes?
Date: Wed, 10 Oct 2007 09:35:59 -0400
Message-ID: <15003.1192023359@sss.pgh.pa.us> (raw)
In-Reply-To: <8C5B026B51B6854CBE88121DBF097A86013F6F6C@ehost010-33.exch010.intermedia.net>
References: <8C5B026B51B6854CBE88121DBF097A863329E8@ehost010-33.exch010.intermedia.net>
<1154448707.2624.11.camel@dba5.int.libertyrms.com>
<8C5B026B51B6854CBE88121DBF097A86013F6F6C@ehost010-33.exch010.intermedia.net>
"George Pavlov" <gpavlov@mynewplace.com> writes:
> so is it safe to say that an index that has
> pg_stat_user_indexes.idx_scan, pg_stat_user_indexes.idx_tup_read, and
> pg_stat_user_indexes.idx_tup_fetch all equal to 0 has not been used
> (since stats have been reset)?
> i have a bunch of those and all of them have
> pg_statio_user_indexes.idx_blks_read > 0 and most of those have
> pg_statio_user_indexes.idx_blks_hit > 0. when/why would that happen?
You have stats_block_level turned on, but not stats_tuple_level?
You have a lot of searches that find no rows?
regards, tom lane
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-sql@postgresql.org
Cc: tgl@sss.pgh.pa.us, gpavlov@mynewplace.com, bnichols@ca.afilias.info, jim@contactbda.com
Subject: Re: finding unused indexes?
In-Reply-To: <15003.1192023359@sss.pgh.pa.us>
* 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