I think your assumption is correct, as long as the statistics collector is working correctly (I've never seen this not being the case), and the setting "track_counts" is set to on.
Am Sa., 1. Dez. 2018 um 05:24 Uhr schrieb Ron <ronljohnso...@gmail.com>: > For indexes that existed before the cluster was last started, and for > which > REINDEX hasn't been run on them since the cluster was last started... is > it > valid to say that an index has not been used since the cluster was started > if these three pg_stat_all_indexes fields all have a value of 0? > > idx_scan > idx_tup_read > idx_tup_fetch > > If it matters, the version is 9.6.6. > > Thanks > > -- > Angular momentum makes the world go 'round. > > -- El genio es 1% inspiración y 99% transpiración. Thomas Alva Edison http://pglearn.blogspot.mx/
