# pt-query-digest slowlog output format looses query cache hit information.

**URL:** <https://forums.percona.com/t/pt-query-digest-slowlog-output-format-looses-query-cache-hit-information/5340>\
**Category:** Percona Toolkit\
**Created:** [January 12, 2017, 8:36am UTC](https://forums.percona.com/t/pt-query-digest-slowlog-output-format-looses-query-cache-hit-information/5340 "2017-01-12T08:36:31Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![tomdesp](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/tomdesp/32/977_2.png) [@tomdesp](https://forums.percona.com/u/tomdesp)\
**Post date:** [January 12, 2017, 8:36am UTC](https://forums.percona.com/t/pt-query-digest-slowlog-output-format-looses-query-cache-hit-information/5340/1 "2017-01-12T08:36:31Z")

</div>

Hi everyone,

I’m using pt-query-digest (v2.2.20) slowlog output format to filter out queries based on their timestamp, to run further digests on the filtered slowlog :

The point is my source log 11-21.slow.log has query cache hit info, for instance :

# Time: 170109 12:08:43

# User@Host: pidf\_user[pidf\_user] @ [10.226.13.132]

# Thread\_id: 32829731 Schema: webmbpidf [COLOR=#FF0000]QC\_hit: No

# Query\_time: 0.015387 Lock\_time: 0.000038 Rows\_sent: 0 Rows\_examined: 0

Whereas the filtered output doesn’t :

# Time: 170109 11:59:59

# User@Host: pest\_user[pest\_user] @ 10.226.13.13

# Thread\_id: 32805954

# Query\_time: 0.000221 Lock\_time: 0.000000 Rows\_sent: 0 Rows\_examined: 0

l lose schema information as well but it’s less a problem in my situation.

Is there a way to keep the query cache info in the slowlog output ?

Any help would me much appreciated.

---

<div class="post-metadata">

**Author:** ![tomdesp](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/tomdesp/32/977_2.png) [@tomdesp](https://forums.percona.com/u/tomdesp)\
**Post date:** [May 20, 2017, 4:28am UTC](https://forums.percona.com/t/pt-query-digest-slowlog-output-format-looses-query-cache-hit-information/5340/2 "2017-05-20T04:28:15Z")

</div>

It appears the bug has already been reported since 2013 : [url][https://bugs.launchpad.net/percona-toolkit/+bug/1220341[/url]](https://bugs.launchpad.net/percona-toolkit/+bug/1220341%5B/url%5D)