| From: | Rene Romero Benavides <rene(dot)romero(dot)b(at)gmail(dot)com> |
|---|---|
| To: | ronljohnsonjr(at)gmail(dot)com |
| Cc: | pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Unused indexes |
| Date: | 2018-12-01 12:42:02 |
| Message-ID: | CANaGW09aUboySD4FCC8Py2Df12p1_5vaEqUzt760Xnu3uwoH8A@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(at)gmail(dot)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/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Martín Marqués | 2018-12-01 12:51:13 | Re: Unused indexes |
| Previous Message | Ron | 2018-12-01 12:37:05 | Re: Transition Tables doesn´t have OID |