Postgres Pro
Downloads
Home   >   mailing lists

Re: Unused indexes - Mailing list pgsql-general

From Rene Romero Benavides
Subject Re: Unused indexes
Date
Msg-id CANaGW09aUboySD4FCC8Py2Df12p1_5vaEqUzt760Xnu3uwoH8A@mail.gmail.com
Whole thread Raw
In response to Unused indexes  (Ron <ronljohnsonjr@gmail.com>)
List pgsql-general
Tree view
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 <ronljohnsonjr@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/

pgsql-general by date:

Previous
From: Ron
Date:
Subject: Re: Transition Tables doesn´t have OID
Next
From: Martín Marqués
Date:
Subject: Re: Unused indexes