Details
Assignee
UnassignedUnassignedReporter
lpjirasynclpjirasync(Deactivated)Priority
Low
Details
Details
Assignee
Unassigned
UnassignedReporter
lpjirasync
lpjirasync(Deactivated)Priority
Smart Checklist
Smart Checklist
Smart Checklist
Created January 24, 2018 at 7:38 PM
Updated December 21, 2019 at 2:32 PM
**Reported in Launchpad by Ryan Lowe last update 02-08-2013 18:37:38
Having run pt-query-digest 2.2 against a slow query log, I get the following (anonymized) output:
Profile
Rank Query ID Response time Calls R/Call V/M Item
==== ================== =============== ======= ======== ===== =========
1 0x9547A60B17EFDFF2 3942.7586 22.1% 2585 1.5252 0.00 SELECT x
2 0x3CA33B6583A85AC0 2033.2187 11.4% 1958 1.0384 0.68 SELECT x y
...
19 0x12CD1C170E457B81 195.6057 1.1% 1 195.6057 0.00 SELECT z
20 0x51363D8AFB1D6F90 186.3636 1.0% 1376 0.1354 0.00 SELECT a
22 0xE524E76CF9719105 144.7776 0.8% 27 5.3621 0.03 SELECT x y
24 0x9D4430B7270E6646 128.3290 0.7% 46 2.7898 1.65 SELECT x b
...
82 0x40A235ECA8139B12 18.0485 0.1% 126 0.1432 1.16 SELECT x y
MISC 0xMISC 3377.6036 18.9% 5170806 0.0007 0.0 <787 ITEMS>
Notice 19-24 where it skips 21 and 23. They also do not appear later in the report. What gives?