Advertisement
Guest User

Untitled

a guest
Sep 19th, 2019
142
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 14.03 KB | None | 0 0
  1. {
  2. "annotations": {
  3. "list": [
  4. {
  5. "builtIn": 1,
  6. "datasource": "-- Grafana --",
  7. "enable": true,
  8. "hide": true,
  9. "iconColor": "rgba(0, 211, 255, 1)",
  10. "name": "Annotations & Alerts",
  11. "type": "dashboard"
  12. }
  13. ]
  14. },
  15. "editable": true,
  16. "gnetId": null,
  17. "graphTooltip": 0,
  18. "id": 2,
  19. "iteration": 1568892474283,
  20. "links": [],
  21. "panels": [
  22. {
  23. "aliasColors": {},
  24. "bars": false,
  25. "dashLength": 10,
  26. "dashes": false,
  27. "fill": 1,
  28. "fillGradient": 0,
  29. "gridPos": {
  30. "h": 6,
  31. "w": 14,
  32. "x": 0,
  33. "y": 0
  34. },
  35. "id": 2,
  36. "legend": {
  37. "avg": false,
  38. "current": false,
  39. "max": false,
  40. "min": false,
  41. "show": true,
  42. "total": false,
  43. "values": false
  44. },
  45. "lines": true,
  46. "linewidth": 1,
  47. "nullPointMode": "null",
  48. "options": {
  49. "dataLinks": []
  50. },
  51. "percentage": false,
  52. "pointradius": 2,
  53. "points": false,
  54. "renderer": "flot",
  55. "seriesOverrides": [],
  56. "spaceLength": 10,
  57. "stack": false,
  58. "steppedLine": false,
  59. "targets": [
  60. {
  61. "format": "time_series",
  62. "group": [],
  63. "metricColumn": "none",
  64. "rawQuery": false,
  65. "rawSql": "SELECT\n $__time(measurement),\n cpu as cpu\nFROM\n server_status\nWHERE\n $__timeFilter(measurement)\n and\n server_id IN ([[server]])\nORDER BY time\n",
  66. "refId": "A",
  67. "select": [
  68. [
  69. {
  70. "params": [
  71. "cpu"
  72. ],
  73. "type": "column"
  74. },
  75. {
  76. "params": [
  77. "cpu"
  78. ],
  79. "type": "alias"
  80. }
  81. ]
  82. ],
  83. "table": "server_status",
  84. "timeColumn": "cpu",
  85. "timeColumnType": "float8",
  86. "where": [
  87. {
  88. "name": "$__unixEpochFilter",
  89. "params": [],
  90. "type": "macro"
  91. }
  92. ]
  93. }
  94. ],
  95. "thresholds": [],
  96. "timeFrom": null,
  97. "timeRegions": [],
  98. "timeShift": null,
  99. "title": "Andamento CPU Usata",
  100. "tooltip": {
  101. "shared": true,
  102. "sort": 0,
  103. "value_type": "individual"
  104. },
  105. "type": "graph",
  106. "xaxis": {
  107. "buckets": null,
  108. "mode": "time",
  109. "name": null,
  110. "show": true,
  111. "values": []
  112. },
  113. "yaxes": [
  114. {
  115. "format": "short",
  116. "label": null,
  117. "logBase": 1,
  118. "max": null,
  119. "min": null,
  120. "show": true
  121. },
  122. {
  123. "format": "short",
  124. "label": null,
  125. "logBase": 1,
  126. "max": null,
  127. "min": null,
  128. "show": true
  129. }
  130. ],
  131. "yaxis": {
  132. "align": false,
  133. "alignLevel": null
  134. }
  135. },
  136. {
  137. "gridPos": {
  138. "h": 6,
  139. "w": 5,
  140. "x": 14,
  141. "y": 0
  142. },
  143. "id": 7,
  144. "options": {
  145. "fieldOptions": {
  146. "calcs": [
  147. "mean"
  148. ],
  149. "defaults": {
  150. "mappings": [],
  151. "max": 8,
  152. "min": 0,
  153. "thresholds": [
  154. {
  155. "color": "green",
  156. "value": null
  157. },
  158. {
  159. "color": "#EAB839",
  160. "value": 2
  161. },
  162. {
  163. "color": "red",
  164. "value": 4
  165. }
  166. ]
  167. },
  168. "override": {},
  169. "values": false
  170. },
  171. "orientation": "auto",
  172. "showThresholdLabels": true,
  173. "showThresholdMarkers": true
  174. },
  175. "pluginVersion": "6.3.5",
  176. "targets": [
  177. {
  178. "format": "time_series",
  179. "group": [
  180. {
  181. "params": [
  182. "$__interval",
  183. "none"
  184. ],
  185. "type": "time"
  186. }
  187. ],
  188. "metricColumn": "none",
  189. "rawQuery": false,
  190. "rawSql": "SELECT\n $__time(measurement),\n cpu as cpu\nFROM\n server_status\nWHERE\n $__timeFilter(measurement)\n and\n server_id IN ([[server]])\n",
  191. "refId": "A",
  192. "select": [
  193. [
  194. {
  195. "params": [
  196. "cpu"
  197. ],
  198. "type": "column"
  199. },
  200. {
  201. "params": [
  202. "avg"
  203. ],
  204. "type": "aggregate"
  205. },
  206. {
  207. "params": [
  208. "cpu"
  209. ],
  210. "type": "alias"
  211. }
  212. ]
  213. ],
  214. "table": "server_status",
  215. "timeColumn": "measurement",
  216. "timeColumnType": "timestamp",
  217. "where": [
  218. {
  219. "name": "$__timeFilter",
  220. "params": [],
  221. "type": "macro"
  222. }
  223. ]
  224. }
  225. ],
  226. "timeFrom": null,
  227. "timeShift": null,
  228. "title": "Cpu Massima utilizzata $server",
  229. "type": "gauge"
  230. },
  231. {
  232. "gridPos": {
  233. "h": 6,
  234. "w": 5,
  235. "x": 19,
  236. "y": 0
  237. },
  238. "id": 6,
  239. "options": {
  240. "fieldOptions": {
  241. "calcs": [
  242. "mean"
  243. ],
  244. "defaults": {
  245. "mappings": [],
  246. "max": 8,
  247. "min": 0,
  248. "thresholds": [
  249. {
  250. "color": "green",
  251. "value": null
  252. },
  253. {
  254. "color": "#EAB839",
  255. "value": 2
  256. },
  257. {
  258. "color": "red",
  259. "value": 4
  260. }
  261. ]
  262. },
  263. "override": {},
  264. "values": false
  265. },
  266. "orientation": "auto",
  267. "showThresholdLabels": true,
  268. "showThresholdMarkers": true
  269. },
  270. "pluginVersion": "6.3.5",
  271. "targets": [
  272. {
  273. "format": "time_series",
  274. "group": [
  275. {
  276. "params": [
  277. "$__interval",
  278. "none"
  279. ],
  280. "type": "time"
  281. }
  282. ],
  283. "metricColumn": "none",
  284. "rawQuery": false,
  285. "rawSql": "SELECT\n $__time(measurement),\n cpu as cpu\nFROM\n server_status\nWHERE\n $__timeFilter(measurement)\n and\n server_id IN ([[server]])\n",
  286. "refId": "A",
  287. "select": [
  288. [
  289. {
  290. "params": [
  291. "cpu"
  292. ],
  293. "type": "column"
  294. },
  295. {
  296. "params": [
  297. "max"
  298. ],
  299. "type": "aggregate"
  300. },
  301. {
  302. "params": [
  303. "cpu"
  304. ],
  305. "type": "alias"
  306. }
  307. ]
  308. ],
  309. "table": "server_status",
  310. "timeColumn": "measurement",
  311. "timeColumnType": "timestamp",
  312. "where": [
  313. {
  314. "name": "$__timeFilter",
  315. "params": [],
  316. "type": "macro"
  317. }
  318. ]
  319. }
  320. ],
  321. "timeFrom": null,
  322. "timeShift": null,
  323. "title": "Cpu Massima utilizzata $server",
  324. "type": "gauge"
  325. },
  326. {
  327. "aliasColors": {},
  328. "bars": false,
  329. "dashLength": 10,
  330. "dashes": false,
  331. "fill": 1,
  332. "fillGradient": 0,
  333. "gridPos": {
  334. "h": 7,
  335. "w": 14,
  336. "x": 0,
  337. "y": 6
  338. },
  339. "id": 4,
  340. "legend": {
  341. "avg": false,
  342. "current": false,
  343. "max": false,
  344. "min": false,
  345. "show": true,
  346. "total": false,
  347. "values": false
  348. },
  349. "lines": true,
  350. "linewidth": 1,
  351. "nullPointMode": "null",
  352. "options": {
  353. "dataLinks": []
  354. },
  355. "percentage": false,
  356. "pluginVersion": "6.3.5",
  357. "pointradius": 2,
  358. "points": true,
  359. "renderer": "flot",
  360. "seriesOverrides": [],
  361. "spaceLength": 10,
  362. "stack": false,
  363. "steppedLine": false,
  364. "targets": [
  365. {
  366. "format": "time_series",
  367. "group": [],
  368. "metricColumn": "none",
  369. "rawQuery": false,
  370. "rawSql": "SELECT\n $__time(time_column),\n value1\nFROM\n metric_table\nWHERE\n $__timeFilter(time_column)\n",
  371. "refId": "A",
  372. "select": [
  373. [
  374. {
  375. "params": [
  376. "num_of_requests"
  377. ],
  378. "type": "column"
  379. }
  380. ]
  381. ],
  382. "table": "server_status",
  383. "timeColumn": "measurement",
  384. "timeColumnType": "timestamp",
  385. "where": [
  386. {
  387. "name": "$__timeFilter",
  388. "params": [],
  389. "type": "macro"
  390. }
  391. ]
  392. }
  393. ],
  394. "thresholds": [],
  395. "timeFrom": null,
  396. "timeRegions": [],
  397. "timeShift": null,
  398. "title": "Numero richieste al minuto",
  399. "tooltip": {
  400. "shared": true,
  401. "sort": 0,
  402. "value_type": "individual"
  403. },
  404. "type": "graph",
  405. "xaxis": {
  406. "buckets": null,
  407. "mode": "time",
  408. "name": null,
  409. "show": true,
  410. "values": []
  411. },
  412. "yaxes": [
  413. {
  414. "format": "short",
  415. "label": null,
  416. "logBase": 1,
  417. "max": null,
  418. "min": null,
  419. "show": true
  420. },
  421. {
  422. "format": "short",
  423. "label": null,
  424. "logBase": 1,
  425. "max": null,
  426. "min": null,
  427. "show": true
  428. }
  429. ],
  430. "yaxis": {
  431. "align": false,
  432. "alignLevel": null
  433. }
  434. },
  435. {
  436. "cacheTimeout": null,
  437. "gridPos": {
  438. "h": 7,
  439. "w": 10,
  440. "x": 14,
  441. "y": 6
  442. },
  443. "id": 9,
  444. "links": [],
  445. "options": {
  446. "displayMode": "lcd",
  447. "fieldOptions": {
  448. "calcs": [
  449. "mean"
  450. ],
  451. "defaults": {
  452. "mappings": [],
  453. "max": 100,
  454. "min": 0,
  455. "thresholds": [
  456. {
  457. "color": "green",
  458. "value": null
  459. },
  460. {
  461. "color": "red",
  462. "value": 70
  463. }
  464. ]
  465. },
  466. "override": {},
  467. "values": false
  468. },
  469. "orientation": "horizontal"
  470. },
  471. "pluginVersion": "6.3.5",
  472. "targets": [
  473. {
  474. "format": "time_series",
  475. "group": [
  476. {
  477. "params": [
  478. "$__interval",
  479. "none"
  480. ],
  481. "type": "time"
  482. }
  483. ],
  484. "metricColumn": "none",
  485. "rawQuery": false,
  486. "rawSql": "SELECT\n $__time(time_column),\n value1\nFROM\n metric_table\nWHERE\n $__timeFilter(time_column)\n",
  487. "refId": "A",
  488. "select": [
  489. [
  490. {
  491. "params": [
  492. "num_of_requests"
  493. ],
  494. "type": "column"
  495. },
  496. {
  497. "params": [
  498. "max"
  499. ],
  500. "type": "aggregate"
  501. },
  502. {
  503. "params": [
  504. "num_of_requests"
  505. ],
  506. "type": "alias"
  507. }
  508. ]
  509. ],
  510. "table": "server_status",
  511. "timeColumn": "measurement",
  512. "timeColumnType": "timestamp",
  513. "where": [
  514. {
  515. "name": "$__timeFilter",
  516. "params": [],
  517. "type": "macro"
  518. }
  519. ]
  520. }
  521. ],
  522. "timeFrom": null,
  523. "timeShift": null,
  524. "title": "Numero di Richieste massimo da $server",
  525. "type": "bargauge"
  526. }
  527. ],
  528. "refresh": "5s",
  529. "schemaVersion": 19,
  530. "style": "dark",
  531. "tags": [],
  532. "templating": {
  533. "list": [
  534. {
  535. "allValue": null,
  536. "current": {
  537. "tags": [],
  538. "text": "All",
  539. "value": [
  540. "$__all"
  541. ]
  542. },
  543. "datasource": "PostgreSQL",
  544. "definition": "SELECT DISTINCT server_id FROM server_status",
  545. "hide": 0,
  546. "includeAll": true,
  547. "label": null,
  548. "multi": true,
  549. "name": "server",
  550. "options": [
  551. {
  552. "selected": false,
  553. "text": "All",
  554. "value": "$__all"
  555. },
  556. {
  557. "selected": true,
  558. "text": "server1",
  559. "value": "server1"
  560. },
  561. {
  562. "selected": false,
  563. "text": "server2",
  564. "value": "server2"
  565. },
  566. {
  567. "selected": false,
  568. "text": "server3",
  569. "value": "server3"
  570. }
  571. ],
  572. "query": "SELECT DISTINCT server_id FROM server_status",
  573. "refresh": 0,
  574. "regex": "",
  575. "skipUrlSync": false,
  576. "sort": 1,
  577. "tagValuesQuery": "",
  578. "tags": [],
  579. "tagsQuery": "",
  580. "type": "query",
  581. "useTags": false
  582. }
  583. ]
  584. },
  585. "time": {
  586. "from": "now-6h",
  587. "to": "now"
  588. },
  589. "timepicker": {
  590. "refresh_intervals": [
  591. "5s",
  592. "10s",
  593. "30s",
  594. "1m",
  595. "5m",
  596. "15m",
  597. "30m",
  598. "1h",
  599. "2h",
  600. "1d"
  601. ]
  602. },
  603. "timezone": "",
  604. "title": "Dashboard esercizi",
  605. "uid": "lnPHMItWz",
  606. "version": 28
  607. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement