Unused indexes

From: Ron <ronljohnsonjr(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Unused indexes
Date: 2018-12-01 11:24:45
Message-ID: df259502-5c03-6f4a-93de-7706924a97b0@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message PegoraroF10 2018-12-01 12:22:18 Transition Tables doesn´t have OID
Previous Message Gavin Flower 2018-11-30 22:10:46 Re: surprising query optimisation