"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 ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match