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

, ,
1

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

2

Welcome to Percona Community @alwaysdba ,

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

Refer documentation:

Thanks,
K

1 Like
3

Thanks Kedar. Its working fine now.