# how to get slow query logs for mysql and analyse it through pt-query-digest?

**URL:** <https://forums.percona.com/t/how-to-get-slow-query-logs-for-mysql-and-analyse-it-through-pt-query-digest/5313>\
**Category:** Percona Toolkit\
**Created:** [December 21, 2016, 7:14am UTC](https://forums.percona.com/t/how-to-get-slow-query-logs-for-mysql-and-analyse-it-through-pt-query-digest/5313 "2016-12-21T07:14:50Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![sudhir.agarwal](https://avatars.discourse-cdn.com/v4/letter/s/258eb7/32.png) [@sudhir.agarwal](https://forums.percona.com/u/sudhir.agarwal)\
**Post date:** [December 21, 2016, 7:14am UTC](https://forums.percona.com/t/how-to-get-slow-query-logs-for-mysql-and-analyse-it-through-pt-query-digest/5313/1 "2016-12-21T07:14:50Z")

</div>

I have enabled slow query logs in config file. when i execute pt-query-digest filename, it just shows the query-size. It does not show complete output like it is showing for tcpdump option. How to analyse the slow query logs??

---

<div class="post-metadata">

**Author:** ![mirfan](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/mirfan/32/16890_2.png) [@mirfan](https://forums.percona.com/u/mirfan)\
**Post date:** [March 31, 2017, 6:14am UTC](https://forums.percona.com/t/how-to-get-slow-query-logs-for-mysql-and-analyse-it-through-pt-query-digest/5313/2 "2017-03-31T06:14:20Z")

</div>

Can you show exact commands you used ? I also had written blogpost on analyzing slow log via pt-query-digest worth to read [url][https://www.percona.com/blog/2014/03/14/mysql-slow-query-log-tools-and-tips/[/url]](https://www.percona.com/blog/2014/03/14/mysql-slow-query-log-tools-and-tips/%5B/url%5D)