# Pt-query-digest missing report (query rank is inconsistent)

**URL:** <https://forums.percona.com/t/pt-query-digest-missing-report-query-rank-is-inconsistent/31216>\
**Category:** Uncategorized\
**Tags:** community, mysql, percona\
**Created:** [June 25, 2024, 9:23am UTC](https://forums.percona.com/t/pt-query-digest-missing-report-query-rank-is-inconsistent/31216 "2024-06-25T09:23:03Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![alwaysdba](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/alwaysdba/32/17029_2.png) [@alwaysdba](https://forums.percona.com/u/alwaysdba)\
**Post date:** [June 25, 2024, 9:23am UTC](https://forums.percona.com/t/pt-query-digest-missing-report-query-rank-is-inconsistent/31216/1 "2024-06-25T09:23:03Z")

</div>

Hi Team,

I am currently using `pt-query-digest` with my slow query log file, which provides detailed information on unique queries (including the number of executions and the average time spent on each). But, when I manually count the number of queries, it shows 135 whereas the report lists 141 ranked queries. Some ranked queries seem to be missing from the report. Is it possible to retrieve all ranked queries without any missing?

Thanks

---

<div class="post-metadata">

**Author:** ![kedarpercona](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/kedarpercona/32/809_2.png) [@kedarpercona](https://forums.percona.com/u/kedarpercona)\
**Post date:** [June 25, 2024, 9:58am UTC](https://forums.percona.com/t/pt-query-digest-missing-report-query-rank-is-inconsistent/31216/2 "2024-06-25T09:58:36Z")

</div>

Welcome to Percona Community @alwaysdba ,

Can you try adding `--limit=100%` to your pt-query-digest command?

Refer documentation:

> **[Percona Toolkit Documentation](https://docs.percona.com/percona-toolkit/pt-query-digest.html#cmdoption-pt-query-digest-limit)**
>
> Command-line tools for common MySQL database administration tasks.

Thanks,  
K

---

<div class="post-metadata">

**Author:** ![alwaysdba](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/alwaysdba/32/17029_2.png) [@alwaysdba](https://forums.percona.com/u/alwaysdba)\
**Post date:** [June 26, 2024, 6:21am UTC](https://forums.percona.com/t/pt-query-digest-missing-report-query-rank-is-inconsistent/31216/3 "2024-06-26T06:21:12Z")

</div>

Thanks Kedar. Its working fine now.