# pt-duplicate-keys, simple doubt...

**URL:** <https://forums.percona.com/t/pt-duplicate-keys-simple-doubt/4188>\
**Category:** Percona Toolkit\
**Created:** [April 27, 2015, 2:14pm UTC](https://forums.percona.com/t/pt-duplicate-keys-simple-doubt/4188 "2015-04-27T14:14:47Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![wagnerbianchi](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/wagnerbianchi/32/802_2.png) [@wagnerbianchi](https://forums.percona.com/u/wagnerbianchi)\
**Post date:** [April 27, 2015, 2:14pm UTC](https://forums.percona.com/t/pt-duplicate-keys-simple-doubt/4188/1 "2015-04-27T14:14:47Z")

</div>

Hey Guys,

A simple doubt, I’ve been working on a test environment to validate the usage of pt-duplicate-keys on certain tables I think have an ugly design and many duplicate/unnecessary indexes and column’s repetitions. BTW, the information on the end of the script execution is very useful, but, I’m in doubt about the “Size Duplicate Indexes” - is this the sum(#) of duplicate indexes lines?

```auto
# ########################################################################
# Summary of indexes
# ########################################################################

# Size Duplicate Indexes 3165489 <<<<<<---- HERE!!!
# Total Duplicate Indexes 9
# Total Indexes 22

```

---

<div class="post-metadata">

**Author:** ![scott.nemes](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/scott.nemes/32/5_2.png) [@scott.nemes](https://forums.percona.com/u/scott.nemes)\
**Post date:** [April 27, 2015, 2:40pm UTC](https://forums.percona.com/t/pt-duplicate-keys-simple-doubt/4188/2 "2015-04-27T14:40:30Z")

</div>

Hi Wagnerbianchi;

It’s an estimate in bytes of the space taken up by the duplicate indexes. There is a good explanation in a bug report where someone asked the same question:

[url][https://bugs.launchpad.net/percona-toolkit/+bug/1415646[/url]](https://bugs.launchpad.net/percona-toolkit/+bug/1415646%5B/url%5D)

-Scott

---

<div class="post-metadata">

**Author:** ![wagnerbianchi](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/wagnerbianchi/32/802_2.png) [@wagnerbianchi](https://forums.percona.com/u/wagnerbianchi)\
**Post date:** [April 27, 2015, 2:44pm UTC](https://forums.percona.com/t/pt-duplicate-keys-simple-doubt/4188/3 "2015-04-27T14:44:39Z")

</div>

Thanks Scott!!