Postgres Pro
Downloads
Home   >   mailing lists

Unused indexes - Mailing list pgsql-general

From Ron
Subject Unused indexes
Date
Msg-id df259502-5c03-6f4a-93de-7706924a97b0@gmail.com
Whole thread Raw
Responses Re: Unused indexes  (Rene Romero Benavides <rene.romero.b@gmail.com>)
Re: Unused indexes  (Martín Marqués <martin.marques@gmail.com>)
List pgsql-general
Tree view 
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.

pgsql-general by date:

Previous
From: Gavin Flower
Date:
Subject: Re: surprising query optimisation
Next
From: PegoraroF10
Date:
Subject: Transition Tables doesn´t have OID