Подобається 0
Створити форк 0

Остання активність 2 months ago

clickhouse.json Неформатований
1{
2 "annotations": {
3 "list": [
4 {
5 "builtIn": 1,
6 "datasource": {
7 "type": "grafana",
8 "uid": "-- Grafana --"
9 },
10 "enable": true,
11 "hide": true,
12 "iconColor": "rgba(0, 211, 255, 1)",
13 "name": "Annotations & Alerts",
14 "type": "dashboard"
15 }
16 ]
17 },
18 "editable": true,
19 "fiscalYearStartMonth": 0,
20 "graphTooltip": 0,
21 "id": 3,
22 "links": [],
23 "liveNow": true,
24 "panels": [
25 {
26 "datasource": {
27 "type": "grafana-clickhouse-datasource",
28 "uid": "fet9b6miuomwwf"
29 },
30 "fieldConfig": {
31 "defaults": {
32 "fieldMinMax": false,
33 "mappings": [],
34 "max": 41943040,
35 "min": 0,
36 "thresholds": {
37 "mode": "percentage",
38 "steps": [
39 {
40 "color": "green",
41 "value": null
42 },
43 {
44 "color": "orange",
45 "value": 70
46 },
47 {
48 "color": "red",
49 "value": 85
50 }
51 ]
52 },
53 "unit": "binBps"
54 },
55 "overrides": []
56 },
57 "gridPos": {
58 "h": 6,
59 "w": 3,
60 "x": 0,
61 "y": 0
62 },
63 "id": 29,
64 "options": {
65 "minVizHeight": 75,
66 "minVizWidth": 75,
67 "orientation": "auto",
68 "reduceOptions": {
69 "calcs": [
70 "lastNotNull"
71 ],
72 "fields": "",
73 "values": false
74 },
75 "showThresholdLabels": false,
76 "showThresholdMarkers": true,
77 "sizing": "auto"
78 },
79 "pluginVersion": "11.1.3",
80 "targets": [
81 {
82 "datasource": {
83 "type": "grafana-clickhouse-datasource",
84 "uid": "fet9b6miuomwwf"
85 },
86 "editorType": "sql",
87 "format": 1,
88 "meta": {
89 "builderOptions": {
90 "columns": [],
91 "database": "",
92 "limit": 1000,
93 "mode": "list",
94 "queryType": "table",
95 "table": ""
96 }
97 },
98 "pluginVersion": "4.10.1",
99 "queryType": "table",
100 "rawSql": "SELECT\n sum(bytes_sent) / (($__toTime) - ($__fromTime)) AS bytes_per_second\nFROM logs.caddy_requests\nWHERE ( ts >= $__fromTime AND ts <= $__toTime )\n AND host LIKE '%${Application}%'\n AND remote_ip LIKE '%${IP}%'\n",
101 "refId": "A"
102 }
103 ],
104 "title": "Average KB per second",
105 "type": "gauge"
106 },
107 {
108 "datasource": {
109 "type": "grafana-clickhouse-datasource",
110 "uid": "fet9b6miuomwwf"
111 },
112 "fieldConfig": {
113 "defaults": {
114 "mappings": [],
115 "max": 100,
116 "min": 0,
117 "thresholds": {
118 "mode": "percentage",
119 "steps": [
120 {
121 "color": "green",
122 "value": null
123 },
124 {
125 "color": "orange",
126 "value": 70
127 },
128 {
129 "color": "red",
130 "value": 85
131 }
132 ]
133 },
134 "unit": "reqps"
135 },
136 "overrides": []
137 },
138 "gridPos": {
139 "h": 6,
140 "w": 3,
141 "x": 3,
142 "y": 0
143 },
144 "id": 30,
145 "options": {
146 "minVizHeight": 75,
147 "minVizWidth": 75,
148 "orientation": "auto",
149 "reduceOptions": {
150 "calcs": [
151 "lastNotNull"
152 ],
153 "fields": "",
154 "values": false
155 },
156 "showThresholdLabels": false,
157 "showThresholdMarkers": true,
158 "sizing": "auto"
159 },
160 "pluginVersion": "11.1.3",
161 "targets": [
162 {
163 "datasource": {
164 "type": "grafana-clickhouse-datasource",
165 "uid": "fet9b6miuomwwf"
166 },
167 "editorType": "sql",
168 "format": 1,
169 "meta": {
170 "builderOptions": {
171 "columns": [],
172 "database": "",
173 "limit": 1000,
174 "mode": "list",
175 "queryType": "table",
176 "table": ""
177 }
178 },
179 "pluginVersion": "4.10.1",
180 "queryType": "table",
181 "rawSql": "SELECT\n count() / dateDiff('second', $__fromTime, $__toTime) AS avg_requests_per_second\nFROM logs.caddy_requests\nWHERE ( ts >= $__fromTime AND ts <= $__toTime )\n AND host LIKE '%${Application}%'\n AND remote_ip LIKE '%${IP}%'\n",
182 "refId": "A"
183 }
184 ],
185 "title": "Average Throughput",
186 "type": "gauge"
187 },
188 {
189 "datasource": {
190 "type": "grafana-clickhouse-datasource",
191 "uid": "fet9b6miuomwwf"
192 },
193 "fieldConfig": {
194 "defaults": {
195 "color": {
196 "mode": "palette-classic"
197 },
198 "custom": {
199 "hideFrom": {
200 "legend": false,
201 "tooltip": false,
202 "viz": false
203 }
204 },
205 "mappings": []
206 },
207 "overrides": []
208 },
209 "gridPos": {
210 "h": 6,
211 "w": 3,
212 "x": 6,
213 "y": 0
214 },
215 "id": 26,
216 "options": {
217 "displayLabels": [
218 "name"
219 ],
220 "legend": {
221 "displayMode": "list",
222 "placement": "bottom",
223 "showLegend": false
224 },
225 "pieType": "donut",
226 "reduceOptions": {
227 "calcs": [
228 "lastNotNull"
229 ],
230 "fields": "/^request_count$/",
231 "values": true
232 },
233 "tooltip": {
234 "mode": "single",
235 "sort": "none"
236 }
237 },
238 "pluginVersion": "11.1.3",
239 "targets": [
240 {
241 "datasource": {
242 "type": "grafana-clickhouse-datasource",
243 "uid": "fet9b6miuomwwf"
244 },
245 "editorType": "sql",
246 "format": 1,
247 "meta": {
248 "builderOptions": {
249 "columns": [],
250 "database": "",
251 "limit": 1000,
252 "mode": "list",
253 "queryType": "table",
254 "table": ""
255 }
256 },
257 "pluginVersion": "4.10.1",
258 "queryType": "table",
259 "rawSql": "SELECT\n toString(status) AS status,\n count() AS request_count\nFROM logs.caddy_requests\nWHERE ( ts >= $__fromTime AND ts <= $__toTime )\n AND host LIKE '%${Application}%'\n AND remote_ip LIKE '%${IP}%'\nGROUP BY status\nORDER BY request_count DESC\n",
260 "refId": "A"
261 }
262 ],
263 "title": "Status Code Distribution",
264 "type": "piechart"
265 },
266 {
267 "datasource": {
268 "type": "grafana-clickhouse-datasource",
269 "uid": "fet9b6miuomwwf"
270 },
271 "fieldConfig": {
272 "defaults": {
273 "color": {
274 "mode": "continuous-GrYlRd"
275 },
276 "custom": {
277 "axisBorderShow": false,
278 "axisCenteredZero": false,
279 "axisColorMode": "text",
280 "axisLabel": "",
281 "axisPlacement": "auto",
282 "barAlignment": 0,
283 "drawStyle": "line",
284 "fillOpacity": 0,
285 "gradientMode": "scheme",
286 "hideFrom": {
287 "legend": false,
288 "tooltip": false,
289 "viz": false
290 },
291 "insertNulls": false,
292 "lineInterpolation": "linear",
293 "lineStyle": {
294 "fill": "solid"
295 },
296 "lineWidth": 1,
297 "pointSize": 5,
298 "scaleDistribution": {
299 "type": "linear"
300 },
301 "showPoints": "auto",
302 "spanNulls": false,
303 "stacking": {
304 "group": "A",
305 "mode": "none"
306 },
307 "thresholdsStyle": {
308 "mode": "off"
309 }
310 },
311 "displayName": "Count",
312 "mappings": [],
313 "thresholds": {
314 "mode": "absolute",
315 "steps": [
316 {
317 "color": "green",
318 "value": null
319 },
320 {
321 "color": "red",
322 "value": 1000
323 }
324 ]
325 }
326 },
327 "overrides": []
328 },
329 "gridPos": {
330 "h": 6,
331 "w": 5,
332 "x": 9,
333 "y": 0
334 },
335 "id": 27,
336 "options": {
337 "legend": {
338 "calcs": [],
339 "displayMode": "table",
340 "placement": "bottom",
341 "showLegend": false
342 },
343 "tooltip": {
344 "mode": "single",
345 "sort": "none"
346 }
347 },
348 "targets": [
349 {
350 "datasource": {
351 "type": "grafana-clickhouse-datasource",
352 "uid": "fet9b6miuomwwf"
353 },
354 "editorType": "sql",
355 "format": 1,
356 "meta": {
357 "builderOptions": {
358 "columns": [],
359 "database": "",
360 "limit": 1000,
361 "mode": "list",
362 "queryType": "table",
363 "table": ""
364 }
365 },
366 "pluginVersion": "4.10.1",
367 "queryType": "table",
368 "rawSql": "SELECT $__timeInterval(ts) as \"time\", count(ts) FROM \"logs\".\"caddy_requests\"\nWHERE ( ts >= $__fromTime AND ts <= $__toTime )\n AND host LIKE '%${Application}%'\n AND remote_ip like '%${IP}%'\n GROUP BY time",
369 "refId": "A"
370 }
371 ],
372 "title": "Requests Count",
373 "type": "timeseries"
374 },
375 {
376 "datasource": {
377 "type": "grafana-clickhouse-datasource",
378 "uid": "fet9b6miuomwwf"
379 },
380 "fieldConfig": {
381 "defaults": {
382 "color": {
383 "mode": "palette-classic"
384 },
385 "mappings": [],
386 "thresholds": {
387 "mode": "absolute",
388 "steps": [
389 {
390 "color": "green",
391 "value": null
392 },
393 {
394 "color": "red",
395 "value": 80
396 }
397 ]
398 },
399 "unit": "short"
400 },
401 "overrides": []
402 },
403 "gridPos": {
404 "h": 6,
405 "w": 3,
406 "x": 14,
407 "y": 0
408 },
409 "id": 21,
410 "options": {
411 "displayMode": "gradient",
412 "maxVizHeight": 300,
413 "minVizHeight": 16,
414 "minVizWidth": 8,
415 "namePlacement": "auto",
416 "orientation": "horizontal",
417 "reduceOptions": {
418 "calcs": [],
419 "fields": "",
420 "values": true
421 },
422 "showUnfilled": false,
423 "sizing": "auto",
424 "valueMode": "color"
425 },
426 "pluginVersion": "11.1.3",
427 "targets": [
428 {
429 "datasource": {
430 "type": "grafana-clickhouse-datasource",
431 "uid": "fet9b6miuomwwf"
432 },
433 "editorType": "sql",
434 "format": 1,
435 "meta": {
436 "builderOptions": {
437 "columns": [],
438 "database": "",
439 "limit": 1000,
440 "mode": "list",
441 "queryType": "table",
442 "table": ""
443 }
444 },
445 "pluginVersion": "4.10.1",
446 "queryType": "table",
447 "rawSql": "SELECT\n method AS method,\n count() AS request_count\nFROM logs.caddy_requests\nWHERE ( ts >= $__fromTime AND ts <= $__toTime )\n AND host LIKE '%${Application}%'\n AND remote_ip LIKE '%${IP}%'\nGROUP BY method\nORDER BY request_count DESC\n",
448 "refId": "A"
449 }
450 ],
451 "title": "Method Distribution",
452 "type": "bargauge"
453 },
454 {
455 "datasource": {
456 "type": "grafana-clickhouse-datasource",
457 "uid": "fet9b6miuomwwf"
458 },
459 "fieldConfig": {
460 "defaults": {
461 "color": {
462 "mode": "thresholds"
463 },
464 "mappings": [],
465 "max": 700,
466 "min": 0,
467 "thresholds": {
468 "mode": "absolute",
469 "steps": [
470 {
471 "color": "green",
472 "value": null
473 },
474 {
475 "color": "red",
476 "value": 240
477 }
478 ]
479 },
480 "unit": "ms"
481 },
482 "overrides": []
483 },
484 "gridPos": {
485 "h": 2,
486 "w": 3,
487 "x": 17,
488 "y": 0
489 },
490 "id": 31,
491 "options": {
492 "displayMode": "lcd",
493 "maxVizHeight": 300,
494 "minVizHeight": 16,
495 "minVizWidth": 8,
496 "namePlacement": "auto",
497 "orientation": "horizontal",
498 "reduceOptions": {
499 "calcs": [
500 "lastNotNull"
501 ],
502 "fields": "",
503 "values": false
504 },
505 "showUnfilled": true,
506 "sizing": "auto",
507 "valueMode": "color"
508 },
509 "pluginVersion": "11.1.3",
510 "targets": [
511 {
512 "datasource": {
513 "type": "grafana-clickhouse-datasource",
514 "uid": "fet9b6miuomwwf"
515 },
516 "editorType": "sql",
517 "format": 1,
518 "meta": {
519 "builderOptions": {
520 "columns": [],
521 "database": "",
522 "limit": 1000,
523 "mode": "list",
524 "queryType": "table",
525 "table": ""
526 }
527 },
528 "pluginVersion": "4.10.1",
529 "queryType": "table",
530 "rawSql": "SELECT\n quantile(0.95)(duration_ms) AS current_p95_response_time_ms\nFROM logs.caddy_requests\nWHERE ts BETWEEN $__fromTime AND $__toTime\n AND status != '101'\n AND host LIKE '%${Application}%'\n AND remote_ip LIKE '%${IP}%'\n",
531 "refId": "A"
532 }
533 ],
534 "title": "P95 Latancy",
535 "type": "bargauge"
536 },
537 {
538 "datasource": {
539 "type": "grafana-clickhouse-datasource",
540 "uid": "fet9b6miuomwwf"
541 },
542 "fieldConfig": {
543 "defaults": {
544 "color": {
545 "mode": "continuous-GrYlRd"
546 },
547 "custom": {
548 "axisBorderShow": false,
549 "axisCenteredZero": false,
550 "axisColorMode": "text",
551 "axisLabel": "",
552 "axisPlacement": "auto",
553 "barAlignment": 0,
554 "drawStyle": "line",
555 "fillOpacity": 0,
556 "gradientMode": "scheme",
557 "hideFrom": {
558 "legend": false,
559 "tooltip": false,
560 "viz": false
561 },
562 "insertNulls": false,
563 "lineInterpolation": "linear",
564 "lineWidth": 1,
565 "pointSize": 5,
566 "scaleDistribution": {
567 "type": "linear"
568 },
569 "showPoints": "auto",
570 "spanNulls": false,
571 "stacking": {
572 "group": "A",
573 "mode": "none"
574 },
575 "thresholdsStyle": {
576 "mode": "off"
577 }
578 },
579 "mappings": [],
580 "thresholds": {
581 "mode": "percentage",
582 "steps": [
583 {
584 "color": "green",
585 "value": null
586 },
587 {
588 "color": "orange",
589 "value": 70
590 },
591 {
592 "color": "red",
593 "value": 85
594 }
595 ]
596 },
597 "unit": "ms"
598 },
599 "overrides": []
600 },
601 "gridPos": {
602 "h": 6,
603 "w": 4,
604 "x": 20,
605 "y": 0
606 },
607 "id": 3,
608 "options": {
609 "legend": {
610 "calcs": [],
611 "displayMode": "list",
612 "placement": "bottom",
613 "showLegend": false
614 },
615 "tooltip": {
616 "mode": "single",
617 "sort": "none"
618 }
619 },
620 "pluginVersion": "11.1.3",
621 "targets": [
622 {
623 "datasource": {
624 "type": "grafana-clickhouse-datasource",
625 "uid": "fet9b6miuomwwf"
626 },
627 "editorType": "sql",
628 "format": 1,
629 "meta": {
630 "builderOptions": {
631 "columns": [],
632 "database": "",
633 "limit": 1000,
634 "mode": "list",
635 "queryType": "table",
636 "table": ""
637 }
638 },
639 "pluginVersion": "4.10.1",
640 "queryType": "table",
641 "rawSql": "SELECT\n $__timeInterval(ts) AS \"time\",\n quantile(0.95)(duration_ms) AS p95_response_time_ms\nFROM \"logs\".\"caddy_requests\"\nWHERE ( ts >= $__fromTime AND ts <= $__toTime )\n AND status != '101'\n AND host LIKE '%${Application}%'\n AND remote_ip LIKE '%${IP}%'\nGROUP BY time\nORDER BY time",
642 "refId": "A"
643 }
644 ],
645 "title": "Requests Latancy P95",
646 "type": "timeseries"
647 },
648 {
649 "datasource": {
650 "type": "grafana-clickhouse-datasource",
651 "uid": "fet9b6miuomwwf"
652 },
653 "fieldConfig": {
654 "defaults": {
655 "color": {
656 "mode": "thresholds"
657 },
658 "mappings": [],
659 "max": 16,
660 "min": 0,
661 "thresholds": {
662 "mode": "absolute",
663 "steps": [
664 {
665 "color": "green",
666 "value": null
667 },
668 {
669 "color": "red",
670 "value": 5
671 }
672 ]
673 },
674 "unit": "ms"
675 },
676 "overrides": []
677 },
678 "gridPos": {
679 "h": 2,
680 "w": 3,
681 "x": 17,
682 "y": 2
683 },
684 "id": 33,
685 "options": {
686 "displayMode": "lcd",
687 "maxVizHeight": 300,
688 "minVizHeight": 16,
689 "minVizWidth": 8,
690 "namePlacement": "auto",
691 "orientation": "horizontal",
692 "reduceOptions": {
693 "calcs": [
694 "lastNotNull"
695 ],
696 "fields": "",
697 "values": false
698 },
699 "showUnfilled": true,
700 "sizing": "auto",
701 "valueMode": "color"
702 },
703 "pluginVersion": "11.1.3",
704 "targets": [
705 {
706 "datasource": {
707 "type": "grafana-clickhouse-datasource",
708 "uid": "fet9b6miuomwwf"
709 },
710 "editorType": "sql",
711 "format": 1,
712 "meta": {
713 "builderOptions": {
714 "columns": [],
715 "database": "",
716 "limit": 1000,
717 "mode": "list",
718 "queryType": "table",
719 "table": ""
720 }
721 },
722 "pluginVersion": "4.10.1",
723 "queryType": "table",
724 "rawSql": "SELECT\n quantile(0.5)(duration_ms) AS current_median_response_time_ms\nFROM logs.caddy_requests\nWHERE ts BETWEEN $__fromTime AND $__toTime\n AND status != '101'\n AND host LIKE '%${Application}%'\n AND remote_ip LIKE '%${IP}%'\n",
725 "refId": "A"
726 }
727 ],
728 "title": "Middle Latancy",
729 "type": "bargauge"
730 },
731 {
732 "datasource": {
733 "type": "grafana-clickhouse-datasource",
734 "uid": "fet9b6miuomwwf"
735 },
736 "fieldConfig": {
737 "defaults": {
738 "color": {
739 "mode": "thresholds"
740 },
741 "mappings": [],
742 "max": 100,
743 "min": 0,
744 "thresholds": {
745 "mode": "absolute",
746 "steps": [
747 {
748 "color": "green",
749 "value": null
750 },
751 {
752 "color": "red",
753 "value": 30
754 }
755 ]
756 },
757 "unit": "ms"
758 },
759 "overrides": []
760 },
761 "gridPos": {
762 "h": 2,
763 "w": 3,
764 "x": 17,
765 "y": 4
766 },
767 "id": 34,
768 "options": {
769 "displayMode": "lcd",
770 "maxVizHeight": 300,
771 "minVizHeight": 16,
772 "minVizWidth": 8,
773 "namePlacement": "auto",
774 "orientation": "horizontal",
775 "reduceOptions": {
776 "calcs": [
777 "lastNotNull"
778 ],
779 "fields": "",
780 "values": false
781 },
782 "showUnfilled": true,
783 "sizing": "auto",
784 "valueMode": "color"
785 },
786 "pluginVersion": "11.1.3",
787 "targets": [
788 {
789 "datasource": {
790 "type": "grafana-clickhouse-datasource",
791 "uid": "fet9b6miuomwwf"
792 },
793 "editorType": "sql",
794 "format": 1,
795 "meta": {
796 "builderOptions": {
797 "columns": [],
798 "database": "",
799 "limit": 1000,
800 "mode": "list",
801 "queryType": "table",
802 "table": ""
803 }
804 },
805 "pluginVersion": "4.10.1",
806 "queryType": "table",
807 "rawSql": "SELECT\n quantile(0.80)(duration_ms) AS current_p95_response_time_ms\nFROM logs.caddy_requests\nWHERE ts BETWEEN $__fromTime AND $__toTime\n AND status != '101'\n AND host LIKE '%${Application}%'\n AND remote_ip LIKE '%${IP}%'\n",
808 "refId": "A"
809 }
810 ],
811 "title": "P80 Latancy",
812 "type": "bargauge"
813 },
814 {
815 "datasource": {
816 "type": "grafana-clickhouse-datasource",
817 "uid": "fet9b6miuomwwf"
818 },
819 "fieldConfig": {
820 "defaults": {
821 "color": {
822 "mode": "continuous-GrYlRd"
823 },
824 "mappings": [],
825 "thresholds": {
826 "mode": "absolute",
827 "steps": [
828 {
829 "color": "green",
830 "value": null
831 },
832 {
833 "color": "red",
834 "value": 80
835 }
836 ]
837 },
838 "unit": "short"
839 },
840 "overrides": []
841 },
842 "gridPos": {
843 "h": 14,
844 "w": 5,
845 "x": 0,
846 "y": 6
847 },
848 "id": 5,
849 "options": {
850 "displayMode": "lcd",
851 "maxVizHeight": 300,
852 "minVizHeight": 16,
853 "minVizWidth": 8,
854 "namePlacement": "auto",
855 "orientation": "horizontal",
856 "reduceOptions": {
857 "calcs": [],
858 "fields": "/^requests$/",
859 "limit": 20,
860 "values": true
861 },
862 "showUnfilled": true,
863 "sizing": "auto",
864 "valueMode": "color"
865 },
866 "pluginVersion": "11.1.3",
867 "targets": [
868 {
869 "datasource": {
870 "type": "grafana-clickhouse-datasource",
871 "uid": "fet9b6miuomwwf"
872 },
873 "editorType": "sql",
874 "format": 1,
875 "meta": {
876 "builderOptions": {
877 "columns": [],
878 "database": "",
879 "limit": 1000,
880 "mode": "list",
881 "queryType": "table",
882 "table": ""
883 }
884 },
885 "pluginVersion": "4.10.1",
886 "queryType": "table",
887 "rawSql": "SELECT\n host as Application,\n count() AS requests\nFROM logs.caddy_requests\nWHERE ( ts >= $__fromTime AND ts <= $__toTime )\n AND host LIKE '%${Application}%'\n AND remote_ip like '%${IP}%'\nGROUP BY Application\nORDER BY requests DESC\n\n",
888 "refId": "A"
889 }
890 ],
891 "title": "Requests By Count",
892 "type": "bargauge"
893 },
894 {
895 "datasource": {
896 "type": "grafana-clickhouse-datasource",
897 "uid": "fet9b6miuomwwf"
898 },
899 "fieldConfig": {
900 "defaults": {
901 "color": {
902 "mode": "continuous-GrYlRd"
903 },
904 "mappings": [],
905 "thresholds": {
906 "mode": "absolute",
907 "steps": [
908 {
909 "color": "green",
910 "value": null
911 },
912 {
913 "color": "red",
914 "value": 80
915 }
916 ]
917 },
918 "unit": "short"
919 },
920 "overrides": []
921 },
922 "gridPos": {
923 "h": 8,
924 "w": 5,
925 "x": 5,
926 "y": 6
927 },
928 "id": 6,
929 "options": {
930 "displayMode": "lcd",
931 "maxVizHeight": 300,
932 "minVizHeight": 16,
933 "minVizWidth": 8,
934 "namePlacement": "auto",
935 "orientation": "horizontal",
936 "reduceOptions": {
937 "calcs": [],
938 "fields": "",
939 "limit": 10,
940 "values": true
941 },
942 "showUnfilled": true,
943 "sizing": "auto",
944 "valueMode": "color"
945 },
946 "pluginVersion": "11.1.3",
947 "targets": [
948 {
949 "datasource": {
950 "type": "grafana-clickhouse-datasource",
951 "uid": "fet9b6miuomwwf"
952 },
953 "editorType": "sql",
954 "format": 1,
955 "meta": {
956 "builderOptions": {
957 "columns": [],
958 "database": "",
959 "limit": 1000,
960 "mode": "list",
961 "queryType": "table",
962 "table": ""
963 }
964 },
965 "pluginVersion": "4.10.1",
966 "queryType": "table",
967 "rawSql": "SELECT\n host AS Application,\n uniqExact(remote_ip) AS unique_ip_count\nFROM logs.caddy_requests\nWHERE ( ts >= $__fromTime AND ts <= $__toTime )\n AND host LIKE '%${Application}%'\n AND remote_ip LIKE '%${IP}%'\nGROUP BY Application\nORDER BY unique_ip_count DESC\n\n",
968 "refId": "A"
969 }
970 ],
971 "title": "Requests By Unique IP Count (IPs)",
972 "type": "bargauge"
973 },
974 {
975 "datasource": {
976 "type": "grafana-clickhouse-datasource",
977 "uid": "fet9b6miuomwwf"
978 },
979 "fieldConfig": {
980 "defaults": {
981 "color": {
982 "mode": "continuous-GrYlRd"
983 },
984 "mappings": [],
985 "thresholds": {
986 "mode": "absolute",
987 "steps": [
988 {
989 "color": "green",
990 "value": null
991 },
992 {
993 "color": "red",
994 "value": 80
995 }
996 ]
997 },
998 "unit": "s"
999 },
1000 "overrides": []
1001 },
1002 "gridPos": {
1003 "h": 8,
1004 "w": 5,
1005 "x": 10,
1006 "y": 6
1007 },
1008 "id": 7,
1009 "options": {
1010 "displayMode": "lcd",
1011 "maxVizHeight": 300,
1012 "minVizHeight": 16,
1013 "minVizWidth": 8,
1014 "namePlacement": "auto",
1015 "orientation": "horizontal",
1016 "reduceOptions": {
1017 "calcs": [],
1018 "fields": "",
1019 "limit": 10,
1020 "values": true
1021 },
1022 "showUnfilled": true,
1023 "sizing": "auto",
1024 "valueMode": "color"
1025 },
1026 "pluginVersion": "11.1.3",
1027 "targets": [
1028 {
1029 "datasource": {
1030 "type": "grafana-clickhouse-datasource",
1031 "uid": "fet9b6miuomwwf"
1032 },
1033 "editorType": "sql",
1034 "format": 1,
1035 "meta": {
1036 "builderOptions": {
1037 "columns": [],
1038 "database": "",
1039 "limit": 1000,
1040 "mode": "list",
1041 "queryType": "table",
1042 "table": ""
1043 }
1044 },
1045 "pluginVersion": "4.10.1",
1046 "queryType": "table",
1047 "rawSql": "SELECT\n host AS Application,\n sum(duration_ms)/1000 AS total_duration_seconds\nFROM logs.caddy_requests\nWHERE ( ts >= $__fromTime AND ts <= $__toTime )\n AND status != '101'\n AND host LIKE '%${Application}%'\n AND remote_ip LIKE '%${IP}%'\nGROUP BY Application\nORDER BY total_duration_seconds DESC",
1048 "refId": "A"
1049 }
1050 ],
1051 "title": "Total Time costs (Seconds)",
1052 "type": "bargauge"
1053 },
1054 {
1055 "datasource": {
1056 "type": "grafana-clickhouse-datasource",
1057 "uid": "fet9b6miuomwwf"
1058 },
1059 "fieldConfig": {
1060 "defaults": {
1061 "color": {
1062 "mode": "continuous-GrYlRd"
1063 },
1064 "mappings": [],
1065 "thresholds": {
1066 "mode": "absolute",
1067 "steps": [
1068 {
1069 "color": "green",
1070 "value": null
1071 },
1072 {
1073 "color": "red",
1074 "value": 80
1075 }
1076 ]
1077 },
1078 "unit": "bytes"
1079 },
1080 "overrides": []
1081 },
1082 "gridPos": {
1083 "h": 8,
1084 "w": 5,
1085 "x": 15,
1086 "y": 6
1087 },
1088 "id": 28,
1089 "options": {
1090 "displayMode": "lcd",
1091 "maxVizHeight": 300,
1092 "minVizHeight": 16,
1093 "minVizWidth": 8,
1094 "namePlacement": "auto",
1095 "orientation": "horizontal",
1096 "reduceOptions": {
1097 "calcs": [],
1098 "fields": "",
1099 "limit": 10,
1100 "values": true
1101 },
1102 "showUnfilled": true,
1103 "sizing": "auto",
1104 "valueMode": "color"
1105 },
1106 "pluginVersion": "11.1.3",
1107 "targets": [
1108 {
1109 "datasource": {
1110 "type": "grafana-clickhouse-datasource",
1111 "uid": "fet9b6miuomwwf"
1112 },
1113 "editorType": "sql",
1114 "format": 1,
1115 "meta": {
1116 "builderOptions": {
1117 "columns": [],
1118 "database": "",
1119 "limit": 1000,
1120 "mode": "list",
1121 "queryType": "table",
1122 "table": ""
1123 }
1124 },
1125 "pluginVersion": "4.10.1",
1126 "queryType": "table",
1127 "rawSql": "SELECT\n host AS Application,\n sum(bytes_sent) AS total_duration_seconds\nFROM logs.caddy_requests\nWHERE ( ts >= $__fromTime AND ts <= $__toTime )\n AND status != '101'\n AND host LIKE '%${Application}%'\n AND remote_ip LIKE '%${IP}%'\nGROUP BY Application\nORDER BY total_duration_seconds DESC",
1128 "refId": "A"
1129 }
1130 ],
1131 "title": "Total Bytes Sent (MB)",
1132 "type": "bargauge"
1133 },
1134 {
1135 "datasource": {
1136 "type": "grafana-clickhouse-datasource",
1137 "uid": "fet9b6miuomwwf"
1138 },
1139 "fieldConfig": {
1140 "defaults": {
1141 "color": {
1142 "mode": "continuous-GrYlRd"
1143 },
1144 "mappings": [],
1145 "thresholds": {
1146 "mode": "absolute",
1147 "steps": [
1148 {
1149 "color": "green",
1150 "value": null
1151 },
1152 {
1153 "color": "red",
1154 "value": 80
1155 }
1156 ]
1157 },
1158 "unit": "percent"
1159 },
1160 "overrides": []
1161 },
1162 "gridPos": {
1163 "h": 8,
1164 "w": 4,
1165 "x": 20,
1166 "y": 6
1167 },
1168 "id": 9,
1169 "options": {
1170 "displayMode": "lcd",
1171 "maxVizHeight": 300,
1172 "minVizHeight": 16,
1173 "minVizWidth": 8,
1174 "namePlacement": "auto",
1175 "orientation": "horizontal",
1176 "reduceOptions": {
1177 "calcs": [],
1178 "fields": "",
1179 "limit": 10,
1180 "values": true
1181 },
1182 "showUnfilled": true,
1183 "sizing": "auto",
1184 "valueMode": "color"
1185 },
1186 "pluginVersion": "11.1.3",
1187 "targets": [
1188 {
1189 "datasource": {
1190 "type": "grafana-clickhouse-datasource",
1191 "uid": "fet9b6miuomwwf"
1192 },
1193 "editorType": "sql",
1194 "format": 1,
1195 "meta": {
1196 "builderOptions": {
1197 "columns": [],
1198 "database": "",
1199 "limit": 1000,
1200 "mode": "list",
1201 "queryType": "table",
1202 "table": ""
1203 }
1204 },
1205 "pluginVersion": "4.10.1",
1206 "queryType": "table",
1207 "rawSql": "SELECT\n host AS Application,\n round(countIf(status >= 500) / count() * 100, 2) AS failure_rate_percent\nFROM logs.caddy_requests\nWHERE ( ts >= $__fromTime AND ts <= $__toTime )\n AND host LIKE '%${Application}%'\n AND remote_ip LIKE '%${IP}%'\nGROUP BY Application\nORDER BY failure_rate_percent DESC\n",
1208 "refId": "A"
1209 }
1210 ],
1211 "title": "500 Failure Rate%",
1212 "type": "bargauge"
1213 },
1214 {
1215 "datasource": {
1216 "type": "grafana-clickhouse-datasource",
1217 "uid": "fet9b6miuomwwf"
1218 },
1219 "fieldConfig": {
1220 "defaults": {
1221 "color": {
1222 "mode": "continuous-GrYlRd"
1223 },
1224 "custom": {
1225 "axisBorderShow": false,
1226 "axisCenteredZero": false,
1227 "axisColorMode": "text",
1228 "axisLabel": "",
1229 "axisPlacement": "auto",
1230 "barAlignment": 0,
1231 "drawStyle": "line",
1232 "fillOpacity": 0,
1233 "gradientMode": "scheme",
1234 "hideFrom": {
1235 "legend": false,
1236 "tooltip": false,
1237 "viz": false
1238 },
1239 "insertNulls": false,
1240 "lineInterpolation": "linear",
1241 "lineWidth": 1,
1242 "pointSize": 5,
1243 "scaleDistribution": {
1244 "type": "linear"
1245 },
1246 "showPoints": "auto",
1247 "spanNulls": false,
1248 "stacking": {
1249 "group": "A",
1250 "mode": "none"
1251 },
1252 "thresholdsStyle": {
1253 "mode": "off"
1254 }
1255 },
1256 "mappings": [],
1257 "thresholds": {
1258 "mode": "absolute",
1259 "steps": [
1260 {
1261 "color": "green",
1262 "value": null
1263 },
1264 {
1265 "color": "red",
1266 "value": 80
1267 }
1268 ]
1269 },
1270 "unit": "short"
1271 },
1272 "overrides": []
1273 },
1274 "gridPos": {
1275 "h": 6,
1276 "w": 5,
1277 "x": 5,
1278 "y": 14
1279 },
1280 "id": 10,
1281 "options": {
1282 "legend": {
1283 "calcs": [],
1284 "displayMode": "table",
1285 "placement": "bottom",
1286 "showLegend": false
1287 },
1288 "tooltip": {
1289 "mode": "single",
1290 "sort": "none"
1291 }
1292 },
1293 "targets": [
1294 {
1295 "datasource": {
1296 "type": "grafana-clickhouse-datasource",
1297 "uid": "fet9b6miuomwwf"
1298 },
1299 "editorType": "sql",
1300 "format": 1,
1301 "meta": {
1302 "builderOptions": {
1303 "columns": [],
1304 "database": "",
1305 "limit": 1000,
1306 "mode": "list",
1307 "queryType": "table",
1308 "table": ""
1309 }
1310 },
1311 "pluginVersion": "4.10.1",
1312 "queryType": "table",
1313 "rawSql": "SELECT\n $__timeInterval(ts) AS \"time\",\n uniqExact(remote_ip) AS unique_ip_count\nFROM \"logs\".\"caddy_requests\"\nWHERE ( ts >= $__fromTime AND ts <= $__toTime )\n AND host LIKE '%${Application}%'\n AND remote_ip LIKE '%${IP}%'\nGROUP BY time\nORDER BY time;",
1314 "refId": "A"
1315 }
1316 ],
1317 "title": "Incoming Unique IPs Count",
1318 "type": "timeseries"
1319 },
1320 {
1321 "datasource": {
1322 "type": "grafana-clickhouse-datasource",
1323 "uid": "fet9b6miuomwwf"
1324 },
1325 "fieldConfig": {
1326 "defaults": {
1327 "color": {
1328 "mode": "continuous-GrYlRd"
1329 },
1330 "custom": {
1331 "axisBorderShow": false,
1332 "axisCenteredZero": false,
1333 "axisColorMode": "text",
1334 "axisLabel": "",
1335 "axisPlacement": "auto",
1336 "barAlignment": 0,
1337 "drawStyle": "points",
1338 "fillOpacity": 0,
1339 "gradientMode": "scheme",
1340 "hideFrom": {
1341 "legend": false,
1342 "tooltip": false,
1343 "viz": false
1344 },
1345 "insertNulls": false,
1346 "lineInterpolation": "linear",
1347 "lineWidth": 1,
1348 "pointSize": 3,
1349 "scaleDistribution": {
1350 "type": "linear"
1351 },
1352 "showPoints": "auto",
1353 "spanNulls": false,
1354 "stacking": {
1355 "group": "A",
1356 "mode": "none"
1357 },
1358 "thresholdsStyle": {
1359 "mode": "off"
1360 }
1361 },
1362 "mappings": [],
1363 "thresholds": {
1364 "mode": "absolute",
1365 "steps": [
1366 {
1367 "color": "green",
1368 "value": null
1369 },
1370 {
1371 "color": "red",
1372 "value": 80
1373 }
1374 ]
1375 },
1376 "unit": "ms"
1377 },
1378 "overrides": []
1379 },
1380 "gridPos": {
1381 "h": 6,
1382 "w": 5,
1383 "x": 10,
1384 "y": 14
1385 },
1386 "id": 11,
1387 "options": {
1388 "legend": {
1389 "calcs": [],
1390 "displayMode": "table",
1391 "placement": "bottom",
1392 "showLegend": false
1393 },
1394 "tooltip": {
1395 "mode": "single",
1396 "sort": "none"
1397 }
1398 },
1399 "targets": [
1400 {
1401 "datasource": {
1402 "type": "grafana-clickhouse-datasource",
1403 "uid": "fet9b6miuomwwf"
1404 },
1405 "editorType": "sql",
1406 "format": 1,
1407 "meta": {
1408 "builderOptions": {
1409 "columns": [],
1410 "database": "",
1411 "limit": 1000,
1412 "mode": "list",
1413 "queryType": "table",
1414 "table": ""
1415 }
1416 },
1417 "pluginVersion": "4.10.1",
1418 "queryType": "table",
1419 "rawSql": "SELECT\n $__timeInterval(ts) AS \"time\",\n sum(duration_ms) AS total_duration_ms\nFROM \"logs\".\"caddy_requests\"\nWHERE ( ts >= $__fromTime AND ts <= $__toTime )\n AND host LIKE '%${Application}%'\n AND remote_ip LIKE '%${IP}%'\nGROUP BY time\nORDER BY time;",
1420 "refId": "A"
1421 }
1422 ],
1423 "title": "Processing Requests Total Time Costs",
1424 "type": "timeseries"
1425 },
1426 {
1427 "datasource": {
1428 "type": "grafana-clickhouse-datasource",
1429 "uid": "fet9b6miuomwwf"
1430 },
1431 "fieldConfig": {
1432 "defaults": {
1433 "color": {
1434 "mode": "continuous-GrYlRd"
1435 },
1436 "custom": {
1437 "axisBorderShow": false,
1438 "axisCenteredZero": false,
1439 "axisColorMode": "text",
1440 "axisLabel": "",
1441 "axisPlacement": "auto",
1442 "barAlignment": 0,
1443 "drawStyle": "line",
1444 "fillOpacity": 0,
1445 "gradientMode": "scheme",
1446 "hideFrom": {
1447 "legend": false,
1448 "tooltip": false,
1449 "viz": false
1450 },
1451 "insertNulls": false,
1452 "lineInterpolation": "smooth",
1453 "lineStyle": {
1454 "fill": "solid"
1455 },
1456 "lineWidth": 1,
1457 "pointSize": 4,
1458 "scaleDistribution": {
1459 "type": "linear"
1460 },
1461 "showPoints": "auto",
1462 "spanNulls": false,
1463 "stacking": {
1464 "group": "A",
1465 "mode": "none"
1466 },
1467 "thresholdsStyle": {
1468 "mode": "off"
1469 }
1470 },
1471 "mappings": [],
1472 "min": 0,
1473 "thresholds": {
1474 "mode": "absolute",
1475 "steps": [
1476 {
1477 "color": "green",
1478 "value": null
1479 }
1480 ]
1481 },
1482 "unit": "binBps"
1483 },
1484 "overrides": []
1485 },
1486 "gridPos": {
1487 "h": 6,
1488 "w": 5,
1489 "x": 15,
1490 "y": 14
1491 },
1492 "id": 12,
1493 "options": {
1494 "legend": {
1495 "calcs": [],
1496 "displayMode": "table",
1497 "placement": "bottom",
1498 "showLegend": false
1499 },
1500 "tooltip": {
1501 "mode": "single",
1502 "sort": "none"
1503 }
1504 },
1505 "targets": [
1506 {
1507 "datasource": {
1508 "type": "grafana-clickhouse-datasource",
1509 "uid": "fet9b6miuomwwf"
1510 },
1511 "editorType": "sql",
1512 "format": 1,
1513 "meta": {
1514 "builderOptions": {
1515 "columns": [],
1516 "database": "",
1517 "limit": 1000,
1518 "mode": "list",
1519 "queryType": "table",
1520 "table": ""
1521 }
1522 },
1523 "pluginVersion": "4.10.1",
1524 "queryType": "table",
1525 "rawSql": "SELECT\n $__timeInterval(ts) AS time,\n sum(bytes_sent) / $__interval_s AS bytes_per_second\nFROM logs.caddy_requests\nWHERE\n $__timeFilter(ts)\n AND host LIKE '%${Application}%'\n AND remote_ip LIKE '%${IP}%'\nGROUP BY\n time\nORDER BY\n time ASC",
1526 "refId": "A"
1527 }
1528 ],
1529 "title": "Upload Bandwidth",
1530 "type": "timeseries"
1531 },
1532 {
1533 "datasource": {
1534 "type": "grafana-clickhouse-datasource",
1535 "uid": "fet9b6miuomwwf"
1536 },
1537 "fieldConfig": {
1538 "defaults": {
1539 "color": {
1540 "fixedColor": "dark-red",
1541 "mode": "fixed"
1542 },
1543 "custom": {
1544 "axisBorderShow": false,
1545 "axisCenteredZero": false,
1546 "axisColorMode": "series",
1547 "axisLabel": "",
1548 "axisPlacement": "auto",
1549 "barAlignment": 0,
1550 "drawStyle": "points",
1551 "fillOpacity": 0,
1552 "gradientMode": "none",
1553 "hideFrom": {
1554 "legend": false,
1555 "tooltip": false,
1556 "viz": false
1557 },
1558 "insertNulls": false,
1559 "lineInterpolation": "linear",
1560 "lineWidth": 1,
1561 "pointSize": 2,
1562 "scaleDistribution": {
1563 "type": "linear"
1564 },
1565 "showPoints": "auto",
1566 "spanNulls": false,
1567 "stacking": {
1568 "group": "A",
1569 "mode": "none"
1570 },
1571 "thresholdsStyle": {
1572 "mode": "off"
1573 }
1574 },
1575 "mappings": [],
1576 "thresholds": {
1577 "mode": "absolute",
1578 "steps": [
1579 {
1580 "color": "green",
1581 "value": null
1582 },
1583 {
1584 "color": "red",
1585 "value": 80
1586 }
1587 ]
1588 }
1589 },
1590 "overrides": []
1591 },
1592 "gridPos": {
1593 "h": 6,
1594 "w": 4,
1595 "x": 20,
1596 "y": 14
1597 },
1598 "id": 13,
1599 "options": {
1600 "legend": {
1601 "calcs": [],
1602 "displayMode": "table",
1603 "placement": "bottom",
1604 "showLegend": false
1605 },
1606 "tooltip": {
1607 "mode": "single",
1608 "sort": "none"
1609 }
1610 },
1611 "targets": [
1612 {
1613 "datasource": {
1614 "type": "grafana-clickhouse-datasource",
1615 "uid": "fet9b6miuomwwf"
1616 },
1617 "editorType": "sql",
1618 "format": 1,
1619 "meta": {
1620 "builderOptions": {
1621 "columns": [],
1622 "database": "",
1623 "limit": 1000,
1624 "mode": "list",
1625 "queryType": "table",
1626 "table": ""
1627 }
1628 },
1629 "pluginVersion": "4.10.1",
1630 "queryType": "table",
1631 "rawSql": "SELECT\n $__timeInterval(ts) AS \"time\",\n countIf(status >= 500) AS failure_count\nFROM \"logs\".\"caddy_requests\"\nWHERE ( ts >= $__fromTime AND ts <= $__toTime )\n AND host LIKE '%${Application}%'\n AND remote_ip LIKE '%${IP}%'\nGROUP BY time\nORDER BY time;",
1632 "refId": "A"
1633 }
1634 ],
1635 "title": "Requests 500 Count",
1636 "type": "timeseries"
1637 },
1638 {
1639 "datasource": {
1640 "type": "grafana-clickhouse-datasource",
1641 "uid": "fet9b6miuomwwf"
1642 },
1643 "fieldConfig": {
1644 "defaults": {
1645 "color": {
1646 "mode": "continuous-BlYlRd"
1647 },
1648 "mappings": [],
1649 "thresholds": {
1650 "mode": "absolute",
1651 "steps": [
1652 {
1653 "color": "green",
1654 "value": null
1655 },
1656 {
1657 "color": "red",
1658 "value": 80
1659 }
1660 ]
1661 },
1662 "unit": "short"
1663 },
1664 "overrides": []
1665 },
1666 "gridPos": {
1667 "h": 8,
1668 "w": 9,
1669 "x": 0,
1670 "y": 20
1671 },
1672 "id": 15,
1673 "options": {
1674 "displayMode": "gradient",
1675 "maxVizHeight": 300,
1676 "minVizHeight": 16,
1677 "minVizWidth": 8,
1678 "namePlacement": "auto",
1679 "orientation": "horizontal",
1680 "reduceOptions": {
1681 "calcs": [
1682 "lastNotNull"
1683 ],
1684 "fields": "/^requests$/",
1685 "limit": 25,
1686 "values": true
1687 },
1688 "showUnfilled": false,
1689 "sizing": "auto",
1690 "valueMode": "color"
1691 },
1692 "pluginVersion": "11.1.3",
1693 "targets": [
1694 {
1695 "datasource": {
1696 "type": "grafana-clickhouse-datasource",
1697 "uid": "fet9b6miuomwwf"
1698 },
1699 "editorType": "sql",
1700 "format": 1,
1701 "meta": {
1702 "builderOptions": {
1703 "columns": [],
1704 "database": "",
1705 "limit": 1000,
1706 "mode": "list",
1707 "queryType": "table",
1708 "table": ""
1709 }
1710 },
1711 "pluginVersion": "4.10.1",
1712 "queryType": "table",
1713 "rawSql": "SELECT\n concat(host, splitByChar('?', uri)[1]) AS Path,\n count() AS requests\nFROM logs.caddy_requests\nWHERE ( ts >= $__fromTime AND ts <= $__toTime )\n AND host LIKE '%${Application}%'\n AND remote_ip LIKE '%${IP}%'\nGROUP BY Path\nORDER BY requests DESC\n",
1714 "refId": "A"
1715 }
1716 ],
1717 "title": "Hot Interfaces",
1718 "type": "bargauge"
1719 },
1720 {
1721 "datasource": {
1722 "type": "grafana-clickhouse-datasource",
1723 "uid": "fet9b6miuomwwf"
1724 },
1725 "fieldConfig": {
1726 "defaults": {
1727 "color": {
1728 "mode": "continuous-GrYlRd"
1729 },
1730 "mappings": [],
1731 "thresholds": {
1732 "mode": "absolute",
1733 "steps": [
1734 {
1735 "color": "green",
1736 "value": null
1737 },
1738 {
1739 "color": "red",
1740 "value": 80
1741 }
1742 ]
1743 },
1744 "unit": "ms"
1745 },
1746 "overrides": []
1747 },
1748 "gridPos": {
1749 "h": 8,
1750 "w": 9,
1751 "x": 9,
1752 "y": 20
1753 },
1754 "id": 18,
1755 "options": {
1756 "displayMode": "gradient",
1757 "maxVizHeight": 300,
1758 "minVizHeight": 16,
1759 "minVizWidth": 8,
1760 "namePlacement": "auto",
1761 "orientation": "horizontal",
1762 "reduceOptions": {
1763 "calcs": [
1764 "lastNotNull"
1765 ],
1766 "fields": "/^avg_response_time_ms$/",
1767 "limit": 25,
1768 "values": true
1769 },
1770 "showUnfilled": false,
1771 "sizing": "auto",
1772 "valueMode": "color"
1773 },
1774 "pluginVersion": "11.1.3",
1775 "targets": [
1776 {
1777 "datasource": {
1778 "type": "grafana-clickhouse-datasource",
1779 "uid": "fet9b6miuomwwf"
1780 },
1781 "editorType": "sql",
1782 "format": 1,
1783 "meta": {
1784 "builderOptions": {
1785 "columns": [],
1786 "database": "",
1787 "limit": 1000,
1788 "mode": "list",
1789 "queryType": "table",
1790 "table": ""
1791 }
1792 },
1793 "pluginVersion": "4.10.1",
1794 "queryType": "table",
1795 "rawSql": "SELECT\n concat(host, splitByChar('?', uri)[1]) AS Path,\n avg(duration_ms) AS avg_response_time_ms\nFROM logs.caddy_requests\nWHERE ( ts >= $__fromTime AND ts <= $__toTime )\n AND host LIKE '%${Application}%'\n AND remote_ip LIKE '%${IP}%'\n AND status != '101'\nGROUP BY Path\nORDER BY avg_response_time_ms DESC\n",
1796 "refId": "A"
1797 }
1798 ],
1799 "title": "Slow Interface",
1800 "type": "bargauge"
1801 },
1802 {
1803 "datasource": {
1804 "type": "grafana-clickhouse-datasource",
1805 "uid": "fet9b6miuomwwf"
1806 },
1807 "fieldConfig": {
1808 "defaults": {
1809 "color": {
1810 "mode": "continuous-GrYlRd"
1811 },
1812 "mappings": [],
1813 "thresholds": {
1814 "mode": "absolute",
1815 "steps": [
1816 {
1817 "color": "green",
1818 "value": null
1819 },
1820 {
1821 "color": "red",
1822 "value": 80
1823 }
1824 ]
1825 },
1826 "unit": "short"
1827 },
1828 "overrides": []
1829 },
1830 "gridPos": {
1831 "h": 8,
1832 "w": 6,
1833 "x": 18,
1834 "y": 20
1835 },
1836 "id": 14,
1837 "options": {
1838 "displayMode": "gradient",
1839 "maxVizHeight": 300,
1840 "minVizHeight": 16,
1841 "minVizWidth": 8,
1842 "namePlacement": "auto",
1843 "orientation": "horizontal",
1844 "reduceOptions": {
1845 "calcs": [
1846 "lastNotNull"
1847 ],
1848 "fields": "/^count$/",
1849 "limit": 20,
1850 "values": true
1851 },
1852 "showUnfilled": false,
1853 "sizing": "auto",
1854 "valueMode": "color"
1855 },
1856 "pluginVersion": "11.1.3",
1857 "targets": [
1858 {
1859 "datasource": {
1860 "type": "grafana-clickhouse-datasource",
1861 "uid": "fet9b6miuomwwf"
1862 },
1863 "editorType": "sql",
1864 "format": 1,
1865 "meta": {
1866 "builderOptions": {
1867 "columns": [],
1868 "database": "",
1869 "limit": 1000,
1870 "mode": "list",
1871 "queryType": "table",
1872 "table": ""
1873 }
1874 },
1875 "pluginVersion": "4.10.1",
1876 "queryType": "table",
1877 "rawSql": "SELECT remote_ip, COUNT(*) AS count\nFROM \"logs\".\"caddy_requests\"\nWHERE ( ts >= $__fromTime AND ts <= $__toTime )\n AND host LIKE '%${Application}%'\n AND remote_ip LIKE '%${IP}%'\nGROUP BY remote_ip\nORDER BY count DESC;",
1878 "refId": "A"
1879 }
1880 ],
1881 "title": "Incoming IPs",
1882 "type": "bargauge"
1883 },
1884 {
1885 "datasource": {
1886 "type": "grafana-clickhouse-datasource",
1887 "uid": "fet9b6miuomwwf"
1888 },
1889 "fieldConfig": {
1890 "defaults": {
1891 "color": {
1892 "mode": "continuous-GrYlRd"
1893 },
1894 "mappings": [],
1895 "thresholds": {
1896 "mode": "absolute",
1897 "steps": [
1898 {
1899 "color": "green",
1900 "value": null
1901 },
1902 {
1903 "color": "red",
1904 "value": 80
1905 }
1906 ]
1907 },
1908 "unit": "short"
1909 },
1910 "overrides": []
1911 },
1912 "gridPos": {
1913 "h": 8,
1914 "w": 9,
1915 "x": 0,
1916 "y": 28
1917 },
1918 "id": 16,
1919 "options": {
1920 "displayMode": "gradient",
1921 "maxVizHeight": 300,
1922 "minVizHeight": 16,
1923 "minVizWidth": 8,
1924 "namePlacement": "auto",
1925 "orientation": "horizontal",
1926 "reduceOptions": {
1927 "calcs": [
1928 "lastNotNull"
1929 ],
1930 "fields": "/^requests$/",
1931 "limit": 25,
1932 "values": true
1933 },
1934 "showUnfilled": false,
1935 "sizing": "auto",
1936 "valueMode": "color"
1937 },
1938 "pluginVersion": "11.1.3",
1939 "targets": [
1940 {
1941 "datasource": {
1942 "type": "grafana-clickhouse-datasource",
1943 "uid": "fet9b6miuomwwf"
1944 },
1945 "editorType": "sql",
1946 "format": 1,
1947 "meta": {
1948 "builderOptions": {
1949 "columns": [],
1950 "database": "",
1951 "limit": 1000,
1952 "mode": "list",
1953 "queryType": "table",
1954 "table": ""
1955 }
1956 },
1957 "pluginVersion": "4.10.1",
1958 "queryType": "table",
1959 "rawSql": "SELECT\n concat(host, splitByChar('?', uri)[1]) AS Path,\n count() AS requests\nFROM logs.caddy_requests\nWHERE ( ts >= $__fromTime AND ts <= $__toTime )\n AND host LIKE '%${Application}%'\n AND remote_ip LIKE '%${IP}%'\n AND status >= 500\nGROUP BY Path\nORDER BY requests DESC\n",
1960 "refId": "A"
1961 }
1962 ],
1963 "title": "Error Interface",
1964 "type": "bargauge"
1965 },
1966 {
1967 "datasource": {
1968 "type": "grafana-clickhouse-datasource",
1969 "uid": "fet9b6miuomwwf"
1970 },
1971 "fieldConfig": {
1972 "defaults": {
1973 "color": {
1974 "mode": "continuous-GrYlRd"
1975 },
1976 "mappings": [],
1977 "thresholds": {
1978 "mode": "absolute",
1979 "steps": [
1980 {
1981 "color": "green",
1982 "value": null
1983 },
1984 {
1985 "color": "red",
1986 "value": 80
1987 }
1988 ]
1989 },
1990 "unit": "percent"
1991 },
1992 "overrides": []
1993 },
1994 "gridPos": {
1995 "h": 8,
1996 "w": 9,
1997 "x": 9,
1998 "y": 28
1999 },
2000 "id": 17,
2001 "options": {
2002 "displayMode": "basic",
2003 "maxVizHeight": 300,
2004 "minVizHeight": 16,
2005 "minVizWidth": 8,
2006 "namePlacement": "auto",
2007 "orientation": "horizontal",
2008 "reduceOptions": {
2009 "calcs": [
2010 "lastNotNull"
2011 ],
2012 "fields": "/^failure_rate_percent$/",
2013 "limit": 75,
2014 "values": true
2015 },
2016 "showUnfilled": false,
2017 "sizing": "auto",
2018 "valueMode": "color"
2019 },
2020 "pluginVersion": "11.1.3",
2021 "targets": [
2022 {
2023 "datasource": {
2024 "type": "grafana-clickhouse-datasource",
2025 "uid": "fet9b6miuomwwf"
2026 },
2027 "editorType": "sql",
2028 "format": 1,
2029 "meta": {
2030 "builderOptions": {
2031 "columns": [],
2032 "database": "",
2033 "limit": 1000,
2034 "mode": "list",
2035 "queryType": "table",
2036 "table": ""
2037 }
2038 },
2039 "pluginVersion": "4.10.1",
2040 "queryType": "table",
2041 "rawSql": "SELECT\n concat(host, splitByChar('?', uri)[1]) AS Path,\n round(countIf(status >= 500) / count() * 100, 2) AS failure_rate_percent\nFROM logs.caddy_requests\nWHERE ( ts >= $__fromTime AND ts <= $__toTime )\n AND host LIKE '%${Application}%'\n AND remote_ip LIKE '%${IP}%'\nGROUP BY Path\nORDER BY failure_rate_percent DESC\n",
2042 "refId": "A"
2043 }
2044 ],
2045 "title": "Error Rate Interface",
2046 "type": "bargauge"
2047 },
2048 {
2049 "datasource": {
2050 "type": "grafana-clickhouse-datasource",
2051 "uid": "fet9b6miuomwwf"
2052 },
2053 "fieldConfig": {
2054 "defaults": {
2055 "color": {
2056 "mode": "continuous-GrYlRd"
2057 },
2058 "mappings": [],
2059 "thresholds": {
2060 "mode": "absolute",
2061 "steps": [
2062 {
2063 "color": "green",
2064 "value": null
2065 },
2066 {
2067 "color": "red",
2068 "value": 80
2069 }
2070 ]
2071 },
2072 "unit": "bytes"
2073 },
2074 "overrides": []
2075 },
2076 "gridPos": {
2077 "h": 8,
2078 "w": 6,
2079 "x": 18,
2080 "y": 28
2081 },
2082 "id": 32,
2083 "options": {
2084 "displayMode": "gradient",
2085 "maxVizHeight": 300,
2086 "minVizHeight": 16,
2087 "minVizWidth": 8,
2088 "namePlacement": "auto",
2089 "orientation": "horizontal",
2090 "reduceOptions": {
2091 "calcs": [
2092 "lastNotNull"
2093 ],
2094 "fields": "/^total_bytes_sent$/",
2095 "limit": 20,
2096 "values": true
2097 },
2098 "showUnfilled": false,
2099 "sizing": "auto",
2100 "valueMode": "color"
2101 },
2102 "pluginVersion": "11.1.3",
2103 "targets": [
2104 {
2105 "datasource": {
2106 "type": "grafana-clickhouse-datasource",
2107 "uid": "fet9b6miuomwwf"
2108 },
2109 "editorType": "sql",
2110 "format": 1,
2111 "meta": {
2112 "builderOptions": {
2113 "columns": [],
2114 "database": "",
2115 "limit": 1000,
2116 "mode": "list",
2117 "queryType": "table",
2118 "table": ""
2119 }
2120 },
2121 "pluginVersion": "4.10.1",
2122 "queryType": "table",
2123 "rawSql": "SELECT\n remote_ip,\n sum(bytes_sent) AS total_bytes_sent\nFROM \"logs\".\"caddy_requests\"\nWHERE ( ts >= $__fromTime AND ts <= $__toTime )\n AND host LIKE '%${Application}%'\n AND remote_ip LIKE '%${IP}%'\nGROUP BY remote_ip\nORDER BY total_bytes_sent DESC;\n",
2124 "refId": "A"
2125 }
2126 ],
2127 "title": "Sent data to IPs",
2128 "type": "bargauge"
2129 },
2130 {
2131 "datasource": {
2132 "type": "grafana-clickhouse-datasource",
2133 "uid": "fet9b6miuomwwf"
2134 },
2135 "fieldConfig": {
2136 "defaults": {
2137 "color": {
2138 "mode": "thresholds"
2139 },
2140 "custom": {
2141 "align": "auto",
2142 "cellOptions": {
2143 "type": "auto"
2144 },
2145 "inspect": false
2146 },
2147 "mappings": [],
2148 "thresholds": {
2149 "mode": "absolute",
2150 "steps": [
2151 {
2152 "color": "green"
2153 },
2154 {
2155 "color": "red",
2156 "value": 80
2157 }
2158 ]
2159 }
2160 },
2161 "overrides": []
2162 },
2163 "gridPos": {
2164 "h": 9,
2165 "w": 24,
2166 "x": 0,
2167 "y": 36
2168 },
2169 "id": 1,
2170 "options": {
2171 "cellHeight": "sm",
2172 "footer": {
2173 "countRows": false,
2174 "fields": "",
2175 "reducer": [
2176 "sum"
2177 ],
2178 "show": false
2179 },
2180 "showHeader": true,
2181 "sortBy": [
2182 {
2183 "desc": false,
2184 "displayName": "duration_ms"
2185 }
2186 ]
2187 },
2188 "pluginVersion": "11.1.3",
2189 "targets": [
2190 {
2191 "builderOptions": {
2192 "aggregates": [],
2193 "columns": [
2194 {
2195 "alias": "level",
2196 "custom": false,
2197 "name": "level",
2198 "type": "LowCardinality(String)"
2199 },
2200 {
2201 "alias": "remote_ip",
2202 "custom": false,
2203 "name": "remote_ip",
2204 "type": "String"
2205 }
2206 ],
2207 "database": "logs",
2208 "filters": [],
2209 "groupBy": [],
2210 "limit": 1000,
2211 "meta": {},
2212 "mode": "list",
2213 "orderBy": [],
2214 "queryType": "table",
2215 "table": "caddy_requests"
2216 },
2217 "datasource": {
2218 "type": "grafana-clickhouse-datasource",
2219 "uid": "fet9b6miuomwwf"
2220 },
2221 "editorType": "sql",
2222 "format": 1,
2223 "meta": {
2224 "builderOptions": {
2225 "aggregates": [],
2226 "columns": [
2227 {
2228 "alias": "level",
2229 "custom": false,
2230 "name": "level",
2231 "type": "LowCardinality(String)"
2232 },
2233 {
2234 "alias": "remote_ip",
2235 "custom": false,
2236 "name": "remote_ip",
2237 "type": "String"
2238 }
2239 ],
2240 "database": "logs",
2241 "filters": [],
2242 "groupBy": [],
2243 "limit": 1000,
2244 "meta": {},
2245 "mode": "list",
2246 "orderBy": [],
2247 "queryType": "table",
2248 "table": "caddy_requests"
2249 }
2250 },
2251 "pluginVersion": "4.10.1",
2252 "queryType": "table",
2253 "rawSql": "SELECT\n remote_ip, method, host, uri, status, bytes_sent, duration_ms\t\nFROM logs.caddy_requests\nWHERE ( ts >= $__fromTime AND ts <= $__toTime )\n AND host LIKE '%${Application}%'\n AND remote_ip LIKE '%${IP}%'\nORDER BY ts DESC\nLIMIT 200",
2254 "refId": "Hot Application"
2255 }
2256 ],
2257 "title": "RAW",
2258 "type": "table"
2259 }
2260 ],
2261 "refresh": "30s",
2262 "schemaVersion": 39,
2263 "tags": [],
2264 "templating": {
2265 "list": [
2266 {
2267 "current": {
2268 "selected": false,
2269 "text": "",
2270 "value": ""
2271 },
2272 "description": "Application",
2273 "hide": 0,
2274 "label": "Application",
2275 "name": "Application",
2276 "options": [
2277 {
2278 "selected": true,
2279 "text": "",
2280 "value": ""
2281 }
2282 ],
2283 "query": "%",
2284 "skipUrlSync": false,
2285 "type": "textbox"
2286 },
2287 {
2288 "current": {
2289 "selected": false,
2290 "text": "",
2291 "value": ""
2292 },
2293 "description": "IP",
2294 "hide": 0,
2295 "label": "IP",
2296 "name": "IP",
2297 "options": [
2298 {
2299 "selected": true,
2300 "text": "",
2301 "value": ""
2302 }
2303 ],
2304 "query": "%",
2305 "skipUrlSync": false,
2306 "type": "textbox"
2307 }
2308 ]
2309 },
2310 "time": {
2311 "from": "now-5y",
2312 "to": "now"
2313 },
2314 "timepicker": {},
2315 "timezone": "browser",
2316 "title": "Caddy",
2317 "uid": "eet9bprvewlq8e",
2318 "version": 66,
2319 "weekStart": ""
2320}
grafana.json Неформатований
1{
2 "annotations": {
3 "list": [
4 {
5 "builtIn": 1,
6 "datasource": {
7 "type": "grafana",
8 "uid": "-- Grafana --"
9 },
10 "enable": true,
11 "hide": true,
12 "iconColor": "rgba(0, 211, 255, 1)",
13 "name": "Annotations & Alerts",
14 "type": "dashboard"
15 }
16 ]
17 },
18 "editable": true,
19 "fiscalYearStartMonth": 0,
20 "graphTooltip": 0,
21 "id": 3,
22 "links": [],
23 "liveNow": true,
24 "panels": [
25 {
26 "datasource": {
27 "type": "grafana-clickhouse-datasource",
28 "uid": "fet9b6miuomwwf"
29 },
30 "fieldConfig": {
31 "defaults": {
32 "fieldMinMax": false,
33 "mappings": [],
34 "max": 41943040,
35 "min": 0,
36 "thresholds": {
37 "mode": "percentage",
38 "steps": [
39 {
40 "color": "green",
41 "value": null
42 },
43 {
44 "color": "orange",
45 "value": 70
46 },
47 {
48 "color": "red",
49 "value": 85
50 }
51 ]
52 },
53 "unit": "binBps"
54 },
55 "overrides": []
56 },
57 "gridPos": {
58 "h": 6,
59 "w": 3,
60 "x": 0,
61 "y": 0
62 },
63 "id": 29,
64 "options": {
65 "minVizHeight": 75,
66 "minVizWidth": 75,
67 "orientation": "auto",
68 "reduceOptions": {
69 "calcs": [
70 "lastNotNull"
71 ],
72 "fields": "",
73 "values": false
74 },
75 "showThresholdLabels": false,
76 "showThresholdMarkers": true,
77 "sizing": "auto"
78 },
79 "pluginVersion": "11.1.3",
80 "targets": [
81 {
82 "datasource": {
83 "type": "grafana-clickhouse-datasource",
84 "uid": "fet9b6miuomwwf"
85 },
86 "editorType": "sql",
87 "format": 1,
88 "meta": {
89 "builderOptions": {
90 "columns": [],
91 "database": "",
92 "limit": 1000,
93 "mode": "list",
94 "queryType": "table",
95 "table": ""
96 }
97 },
98 "pluginVersion": "4.10.1",
99 "queryType": "table",
100 "rawSql": "SELECT\n sum(bytes_sent) / (($__toTime) - ($__fromTime)) AS bytes_per_second\nFROM logs.caddy_requests\nWHERE ( ts >= $__fromTime AND ts <= $__toTime )\n AND host LIKE '%${Application}%'\n AND remote_ip LIKE '%${IP}%'\n",
101 "refId": "A"
102 }
103 ],
104 "title": "Average KB per second",
105 "type": "gauge"
106 },
107 {
108 "datasource": {
109 "type": "grafana-clickhouse-datasource",
110 "uid": "fet9b6miuomwwf"
111 },
112 "fieldConfig": {
113 "defaults": {
114 "mappings": [],
115 "max": 100,
116 "min": 0,
117 "thresholds": {
118 "mode": "percentage",
119 "steps": [
120 {
121 "color": "green",
122 "value": null
123 },
124 {
125 "color": "orange",
126 "value": 70
127 },
128 {
129 "color": "red",
130 "value": 85
131 }
132 ]
133 },
134 "unit": "reqps"
135 },
136 "overrides": []
137 },
138 "gridPos": {
139 "h": 6,
140 "w": 3,
141 "x": 3,
142 "y": 0
143 },
144 "id": 30,
145 "options": {
146 "minVizHeight": 75,
147 "minVizWidth": 75,
148 "orientation": "auto",
149 "reduceOptions": {
150 "calcs": [
151 "lastNotNull"
152 ],
153 "fields": "",
154 "values": false
155 },
156 "showThresholdLabels": false,
157 "showThresholdMarkers": true,
158 "sizing": "auto"
159 },
160 "pluginVersion": "11.1.3",
161 "targets": [
162 {
163 "datasource": {
164 "type": "grafana-clickhouse-datasource",
165 "uid": "fet9b6miuomwwf"
166 },
167 "editorType": "sql",
168 "format": 1,
169 "meta": {
170 "builderOptions": {
171 "columns": [],
172 "database": "",
173 "limit": 1000,
174 "mode": "list",
175 "queryType": "table",
176 "table": ""
177 }
178 },
179 "pluginVersion": "4.10.1",
180 "queryType": "table",
181 "rawSql": "SELECT\n count() / dateDiff('second', $__fromTime, $__toTime) AS avg_requests_per_second\nFROM logs.caddy_requests\nWHERE ( ts >= $__fromTime AND ts <= $__toTime )\n AND host LIKE '%${Application}%'\n AND remote_ip LIKE '%${IP}%'\n",
182 "refId": "A"
183 }
184 ],
185 "title": "Average Throughput",
186 "type": "gauge"
187 },
188 {
189 "datasource": {
190 "type": "grafana-clickhouse-datasource",
191 "uid": "fet9b6miuomwwf"
192 },
193 "fieldConfig": {
194 "defaults": {
195 "color": {
196 "mode": "palette-classic"
197 },
198 "custom": {
199 "hideFrom": {
200 "legend": false,
201 "tooltip": false,
202 "viz": false
203 }
204 },
205 "mappings": []
206 },
207 "overrides": []
208 },
209 "gridPos": {
210 "h": 6,
211 "w": 3,
212 "x": 6,
213 "y": 0
214 },
215 "id": 26,
216 "options": {
217 "displayLabels": [
218 "name"
219 ],
220 "legend": {
221 "displayMode": "list",
222 "placement": "bottom",
223 "showLegend": false
224 },
225 "pieType": "donut",
226 "reduceOptions": {
227 "calcs": [
228 "lastNotNull"
229 ],
230 "fields": "/^request_count$/",
231 "values": true
232 },
233 "tooltip": {
234 "mode": "single",
235 "sort": "none"
236 }
237 },
238 "pluginVersion": "11.1.3",
239 "targets": [
240 {
241 "datasource": {
242 "type": "grafana-clickhouse-datasource",
243 "uid": "fet9b6miuomwwf"
244 },
245 "editorType": "sql",
246 "format": 1,
247 "meta": {
248 "builderOptions": {
249 "columns": [],
250 "database": "",
251 "limit": 1000,
252 "mode": "list",
253 "queryType": "table",
254 "table": ""
255 }
256 },
257 "pluginVersion": "4.10.1",
258 "queryType": "table",
259 "rawSql": "SELECT\n toString(status) AS status,\n count() AS request_count\nFROM logs.caddy_requests\nWHERE ( ts >= $__fromTime AND ts <= $__toTime )\n AND host LIKE '%${Application}%'\n AND remote_ip LIKE '%${IP}%'\nGROUP BY status\nORDER BY request_count DESC\n",
260 "refId": "A"
261 }
262 ],
263 "title": "Status Code Distribution",
264 "type": "piechart"
265 },
266 {
267 "datasource": {
268 "type": "grafana-clickhouse-datasource",
269 "uid": "fet9b6miuomwwf"
270 },
271 "fieldConfig": {
272 "defaults": {
273 "color": {
274 "mode": "palette-classic"
275 },
276 "mappings": [],
277 "thresholds": {
278 "mode": "absolute",
279 "steps": [
280 {
281 "color": "green",
282 "value": null
283 },
284 {
285 "color": "red",
286 "value": 80
287 }
288 ]
289 },
290 "unit": "short"
291 },
292 "overrides": []
293 },
294 "gridPos": {
295 "h": 6,
296 "w": 3,
297 "x": 9,
298 "y": 0
299 },
300 "id": 21,
301 "options": {
302 "displayMode": "gradient",
303 "maxVizHeight": 300,
304 "minVizHeight": 16,
305 "minVizWidth": 8,
306 "namePlacement": "auto",
307 "orientation": "horizontal",
308 "reduceOptions": {
309 "calcs": [],
310 "fields": "",
311 "values": true
312 },
313 "showUnfilled": false,
314 "sizing": "auto",
315 "valueMode": "color"
316 },
317 "pluginVersion": "11.1.3",
318 "targets": [
319 {
320 "datasource": {
321 "type": "grafana-clickhouse-datasource",
322 "uid": "fet9b6miuomwwf"
323 },
324 "editorType": "sql",
325 "format": 1,
326 "meta": {
327 "builderOptions": {
328 "columns": [],
329 "database": "",
330 "limit": 1000,
331 "mode": "list",
332 "queryType": "table",
333 "table": ""
334 }
335 },
336 "pluginVersion": "4.10.1",
337 "queryType": "table",
338 "rawSql": "SELECT\n method AS method,\n count() AS request_count\nFROM logs.caddy_requests\nWHERE ( ts >= $__fromTime AND ts <= $__toTime )\n AND host LIKE '%${Application}%'\n AND remote_ip LIKE '%${IP}%'\nGROUP BY method\nORDER BY request_count DESC\n",
339 "refId": "A"
340 }
341 ],
342 "title": "Method Distribution",
343 "type": "bargauge"
344 },
345 {
346 "datasource": {
347 "type": "grafana-clickhouse-datasource",
348 "uid": "fet9b6miuomwwf"
349 },
350 "fieldConfig": {
351 "defaults": {
352 "color": {
353 "mode": "thresholds"
354 },
355 "mappings": [],
356 "max": 700,
357 "min": 0,
358 "thresholds": {
359 "mode": "absolute",
360 "steps": [
361 {
362 "color": "green",
363 "value": null
364 },
365 {
366 "color": "red",
367 "value": 240
368 }
369 ]
370 },
371 "unit": "ms"
372 },
373 "overrides": []
374 },
375 "gridPos": {
376 "h": 2,
377 "w": 3,
378 "x": 12,
379 "y": 0
380 },
381 "id": 31,
382 "options": {
383 "displayMode": "lcd",
384 "maxVizHeight": 300,
385 "minVizHeight": 16,
386 "minVizWidth": 8,
387 "namePlacement": "auto",
388 "orientation": "horizontal",
389 "reduceOptions": {
390 "calcs": [
391 "lastNotNull"
392 ],
393 "fields": "",
394 "values": false
395 },
396 "showUnfilled": true,
397 "sizing": "auto",
398 "valueMode": "color"
399 },
400 "pluginVersion": "11.1.3",
401 "targets": [
402 {
403 "datasource": {
404 "type": "grafana-clickhouse-datasource",
405 "uid": "fet9b6miuomwwf"
406 },
407 "editorType": "sql",
408 "format": 1,
409 "meta": {
410 "builderOptions": {
411 "columns": [],
412 "database": "",
413 "limit": 1000,
414 "mode": "list",
415 "queryType": "table",
416 "table": ""
417 }
418 },
419 "pluginVersion": "4.10.1",
420 "queryType": "table",
421 "rawSql": "SELECT\n quantile(0.95)(duration_ms) AS current_p95_response_time_ms\nFROM logs.caddy_requests\nWHERE ts BETWEEN $__fromTime AND $__toTime\n AND status != '101'\n AND host LIKE '%${Application}%'\n AND remote_ip LIKE '%${IP}%'\n",
422 "refId": "A"
423 }
424 ],
425 "title": "P95 Latancy",
426 "type": "bargauge"
427 },
428 {
429 "datasource": {
430 "type": "grafana-clickhouse-datasource",
431 "uid": "fet9b6miuomwwf"
432 },
433 "fieldConfig": {
434 "defaults": {
435 "color": {
436 "mode": "continuous-YlRd"
437 },
438 "custom": {
439 "axisBorderShow": false,
440 "axisCenteredZero": false,
441 "axisColorMode": "text",
442 "axisLabel": "",
443 "axisPlacement": "auto",
444 "barAlignment": 0,
445 "drawStyle": "line",
446 "fillOpacity": 0,
447 "gradientMode": "hue",
448 "hideFrom": {
449 "legend": false,
450 "tooltip": false,
451 "viz": false
452 },
453 "insertNulls": false,
454 "lineInterpolation": "linear",
455 "lineStyle": {
456 "fill": "solid"
457 },
458 "lineWidth": 1,
459 "pointSize": 5,
460 "scaleDistribution": {
461 "type": "linear"
462 },
463 "showPoints": "auto",
464 "spanNulls": false,
465 "stacking": {
466 "group": "A",
467 "mode": "none"
468 },
469 "thresholdsStyle": {
470 "mode": "off"
471 }
472 },
473 "displayName": "Count",
474 "mappings": [],
475 "thresholds": {
476 "mode": "absolute",
477 "steps": [
478 {
479 "color": "green",
480 "value": null
481 },
482 {
483 "color": "red",
484 "value": 1000
485 }
486 ]
487 }
488 },
489 "overrides": []
490 },
491 "gridPos": {
492 "h": 6,
493 "w": 9,
494 "x": 15,
495 "y": 0
496 },
497 "id": 27,
498 "options": {
499 "legend": {
500 "calcs": [],
501 "displayMode": "table",
502 "placement": "bottom",
503 "showLegend": false
504 },
505 "tooltip": {
506 "mode": "single",
507 "sort": "none"
508 }
509 },
510 "targets": [
511 {
512 "datasource": {
513 "type": "grafana-clickhouse-datasource",
514 "uid": "fet9b6miuomwwf"
515 },
516 "editorType": "sql",
517 "format": 1,
518 "meta": {
519 "builderOptions": {
520 "columns": [],
521 "database": "",
522 "limit": 1000,
523 "mode": "list",
524 "queryType": "table",
525 "table": ""
526 }
527 },
528 "pluginVersion": "4.10.1",
529 "queryType": "table",
530 "rawSql": "SELECT $__timeInterval(ts) as \"time\", count(ts) FROM \"logs\".\"caddy_requests\"\nWHERE ( ts >= $__fromTime AND ts <= $__toTime )\n AND host LIKE '%${Application}%'\n AND remote_ip like '%${IP}%'\n GROUP BY time",
531 "refId": "A"
532 }
533 ],
534 "title": "Requests Trend",
535 "type": "timeseries"
536 },
537 {
538 "datasource": {
539 "type": "grafana-clickhouse-datasource",
540 "uid": "fet9b6miuomwwf"
541 },
542 "fieldConfig": {
543 "defaults": {
544 "color": {
545 "mode": "thresholds"
546 },
547 "mappings": [],
548 "max": 100,
549 "min": 0,
550 "thresholds": {
551 "mode": "absolute",
552 "steps": [
553 {
554 "color": "green",
555 "value": null
556 },
557 {
558 "color": "red",
559 "value": 30
560 }
561 ]
562 },
563 "unit": "ms"
564 },
565 "overrides": []
566 },
567 "gridPos": {
568 "h": 2,
569 "w": 3,
570 "x": 12,
571 "y": 2
572 },
573 "id": 34,
574 "options": {
575 "displayMode": "lcd",
576 "maxVizHeight": 300,
577 "minVizHeight": 16,
578 "minVizWidth": 8,
579 "namePlacement": "auto",
580 "orientation": "horizontal",
581 "reduceOptions": {
582 "calcs": [
583 "lastNotNull"
584 ],
585 "fields": "",
586 "values": false
587 },
588 "showUnfilled": true,
589 "sizing": "auto",
590 "valueMode": "color"
591 },
592 "pluginVersion": "11.1.3",
593 "targets": [
594 {
595 "datasource": {
596 "type": "grafana-clickhouse-datasource",
597 "uid": "fet9b6miuomwwf"
598 },
599 "editorType": "sql",
600 "format": 1,
601 "meta": {
602 "builderOptions": {
603 "columns": [],
604 "database": "",
605 "limit": 1000,
606 "mode": "list",
607 "queryType": "table",
608 "table": ""
609 }
610 },
611 "pluginVersion": "4.10.1",
612 "queryType": "table",
613 "rawSql": "SELECT\n quantile(0.80)(duration_ms) AS current_p95_response_time_ms\nFROM logs.caddy_requests\nWHERE ts BETWEEN $__fromTime AND $__toTime\n AND status != '101'\n AND host LIKE '%${Application}%'\n AND remote_ip LIKE '%${IP}%'\n",
614 "refId": "A"
615 }
616 ],
617 "title": "P80 Latancy",
618 "type": "bargauge"
619 },
620 {
621 "datasource": {
622 "type": "grafana-clickhouse-datasource",
623 "uid": "fet9b6miuomwwf"
624 },
625 "fieldConfig": {
626 "defaults": {
627 "color": {
628 "mode": "thresholds"
629 },
630 "mappings": [],
631 "max": 16,
632 "min": 0,
633 "thresholds": {
634 "mode": "absolute",
635 "steps": [
636 {
637 "color": "green",
638 "value": null
639 },
640 {
641 "color": "red",
642 "value": 5
643 }
644 ]
645 },
646 "unit": "ms"
647 },
648 "overrides": []
649 },
650 "gridPos": {
651 "h": 2,
652 "w": 3,
653 "x": 12,
654 "y": 4
655 },
656 "id": 33,
657 "options": {
658 "displayMode": "lcd",
659 "maxVizHeight": 300,
660 "minVizHeight": 16,
661 "minVizWidth": 8,
662 "namePlacement": "auto",
663 "orientation": "horizontal",
664 "reduceOptions": {
665 "calcs": [
666 "lastNotNull"
667 ],
668 "fields": "",
669 "values": false
670 },
671 "showUnfilled": true,
672 "sizing": "auto",
673 "valueMode": "color"
674 },
675 "pluginVersion": "11.1.3",
676 "targets": [
677 {
678 "datasource": {
679 "type": "grafana-clickhouse-datasource",
680 "uid": "fet9b6miuomwwf"
681 },
682 "editorType": "sql",
683 "format": 1,
684 "meta": {
685 "builderOptions": {
686 "columns": [],
687 "database": "",
688 "limit": 1000,
689 "mode": "list",
690 "queryType": "table",
691 "table": ""
692 }
693 },
694 "pluginVersion": "4.10.1",
695 "queryType": "table",
696 "rawSql": "SELECT\n quantile(0.5)(duration_ms) AS current_median_response_time_ms\nFROM logs.caddy_requests\nWHERE ts BETWEEN $__fromTime AND $__toTime\n AND status != '101'\n AND host LIKE '%${Application}%'\n AND remote_ip LIKE '%${IP}%'\n",
697 "refId": "A"
698 }
699 ],
700 "title": "Middle Latancy",
701 "type": "bargauge"
702 },
703 {
704 "datasource": {
705 "type": "grafana-clickhouse-datasource",
706 "uid": "fet9b6miuomwwf"
707 },
708 "fieldConfig": {
709 "defaults": {
710 "color": {
711 "mode": "continuous-GrYlRd"
712 },
713 "mappings": [],
714 "thresholds": {
715 "mode": "absolute",
716 "steps": [
717 {
718 "color": "green",
719 "value": null
720 },
721 {
722 "color": "red",
723 "value": 80
724 }
725 ]
726 }
727 },
728 "overrides": []
729 },
730 "gridPos": {
731 "h": 8,
732 "w": 5,
733 "x": 0,
734 "y": 6
735 },
736 "id": 5,
737 "options": {
738 "displayMode": "lcd",
739 "maxVizHeight": 300,
740 "minVizHeight": 16,
741 "minVizWidth": 8,
742 "namePlacement": "auto",
743 "orientation": "horizontal",
744 "reduceOptions": {
745 "calcs": [],
746 "fields": "/^requests$/",
747 "limit": 10,
748 "values": true
749 },
750 "showUnfilled": true,
751 "sizing": "auto",
752 "valueMode": "color"
753 },
754 "pluginVersion": "11.1.3",
755 "targets": [
756 {
757 "datasource": {
758 "type": "grafana-clickhouse-datasource",
759 "uid": "fet9b6miuomwwf"
760 },
761 "editorType": "sql",
762 "format": 1,
763 "meta": {
764 "builderOptions": {
765 "columns": [],
766 "database": "",
767 "limit": 1000,
768 "mode": "list",
769 "queryType": "table",
770 "table": ""
771 }
772 },
773 "pluginVersion": "4.10.1",
774 "queryType": "table",
775 "rawSql": "SELECT\n host as Application,\n count() AS requests\nFROM logs.caddy_requests\nWHERE ( ts >= $__fromTime AND ts <= $__toTime )\n AND host LIKE '%${Application}%'\n AND remote_ip like '%${IP}%'\nGROUP BY Application\nORDER BY requests DESC\n\n",
776 "refId": "A"
777 }
778 ],
779 "title": "Requests By Count",
780 "type": "bargauge"
781 },
782 {
783 "datasource": {
784 "type": "grafana-clickhouse-datasource",
785 "uid": "fet9b6miuomwwf"
786 },
787 "fieldConfig": {
788 "defaults": {
789 "color": {
790 "mode": "continuous-GrYlRd"
791 },
792 "mappings": [],
793 "thresholds": {
794 "mode": "absolute",
795 "steps": [
796 {
797 "color": "green",
798 "value": null
799 },
800 {
801 "color": "red",
802 "value": 80
803 }
804 ]
805 }
806 },
807 "overrides": []
808 },
809 "gridPos": {
810 "h": 8,
811 "w": 5,
812 "x": 5,
813 "y": 6
814 },
815 "id": 6,
816 "options": {
817 "displayMode": "lcd",
818 "maxVizHeight": 300,
819 "minVizHeight": 16,
820 "minVizWidth": 8,
821 "namePlacement": "auto",
822 "orientation": "horizontal",
823 "reduceOptions": {
824 "calcs": [],
825 "fields": "",
826 "limit": 10,
827 "values": true
828 },
829 "showUnfilled": true,
830 "sizing": "auto",
831 "valueMode": "color"
832 },
833 "pluginVersion": "11.1.3",
834 "targets": [
835 {
836 "datasource": {
837 "type": "grafana-clickhouse-datasource",
838 "uid": "fet9b6miuomwwf"
839 },
840 "editorType": "sql",
841 "format": 1,
842 "meta": {
843 "builderOptions": {
844 "columns": [],
845 "database": "",
846 "limit": 1000,
847 "mode": "list",
848 "queryType": "table",
849 "table": ""
850 }
851 },
852 "pluginVersion": "4.10.1",
853 "queryType": "table",
854 "rawSql": "SELECT\n host AS Application,\n uniqExact(remote_ip) AS unique_ip_count\nFROM logs.caddy_requests\nWHERE ( ts >= $__fromTime AND ts <= $__toTime )\n AND host LIKE '%${Application}%'\n AND remote_ip LIKE '%${IP}%'\nGROUP BY Application\nORDER BY unique_ip_count DESC\n\n",
855 "refId": "A"
856 }
857 ],
858 "title": "Requests By Unique IP Count (IPs)",
859 "type": "bargauge"
860 },
861 {
862 "datasource": {
863 "type": "grafana-clickhouse-datasource",
864 "uid": "fet9b6miuomwwf"
865 },
866 "fieldConfig": {
867 "defaults": {
868 "color": {
869 "mode": "continuous-GrYlRd"
870 },
871 "mappings": [],
872 "thresholds": {
873 "mode": "absolute",
874 "steps": [
875 {
876 "color": "green",
877 "value": null
878 },
879 {
880 "color": "red",
881 "value": 80
882 }
883 ]
884 },
885 "unit": "s"
886 },
887 "overrides": []
888 },
889 "gridPos": {
890 "h": 8,
891 "w": 5,
892 "x": 10,
893 "y": 6
894 },
895 "id": 7,
896 "options": {
897 "displayMode": "lcd",
898 "maxVizHeight": 300,
899 "minVizHeight": 16,
900 "minVizWidth": 8,
901 "namePlacement": "auto",
902 "orientation": "horizontal",
903 "reduceOptions": {
904 "calcs": [],
905 "fields": "",
906 "limit": 10,
907 "values": true
908 },
909 "showUnfilled": true,
910 "sizing": "auto",
911 "valueMode": "color"
912 },
913 "pluginVersion": "11.1.3",
914 "targets": [
915 {
916 "datasource": {
917 "type": "grafana-clickhouse-datasource",
918 "uid": "fet9b6miuomwwf"
919 },
920 "editorType": "sql",
921 "format": 1,
922 "meta": {
923 "builderOptions": {
924 "columns": [],
925 "database": "",
926 "limit": 1000,
927 "mode": "list",
928 "queryType": "table",
929 "table": ""
930 }
931 },
932 "pluginVersion": "4.10.1",
933 "queryType": "table",
934 "rawSql": "SELECT\n host AS Application,\n sum(duration_ms)/1000 AS total_duration_seconds\nFROM logs.caddy_requests\nWHERE ( ts >= $__fromTime AND ts <= $__toTime )\n AND status != '101'\n AND host LIKE '%${Application}%'\n AND remote_ip LIKE '%${IP}%'\nGROUP BY Application\nORDER BY total_duration_seconds DESC",
935 "refId": "A"
936 }
937 ],
938 "title": "Total Time costs (Seconds)",
939 "type": "bargauge"
940 },
941 {
942 "datasource": {
943 "type": "grafana-clickhouse-datasource",
944 "uid": "fet9b6miuomwwf"
945 },
946 "fieldConfig": {
947 "defaults": {
948 "color": {
949 "mode": "continuous-GrYlRd"
950 },
951 "mappings": [],
952 "thresholds": {
953 "mode": "absolute",
954 "steps": [
955 {
956 "color": "green",
957 "value": null
958 },
959 {
960 "color": "red",
961 "value": 80
962 }
963 ]
964 },
965 "unit": "bytes"
966 },
967 "overrides": []
968 },
969 "gridPos": {
970 "h": 8,
971 "w": 5,
972 "x": 15,
973 "y": 6
974 },
975 "id": 28,
976 "options": {
977 "displayMode": "lcd",
978 "maxVizHeight": 300,
979 "minVizHeight": 16,
980 "minVizWidth": 8,
981 "namePlacement": "auto",
982 "orientation": "horizontal",
983 "reduceOptions": {
984 "calcs": [],
985 "fields": "",
986 "limit": 10,
987 "values": true
988 },
989 "showUnfilled": true,
990 "sizing": "auto",
991 "valueMode": "color"
992 },
993 "pluginVersion": "11.1.3",
994 "targets": [
995 {
996 "datasource": {
997 "type": "grafana-clickhouse-datasource",
998 "uid": "fet9b6miuomwwf"
999 },
1000 "editorType": "sql",
1001 "format": 1,
1002 "meta": {
1003 "builderOptions": {
1004 "columns": [],
1005 "database": "",
1006 "limit": 1000,
1007 "mode": "list",
1008 "queryType": "table",
1009 "table": ""
1010 }
1011 },
1012 "pluginVersion": "4.10.1",
1013 "queryType": "table",
1014 "rawSql": "SELECT\n host AS Application,\n sum(bytes_sent) AS total_duration_seconds\nFROM logs.caddy_requests\nWHERE ( ts >= $__fromTime AND ts <= $__toTime )\n AND status != '101'\n AND host LIKE '%${Application}%'\n AND remote_ip LIKE '%${IP}%'\nGROUP BY Application\nORDER BY total_duration_seconds DESC",
1015 "refId": "A"
1016 }
1017 ],
1018 "title": "Total Bytes Sent (MB)",
1019 "type": "bargauge"
1020 },
1021 {
1022 "datasource": {
1023 "type": "grafana-clickhouse-datasource",
1024 "uid": "fet9b6miuomwwf"
1025 },
1026 "fieldConfig": {
1027 "defaults": {
1028 "color": {
1029 "mode": "continuous-GrYlRd"
1030 },
1031 "mappings": [],
1032 "thresholds": {
1033 "mode": "absolute",
1034 "steps": [
1035 {
1036 "color": "green",
1037 "value": null
1038 },
1039 {
1040 "color": "red",
1041 "value": 80
1042 }
1043 ]
1044 }
1045 },
1046 "overrides": []
1047 },
1048 "gridPos": {
1049 "h": 8,
1050 "w": 4,
1051 "x": 20,
1052 "y": 6
1053 },
1054 "id": 9,
1055 "options": {
1056 "displayMode": "lcd",
1057 "maxVizHeight": 300,
1058 "minVizHeight": 16,
1059 "minVizWidth": 8,
1060 "namePlacement": "auto",
1061 "orientation": "horizontal",
1062 "reduceOptions": {
1063 "calcs": [],
1064 "fields": "",
1065 "limit": 10,
1066 "values": true
1067 },
1068 "showUnfilled": true,
1069 "sizing": "auto",
1070 "valueMode": "color"
1071 },
1072 "pluginVersion": "11.1.3",
1073 "targets": [
1074 {
1075 "datasource": {
1076 "type": "grafana-clickhouse-datasource",
1077 "uid": "fet9b6miuomwwf"
1078 },
1079 "editorType": "sql",
1080 "format": 1,
1081 "meta": {
1082 "builderOptions": {
1083 "columns": [],
1084 "database": "",
1085 "limit": 1000,
1086 "mode": "list",
1087 "queryType": "table",
1088 "table": ""
1089 }
1090 },
1091 "pluginVersion": "4.10.1",
1092 "queryType": "table",
1093 "rawSql": "SELECT\n host AS Application,\n round(countIf(status >= 500) / count() * 100, 2) AS failure_rate_percent\nFROM logs.caddy_requests\nWHERE ( ts >= $__fromTime AND ts <= $__toTime )\n AND host LIKE '%${Application}%'\n AND remote_ip LIKE '%${IP}%'\nGROUP BY Application\nORDER BY failure_rate_percent DESC\n",
1094 "refId": "A"
1095 }
1096 ],
1097 "title": "500 Failure Rate%",
1098 "type": "bargauge"
1099 },
1100 {
1101 "datasource": {
1102 "type": "grafana-clickhouse-datasource",
1103 "uid": "fet9b6miuomwwf"
1104 },
1105 "fieldConfig": {
1106 "defaults": {
1107 "color": {
1108 "mode": "palette-classic"
1109 },
1110 "custom": {
1111 "axisBorderShow": false,
1112 "axisCenteredZero": false,
1113 "axisColorMode": "text",
1114 "axisLabel": "",
1115 "axisPlacement": "auto",
1116 "barAlignment": 0,
1117 "drawStyle": "line",
1118 "fillOpacity": 0,
1119 "gradientMode": "none",
1120 "hideFrom": {
1121 "legend": false,
1122 "tooltip": false,
1123 "viz": false
1124 },
1125 "insertNulls": false,
1126 "lineInterpolation": "linear",
1127 "lineWidth": 1,
1128 "pointSize": 5,
1129 "scaleDistribution": {
1130 "type": "linear"
1131 },
1132 "showPoints": "auto",
1133 "spanNulls": false,
1134 "stacking": {
1135 "group": "A",
1136 "mode": "none"
1137 },
1138 "thresholdsStyle": {
1139 "mode": "off"
1140 }
1141 },
1142 "mappings": [],
1143 "thresholds": {
1144 "mode": "percentage",
1145 "steps": [
1146 {
1147 "color": "green",
1148 "value": null
1149 },
1150 {
1151 "color": "orange",
1152 "value": 70
1153 },
1154 {
1155 "color": "red",
1156 "value": 85
1157 }
1158 ]
1159 },
1160 "unit": "ms"
1161 },
1162 "overrides": []
1163 },
1164 "gridPos": {
1165 "h": 6,
1166 "w": 5,
1167 "x": 0,
1168 "y": 14
1169 },
1170 "id": 3,
1171 "options": {
1172 "legend": {
1173 "calcs": [],
1174 "displayMode": "list",
1175 "placement": "bottom",
1176 "showLegend": false
1177 },
1178 "tooltip": {
1179 "mode": "single",
1180 "sort": "none"
1181 }
1182 },
1183 "pluginVersion": "11.1.3",
1184 "targets": [
1185 {
1186 "datasource": {
1187 "type": "grafana-clickhouse-datasource",
1188 "uid": "fet9b6miuomwwf"
1189 },
1190 "editorType": "sql",
1191 "format": 1,
1192 "meta": {
1193 "builderOptions": {
1194 "columns": [],
1195 "database": "",
1196 "limit": 1000,
1197 "mode": "list",
1198 "queryType": "table",
1199 "table": ""
1200 }
1201 },
1202 "pluginVersion": "4.10.1",
1203 "queryType": "table",
1204 "rawSql": "SELECT\n $__timeInterval(ts) AS \"time\",\n quantile(0.95)(duration_ms) AS p95_response_time_ms\nFROM \"logs\".\"caddy_requests\"\nWHERE ( ts >= $__fromTime AND ts <= $__toTime )\n AND status != '101'\n AND host LIKE '%${Application}%'\n AND remote_ip LIKE '%${IP}%'\nGROUP BY time\nORDER BY time",
1205 "refId": "A"
1206 }
1207 ],
1208 "title": "Requests Latancy P95",
1209 "type": "timeseries"
1210 },
1211 {
1212 "datasource": {
1213 "type": "grafana-clickhouse-datasource",
1214 "uid": "fet9b6miuomwwf"
1215 },
1216 "fieldConfig": {
1217 "defaults": {
1218 "color": {
1219 "mode": "palette-classic"
1220 },
1221 "custom": {
1222 "axisBorderShow": false,
1223 "axisCenteredZero": false,
1224 "axisColorMode": "text",
1225 "axisLabel": "",
1226 "axisPlacement": "auto",
1227 "barAlignment": 0,
1228 "drawStyle": "line",
1229 "fillOpacity": 0,
1230 "gradientMode": "none",
1231 "hideFrom": {
1232 "legend": false,
1233 "tooltip": false,
1234 "viz": false
1235 },
1236 "insertNulls": false,
1237 "lineInterpolation": "linear",
1238 "lineWidth": 1,
1239 "pointSize": 5,
1240 "scaleDistribution": {
1241 "type": "linear"
1242 },
1243 "showPoints": "auto",
1244 "spanNulls": false,
1245 "stacking": {
1246 "group": "A",
1247 "mode": "none"
1248 },
1249 "thresholdsStyle": {
1250 "mode": "off"
1251 }
1252 },
1253 "mappings": [],
1254 "thresholds": {
1255 "mode": "absolute",
1256 "steps": [
1257 {
1258 "color": "green",
1259 "value": null
1260 },
1261 {
1262 "color": "red",
1263 "value": 80
1264 }
1265 ]
1266 }
1267 },
1268 "overrides": []
1269 },
1270 "gridPos": {
1271 "h": 6,
1272 "w": 5,
1273 "x": 5,
1274 "y": 14
1275 },
1276 "id": 10,
1277 "options": {
1278 "legend": {
1279 "calcs": [],
1280 "displayMode": "table",
1281 "placement": "bottom",
1282 "showLegend": false
1283 },
1284 "tooltip": {
1285 "mode": "single",
1286 "sort": "none"
1287 }
1288 },
1289 "targets": [
1290 {
1291 "datasource": {
1292 "type": "grafana-clickhouse-datasource",
1293 "uid": "fet9b6miuomwwf"
1294 },
1295 "editorType": "sql",
1296 "format": 1,
1297 "meta": {
1298 "builderOptions": {
1299 "columns": [],
1300 "database": "",
1301 "limit": 1000,
1302 "mode": "list",
1303 "queryType": "table",
1304 "table": ""
1305 }
1306 },
1307 "pluginVersion": "4.10.1",
1308 "queryType": "table",
1309 "rawSql": "SELECT\n $__timeInterval(ts) AS \"time\",\n uniqExact(remote_ip) AS unique_ip_count\nFROM \"logs\".\"caddy_requests\"\nWHERE ( ts >= $__fromTime AND ts <= $__toTime )\n AND host LIKE '%${Application}%'\n AND remote_ip LIKE '%${IP}%'\nGROUP BY time\nORDER BY time;",
1310 "refId": "A"
1311 }
1312 ],
1313 "title": "Incoming Unique IPs Count",
1314 "type": "timeseries"
1315 },
1316 {
1317 "datasource": {
1318 "type": "grafana-clickhouse-datasource",
1319 "uid": "fet9b6miuomwwf"
1320 },
1321 "fieldConfig": {
1322 "defaults": {
1323 "color": {
1324 "mode": "palette-classic"
1325 },
1326 "custom": {
1327 "axisBorderShow": false,
1328 "axisCenteredZero": false,
1329 "axisColorMode": "text",
1330 "axisLabel": "",
1331 "axisPlacement": "auto",
1332 "barAlignment": 0,
1333 "drawStyle": "points",
1334 "fillOpacity": 0,
1335 "gradientMode": "none",
1336 "hideFrom": {
1337 "legend": false,
1338 "tooltip": false,
1339 "viz": false
1340 },
1341 "insertNulls": false,
1342 "lineInterpolation": "linear",
1343 "lineWidth": 1,
1344 "pointSize": 3,
1345 "scaleDistribution": {
1346 "type": "linear"
1347 },
1348 "showPoints": "auto",
1349 "spanNulls": false,
1350 "stacking": {
1351 "group": "A",
1352 "mode": "none"
1353 },
1354 "thresholdsStyle": {
1355 "mode": "off"
1356 }
1357 },
1358 "mappings": [],
1359 "thresholds": {
1360 "mode": "absolute",
1361 "steps": [
1362 {
1363 "color": "green",
1364 "value": null
1365 },
1366 {
1367 "color": "red",
1368 "value": 80
1369 }
1370 ]
1371 },
1372 "unit": "ms"
1373 },
1374 "overrides": []
1375 },
1376 "gridPos": {
1377 "h": 6,
1378 "w": 5,
1379 "x": 10,
1380 "y": 14
1381 },
1382 "id": 11,
1383 "options": {
1384 "legend": {
1385 "calcs": [],
1386 "displayMode": "table",
1387 "placement": "bottom",
1388 "showLegend": false
1389 },
1390 "tooltip": {
1391 "mode": "single",
1392 "sort": "none"
1393 }
1394 },
1395 "targets": [
1396 {
1397 "datasource": {
1398 "type": "grafana-clickhouse-datasource",
1399 "uid": "fet9b6miuomwwf"
1400 },
1401 "editorType": "sql",
1402 "format": 1,
1403 "meta": {
1404 "builderOptions": {
1405 "columns": [],
1406 "database": "",
1407 "limit": 1000,
1408 "mode": "list",
1409 "queryType": "table",
1410 "table": ""
1411 }
1412 },
1413 "pluginVersion": "4.10.1",
1414 "queryType": "table",
1415 "rawSql": "SELECT\n $__timeInterval(ts) AS \"time\",\n sum(duration_ms) AS total_duration_ms\nFROM \"logs\".\"caddy_requests\"\nWHERE ( ts >= $__fromTime AND ts <= $__toTime )\n AND host LIKE '%${Application}%'\n AND remote_ip LIKE '%${IP}%'\nGROUP BY time\nORDER BY time;",
1416 "refId": "A"
1417 }
1418 ],
1419 "title": "Processing Requests Total Time Costs",
1420 "type": "timeseries"
1421 },
1422 {
1423 "datasource": {
1424 "type": "grafana-clickhouse-datasource",
1425 "uid": "fet9b6miuomwwf"
1426 },
1427 "fieldConfig": {
1428 "defaults": {
1429 "color": {
1430 "mode": "palette-classic"
1431 },
1432 "custom": {
1433 "axisBorderShow": false,
1434 "axisCenteredZero": false,
1435 "axisColorMode": "text",
1436 "axisLabel": "",
1437 "axisPlacement": "auto",
1438 "barAlignment": 0,
1439 "drawStyle": "line",
1440 "fillOpacity": 0,
1441 "gradientMode": "none",
1442 "hideFrom": {
1443 "legend": false,
1444 "tooltip": false,
1445 "viz": false
1446 },
1447 "insertNulls": false,
1448 "lineInterpolation": "linear",
1449 "lineWidth": 1,
1450 "pointSize": 5,
1451 "scaleDistribution": {
1452 "type": "linear"
1453 },
1454 "showPoints": "auto",
1455 "spanNulls": false,
1456 "stacking": {
1457 "group": "A",
1458 "mode": "none"
1459 },
1460 "thresholdsStyle": {
1461 "mode": "off"
1462 }
1463 },
1464 "mappings": [],
1465 "thresholds": {
1466 "mode": "absolute",
1467 "steps": [
1468 {
1469 "color": "green",
1470 "value": null
1471 },
1472 {
1473 "color": "red",
1474 "value": 80
1475 }
1476 ]
1477 },
1478 "unit": "binBps"
1479 },
1480 "overrides": []
1481 },
1482 "gridPos": {
1483 "h": 6,
1484 "w": 5,
1485 "x": 15,
1486 "y": 14
1487 },
1488 "id": 12,
1489 "options": {
1490 "legend": {
1491 "calcs": [],
1492 "displayMode": "table",
1493 "placement": "bottom",
1494 "showLegend": false
1495 },
1496 "tooltip": {
1497 "mode": "single",
1498 "sort": "none"
1499 }
1500 },
1501 "targets": [
1502 {
1503 "datasource": {
1504 "type": "grafana-clickhouse-datasource",
1505 "uid": "fet9b6miuomwwf"
1506 },
1507 "editorType": "sql",
1508 "format": 1,
1509 "meta": {
1510 "builderOptions": {
1511 "columns": [],
1512 "database": "",
1513 "limit": 1000,
1514 "mode": "list",
1515 "queryType": "table",
1516 "table": ""
1517 }
1518 },
1519 "pluginVersion": "4.10.1",
1520 "queryType": "table",
1521 "rawSql": "SELECT\n $__timeInterval(ts) AS time,\n sum(bytes_sent) / $__interval_s AS bytes_per_second\nFROM logs.caddy_requests\nWHERE\n $__timeFilter(ts)\n AND host LIKE '%${Application}%'\n AND remote_ip LIKE '%${IP}%'\nGROUP BY\n time\nORDER BY\n time ASC",
1522 "refId": "A"
1523 }
1524 ],
1525 "title": "Upload Bandwidth",
1526 "type": "timeseries"
1527 },
1528 {
1529 "datasource": {
1530 "type": "grafana-clickhouse-datasource",
1531 "uid": "fet9b6miuomwwf"
1532 },
1533 "fieldConfig": {
1534 "defaults": {
1535 "color": {
1536 "fixedColor": "dark-red",
1537 "mode": "fixed"
1538 },
1539 "custom": {
1540 "axisBorderShow": false,
1541 "axisCenteredZero": false,
1542 "axisColorMode": "series",
1543 "axisLabel": "",
1544 "axisPlacement": "auto",
1545 "barAlignment": 0,
1546 "drawStyle": "points",
1547 "fillOpacity": 0,
1548 "gradientMode": "none",
1549 "hideFrom": {
1550 "legend": false,
1551 "tooltip": false,
1552 "viz": false
1553 },
1554 "insertNulls": false,
1555 "lineInterpolation": "linear",
1556 "lineWidth": 1,
1557 "pointSize": 2,
1558 "scaleDistribution": {
1559 "type": "linear"
1560 },
1561 "showPoints": "auto",
1562 "spanNulls": false,
1563 "stacking": {
1564 "group": "A",
1565 "mode": "none"
1566 },
1567 "thresholdsStyle": {
1568 "mode": "off"
1569 }
1570 },
1571 "mappings": [],
1572 "thresholds": {
1573 "mode": "absolute",
1574 "steps": [
1575 {
1576 "color": "green",
1577 "value": null
1578 },
1579 {
1580 "color": "red",
1581 "value": 80
1582 }
1583 ]
1584 }
1585 },
1586 "overrides": []
1587 },
1588 "gridPos": {
1589 "h": 6,
1590 "w": 4,
1591 "x": 20,
1592 "y": 14
1593 },
1594 "id": 13,
1595 "options": {
1596 "legend": {
1597 "calcs": [],
1598 "displayMode": "table",
1599 "placement": "bottom",
1600 "showLegend": false
1601 },
1602 "tooltip": {
1603 "mode": "single",
1604 "sort": "none"
1605 }
1606 },
1607 "targets": [
1608 {
1609 "datasource": {
1610 "type": "grafana-clickhouse-datasource",
1611 "uid": "fet9b6miuomwwf"
1612 },
1613 "editorType": "sql",
1614 "format": 1,
1615 "meta": {
1616 "builderOptions": {
1617 "columns": [],
1618 "database": "",
1619 "limit": 1000,
1620 "mode": "list",
1621 "queryType": "table",
1622 "table": ""
1623 }
1624 },
1625 "pluginVersion": "4.10.1",
1626 "queryType": "table",
1627 "rawSql": "SELECT\n $__timeInterval(ts) AS \"time\",\n countIf(status >= 500) AS failure_count\nFROM \"logs\".\"caddy_requests\"\nWHERE ( ts >= $__fromTime AND ts <= $__toTime )\n AND host LIKE '%${Application}%'\n AND remote_ip LIKE '%${IP}%'\nGROUP BY time\nORDER BY time;",
1628 "refId": "A"
1629 }
1630 ],
1631 "title": "Requests 500 Count",
1632 "type": "timeseries"
1633 },
1634 {
1635 "datasource": {
1636 "type": "grafana-clickhouse-datasource",
1637 "uid": "fet9b6miuomwwf"
1638 },
1639 "fieldConfig": {
1640 "defaults": {
1641 "color": {
1642 "mode": "continuous-BlYlRd"
1643 },
1644 "mappings": [],
1645 "thresholds": {
1646 "mode": "absolute",
1647 "steps": [
1648 {
1649 "color": "green",
1650 "value": null
1651 },
1652 {
1653 "color": "red",
1654 "value": 80
1655 }
1656 ]
1657 },
1658 "unit": "short"
1659 },
1660 "overrides": []
1661 },
1662 "gridPos": {
1663 "h": 8,
1664 "w": 9,
1665 "x": 0,
1666 "y": 20
1667 },
1668 "id": 15,
1669 "options": {
1670 "displayMode": "gradient",
1671 "maxVizHeight": 300,
1672 "minVizHeight": 16,
1673 "minVizWidth": 8,
1674 "namePlacement": "auto",
1675 "orientation": "horizontal",
1676 "reduceOptions": {
1677 "calcs": [
1678 "lastNotNull"
1679 ],
1680 "fields": "/^requests$/",
1681 "limit": 25,
1682 "values": true
1683 },
1684 "showUnfilled": false,
1685 "sizing": "auto",
1686 "valueMode": "color"
1687 },
1688 "pluginVersion": "11.1.3",
1689 "targets": [
1690 {
1691 "datasource": {
1692 "type": "grafana-clickhouse-datasource",
1693 "uid": "fet9b6miuomwwf"
1694 },
1695 "editorType": "sql",
1696 "format": 1,
1697 "meta": {
1698 "builderOptions": {
1699 "columns": [],
1700 "database": "",
1701 "limit": 1000,
1702 "mode": "list",
1703 "queryType": "table",
1704 "table": ""
1705 }
1706 },
1707 "pluginVersion": "4.10.1",
1708 "queryType": "table",
1709 "rawSql": "SELECT\n concat(host, splitByChar('?', uri)[1]) AS Path,\n count() AS requests\nFROM logs.caddy_requests\nWHERE ( ts >= $__fromTime AND ts <= $__toTime )\n AND host LIKE '%${Application}%'\n AND remote_ip LIKE '%${IP}%'\nGROUP BY Path\nORDER BY requests DESC\n",
1710 "refId": "A"
1711 }
1712 ],
1713 "title": "Hot Interfaces",
1714 "type": "bargauge"
1715 },
1716 {
1717 "datasource": {
1718 "type": "grafana-clickhouse-datasource",
1719 "uid": "fet9b6miuomwwf"
1720 },
1721 "fieldConfig": {
1722 "defaults": {
1723 "color": {
1724 "mode": "continuous-GrYlRd"
1725 },
1726 "mappings": [],
1727 "thresholds": {
1728 "mode": "absolute",
1729 "steps": [
1730 {
1731 "color": "green",
1732 "value": null
1733 },
1734 {
1735 "color": "red",
1736 "value": 80
1737 }
1738 ]
1739 },
1740 "unit": "ms"
1741 },
1742 "overrides": []
1743 },
1744 "gridPos": {
1745 "h": 8,
1746 "w": 9,
1747 "x": 9,
1748 "y": 20
1749 },
1750 "id": 18,
1751 "options": {
1752 "displayMode": "gradient",
1753 "maxVizHeight": 300,
1754 "minVizHeight": 16,
1755 "minVizWidth": 8,
1756 "namePlacement": "auto",
1757 "orientation": "horizontal",
1758 "reduceOptions": {
1759 "calcs": [
1760 "lastNotNull"
1761 ],
1762 "fields": "/^avg_response_time_ms$/",
1763 "limit": 25,
1764 "values": true
1765 },
1766 "showUnfilled": false,
1767 "sizing": "auto",
1768 "valueMode": "color"
1769 },
1770 "pluginVersion": "11.1.3",
1771 "targets": [
1772 {
1773 "datasource": {
1774 "type": "grafana-clickhouse-datasource",
1775 "uid": "fet9b6miuomwwf"
1776 },
1777 "editorType": "sql",
1778 "format": 1,
1779 "meta": {
1780 "builderOptions": {
1781 "columns": [],
1782 "database": "",
1783 "limit": 1000,
1784 "mode": "list",
1785 "queryType": "table",
1786 "table": ""
1787 }
1788 },
1789 "pluginVersion": "4.10.1",
1790 "queryType": "table",
1791 "rawSql": "SELECT\n concat(host, splitByChar('?', uri)[1]) AS Path,\n avg(duration_ms) AS avg_response_time_ms\nFROM logs.caddy_requests\nWHERE ( ts >= $__fromTime AND ts <= $__toTime )\n AND host LIKE '%${Application}%'\n AND remote_ip LIKE '%${IP}%'\n AND status != '101'\nGROUP BY Path\nORDER BY avg_response_time_ms DESC\n",
1792 "refId": "A"
1793 }
1794 ],
1795 "title": "Slow Interface",
1796 "type": "bargauge"
1797 },
1798 {
1799 "datasource": {
1800 "type": "grafana-clickhouse-datasource",
1801 "uid": "fet9b6miuomwwf"
1802 },
1803 "fieldConfig": {
1804 "defaults": {
1805 "color": {
1806 "mode": "continuous-GrYlRd"
1807 },
1808 "mappings": [],
1809 "thresholds": {
1810 "mode": "absolute",
1811 "steps": [
1812 {
1813 "color": "green",
1814 "value": null
1815 },
1816 {
1817 "color": "red",
1818 "value": 80
1819 }
1820 ]
1821 },
1822 "unit": "short"
1823 },
1824 "overrides": []
1825 },
1826 "gridPos": {
1827 "h": 8,
1828 "w": 6,
1829 "x": 18,
1830 "y": 20
1831 },
1832 "id": 14,
1833 "options": {
1834 "displayMode": "gradient",
1835 "maxVizHeight": 300,
1836 "minVizHeight": 16,
1837 "minVizWidth": 8,
1838 "namePlacement": "auto",
1839 "orientation": "horizontal",
1840 "reduceOptions": {
1841 "calcs": [
1842 "lastNotNull"
1843 ],
1844 "fields": "/^count$/",
1845 "limit": 20,
1846 "values": true
1847 },
1848 "showUnfilled": false,
1849 "sizing": "auto",
1850 "valueMode": "color"
1851 },
1852 "pluginVersion": "11.1.3",
1853 "targets": [
1854 {
1855 "datasource": {
1856 "type": "grafana-clickhouse-datasource",
1857 "uid": "fet9b6miuomwwf"
1858 },
1859 "editorType": "sql",
1860 "format": 1,
1861 "meta": {
1862 "builderOptions": {
1863 "columns": [],
1864 "database": "",
1865 "limit": 1000,
1866 "mode": "list",
1867 "queryType": "table",
1868 "table": ""
1869 }
1870 },
1871 "pluginVersion": "4.10.1",
1872 "queryType": "table",
1873 "rawSql": "SELECT remote_ip, COUNT(*) AS count\nFROM \"logs\".\"caddy_requests\"\nWHERE ( ts >= $__fromTime AND ts <= $__toTime )\n AND host LIKE '%${Application}%'\n AND remote_ip LIKE '%${IP}%'\nGROUP BY remote_ip\nORDER BY count DESC;",
1874 "refId": "A"
1875 }
1876 ],
1877 "title": "Incoming IPs",
1878 "type": "bargauge"
1879 },
1880 {
1881 "datasource": {
1882 "type": "grafana-clickhouse-datasource",
1883 "uid": "fet9b6miuomwwf"
1884 },
1885 "fieldConfig": {
1886 "defaults": {
1887 "color": {
1888 "mode": "continuous-GrYlRd"
1889 },
1890 "mappings": [],
1891 "thresholds": {
1892 "mode": "absolute",
1893 "steps": [
1894 {
1895 "color": "green",
1896 "value": null
1897 },
1898 {
1899 "color": "red",
1900 "value": 80
1901 }
1902 ]
1903 },
1904 "unit": "short"
1905 },
1906 "overrides": []
1907 },
1908 "gridPos": {
1909 "h": 8,
1910 "w": 9,
1911 "x": 0,
1912 "y": 28
1913 },
1914 "id": 16,
1915 "options": {
1916 "displayMode": "gradient",
1917 "maxVizHeight": 300,
1918 "minVizHeight": 16,
1919 "minVizWidth": 8,
1920 "namePlacement": "auto",
1921 "orientation": "horizontal",
1922 "reduceOptions": {
1923 "calcs": [
1924 "lastNotNull"
1925 ],
1926 "fields": "/^requests$/",
1927 "limit": 25,
1928 "values": true
1929 },
1930 "showUnfilled": false,
1931 "sizing": "auto",
1932 "valueMode": "color"
1933 },
1934 "pluginVersion": "11.1.3",
1935 "targets": [
1936 {
1937 "datasource": {
1938 "type": "grafana-clickhouse-datasource",
1939 "uid": "fet9b6miuomwwf"
1940 },
1941 "editorType": "sql",
1942 "format": 1,
1943 "meta": {
1944 "builderOptions": {
1945 "columns": [],
1946 "database": "",
1947 "limit": 1000,
1948 "mode": "list",
1949 "queryType": "table",
1950 "table": ""
1951 }
1952 },
1953 "pluginVersion": "4.10.1",
1954 "queryType": "table",
1955 "rawSql": "SELECT\n concat(host, splitByChar('?', uri)[1]) AS Path,\n count() AS requests\nFROM logs.caddy_requests\nWHERE ( ts >= $__fromTime AND ts <= $__toTime )\n AND host LIKE '%${Application}%'\n AND remote_ip LIKE '%${IP}%'\n AND status >= 500\nGROUP BY Path\nORDER BY requests DESC\n",
1956 "refId": "A"
1957 }
1958 ],
1959 "title": "Error Interface",
1960 "type": "bargauge"
1961 },
1962 {
1963 "datasource": {
1964 "type": "grafana-clickhouse-datasource",
1965 "uid": "fet9b6miuomwwf"
1966 },
1967 "fieldConfig": {
1968 "defaults": {
1969 "color": {
1970 "mode": "continuous-GrYlRd"
1971 },
1972 "mappings": [],
1973 "thresholds": {
1974 "mode": "absolute",
1975 "steps": [
1976 {
1977 "color": "green",
1978 "value": null
1979 },
1980 {
1981 "color": "red",
1982 "value": 80
1983 }
1984 ]
1985 },
1986 "unit": "percent"
1987 },
1988 "overrides": []
1989 },
1990 "gridPos": {
1991 "h": 8,
1992 "w": 9,
1993 "x": 9,
1994 "y": 28
1995 },
1996 "id": 17,
1997 "options": {
1998 "displayMode": "basic",
1999 "maxVizHeight": 300,
2000 "minVizHeight": 16,
2001 "minVizWidth": 8,
2002 "namePlacement": "auto",
2003 "orientation": "horizontal",
2004 "reduceOptions": {
2005 "calcs": [
2006 "lastNotNull"
2007 ],
2008 "fields": "/^failure_rate_percent$/",
2009 "limit": 25,
2010 "values": true
2011 },
2012 "showUnfilled": false,
2013 "sizing": "auto",
2014 "valueMode": "color"
2015 },
2016 "pluginVersion": "11.1.3",
2017 "targets": [
2018 {
2019 "datasource": {
2020 "type": "grafana-clickhouse-datasource",
2021 "uid": "fet9b6miuomwwf"
2022 },
2023 "editorType": "sql",
2024 "format": 1,
2025 "meta": {
2026 "builderOptions": {
2027 "columns": [],
2028 "database": "",
2029 "limit": 1000,
2030 "mode": "list",
2031 "queryType": "table",
2032 "table": ""
2033 }
2034 },
2035 "pluginVersion": "4.10.1",
2036 "queryType": "table",
2037 "rawSql": "SELECT\n concat(host, splitByChar('?', uri)[1]) AS Path,\n round(countIf(status >= 500) / count() * 100, 2) AS failure_rate_percent\nFROM logs.caddy_requests\nWHERE ( ts >= $__fromTime AND ts <= $__toTime )\n AND host LIKE '%${Application}%'\n AND remote_ip LIKE '%${IP}%'\nGROUP BY Path\nORDER BY failure_rate_percent DESC\n",
2038 "refId": "A"
2039 }
2040 ],
2041 "title": "Error Rate Interface",
2042 "type": "bargauge"
2043 },
2044 {
2045 "datasource": {
2046 "type": "grafana-clickhouse-datasource",
2047 "uid": "fet9b6miuomwwf"
2048 },
2049 "fieldConfig": {
2050 "defaults": {
2051 "color": {
2052 "mode": "continuous-GrYlRd"
2053 },
2054 "mappings": [],
2055 "thresholds": {
2056 "mode": "absolute",
2057 "steps": [
2058 {
2059 "color": "green",
2060 "value": null
2061 },
2062 {
2063 "color": "red",
2064 "value": 80
2065 }
2066 ]
2067 },
2068 "unit": "bytes"
2069 },
2070 "overrides": []
2071 },
2072 "gridPos": {
2073 "h": 8,
2074 "w": 6,
2075 "x": 18,
2076 "y": 28
2077 },
2078 "id": 32,
2079 "options": {
2080 "displayMode": "gradient",
2081 "maxVizHeight": 300,
2082 "minVizHeight": 16,
2083 "minVizWidth": 8,
2084 "namePlacement": "auto",
2085 "orientation": "horizontal",
2086 "reduceOptions": {
2087 "calcs": [
2088 "lastNotNull"
2089 ],
2090 "fields": "/^total_bytes_sent$/",
2091 "limit": 20,
2092 "values": true
2093 },
2094 "showUnfilled": false,
2095 "sizing": "auto",
2096 "valueMode": "color"
2097 },
2098 "pluginVersion": "11.1.3",
2099 "targets": [
2100 {
2101 "datasource": {
2102 "type": "grafana-clickhouse-datasource",
2103 "uid": "fet9b6miuomwwf"
2104 },
2105 "editorType": "sql",
2106 "format": 1,
2107 "meta": {
2108 "builderOptions": {
2109 "columns": [],
2110 "database": "",
2111 "limit": 1000,
2112 "mode": "list",
2113 "queryType": "table",
2114 "table": ""
2115 }
2116 },
2117 "pluginVersion": "4.10.1",
2118 "queryType": "table",
2119 "rawSql": "SELECT\n remote_ip,\n sum(bytes_sent) AS total_bytes_sent\nFROM \"logs\".\"caddy_requests\"\nWHERE ( ts >= $__fromTime AND ts <= $__toTime )\n AND host LIKE '%${Application}%'\n AND remote_ip LIKE '%${IP}%'\nGROUP BY remote_ip\nORDER BY total_bytes_sent DESC;\n",
2120 "refId": "A"
2121 }
2122 ],
2123 "title": "Sent data to IPs",
2124 "type": "bargauge"
2125 },
2126 {
2127 "datasource": {
2128 "type": "grafana-clickhouse-datasource",
2129 "uid": "fet9b6miuomwwf"
2130 },
2131 "fieldConfig": {
2132 "defaults": {
2133 "color": {
2134 "mode": "thresholds"
2135 },
2136 "custom": {
2137 "align": "auto",
2138 "cellOptions": {
2139 "type": "auto"
2140 },
2141 "inspect": false
2142 },
2143 "mappings": [],
2144 "thresholds": {
2145 "mode": "absolute",
2146 "steps": [
2147 {
2148 "color": "green",
2149 "value": null
2150 },
2151 {
2152 "color": "red",
2153 "value": 80
2154 }
2155 ]
2156 }
2157 },
2158 "overrides": []
2159 },
2160 "gridPos": {
2161 "h": 9,
2162 "w": 24,
2163 "x": 0,
2164 "y": 36
2165 },
2166 "id": 1,
2167 "options": {
2168 "cellHeight": "sm",
2169 "footer": {
2170 "countRows": false,
2171 "fields": "",
2172 "reducer": [
2173 "sum"
2174 ],
2175 "show": false
2176 },
2177 "showHeader": true,
2178 "sortBy": [
2179 {
2180 "desc": false,
2181 "displayName": "status"
2182 }
2183 ]
2184 },
2185 "pluginVersion": "11.1.3",
2186 "targets": [
2187 {
2188 "builderOptions": {
2189 "aggregates": [],
2190 "columns": [
2191 {
2192 "alias": "level",
2193 "custom": false,
2194 "name": "level",
2195 "type": "LowCardinality(String)"
2196 },
2197 {
2198 "alias": "remote_ip",
2199 "custom": false,
2200 "name": "remote_ip",
2201 "type": "String"
2202 }
2203 ],
2204 "database": "logs",
2205 "filters": [],
2206 "groupBy": [],
2207 "limit": 1000,
2208 "meta": {},
2209 "mode": "list",
2210 "orderBy": [],
2211 "queryType": "table",
2212 "table": "caddy_requests"
2213 },
2214 "datasource": {
2215 "type": "grafana-clickhouse-datasource",
2216 "uid": "fet9b6miuomwwf"
2217 },
2218 "editorType": "sql",
2219 "format": 1,
2220 "meta": {
2221 "builderOptions": {
2222 "aggregates": [],
2223 "columns": [
2224 {
2225 "alias": "level",
2226 "custom": false,
2227 "name": "level",
2228 "type": "LowCardinality(String)"
2229 },
2230 {
2231 "alias": "remote_ip",
2232 "custom": false,
2233 "name": "remote_ip",
2234 "type": "String"
2235 }
2236 ],
2237 "database": "logs",
2238 "filters": [],
2239 "groupBy": [],
2240 "limit": 1000,
2241 "meta": {},
2242 "mode": "list",
2243 "orderBy": [],
2244 "queryType": "table",
2245 "table": "caddy_requests"
2246 }
2247 },
2248 "pluginVersion": "4.10.1",
2249 "queryType": "table",
2250 "rawSql": "SELECT\n remote_ip, method, host, uri, status, bytes_sent, duration_ms\t\nFROM logs.caddy_requests\nWHERE ( ts >= $__fromTime AND ts <= $__toTime )\n AND host LIKE '%${Application}%'\n AND remote_ip LIKE '%${IP}%'\nORDER BY ts DESC\nLIMIT 200",
2251 "refId": "Hot Application"
2252 }
2253 ],
2254 "title": "RAW",
2255 "type": "table"
2256 }
2257 ],
2258 "refresh": "30s",
2259 "schemaVersion": 39,
2260 "tags": [],
2261 "templating": {
2262 "list": [
2263 {
2264 "current": {
2265 "selected": false,
2266 "text": "",
2267 "value": ""
2268 },
2269 "description": "Application",
2270 "hide": 0,
2271 "label": "Application",
2272 "name": "Application",
2273 "options": [
2274 {
2275 "selected": true,
2276 "text": "",
2277 "value": ""
2278 }
2279 ],
2280 "query": "",
2281 "skipUrlSync": false,
2282 "type": "textbox"
2283 },
2284 {
2285 "current": {
2286 "selected": false,
2287 "text": "",
2288 "value": ""
2289 },
2290 "description": "IP",
2291 "hide": 0,
2292 "label": "IP",
2293 "name": "IP",
2294 "options": [
2295 {
2296 "selected": true,
2297 "text": "",
2298 "value": ""
2299 }
2300 ],
2301 "query": "",
2302 "skipUrlSync": false,
2303 "type": "textbox"
2304 }
2305 ]
2306 },
2307 "time": {
2308 "from": "now-1h",
2309 "to": "now"
2310 },
2311 "timepicker": {},
2312 "timezone": "browser",
2313 "title": "Caddy",
2314 "uid": "eet9bprvewlq8e",
2315 "version": 54,
2316 "weekStart": ""
2317}

Працює на Opengist ⋅ Load: 55ms⋅

Українська