Thanks.
how about the case as follows?
idx_scan = 0 and idx_tup_read = 0 and idx_tup_fetch = 0, but
idx_blks_read is not 0 and idx_blks_hit is not 0
?
regards
On 3 Sep 2013, at 5:31 PM, Abdul Sayeed wrote:
Hi,
Below query can be handy to find unused indexes.
select indexrelname from pg_stat_user_indexes where idx_scan = 0 and idx_tup_read = 0 and idx_tup_fetch = 0 ;
Hope it helps.