# pt-archiver Cleaning up a table containing longtext columns is slow

**URL:** <https://forums.percona.com/t/pt-archiver-cleaning-up-a-table-containing-longtext-columns-is-slow/6483>\
**Category:** Percona Toolkit\
**Created:** [July 28, 2018, 9:32am UTC](https://forums.percona.com/t/pt-archiver-cleaning-up-a-table-containing-longtext-columns-is-slow/6483 "2018-07-28T09:32:42Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Fan](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/fan/32/40_2.png) [@Fan](https://forums.percona.com/u/Fan)\
**Post date:** [July 28, 2018, 9:32am UTC](https://forums.percona.com/t/pt-archiver-cleaning-up-a-table-containing-longtext-columns-is-slow/6483/1 "2018-07-28T09:32:42Z")

</div>

It seems to be slow on select, why pt-archiver query all columns instead of just select the primary key column?

---

<div class="post-metadata">

**Author:** ![carlos.salguero](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/carlos.salguero/32/20_2.png) [@carlos.salguero](https://forums.percona.com/u/carlos.salguero)\
**Post date:** [July 30, 2018, 7:25am UTC](https://forums.percona.com/t/pt-archiver-cleaning-up-a-table-containing-longtext-columns-is-slow/6483/2 "2018-07-30T07:25:11Z")

</div>

Could you provide more information?

- pt tools version
- MySQL version
- The output of the SHOW CREATE TABLE for the table you are trying to archive.
- Command line parameters used with pt-archiver
- Are there slaves in you set up?

Regards