| From: | "Benjamin Krajmalnik" <kraj(at)servoyant(dot)com> |
|---|---|
| To: | <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Unused indices |
| Date: | 2011-02-23 19:12:42 |
| Message-ID: | F4E6A2751A2823418A21D4A160B689887B0F8E@fletch.stackdump.local |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
I am trying to clean up our schema by removing any indices which are not
being used frequently or at all.
Using pgadmin, looking at the statistics for an index, I see various
pieces of information:
Index Scans, Index Tuples Read, Index Tuples Fetched, Index Blocks Read,
and Index Blocks Hit.
I have on index with the following statistics:
Index Scans 0
Index Tuples Read 0
Index Tuples Fetched 0
Index Blocks Read 834389
Index Blocks Hit 247283300
Index Size 1752 kB
Since there are no index scans, would it be safe to remove this one?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mathieu De Zutter | 2011-02-23 19:27:11 | NULLS LAST performance |
| Previous Message | Robert Haas | 2011-02-23 17:59:31 | Re: Exhaustive list of what takes what locks |