Get detailed result from pt-query-digest

Question

I have slow query log file from Amazon RDS that using mysql as engine.

I am running pt-query-digest with that log file. with following command.

pt-query-digest --report-all --limit=0% /tmp/mysql.slow_log.log > result.txt

this is output:

How can i get more detailed output like in here.

Answer 1

--log_slow_verbosity=full

Caveat:

This flag can only be used with the Percona Server.