API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Nov 14th, 2019
166
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 14.85 KB | None | 0 0
raw download clone embed print report
  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": 1,
  19. "links": [],
  20. "panels": [
  21. {
  22. "columns": [],
  23. "datasource": null,
  24. "fontSize": "100%",
  25. "gridPos": {
  26. "h": 8,
  27. "w": 12,
  28. "x": 0,
  29. "y": 0
  30. },
  31. "id": 10,
  32. "options": {},
  33. "pageSize": null,
  34. "showHeader": true,
  35. "sort": {
  36. "col": 0,
  37. "desc": true
  38. },
  39. "styles": [
  40. {
  41. "alias": "Time",
  42. "dateFormat": "YYYY-MM-DD HH:mm:ss",
  43. "pattern": "Time",
  44. "type": "date"
  45. },
  46. {
  47. "alias": "",
  48. "colorMode": null,
  49. "colors": [
  50. "rgba(245, 54, 54, 0.9)",
  51. "rgba(237, 129, 40, 0.89)",
  52. "rgba(50, 172, 45, 0.97)"
  53. ],
  54. "decimals": 2,
  55. "pattern": "/.*/",
  56. "thresholds": [],
  57. "type": "number",
  58. "unit": "short"
  59. }
  60. ],
  61. "targets": [
  62. {
  63. "format": "table",
  64. "group": [],
  65. "metricColumn": "none",
  66. "rawQuery": true,
  67. "rawSql": "SELECT nome_fantasia, razao_social FROM bandeira;",
  68. "refId": "A",
  69. "select": [
  70. [
  71. {
  72. "params": [
  73. "value"
  74. ],
  75. "type": "column"
  76. }
  77. ]
  78. ],
  79. "timeColumn": "time",
  80. "where": [
  81. {
  82. "name": "$__timeFilter",
  83. "params": [],
  84. "type": "macro"
  85. }
  86. ]
  87. }
  88. ],
  89. "timeFrom": null,
  90. "timeShift": null,
  91. "title": "Lista de bandeiras",
  92. "transform": "table",
  93. "type": "table"
  94. },
  95. {
  96. "columns": [],
  97. "datasource": null,
  98. "fontSize": "100%",
  99. "gridPos": {
  100. "h": 8,
  101. "w": 12,
  102. "x": 12,
  103. "y": 0
  104. },
  105. "id": 11,
  106. "options": {},
  107. "pageSize": null,
  108. "showHeader": true,
  109. "sort": {
  110. "col": 0,
  111. "desc": true
  112. },
  113. "styles": [
  114. {
  115. "alias": "Time",
  116. "dateFormat": "YYYY-MM-DD HH:mm:ss",
  117. "pattern": "Time",
  118. "type": "date"
  119. },
  120. {
  121. "alias": "",
  122. "colorMode": null,
  123. "colors": [
  124. "rgba(245, 54, 54, 0.9)",
  125. "rgba(237, 129, 40, 0.89)",
  126. "rgba(50, 172, 45, 0.97)"
  127. ],
  128. "decimals": 2,
  129. "pattern": "/.*/",
  130. "thresholds": [],
  131. "type": "number",
  132. "unit": "short"
  133. }
  134. ],
  135. "targets": [
  136. {
  137. "format": "table",
  138. "group": [],
  139. "metricColumn": "none",
  140. "rawQuery": true,
  141. "rawSql": "SELECT posto.nome_fantasia, posto.razao_social, bandeira.nome_fantasia AS 'bandeira_nome_fantasia' FROM posto\nINNER JOIN bandeira ON posto.bandeira_id = bandeira.id;",
  142. "refId": "A",
  143. "select": [
  144. [
  145. {
  146. "params": [
  147. "value"
  148. ],
  149. "type": "column"
  150. }
  151. ]
  152. ],
  153. "timeColumn": "time",
  154. "where": [
  155. {
  156. "name": "$__timeFilter",
  157. "params": [],
  158. "type": "macro"
  159. }
  160. ]
  161. }
  162. ],
  163. "timeFrom": null,
  164. "timeShift": null,
  165. "title": "Lista de postos",
  166. "transform": "table",
  167. "type": "table"
  168. },
  169. {
  170. "cacheTimeout": null,
  171. "colorBackground": false,
  172. "colorValue": false,
  173. "colors": [
  174. "#299c46",
  175. "rgba(237, 129, 40, 0.89)",
  176. "#d44a3a"
  177. ],
  178. "datasource": null,
  179. "format": "none",
  180. "gauge": {
  181. "maxValue": 100,
  182. "minValue": 0,
  183. "show": false,
  184. "thresholdLabels": false,
  185. "thresholdMarkers": true
  186. },
  187. "gridPos": {
  188. "h": 8,
  189. "w": 12,
  190. "x": 0,
  191. "y": 8
  192. },
  193. "id": 8,
  194. "interval": null,
  195. "links": [],
  196. "mappingType": 1,
  197. "mappingTypes": [
  198. {
  199. "name": "value to text",
  200. "value": 1
  201. },
  202. {
  203. "name": "range to text",
  204. "value": 2
  205. }
  206. ],
  207. "maxDataPoints": 100,
  208. "nullPointMode": "connected",
  209. "nullText": null,
  210. "options": {},
  211. "postfix": "",
  212. "postfixFontSize": "50%",
  213. "prefix": "",
  214. "prefixFontSize": "50%",
  215. "rangeMaps": [
  216. {
  217. "from": "null",
  218. "text": "N/A",
  219. "to": "null"
  220. }
  221. ],
  222. "sparkline": {
  223. "fillColor": "rgba(31, 118, 189, 0.18)",
  224. "full": false,
  225. "lineColor": "rgb(31, 120, 193)",
  226. "show": false,
  227. "ymax": null,
  228. "ymin": null
  229. },
  230. "tableColumn": "",
  231. "targets": [
  232. {
  233. "format": "table",
  234. "group": [],
  235. "metricColumn": "none",
  236. "rawQuery": true,
  237. "rawSql": "SELECT\n COUNT(*)\nFROM bandeira;\n",
  238. "refId": "A",
  239. "select": [
  240. [
  241. {
  242. "params": [
  243. "abastecimentos_id"
  244. ],
  245. "type": "column"
  246. }
  247. ]
  248. ],
  249. "table": "abastecimentos",
  250. "timeColumn": "data_de_abastecimento",
  251. "timeColumnType": "timestamp",
  252. "where": [
  253. {
  254. "name": "$__timeFilter",
  255. "params": [],
  256. "type": "macro"
  257. }
  258. ]
  259. }
  260. ],
  261. "thresholds": "",
  262. "timeFrom": null,
  263. "timeShift": null,
  264. "title": "Panel Title",
  265. "type": "singlestat",
  266. "valueFontSize": "80%",
  267. "valueMaps": [
  268. {
  269. "op": "=",
  270. "text": "N/A",
  271. "value": "null"
  272. }
  273. ],
  274. "valueName": "avg"
  275. },
  276. {
  277. "cacheTimeout": null,
  278. "colorBackground": false,
  279. "colorValue": false,
  280. "colors": [
  281. "#299c46",
  282. "rgba(237, 129, 40, 0.89)",
  283. "#d44a3a"
  284. ],
  285. "datasource": null,
  286. "format": "none",
  287. "gauge": {
  288. "maxValue": 100,
  289. "minValue": 0,
  290. "show": false,
  291. "thresholdLabels": false,
  292. "thresholdMarkers": true
  293. },
  294. "gridPos": {
  295. "h": 5,
  296. "w": 5,
  297. "x": 14,
  298. "y": 8
  299. },
  300. "id": 6,
  301. "interval": null,
  302. "links": [],
  303. "mappingType": 1,
  304. "mappingTypes": [
  305. {
  306. "name": "value to text",
  307. "value": 1
  308. },
  309. {
  310. "name": "range to text",
  311. "value": 2
  312. }
  313. ],
  314. "maxDataPoints": 100,
  315. "nullPointMode": "connected",
  316. "nullText": null,
  317. "options": {},
  318. "postfix": "",
  319. "postfixFontSize": "50%",
  320. "prefix": "",
  321. "prefixFontSize": "50%",
  322. "rangeMaps": [
  323. {
  324. "from": "null",
  325. "text": "N/A",
  326. "to": "null"
  327. }
  328. ],
  329. "sparkline": {
  330. "fillColor": "rgba(31, 118, 189, 0.18)",
  331. "full": false,
  332. "lineColor": "rgb(31, 120, 193)",
  333. "show": false,
  334. "ymax": null,
  335. "ymin": null
  336. },
  337. "tableColumn": "",
  338. "targets": [
  339. {
  340. "format": "table",
  341. "group": [],
  342. "metricColumn": "none",
  343. "rawQuery": true,
  344. "rawSql": "SELECT\n COUNT(*)\nFROM posto;\n",
  345. "refId": "A",
  346. "select": [
  347. [
  348. {
  349. "params": [
  350. "bandeira_id"
  351. ],
  352. "type": "column"
  353. },
  354. {
  355. "params": [
  356. "bandeira_id"
  357. ],
  358. "type": "alias"
  359. }
  360. ]
  361. ],
  362. "table": "posto",
  363. "timeColumn": "bandeira_id",
  364. "timeColumnType": "int",
  365. "where": []
  366. }
  367. ],
  368. "thresholds": "",
  369. "timeFrom": null,
  370. "timeShift": null,
  371. "title": "Qtd de postos",
  372. "type": "singlestat",
  373. "valueFontSize": "80%",
  374. "valueMaps": [
  375. {
  376. "op": "=",
  377. "text": "N/A",
  378. "value": "null"
  379. }
  380. ],
  381. "valueName": "avg"
  382. },
  383. {
  384. "cacheTimeout": null,
  385. "colorBackground": false,
  386. "colorValue": false,
  387. "colors": [
  388. "#299c46",
  389. "rgba(237, 129, 40, 0.89)",
  390. "#d44a3a"
  391. ],
  392. "datasource": "MySQL",
  393. "format": "none",
  394. "gauge": {
  395. "maxValue": 100,
  396. "minValue": 0,
  397. "show": false,
  398. "thresholdLabels": false,
  399. "thresholdMarkers": true
  400. },
  401. "gridPos": {
  402. "h": 5,
  403. "w": 5,
  404. "x": 0,
  405. "y": 16
  406. },
  407. "id": 4,
  408. "interval": null,
  409. "links": [],
  410. "mappingType": 1,
  411. "mappingTypes": [
  412. {
  413. "name": "value to text",
  414. "value": 1
  415. },
  416. {
  417. "name": "range to text",
  418. "value": 2
  419. }
  420. ],
  421. "maxDataPoints": 100,
  422. "nullPointMode": "connected",
  423. "nullText": null,
  424. "options": {},
  425. "postfix": "",
  426. "postfixFontSize": "50%",
  427. "prefix": "",
  428. "prefixFontSize": "50%",
  429. "rangeMaps": [
  430. {
  431. "from": "null",
  432. "text": "N/A",
  433. "to": "null"
  434. }
  435. ],
  436. "sparkline": {
  437. "fillColor": "rgba(31, 118, 189, 0.18)",
  438. "full": false,
  439. "lineColor": "rgb(31, 120, 193)",
  440. "show": false,
  441. "ymax": null,
  442. "ymin": null
  443. },
  444. "tableColumn": "",
  445. "targets": [
  446. {
  447. "format": "time_series",
  448. "group": [],
  449. "metricColumn": "none",
  450. "rawQuery": true,
  451. "rawSql": "SELECT COUNT(*), ANY_VALUE(data_de_abastecimento) as \"time\" FROM PetroLinda.abastecimentos\nWHERE\n $__timeFilter(ANY_VALUE(data_de_abastecimento))\nORDER BY ANY_VALUE(data_de_abastecimento)",
  452. "refId": "A",
  453. "select": [
  454. [
  455. {
  456. "params": [
  457. "abastecimentos_id"
  458. ],
  459. "type": "column"
  460. }
  461. ]
  462. ],
  463. "table": "abastecimentos",
  464. "timeColumn": "data_de_abastecimento",
  465. "timeColumnType": "timestamp",
  466. "where": [
  467. {
  468. "name": "$__timeFilter",
  469. "params": [],
  470. "type": "macro"
  471. }
  472. ]
  473. }
  474. ],
  475. "thresholds": "",
  476. "timeFrom": null,
  477. "timeShift": null,
  478. "title": "Qtd de abastecimentos no periodo",
  479. "type": "singlestat",
  480. "valueFontSize": "80%",
  481. "valueMaps": [
  482. {
  483. "op": "=",
  484. "text": "N/A",
  485. "value": "null"
  486. }
  487. ],
  488. "valueName": "avg"
  489. },
  490. {
  491. "aliasColors": {},
  492. "bars": false,
  493. "dashLength": 10,
  494. "dashes": false,
  495. "datasource": null,
  496. "decimals": null,
  497. "fill": 1,
  498. "fillGradient": 0,
  499. "gridPos": {
  500. "h": 5,
  501. "w": 12,
  502. "x": 5,
  503. "y": 16
  504. },
  505. "id": 2,
  506. "interval": "1h",
  507. "legend": {
  508. "avg": false,
  509. "current": false,
  510. "max": false,
  511. "min": false,
  512. "rightSide": false,
  513. "show": true,
  514. "total": false,
  515. "values": false
  516. },
  517. "lines": true,
  518. "linewidth": 1,
  519. "nullPointMode": "null",
  520. "options": {
  521. "dataLinks": []
  522. },
  523. "percentage": false,
  524. "pointradius": 2,
  525. "points": false,
  526. "renderer": "flot",
  527. "seriesOverrides": [],
  528. "spaceLength": 10,
  529. "stack": false,
  530. "steppedLine": false,
  531. "targets": [
  532. {
  533. "format": "time_series",
  534. "group": [],
  535. "metricColumn": "\"qtd\"",
  536. "rawQuery": true,
  537. "rawSql": "SELECT\n\tCOUNT(*),\n ANY_VALUE(data_de_abastecimento) AS \"time\",\n \"qtd\" AS metric\nFROM abastecimentos\nWHERE\n $__timeFilter(ANY_VALUE(data_de_abastecimento))\nGROUP BY Hour(data_de_abastecimento), \n Day(data_de_abastecimento), \n Month(data_de_abastecimento), \n Year(data_de_abastecimento)\nORDER BY ANY_VALUE(data_de_abastecimento)",
  538. "refId": "A",
  539. "select": [
  540. [
  541. {
  542. "params": [
  543. "abastecimentos_id"
  544. ],
  545. "type": "column"
  546. },
  547. {
  548. "params": [
  549. "abastecimentos_id"
  550. ],
  551. "type": "alias"
  552. }
  553. ]
  554. ],
  555. "table": "abastecimentos",
  556. "timeColumn": "data_de_abastecimento",
  557. "timeColumnType": "timestamp",
  558. "where": [
  559. {
  560. "name": "$__timeFilter",
  561. "params": [],
  562. "type": "macro"
  563. }
  564. ]
  565. }
  566. ],
  567. "thresholds": [],
  568. "timeFrom": null,
  569. "timeRegions": [],
  570. "timeShift": null,
  571. "title": "Historico de abastecimentos",
  572. "tooltip": {
  573. "shared": true,
  574. "sort": 0,
  575. "value_type": "individual"
  576. },
  577. "type": "graph",
  578. "xaxis": {
  579. "buckets": null,
  580. "mode": "time",
  581. "name": null,
  582. "show": true,
  583. "values": []
  584. },
  585. "yaxes": [
  586. {
  587. "format": "short",
  588. "label": null,
  589. "logBase": 1,
  590. "max": null,
  591. "min": null,
  592. "show": true
  593. },
  594. {
  595. "format": "short",
  596. "label": null,
  597. "logBase": 1,
  598. "max": null,
  599. "min": null,
  600. "show": true
  601. }
  602. ],
  603. "yaxis": {
  604. "align": false,
  605. "alignLevel": null
  606. }
  607. }
  608. ],
  609. "refresh": false,
  610. "schemaVersion": 20,
  611. "style": "dark",
  612. "tags": [],
  613. "templating": {
  614. "list": []
  615. },
  616. "time": {
  617. "from": "now-1y/y",
  618. "to": "now-1y/y"
  619. },
  620. "timepicker": {
  621. "refresh_intervals": [
  622. "5s",
  623. "10s",
  624. "30s",
  625. "1m",
  626. "5m",
  627. "15m",
  628. "30m",
  629. "1h",
  630. "2h",
  631. "1d"
  632. ]
  633. },
  634. "timezone": "",
  635. "title": "Overview do sistema",
  636. "uid": "JIl22QJZz",
  637. "version": 3
  638. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!