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

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.

It appears the bug has already been reported since 2013 : https://bugs.launchpad.net/percona-toolkit/+bug/1220341