Debian Codegraph @

event/testdata/slow023.golden

raw
1 {
2 "Global": {
3 "Id": "",
4 "User": "",
5 "Host": "",
6 "Db": "",
7 "Server": "",
8 "LabelsKey": [],
9 "LabelsValue": [],
10 "Fingerprint": "",
11 "Metrics": {
12 "TimeMetrics": {
13 "Lock_time": {
14 "Cnt": 8,
15 "Sum": 0.000238,
16 "Min": 0,
17 "P99": 0.000141,
18 "Max": 0.000141
19 },
20 "Query_time": {
21 "Cnt": 8,
22 "Sum": 0.8918539999999999,
23 "Min": 0.000037,
24 "P99": 0.321092,
25 "Max": 0.321092
26 }
27 },
28 "NumberMetrics": {
29 "Rows_examined": {
30 "Cnt": 8,
31 "Sum": 2,
32 "Min": 0,
33 "P99": 1,
34 "Max": 1
35 },
36 "Rows_sent": {
37 "Cnt": 8,
38 "Sum": 4,
39 "Min": 0,
40 "P99": 1,
41 "Max": 1
42 }
43 }
44 },
45 "TotalQueries": 8,
46 "UniqueQueries": 8,
47 "NumQueriesWithErrors": 0,
48 "ErrorsCode": null,
49 "ErrorsCount": null
50 },
51 "Class": {
52 "54FB1194093381DB;percona-agent;localhost;;": {
53 "Id": "54FB1194093381DB",
54 "User": "percona-agent",
55 "Host": "localhost",
56 "Db": "",
57 "Server": "",
58 "LabelsKey": [],
59 "LabelsValue": [],
60 "Fingerprint": "set global slow_query_log=on",
61 "Metrics": {
62 "TimeMetrics": {
63 "Lock_time": {
64 "Cnt": 1,
65 "Sum": 0,
66 "Min": 0,
67 "P99": 0,
68 "Max": 0
69 },
70 "Query_time": {
71 "Cnt": 1,
72 "Sum": 0.31645,
73 "Min": 0.31645,
74 "P99": 0.31645,
75 "Max": 0.31645
76 }
77 },
78 "NumberMetrics": {
79 "Rows_examined": {
80 "Cnt": 1,
81 "Sum": 0,
82 "Min": 0,
83 "P99": 0,
84 "Max": 0
85 },
86 "Rows_sent": {
87 "Cnt": 1,
88 "Sum": 0,
89 "Min": 0,
90 "P99": 0,
91 "Max": 0
92 }
93 }
94 },
95 "TotalQueries": 1,
96 "UniqueQueries": 1,
97 "Example": {
98 "QueryTime": 0.31645,
99 "Db": "",
100 "Query": "SET GLOBAL slow_query_log=ON",
101 "Size": 28
102 },
103 "NumQueriesWithErrors": 0,
104 "ErrorsCode": null,
105 "ErrorsCount": null
106 },
107 "6C099B0B73EA7633;backup;localhost;dbnameb;": {
108 "Id": "6C099B0B73EA7633",
109 "User": "backup",
110 "Host": "localhost",
111 "Db": "dbnameb",
112 "Server": "",
113 "LabelsKey": [],
114 "LabelsValue": [],
115 "Fingerprint": "use ?",
116 "Metrics": {
117 "TimeMetrics": {
118 "Lock_time": {
119 "Cnt": 1,
120 "Sum": 0,
121 "Min": 0,
122 "P99": 0,
123 "Max": 0
124 },
125 "Query_time": {
126 "Cnt": 1,
127 "Sum": 0.000558,
128 "Min": 0.000558,
129 "P99": 0.000558,
130 "Max": 0.000558
131 }
132 },
133 "NumberMetrics": {
134 "Rows_examined": {
135 "Cnt": 1,
136 "Sum": 0,
137 "Min": 0,
138 "P99": 0,
139 "Max": 0
140 },
141 "Rows_sent": {
142 "Cnt": 1,
143 "Sum": 0,
144 "Min": 0,
145 "P99": 0,
146 "Max": 0
147 }
148 }
149 },
150 "TotalQueries": 1,
151 "UniqueQueries": 1,
152 "Example": {
153 "QueryTime": 0.000558,
154 "Db": "dbnameb",
155 "Query": "use `dbnameb`",
156 "Size": 13
157 },
158 "NumQueriesWithErrors": 0,
159 "ErrorsCode": null,
160 "ErrorsCount": null
161 },
162 "7C1934E82086DF57;bookblogs;localhost;;": {
163 "Id": "7C1934E82086DF57",
164 "User": "bookblogs",
165 "Host": "localhost",
166 "Db": "",
167 "Server": "",
168 "LabelsKey": [],
169 "LabelsValue": [],
170 "Fingerprint": "set names utf8",
171 "Metrics": {
172 "TimeMetrics": {
173 "Lock_time": {
174 "Cnt": 1,
175 "Sum": 0,
176 "Min": 0,
177 "P99": 0,
178 "Max": 0
179 },
180 "Query_time": {
181 "Cnt": 1,
182 "Sum": 0.253052,
183 "Min": 0.253052,
184 "P99": 0.253052,
185 "Max": 0.253052
186 }
187 },
188 "NumberMetrics": {
189 "Rows_examined": {
190 "Cnt": 1,
191 "Sum": 0,
192 "Min": 0,
193 "P99": 0,
194 "Max": 0
195 },
196 "Rows_sent": {
197 "Cnt": 1,
198 "Sum": 0,
199 "Min": 0,
200 "P99": 0,
201 "Max": 0
202 }
203 }
204 },
205 "TotalQueries": 1,
206 "UniqueQueries": 1,
207 "Example": {
208 "QueryTime": 0.253052,
209 "Db": "",
210 "Query": "SET NAMES utf8",
211 "Size": 14
212 },
213 "NumQueriesWithErrors": 0,
214 "ErrorsCode": null,
215 "ErrorsCount": null
216 },
217 "83497A0046FCD7A7;bookblogs;localhost;dbnamea;": {
218 "Id": "83497A0046FCD7A7",
219 "User": "bookblogs",
220 "Host": "localhost",
221 "Db": "dbnamea",
222 "Server": "",
223 "LabelsKey": [],
224 "LabelsValue": [],
225 "Fingerprint": "select field from table_a where some_other_field = ? limit ?",
226 "Metrics": {
227 "TimeMetrics": {
228 "Lock_time": {
229 "Cnt": 1,
230 "Sum": 0.000038,
231 "Min": 0.000038,
232 "P99": 0.000038,
233 "Max": 0.000038
234 },
235 "Query_time": {
236 "Cnt": 1,
237 "Sum": 0.321092,
238 "Min": 0.321092,
239 "P99": 0.321092,
240 "Max": 0.321092
241 }
242 },
243 "NumberMetrics": {
244 "Rows_examined": {
245 "Cnt": 1,
246 "Sum": 0,
247 "Min": 0,
248 "P99": 0,
249 "Max": 0
250 },
251 "Rows_sent": {
252 "Cnt": 1,
253 "Sum": 0,
254 "Min": 0,
255 "P99": 0,
256 "Max": 0
257 }
258 }
259 },
260 "TotalQueries": 1,
261 "UniqueQueries": 1,
262 "Example": {
263 "QueryTime": 0.321092,
264 "Db": "dbnamea",
265 "Query": "SELECT field FROM table_a WHERE some_other_field = 'yahoo' LIMIT 1",
266 "Size": 66
267 },
268 "NumQueriesWithErrors": 0,
269 "ErrorsCode": null,
270 "ErrorsCount": null
271 },
272 "9FD5245EAE433B90;bookblogs;localhost;;": {
273 "Id": "9FD5245EAE433B90",
274 "User": "bookblogs",
275 "Host": "localhost",
276 "Db": "",
277 "Server": "",
278 "LabelsKey": [],
279 "LabelsValue": [],
280 "Fingerprint": "select another_field from table_c where a_third_field = ? and site_id = ?",
281 "Metrics": {
282 "TimeMetrics": {
283 "Lock_time": {
284 "Cnt": 1,
285 "Sum": 0.000059,
286 "Min": 0.000059,
287 "P99": 0.000059,
288 "Max": 0.000059
289 },
290 "Query_time": {
291 "Cnt": 1,
292 "Sum": 0.000164,
293 "Min": 0.000164,
294 "P99": 0.000164,
295 "Max": 0.000164
296 }
297 },
298 "NumberMetrics": {
299 "Rows_examined": {
300 "Cnt": 1,
301 "Sum": 1,
302 "Min": 1,
303 "P99": 1,
304 "Max": 1
305 },
306 "Rows_sent": {
307 "Cnt": 1,
308 "Sum": 1,
309 "Min": 1,
310 "P99": 1,
311 "Max": 1
312 }
313 }
314 },
315 "TotalQueries": 1,
316 "UniqueQueries": 1,
317 "Example": {
318 "QueryTime": 0.000164,
319 "Db": "",
320 "Query": "SELECT another_field FROM table_c WHERE a_third_field = 'tiruriru' AND site_id = 1",
321 "Size": 82
322 },
323 "NumQueriesWithErrors": 0,
324 "ErrorsCode": null,
325 "ErrorsCount": null
326 },
327 "AC5C18B304F9DE87;backup;localhost;;": {
328 "Id": "AC5C18B304F9DE87",
329 "User": "backup",
330 "Host": "localhost",
331 "Db": "",
332 "Server": "",
333 "LabelsKey": [],
334 "LabelsValue": [],
335 "Fingerprint": "select @@collation_database",
336 "Metrics": {
337 "TimeMetrics": {
338 "Lock_time": {
339 "Cnt": 1,
340 "Sum": 0,
341 "Min": 0,
342 "P99": 0,
343 "Max": 0
344 },
345 "Query_time": {
346 "Cnt": 1,
347 "Sum": 0.000204,
348 "Min": 0.000204,
349 "P99": 0.000204,
350 "Max": 0.000204
351 }
352 },
353 "NumberMetrics": {
354 "Rows_examined": {
355 "Cnt": 1,
356 "Sum": 0,
357 "Min": 0,
358 "P99": 0,
359 "Max": 0
360 },
361 "Rows_sent": {
362 "Cnt": 1,
363 "Sum": 1,
364 "Min": 1,
365 "P99": 1,
366 "Max": 1
367 }
368 }
369 },
370 "TotalQueries": 1,
371 "UniqueQueries": 1,
372 "Example": {
373 "QueryTime": 0.000204,
374 "Db": "",
375 "Query": "select @@collation_database",
376 "Size": 27
377 },
378 "NumQueriesWithErrors": 0,
379 "ErrorsCode": null,
380 "ErrorsCount": null
381 },
382 "B98E038C9D12BDA1;bookblogs;localhost;;": {
383 "Id": "B98E038C9D12BDA1",
384 "User": "bookblogs",
385 "Host": "localhost",
386 "Db": "",
387 "Server": "",
388 "LabelsKey": [],
389 "LabelsValue": [],
390 "Fingerprint": "select field from table_b where another_field = ? and site_id = ?",
391 "Metrics": {
392 "TimeMetrics": {
393 "Lock_time": {
394 "Cnt": 1,
395 "Sum": 0.000141,
396 "Min": 0.000141,
397 "P99": 0.000141,
398 "Max": 0.000141
399 },
400 "Query_time": {
401 "Cnt": 1,
402 "Sum": 0.000297,
403 "Min": 0.000297,
404 "P99": 0.000297,
405 "Max": 0.000297
406 }
407 },
408 "NumberMetrics": {
409 "Rows_examined": {
410 "Cnt": 1,
411 "Sum": 1,
412 "Min": 1,
413 "P99": 1,
414 "Max": 1
415 },
416 "Rows_sent": {
417 "Cnt": 1,
418 "Sum": 1,
419 "Min": 1,
420 "P99": 1,
421 "Max": 1
422 }
423 }
424 },
425 "TotalQueries": 1,
426 "UniqueQueries": 1,
427 "Example": {
428 "QueryTime": 0.000297,
429 "Db": "",
430 "Query": "SELECT field FROM table_b WHERE another_field = 'bazinga' AND site_id = 1",
431 "Size": 73
432 },
433 "NumQueriesWithErrors": 0,
434 "ErrorsCode": null,
435 "ErrorsCount": null
436 },
437 "F0265D81808CE240;bookblogs;localhost;;": {
438 "Id": "F0265D81808CE240",
439 "User": "bookblogs",
440 "Host": "localhost",
441 "Db": "",
442 "Server": "",
443 "LabelsKey": [],
444 "LabelsValue": [],
445 "Fingerprint": "select @@session.sql_mode",
446 "Metrics": {
447 "TimeMetrics": {
448 "Lock_time": {
449 "Cnt": 1,
450 "Sum": 0,
451 "Min": 0,
452 "P99": 0,
453 "Max": 0
454 },
455 "Query_time": {
456 "Cnt": 1,
457 "Sum": 0.000037,
458 "Min": 0.000037,
459 "P99": 0.000037,
460 "Max": 0.000037
461 }
462 },
463 "NumberMetrics": {
464 "Rows_examined": {
465 "Cnt": 1,
466 "Sum": 0,
467 "Min": 0,
468 "P99": 0,
469 "Max": 0
470 },
471 "Rows_sent": {
472 "Cnt": 1,
473 "Sum": 1,
474 "Min": 1,
475 "P99": 1,
476 "Max": 1
477 }
478 }
479 },
480 "TotalQueries": 1,
481 "UniqueQueries": 1,
482 "Example": {
483 "QueryTime": 0.000037,
484 "Db": "",
485 "Query": "SELECT @@SESSION.sql_mode",
486 "Size": 25
487 },
488 "NumQueriesWithErrors": 0,
489 "ErrorsCode": null,
490 "ErrorsCount": null
491 }
492 },
493 "RateLimit": 0,
494 "Error": ""
495 }