Debian Codegraph @

event/testdata/slow018.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": 4,
15 "Sum": 0,
16 "Min": 0,
17 "P99": 0,
18 "Max": 0
19 },
20 "Query_time": {
21 "Cnt": 4,
22 "Sum": 0.9010440000000001,
23 "Min": 0.000001,
24 "P99": 0.900001,
25 "Max": 0.900001
26 }
27 },
28 "NumberMetrics": {
29 "Merge_passes": {
30 "Cnt": 4,
31 "Sum": 0,
32 "Min": 0,
33 "P99": 0,
34 "Max": 0
35 },
36 "Rows_examined": {
37 "Cnt": 4,
38 "Sum": 10,
39 "Min": 1,
40 "P99": 4,
41 "Max": 4
42 },
43 "Rows_sent": {
44 "Cnt": 4,
45 "Sum": 10,
46 "Min": 1,
47 "P99": 4,
48 "Max": 4
49 }
50 },
51 "BoolMetrics": {
52 "Filesort": {
53 "Cnt": 4,
54 "Sum": 4
55 },
56 "Filesort_on_disk": {
57 "Cnt": 4,
58 "Sum": 0
59 },
60 "Full_join": {
61 "Cnt": 4,
62 "Sum": 0
63 },
64 "Full_scan": {
65 "Cnt": 4,
66 "Sum": 1
67 },
68 "QC_Hit": {
69 "Cnt": 4,
70 "Sum": 0
71 },
72 "Tmp_table": {
73 "Cnt": 4,
74 "Sum": 2
75 },
76 "Tmp_table_on_disk": {
77 "Cnt": 4,
78 "Sum": 0
79 }
80 }
81 },
82 "TotalQueries": 4,
83 "UniqueQueries": 2,
84 "NumQueriesWithErrors": 0,
85 "ErrorsCode": null,
86 "ErrorsCount": null
87 },
88 "Class": {
89 "B2414E722E8A89DD;[SQL_SLAVE];;;": {
90 "Id": "B2414E722E8A89DD",
91 "User": "[SQL_SLAVE]",
92 "Host": "",
93 "Db": "",
94 "Server": "",
95 "LabelsKey": [],
96 "LabelsValue": [],
97 "Fingerprint": "select * from t where id in(?+)",
98 "Metrics": {
99 "TimeMetrics": {
100 "Lock_time": {
101 "Cnt": 3,
102 "Sum": 0,
103 "Min": 0,
104 "P99": 0,
105 "Max": 0
106 },
107 "Query_time": {
108 "Cnt": 3,
109 "Sum": 0.901043,
110 "Min": 0.000512,
111 "P99": 0.900001,
112 "Max": 0.900001
113 }
114 },
115 "NumberMetrics": {
116 "Merge_passes": {
117 "Cnt": 3,
118 "Sum": 0,
119 "Min": 0,
120 "P99": 0,
121 "Max": 0
122 },
123 "Rows_examined": {
124 "Cnt": 3,
125 "Sum": 9,
126 "Min": 2,
127 "P99": 4,
128 "Max": 4
129 },
130 "Rows_sent": {
131 "Cnt": 3,
132 "Sum": 9,
133 "Min": 2,
134 "P99": 4,
135 "Max": 4
136 }
137 },
138 "BoolMetrics": {
139 "Filesort": {
140 "Cnt": 3,
141 "Sum": 3
142 },
143 "Filesort_on_disk": {
144 "Cnt": 3,
145 "Sum": 0
146 },
147 "Full_join": {
148 "Cnt": 3,
149 "Sum": 0
150 },
151 "Full_scan": {
152 "Cnt": 3,
153 "Sum": 0
154 },
155 "QC_Hit": {
156 "Cnt": 3,
157 "Sum": 0
158 },
159 "Tmp_table": {
160 "Cnt": 3,
161 "Sum": 1
162 },
163 "Tmp_table_on_disk": {
164 "Cnt": 3,
165 "Sum": 0
166 }
167 }
168 },
169 "TotalQueries": 3,
170 "UniqueQueries": 1,
171 "Example": {
172 "QueryTime": 0.900001,
173 "Db": "",
174 "Query": "select * from t where id in (10000,20000,30000)",
175 "Size": 47
176 },
177 "NumQueriesWithErrors": 0,
178 "ErrorsCode": null,
179 "ErrorsCount": null
180 },
181 "B2414E722E8A89DD;[SQL_SLAVE];;db1;": {
182 "Id": "B2414E722E8A89DD",
183 "User": "[SQL_SLAVE]",
184 "Host": "",
185 "Db": "db1",
186 "Server": "",
187 "LabelsKey": [],
188 "LabelsValue": [],
189 "Fingerprint": "select * from t where id in(?+)",
190 "Metrics": {
191 "TimeMetrics": {
192 "Lock_time": {
193 "Cnt": 1,
194 "Sum": 0,
195 "Min": 0,
196 "P99": 0,
197 "Max": 0
198 },
199 "Query_time": {
200 "Cnt": 1,
201 "Sum": 0.000001,
202 "Min": 0.000001,
203 "P99": 0.000001,
204 "Max": 0.000001
205 }
206 },
207 "NumberMetrics": {
208 "Merge_passes": {
209 "Cnt": 1,
210 "Sum": 0,
211 "Min": 0,
212 "P99": 0,
213 "Max": 0
214 },
215 "Rows_examined": {
216 "Cnt": 1,
217 "Sum": 1,
218 "Min": 1,
219 "P99": 1,
220 "Max": 1
221 },
222 "Rows_sent": {
223 "Cnt": 1,
224 "Sum": 1,
225 "Min": 1,
226 "P99": 1,
227 "Max": 1
228 }
229 },
230 "BoolMetrics": {
231 "Filesort": {
232 "Cnt": 1,
233 "Sum": 1
234 },
235 "Filesort_on_disk": {
236 "Cnt": 1,
237 "Sum": 0
238 },
239 "Full_join": {
240 "Cnt": 1,
241 "Sum": 0
242 },
243 "Full_scan": {
244 "Cnt": 1,
245 "Sum": 1
246 },
247 "QC_Hit": {
248 "Cnt": 1,
249 "Sum": 0
250 },
251 "Tmp_table": {
252 "Cnt": 1,
253 "Sum": 1
254 },
255 "Tmp_table_on_disk": {
256 "Cnt": 1,
257 "Sum": 0
258 }
259 }
260 },
261 "TotalQueries": 1,
262 "UniqueQueries": 1,
263 "Example": {
264 "QueryTime": 0.000001,
265 "Db": "db1",
266 "Query": "select * from t where id in (1,2,3)",
267 "Size": 35
268 },
269 "NumQueriesWithErrors": 0,
270 "ErrorsCode": null,
271 "ErrorsCount": null
272 }
273 },
274 "RateLimit": 0,
275 "Error": ""
276 }