Working JSON Model for Grafana Dashboard for LRO Cosmic Watch Muon Detectors V2 (currently used https://cosmicwatch.astronomy.me.uk 29/6/2025) — 29/6/2025@22:30
{
“annotations”: {
“list”: [
{
“builtIn”: 1,
“datasource”: {
“type”: “datasource”,
“uid”: “grafana”
},
“enable”: true,
“hide”: true,
“iconColor”: “rgba(0, 211, 255, 1)”,
“name”: “Annotations & Alerts”,
“target”: {
“limit”: 100,
“matchAny”: false,
“tags”: [],
“type”: “dashboard”
},
“type”: “dashboard”
}
]
},
“description”: “Basic data analysis”,
“editable”: true,
“fiscalYearStartMonth”: 0,
“graphTooltip”: 2,
“id”: 6,
“links”: [],
“panels”: [
{
“fieldConfig”: {
“defaults”: {},
“overrides”: []
},
“gridPos”: {
“h”: 3,
“w”: 24,
“x”: 0,
“y”: 0
},
“id”: 126,
“options”: {
“code”: {
“language”: “html”,
“showLineNumbers”: false,
“showMiniMap”: false
},
“content”: “This dashboard provides access to summary data from the two Cosmic Watch Muon Detectors housed at Lichfield Radio Observatory (LRO, https://astronomy.me.uk).\r\n\r\nThese detectors were manufactored by the UKRAA and are in coincidence mode, with master sat directly on top of slave and data taken from the slave detector.”,
“mode”: “html”
},
“pluginVersion”: “12.0.2”,
“title”: “Explanation “,
“type”: “text”
},
{
“datasource”: {
“type”: “grafana-postgresql-datasource”,
“uid”: “aeogu4pxwlxc0b”
},
“description”: “”,
“fieldConfig”: {
“defaults”: {
“color”: {
“mode”: “thresholds”
},
“mappings”: [],
“thresholds”: {
“mode”: “absolute”,
“steps”: [
{
“color”: “green”
},
{
“color”: “red”,
“value”: 80
}
]
}
},
“overrides”: []
},
“gridPos”: {
“h”: 4,
“w”: 4,
“x”: 0,
“y”: 3
},
“id”: 2,
“options”: {
“colorMode”: “value”,
“graphMode”: “area”,
“justifyMode”: “auto”,
“orientation”: “auto”,
“percentChangeColorMode”: “standard”,
“reduceOptions”: {
“calcs”: [
“lastNotNull”
],
“fields”: “/^count$/”,
“limit”: 1,
“values”: true
},
“showPercentChange”: false,
“textMode”: “auto”,
“wideLayout”: true
},
“pluginVersion”: “12.0.2”,
“targets”: [
{
“datasource”: {
“type”: “grafana-postgresql-datasource”,
“uid”: “aeogu4pxwlxc0b”
},
“editorMode”: “code”,
“format”: “table”,
“group”: [],
“metricColumn”: “none”,
“rawQuery”: true,
“rawSql”: “SELECT count(event) FROM muon_schema.muon_data_0 “,
“refId”: “A”,
“select”: [
[
{
“params”: [
“sipm”
],
“type”: “column”
}
]
],
“sql”: {
“columns”: [
{
“parameters”: [],
“type”: “function”
}
],
“groupBy”: [
{
“property”: {
“type”: “string”
},
“type”: “groupBy”
}
],
“limit”: 50
},
“table”: “registros”,
“timeColumn”: “fecha”,
“timeColumnType”: “timestamp”,
“where”: [
{
“name”: “$__timeFilter”,
“params”: [],
“type”: “macro”
}
]
}
],
“title”: “Muons detected (USB0)”,
“type”: “stat”
},
{
“datasource”: {
“type”: “grafana-postgresql-datasource”,
“uid”: “aeogu4pxwlxc0b”
},
“description”: “”,
“fieldConfig”: {
“defaults”: {
“color”: {
“mode”: “thresholds”
},
“decimals”: 4,
“mappings”: [],
“max”: 1,
“min”: 0,
“thresholds”: {
“mode”: “absolute”,
“steps”: [
{
“color”: “green”
},
{
“color”: “red”,
“value”: 80
}
]
},
“unit”: “cps”
},
“overrides”: []
},
“gridPos”: {
“h”: 4,
“w”: 4,
“x”: 4,
“y”: 3
},
“id”: 4,
“options”: {
“colorMode”: “value”,
“graphMode”: “none”,
“justifyMode”: “auto”,
“orientation”: “auto”,
“percentChangeColorMode”: “standard”,
“reduceOptions”: {
“calcs”: [
“lastNotNull”
],
“fields”: “”,
“values”: false
},
“showPercentChange”: false,
“textMode”: “auto”,
“wideLayout”: true
},
“pluginVersion”: “12.0.2”,
“targets”: [
{
“datasource”: {
“type”: “grafana-postgresql-datasource”,
“uid”: “aeogu4pxwlxc0b”
},
“editorMode”: “code”,
“format”: “table”,
“group”: [],
“hide”: false,
“metricColumn”: “none”,
“rawQuery”: true,
“rawSql”: “SELECT comp_time, f0 FROM muon_schema.muon_data_0 WHERE f0 <> 0 limit 1”,
“refId”: “A”,
“select”: [
[
{
“params”: [
“sipm”
],
“type”: “column”
}
]
],
“sql”: {
“columns”: [
{
“parameters”: [],
“type”: “function”
}
],
“groupBy”: [
{
“property”: {
“type”: “string”
},
“type”: “groupBy”
}
],
“limit”: 50
},
“table”: “registros”,
“timeColumn”: “fecha”,
“timeColumnType”: “timestamp”,
“where”: [
{
“name”: “$__timeFilter”,
“params”: [],
“type”: “macro”
}
]
},
{
“datasource”: {
“type”: “grafana-postgresql-datasource”,
“uid”: “aeogu4pxwlxc0b”
},
“editorMode”: “code”,
“format”: “table”,
“group”: [],
“hide”: true,
“metricColumn”: “none”,
“rawQuery”: true,
“rawSql”: “SELECT fecha, sqrt(id::float)/(tr/1000::numeric) AS incertidumbre FROM registros order by fecha desc limit 1”,
“refId”: “B”,
“select”: [
[
{
“params”: [
“sipm”
],
“type”: “column”
}
]
],
“sql”: {
“columns”: [
{
“parameters”: [],
“type”: “function”
}
],
“groupBy”: [
{
“property”: {
“type”: “string”
},
“type”: “groupBy”
}
],
“limit”: 50
},
“table”: “registros”,
“timeColumn”: “fecha”,
“timeColumnType”: “timestamp”,
“where”: [
{
“name”: “$__timeFilter”,
“params”: [],
“type”: “macro”
}
]
}
],
“title”: “Muon flux per second (USB0)”,
“type”: “stat”
},
{
“datasource”: {
“type”: “grafana-postgresql-datasource”,
“uid”: “aeogu4pxwlxc0b”
},
“description”: “”,
“fieldConfig”: {
“defaults”: {
“color”: {
“mode”: “thresholds”
},
“decimals”: 1,
“mappings”: [],
“thresholds”: {
“mode”: “absolute”,
“steps”: [
{
“color”: “green”
},
{
“color”: “red”,
“value”: 80
}
]
},
“unit”: “none”
},
“overrides”: []
},
“gridPos”: {
“h”: 4,
“w”: 4,
“x”: 8,
“y”: 3
},
“id”: 6,
“options”: {
“colorMode”: “value”,
“graphMode”: “none”,
“justifyMode”: “auto”,
“orientation”: “auto”,
“percentChangeColorMode”: “standard”,
“reduceOptions”: {
“calcs”: [
“lastNotNull”
],
“fields”: “”,
“values”: false
},
“showPercentChange”: false,
“textMode”: “auto”,
“wideLayout”: true
},
“pluginVersion”: “12.0.2”,
“targets”: [
{
“datasource”: {
“type”: “grafana-postgresql-datasource”,
“uid”: “aeogu4pxwlxc0b”
},
“editorMode”: “code”,
“format”: “table”,
“group”: [],
“metricColumn”: “none”,
“rawQuery”: true,
“rawSql”: “SELECT comp_time, 60*f0 FROM muon_schema.muon_data_0 WHERE f0 <> 0 order by comp_time asc LIMIT 1”,
“refId”: “A”,
“select”: [
[
{
“params”: [
“sipm”
],
“type”: “column”
}
]
],
“sql”: {
“columns”: [
{
“parameters”: [],
“type”: “function”
}
],
“groupBy”: [
{
“property”: {
“type”: “string”
},
“type”: “groupBy”
}
],
“limit”: 50
},
“table”: “registros”,
“timeColumn”: “fecha”,
“timeColumnType”: “timestamp”,
“where”: [
{
“name”: “$__timeFilter”,
“params”: [],
“type”: “macro”
}
]
}
],
“title”: “Muon flux per minute (USB0)”,
“type”: “stat”
},
{
“datasource”: {
“type”: “grafana-postgresql-datasource”,
“uid”: “aeogu4pxwlxc0b”
},
“description”: “”,
“fieldConfig”: {
“defaults”: {
“color”: {
“mode”: “thresholds”
},
“decimals”: 1,
“mappings”: [],
“thresholds”: {
“mode”: “absolute”,
“steps”: [
{
“color”: “green”
},
{
“color”: “red”,
“value”: 80
}
]
},
“unit”: “none”
},
“overrides”: []
},
“gridPos”: {
“h”: 4,
“w”: 4,
“x”: 12,
“y”: 3
},
“id”: 8,
“options”: {
“colorMode”: “value”,
“graphMode”: “none”,
“justifyMode”: “auto”,
“orientation”: “auto”,
“percentChangeColorMode”: “standard”,
“reduceOptions”: {
“calcs”: [
“lastNotNull”
],
“fields”: “”,
“values”: false
},
“showPercentChange”: false,
“textMode”: “auto”,
“wideLayout”: true
},
“pluginVersion”: “12.0.2”,
“targets”: [
{
“datasource”: {
“type”: “grafana-postgresql-datasource”,
“uid”: “aeogu4pxwlxc0b”
},
“editorMode”: “code”,
“format”: “table”,
“group”: [],
“metricColumn”: “none”,
“rawQuery”: true,
“rawSql”: “SELECT comp_time, 3600*f0 FROM muon_schema.muon_data_0 WHERE f0 <> 0 order by comp_time asc LIMIT 1”,
“refId”: “A”,
“select”: [
[
{
“params”: [
“sipm”
],
“type”: “column”
}
]
],
“sql”: {
“columns”: [
{
“parameters”: [],
“type”: “function”
}
],
“groupBy”: [
{
“property”: {
“type”: “string”
},
“type”: “groupBy”
}
],
“limit”: 50
},
“table”: “registros”,
“timeColumn”: “fecha”,
“timeColumnType”: “timestamp”,
“where”: [
{
“name”: “$__timeFilter”,
“params”: [],
“type”: “macro”
}
]
}
],
“title”: “Muon flux per hour (USB0)”,
“type”: “stat”
},
{
“datasource”: {
“type”: “grafana-postgresql-datasource”,
“uid”: “aeogu4pxwlxc0b”
},
“description”: “”,
“fieldConfig”: {
“defaults”: {
“color”: {
“mode”: “thresholds”
},
“decimals”: 1,
“mappings”: [],
“min”: 0,
“thresholds”: {
“mode”: “absolute”,
“steps”: [
{
“color”: “green”
},
{
“color”: “red”,
“value”: 80
}
]
},
“unit”: “mV”
},
“overrides”: []
},
“gridPos”: {
“h”: 4,
“w”: 6,
“x”: 16,
“y”: 3
},
“id”: 22,
“options”: {
“minVizHeight”: 75,
“minVizWidth”: 75,
“orientation”: “auto”,
“reduceOptions”: {
“calcs”: [
“lastNotNull”
],
“fields”: “”,
“values”: false
},
“showThresholdLabels”: false,
“showThresholdMarkers”: true,
“sizing”: “auto”
},
“pluginVersion”: “12.0.2”,
“targets”: [
{
“datasource”: {
“type”: “grafana-postgresql-datasource”,
“uid”: “aeogu4pxwlxc0b”
},
“editorMode”: “code”,
“format”: “table”,
“group”: [],
“hide”: false,
“metricColumn”: “none”,
“rawQuery”: true,
“rawSql”: “SELECT min(sipm) AS min, max(sipm) AS max, avg(sipm) AS average, mode() WITHIN GROUP (ORDER BY sipm) AS mode FROM muon_schema.muon_data_0 “,
“refId”: “A”,
“select”: [
[
{
“params”: [
“sipm”
],
“type”: “column”
}
]
],
“sql”: {
“columns”: [
{
“parameters”: [],
“type”: “function”
}
],
“groupBy”: [
{
“property”: {
“type”: “string”
},
“type”: “groupBy”
}
],
“limit”: 50
},
“table”: “registros”,
“timeColumn”: “fecha”,
“timeColumnType”: “timestamp”,
“where”: [
{
“name”: “$__timeFilter”,
“params”: [],
“type”: “macro”
}
]
}
],
“title”: “SIPM Values (mV) (USB0)”,
“type”: “gauge”
},
{
“datasource”: {
“type”: “grafana-postgresql-datasource”,
“uid”: “aeogu4pxwlxc0b”
},
“fieldConfig”: {
“defaults”: {
“color”: {
“mode”: “thresholds”
},
“mappings”: [],
“thresholds”: {
“mode”: “absolute”,
“steps”: [
{
“color”: “green”
},
{
“color”: “red”,
“value”: 80
}
]
},
“unit”: “celsius”
},
“overrides”: []
},
“gridPos”: {
“h”: 4,
“w”: 2,
“x”: 22,
“y”: 3
},
“id”: 24,
“options”: {
“colorMode”: “value”,
“graphMode”: “none”,
“justifyMode”: “auto”,
“orientation”: “auto”,
“percentChangeColorMode”: “standard”,
“reduceOptions”: {
“calcs”: [
“lastNotNull”
],
“fields”: “/^temp$/”,
“values”: false
},
“showPercentChange”: false,
“textMode”: “auto”,
“wideLayout”: true
},
“pluginVersion”: “12.0.2”,
“targets”: [
{
“datasource”: {
“type”: “grafana-postgresql-datasource”,
“uid”: “aeogu4pxwlxc0b”
},
“editorMode”: “code”,
“format”: “table”,
“group”: [],
“metricColumn”: “none”,
“rawQuery”: true,
“rawSql”: “SELECT temp FROM muon_schema.muon_data_0 order by comp_time desc Limit 1”,
“refId”: “A”,
“select”: [
[
{
“params”: [
“sipm”
],
“type”: “column”
}
]
],
“sql”: {
“columns”: [
{
“parameters”: [],
“type”: “function”
}
],
“groupBy”: [
{
“property”: {
“type”: “string”
},
“type”: “groupBy”
}
],
“limit”: 50
},
“table”: “registros”,
“timeColumn”: “fecha”,
“timeColumnType”: “timestamp”,
“where”: [
{
“name”: “$__timeFilter”,
“params”: [],
“type”: “macro”
}
]
}
],
“title”: “Temp. (USB0)”,
“type”: “stat”
},
{
“datasource”: {
“type”: “grafana-postgresql-datasource”,
“uid”: “aeogu4pxwlxc0b”
},
“description”: “% change in f_0 for usb0/1\n\nf_0 = frecuency last 150 muons\n\n% = (f_0 – avg(f_0))/avg(f_0) x 100 for the period shown\n\nFor OULU (neutrons): The same but with the neutron flux\n”,
“fieldConfig”: {
“defaults”: {
“color”: {
“mode”: “palette-classic”
},
“custom”: {
“axisBorderShow”: false,
“axisCenteredZero”: false,
“axisColorMode”: “text”,
“axisLabel”: “”,
“axisPlacement”: “auto”,
“barAlignment”: 0,
“barWidthFactor”: 0.6,
“drawStyle”: “line”,
“fillOpacity”: 0,
“gradientMode”: “none”,
“hideFrom”: {
“legend”: false,
“tooltip”: false,
“viz”: false
},
“insertNulls”: false,
“lineInterpolation”: “linear”,
“lineWidth”: 1,
“pointSize”: 5,
“scaleDistribution”: {
“type”: “linear”
},
“showPoints”: “auto”,
“spanNulls”: false,
“stacking”: {
“group”: “A”,
“mode”: “none”
},
“thresholdsStyle”: {
“mode”: “off”
}
},
“fieldMinMax”: false,
“mappings”: [],
“thresholds”: {
“mode”: “absolute”,
“steps”: [
{
“color”: “green”
},
{
“color”: “red”,
“value”: 80
}
]
},
“unit”: “%”
},
“overrides”: [
{
“matcher”: {
“id”: “byName”,
“options”: “f0”
},
“properties”: [
{
“id”: “color”,
“value”: {
“fixedColor”: “green”,
“mode”: “fixed”
}
},
{
“id”: “custom.axisPlacement”,
“value”: “auto”
}
]
},
{
“matcher”: {
“id”: “byName”,
“options”: “f1”
},
“properties”: [
{
“id”: “custom.axisPlacement”,
“value”: “right”
}
]
},
{
“matcher”: {
“id”: “byName”,
“options”: “f2”
},
“properties”: [
{
“id”: “custom.axisPlacement”,
“value”: “auto”
}
]
},
{
“matcher”: {
“id”: “byName”,
“options”: “f3”
},
“properties”: [
{
“id”: “custom.axisPlacement”,
“value”: “auto”
}
]
},
{
“matcher”: {
“id”: “byName”,
“options”: “f4”
},
“properties”: [
{
“id”: “custom.axisPlacement”,
“value”: “auto”
}
]
},
{
“matcher”: {
“id”: “byName”,
“options”: “f5”
},
“properties”: [
{
“id”: “custom.axisPlacement”,
“value”: “auto”
},
{
“id”: “color”,
“value”: {
“fixedColor”: “purple”,
“mode”: “fixed”
}
}
]
},
{
“matcher”: {
“id”: “byName”,
“options”: “f0_change”
},
“properties”: [
{
“id”: “color”,
“value”: {
“fixedColor”: “purple”,
“mode”: “fixed”
}
}
]
},
{
“matcher”: {
“id”: “byName”,
“options”: “f1_change”
},
“properties”: [
{
“id”: “color”,
“value”: {
“fixedColor”: “text”,
“mode”: “fixed”
}
}
]
},
{
“matcher”: {
“id”: “byName”,
“options”: “f0_change_usb0”
},
“properties”: [
{
“id”: “color”,
“value”: {
“fixedColor”: “red”,
“mode”: “fixed”
}
}
]
},
{
“matcher”: {
“id”: “byName”,
“options”: “f0_change_usb1”
},
“properties”: [
{
“id”: “color”,
“value”: {
“fixedColor”: “text”,
“mode”: “fixed”
}
}
]
}
]
},
“gridPos”: {
“h”: 10,
“w”: 24,
“x”: 0,
“y”: 7
},
“id”: 119,
“options”: {
“legend”: {
“calcs”: [],
“displayMode”: “list”,
“placement”: “bottom”,
“showLegend”: true
},
“timezone”: [
“utc”
],
“tooltip”: {
“hideZeros”: false,
“mode”: “single”,
“sort”: “none”
}
},
“pluginVersion”: “12.0.2”,
“targets”: [
{
“datasource”: {
“type”: “grafana-postgresql-datasource”,
“uid”: “aeogu4pxwlxc0b”
},
“editorMode”: “code”,
“format”: “table”,
“hide”: false,
“rawQuery”: true,
“rawSql”: “SELECT time_tag AS time, (flux-(SELECT avg(flux) FROM externos.nmdb_neutrones WHERE estacion = ‘OULU’ \r\nAND time_tag > $__timeFrom() AND time_tag < $__timeTo()))*300/((SELECT avg(flux) FROM externos.nmdb_neutrones WHERE estacion = ‘OULU’ \r\nAND time_tag > $__timeFrom() AND time_tag < $__timeTo())) AS flux_change_OULU \r\nFROM externos.nmdb_neutrones\r\nWHERE estacion = ‘OULU’ AND time_tag > $__timeFrom() AND time_tag < $__timeTo() order by time_tag asc\r\n\r\n”,
“refId”: “B”,
“sql”: {
“columns”: [
{
“parameters”: [],
“type”: “function”
}
],
“groupBy”: [
{
“property”: {
“type”: “string”
},
“type”: “groupBy”
}
],
“limit”: 50
}
},
{
“datasource”: {
“type”: “grafana-postgresql-datasource”,
“uid”: “aeogu4pxwlxc0b”
},
“editorMode”: “code”,
“format”: “table”,
“hide”: false,
“rawQuery”: true,
“rawSql”: “WITH v_referencia AS (SELECT avg(f0) AS media FROM muon_schema.muon_data_0 WHERE comp_time > $__timeFrom() AND comp_time < $__timeTo())\r\n\r\nSELECT comp_time AS time, (f0-v_referencia.media)*100/v_referencia.media AS f0_change_usb0 FROM muon_schema.muon_data_0, v_referencia WHERE comp_time > $__timeFrom() AND comp_time < $__timeTo()\r\n”,
“refId”: “C”,
“sql”: {
“columns”: [
{
“parameters”: [],
“type”: “function”
}
],
“groupBy”: [
{
“property”: {
“type”: “string”
},
“type”: “groupBy”
}
],
“limit”: 50
}
},
{
“datasource”: {
“type”: “grafana-postgresql-datasource”,
“uid”: “aeogu4pxwlxc0b”
},
“editorMode”: “code”,
“format”: “table”,
“hide”: false,
“rawQuery”: true,
“rawSql”: “WITH v_referencia AS (SELECT avg(f0) AS media FROM muon_schema.muon_data_1 WHERE comp_time > $__timeFrom() AND comp_time < $__timeTo())\r\n\r\nSELECT comp_time AS time, (f0-v_referencia.media)*100/v_referencia.media AS f0_change_usb1 FROM muon_schema.muon_data_1, v_referencia WHERE comp_time > $__timeFrom() AND comp_time < $__timeTo()\r\n”,
“refId”: “D”,
“sql”: {
“columns”: [
{
“parameters”: [],
“type”: “function”
}
],
“groupBy”: [
{
“property”: {
“type”: “string”
},
“type”: “groupBy”
}
],
“limit”: 50
}
}
],
“title”: “Graph 3: % muons (every 5 minutes) – USB0/USB1”,
“type”: “timeseries”
},
{
“datasource”: {
“type”: “grafana-postgresql-datasource”,
“uid”: “aeogu4pxwlxc0b”
},
“description”: “f_i = (2i+1)/(t_r(+i)-t_r(-i)) —- frecuency of (2i+1) muons\n\nf_0 = 150/(t_r(150 muons)) —- frecuency of (150) muons\n\n\ni – i-th muon ;\nt_r – real time (whitout t_dead)”,
“fieldConfig”: {
“defaults”: {
“color”: {
“mode”: “palette-classic”
},
“custom”: {
“axisBorderShow”: false,
“axisCenteredZero”: false,
“axisColorMode”: “text”,
“axisLabel”: “”,
“axisPlacement”: “auto”,
“barAlignment”: 0,
“barWidthFactor”: 0.6,
“drawStyle”: “line”,
“fillOpacity”: 0,
“gradientMode”: “none”,
“hideFrom”: {
“legend”: false,
“tooltip”: false,
“viz”: false
},
“insertNulls”: false,
“lineInterpolation”: “linear”,
“lineWidth”: 1,
“pointSize”: 5,
“scaleDistribution”: {
“type”: “linear”
},
“showPoints”: “auto”,
“spanNulls”: false,
“stacking”: {
“group”: “A”,
“mode”: “none”
},
“thresholdsStyle”: {
“mode”: “off”
}
},
“fieldMinMax”: false,
“mappings”: [],
“thresholds”: {
“mode”: “absolute”,
“steps”: [
{
“color”: “green”
},
{
“color”: “red”,
“value”: 80
}
]
},
“unit”: “rothz”
},
“overrides”: [
{
“matcher”: {
“id”: “byName”,
“options”: “f0”
},
“properties”: [
{
“id”: “color”,
“value”: {
“fixedColor”: “green”,
“mode”: “fixed”
}
},
{
“id”: “custom.axisPlacement”,
“value”: “auto”
}
]
},
{
“matcher”: {
“id”: “byName”,
“options”: “f1”
},
“properties”: [
{
“id”: “custom.axisPlacement”,
“value”: “right”
}
]
},
{
“matcher”: {
“id”: “byName”,
“options”: “f2”
},
“properties”: [
{
“id”: “custom.axisPlacement”,
“value”: “auto”
}
]
},
{
“matcher”: {
“id”: “byName”,
“options”: “f3”
},
“properties”: [
{
“id”: “custom.axisPlacement”,
“value”: “auto”
}
]
},
{
“matcher”: {
“id”: “byName”,
“options”: “f4”
},
“properties”: [
{
“id”: “custom.axisPlacement”,
“value”: “auto”
}
]
},
{
“matcher”: {
“id”: “byName”,
“options”: “f5”
},
“properties”: [
{
“id”: “custom.axisPlacement”,
“value”: “auto”
},
{
“id”: “color”,
“value”: {
“fixedColor”: “purple”,
“mode”: “fixed”
}
}
]
}
]
},
“gridPos”: {
“h”: 10,
“w”: 24,
“x”: 0,
“y”: 17
},
“id”: 111,
“options”: {
“legend”: {
“calcs”: [],
“displayMode”: “list”,
“placement”: “bottom”,
“showLegend”: true
},
“timezone”: [
“utc”
],
“tooltip”: {
“hideZeros”: false,
“mode”: “single”,
“sort”: “none”
}
},
“pluginVersion”: “12.0.2”,
“targets”: [
{
“datasource”: {
“type”: “grafana-postgresql-datasource”,
“uid”: “aeogu4pxwlxc0b”
},
“editorMode”: “code”,
“format”: “time_series”,
“group”: [],
“hide”: false,
“metricColumn”: “none”,
“rawQuery”: true,
“rawSql”: “SELECT comp_time AS time, f0 FROM muon_schema.muon_data_0 WHERE comp_time > $__timeFrom() AND comp_time < $__timeTo()”,
“refId”: “A”,
“select”: [
[
{
“params”: [
“sipm”
],
“type”: “column”
}
]
],
“sql”: {
“columns”: [
{
“parameters”: [],
“type”: “function”
}
],
“groupBy”: [
{
“property”: {
“type”: “string”
},
“type”: “groupBy”
}
],
“limit”: 50
},
“table”: “registros”,
“timeColumn”: “fecha”,
“timeColumnType”: “timestamp”,
“where”: [
{
“name”: “$__timeFilter”,
“params”: [],
“type”: “macro”
}
]
},
{
“datasource”: {
“type”: “grafana-postgresql-datasource”,
“uid”: “aeogu4pxwlxc0b”
},
“editorMode”: “code”,
“format”: “time_series”,
“group”: [],
“hide”: false,
“metricColumn”: “none”,
“rawQuery”: true,
“rawSql”: “SELECT comp_time AS time, f1 FROM muon_schema.muon_data_0 WHERE comp_time > $__timeFrom() AND comp_time < $__timeTo()”,
“refId”: “B”,
“select”: [
[
{
“params”: [
“sipm”
],
“type”: “column”
}
]
],
“sql”: {
“columns”: [
{
“parameters”: [],
“type”: “function”
}
],
“groupBy”: [
{
“property”: {
“type”: “string”
},
“type”: “groupBy”
}
],
“limit”: 50
},
“table”: “registros”,
“timeColumn”: “fecha”,
“timeColumnType”: “timestamp”,
“where”: [
{
“name”: “$__timeFilter”,
“params”: [],
“type”: “macro”
}
]
},
{
“datasource”: {
“type”: “grafana-postgresql-datasource”,
“uid”: “aeogu4pxwlxc0b”
},
“editorMode”: “code”,
“format”: “time_series”,
“group”: [],
“hide”: false,
“metricColumn”: “none”,
“rawQuery”: true,
“rawSql”: “SELECT comp_time AS time, f2 FROM muon_schema.muon_data_0 WHERE comp_time > $__timeFrom() AND comp_time < $__timeTo()”,
“refId”: “C”,
“select”: [
[
{
“params”: [
“sipm”
],
“type”: “column”
}
]
],
“sql”: {
“columns”: [
{
“parameters”: [],
“type”: “function”
}
],
“groupBy”: [
{
“property”: {
“type”: “string”
},
“type”: “groupBy”
}
],
“limit”: 50
},
“table”: “registros”,
“timeColumn”: “fecha”,
“timeColumnType”: “timestamp”,
“where”: [
{
“name”: “$__timeFilter”,
“params”: [],
“type”: “macro”
}
]
},
{
“datasource”: {
“type”: “grafana-postgresql-datasource”,
“uid”: “aeogu4pxwlxc0b”
},
“editorMode”: “code”,
“format”: “time_series”,
“group”: [],
“hide”: false,
“metricColumn”: “none”,
“rawQuery”: true,
“rawSql”: “SELECT comp_time AS time, f3 FROM muon_schema.muon_data_0 WHERE comp_time > $__timeFrom() AND comp_time < $__timeTo()”,
“refId”: “D”,
“select”: [
[
{
“params”: [
“sipm”
],
“type”: “column”
}
]
],
“sql”: {
“columns”: [
{
“parameters”: [],
“type”: “function”
}
],
“groupBy”: [
{
“property”: {
“type”: “string”
},
“type”: “groupBy”
}
],
“limit”: 50
},
“table”: “registros”,
“timeColumn”: “fecha”,
“timeColumnType”: “timestamp”,
“where”: [
{
“name”: “$__timeFilter”,
“params”: [],
“type”: “macro”
}
]
},
{
“datasource”: {
“type”: “grafana-postgresql-datasource”,
“uid”: “aeogu4pxwlxc0b”
},
“editorMode”: “code”,
“format”: “time_series”,
“group”: [],
“hide”: false,
“metricColumn”: “none”,
“rawQuery”: true,
“rawSql”: “SELECT comp_time AS time, f4 FROM muon_schema.muon_data_0 WHERE comp_time > $__timeFrom() AND comp_time < $__timeTo()”,
“refId”: “E”,
“select”: [
[
{
“params”: [
“sipm”
],
“type”: “column”
}
]
],
“sql”: {
“columns”: [
{
“parameters”: [],
“type”: “function”
}
],
“groupBy”: [
{
“property”: {
“type”: “string”
},
“type”: “groupBy”
}
],
“limit”: 50
},
“table”: “registros”,
“timeColumn”: “fecha”,
“timeColumnType”: “timestamp”,
“where”: [
{
“name”: “$__timeFilter”,
“params”: [],
“type”: “macro”
}
]
},
{
“datasource”: {
“type”: “grafana-postgresql-datasource”,
“uid”: “aeogu4pxwlxc0b”
},
“editorMode”: “code”,
“format”: “time_series”,
“group”: [],
“hide”: false,
“metricColumn”: “none”,
“rawQuery”: true,
“rawSql”: “SELECT comp_time AS time, f5 FROM muon_schema.muon_data_0 WHERE comp_time > $__timeFrom() AND comp_time < $__timeTo()”,
“refId”: “F”,
“select”: [
[
{
“params”: [
“sipm”
],
“type”: “column”
}
]
],
“sql”: {
“columns”: [
{
“parameters”: [],
“type”: “function”
}
],
“groupBy”: [
{
“property”: {
“type”: “string”
},
“type”: “groupBy”
}
],
“limit”: 50
},
“table”: “registros”,
“timeColumn”: “fecha”,
“timeColumnType”: “timestamp”,
“where”: [
{
“name”: “$__timeFilter”,
“params”: [],
“type”: “macro”
}
]
}
],
“title”: “Graph 4: Muon frecuency – USB0”,
“type”: “timeseries”
},
{
“datasource”: {
“type”: “grafana-postgresql-datasource”,
“uid”: “aeogu4pxwlxc0b”
},
“description”: “Anomaly in f_j if f_j > 4f_0 —\n\nstatus 1 -> 1 anomaly\n\n…………..\n\nstatus 5 -> 5 anomalies -> f_1, …, f_5 > f 4f_0”,
“fieldConfig”: {
“defaults”: {
“color”: {
“mode”: “palette-classic”
},
“custom”: {
“axisBorderShow”: false,
“axisCenteredZero”: false,
“axisColorMode”: “text”,
“axisLabel”: “”,
“axisPlacement”: “auto”,
“barAlignment”: 0,
“barWidthFactor”: 0.6,
“drawStyle”: “points”,
“fillOpacity”: 0,
“gradientMode”: “none”,
“hideFrom”: {
“legend”: false,
“tooltip”: false,
“viz”: false
},
“insertNulls”: false,
“lineInterpolation”: “linear”,
“lineWidth”: 1,
“pointSize”: 5,
“scaleDistribution”: {
“type”: “linear”
},
“showPoints”: “auto”,
“spanNulls”: false,
“stacking”: {
“group”: “A”,
“mode”: “none”
},
“thresholdsStyle”: {
“mode”: “off”
}
},
“decimals”: 0,
“fieldMinMax”: false,
“mappings”: [],
“thresholds”: {
“mode”: “absolute”,
“steps”: [
{
“color”: “green”
},
{
“color”: “red”,
“value”: 80
}
]
},
“unit”: “none”
},
“overrides”: []
},
“gridPos”: {
“h”: 10,
“w”: 24,
“x”: 0,
“y”: 27
},
“id”: 89,
“options”: {
“legend”: {
“calcs”: [],
“displayMode”: “list”,
“placement”: “bottom”,
“showLegend”: true
},
“timezone”: [
“utc”
],
“tooltip”: {
“hideZeros”: false,
“mode”: “single”,
“sort”: “none”
}
},
“pluginVersion”: “12.0.2”,
“targets”: [
{
“datasource”: {
“type”: “grafana-postgresql-datasource”,
“uid”: “aeogu4pxwlxc0b”
},
“editorMode”: “code”,
“format”: “time_series”,
“group”: [],
“hide”: false,
“metricColumn”: “none”,
“rawQuery”: true,
“rawSql”: “SELECT comp_time AS time, status AS status2 FROM muon_schema.muon_data_0 WHERE status = 2 AND comp_time > $__timeFrom() AND comp_time < $__timeTo()”,
“refId”: “A”,
“select”: [
[
{
“params”: [
“sipm”
],
“type”: “column”
}
]
],
“sql”: {
“columns”: [
{
“parameters”: [],
“type”: “function”
}
],
“groupBy”: [
{
“property”: {
“type”: “string”
},
“type”: “groupBy”
}
],
“limit”: 50
},
“table”: “registros”,
“timeColumn”: “fecha”,
“timeColumnType”: “timestamp”,
“where”: [
{
“name”: “$__timeFilter”,
“params”: [],
“type”: “macro”
}
]
},
{
“datasource”: {
“type”: “grafana-postgresql-datasource”,
“uid”: “aeogu4pxwlxc0b”
},
“editorMode”: “code”,
“format”: “time_series”,
“group”: [],
“hide”: false,
“metricColumn”: “none”,
“rawQuery”: true,
“rawSql”: “SELECT comp_time AS time, status AS status3 FROM muon_schema.muon_data_0 WHERE status = 3 AND comp_time > $__timeFrom() AND comp_time < $__timeTo()”,
“refId”: “B”,
“select”: [
[
{
“params”: [
“sipm”
],
“type”: “column”
}
]
],
“sql”: {
“columns”: [
{
“parameters”: [],
“type”: “function”
}
],
“groupBy”: [
{
“property”: {
“type”: “string”
},
“type”: “groupBy”
}
],
“limit”: 50
},
“table”: “registros”,
“timeColumn”: “fecha”,
“timeColumnType”: “timestamp”,
“where”: [
{
“name”: “$__timeFilter”,
“params”: [],
“type”: “macro”
}
]
},
{
“datasource”: {
“type”: “grafana-postgresql-datasource”,
“uid”: “aeogu4pxwlxc0b”
},
“editorMode”: “code”,
“format”: “time_series”,
“group”: [],
“hide”: false,
“metricColumn”: “none”,
“rawQuery”: true,
“rawSql”: “SELECT comp_time AS time, status AS status4 FROM muon_schema.muon_data_0 WHERE status = 4 AND comp_time > $__timeFrom() AND comp_time < $__timeTo()”,
“refId”: “C”,
“select”: [
[
{
“params”: [
“sipm”
],
“type”: “column”
}
]
],
“sql”: {
“columns”: [
{
“parameters”: [],
“type”: “function”
}
],
“groupBy”: [
{
“property”: {
“type”: “string”
},
“type”: “groupBy”
}
],
“limit”: 50
},
“table”: “registros”,
“timeColumn”: “fecha”,
“timeColumnType”: “timestamp”,
“where”: [
{
“name”: “$__timeFilter”,
“params”: [],
“type”: “macro”
}
]
},
{
“datasource”: {
“type”: “grafana-postgresql-datasource”,
“uid”: “aeogu4pxwlxc0b”
},
“editorMode”: “code”,
“format”: “time_series”,
“group”: [],
“hide”: false,
“metricColumn”: “none”,
“rawQuery”: true,
“rawSql”: “SELECT comp_time AS time, status AS status5 FROM muon_schema.muon_data_0 WHERE status = 5 AND comp_time > $__timeFrom() AND comp_time < $__timeTo()”,
“refId”: “D”,
“select”: [
[
{
“params”: [
“sipm”
],
“type”: “column”
}
]
],
“sql”: {
“columns”: [
{
“parameters”: [],
“type”: “function”
}
],
“groupBy”: [
{
“property”: {
“type”: “string”
},
“type”: “groupBy”
}
],
“limit”: 50
},
“table”: “registros”,
“timeColumn”: “fecha”,
“timeColumnType”: “timestamp”,
“where”: [
{
“name”: “$__timeFilter”,
“params”: [],
“type”: “macro”
}
]
}
],
“title”: “Graph 4 bis: Muon frecuency Status – USB0”,
“type”: “timeseries”
},
{
“datasource”: {
“type”: “grafana-postgresql-datasource”,
“uid”: “aeogu4pxwlxc0b”
},
“fieldConfig”: {
“defaults”: {
“color”: {
“mode”: “thresholds”
},
“mappings”: [],
“thresholds”: {
“mode”: “absolute”,
“steps”: [
{
“color”: “green”
},
{
“color”: “red”,
“value”: 80
}
]
},
“unit”: “rothz”
},
“overrides”: []
},
“gridPos”: {
“h”: 3,
“w”: 24,
“x”: 0,
“y”: 37
},
“id”: 96,
“options”: {
“colorMode”: “value”,
“graphMode”: “area”,
“justifyMode”: “auto”,
“orientation”: “auto”,
“percentChangeColorMode”: “standard”,
“reduceOptions”: {
“calcs”: [
“lastNotNull”
],
“fields”: “”,
“values”: false
},
“showPercentChange”: false,
“textMode”: “auto”,
“wideLayout”: true
},
“pluginVersion”: “12.0.2”,
“targets”: [
{
“datasource”: {
“type”: “grafana-postgresql-datasource”,
“uid”: “aeogu4pxwlxc0b”
},
“editorMode”: “code”,
“format”: “table”,
“rawQuery”: true,
“rawSql”: “SELECT max(f1) AS f1_max FROM muon_schema.muon_data_0 “,
“refId”: “A”,
“sql”: {
“columns”: [
{
“parameters”: [],
“type”: “function”
}
],
“groupBy”: [
{
“property”: {
“type”: “string”
},
“type”: “groupBy”
}
],
“limit”: 50
}
},
{
“datasource”: {
“type”: “grafana-postgresql-datasource”,
“uid”: “aeogu4pxwlxc0b”
},
“editorMode”: “code”,
“format”: “table”,
“hide”: false,
“rawQuery”: true,
“rawSql”: “SELECT max(f2) AS f2_max FROM muon_schema.muon_data_0 “,
“refId”: “B”,
“sql”: {
“columns”: [
{
“parameters”: [],
“type”: “function”
}
],
“groupBy”: [
{
“property”: {
“type”: “string”
},
“type”: “groupBy”
}
],
“limit”: 50
}
},
{
“datasource”: {
“type”: “grafana-postgresql-datasource”,
“uid”: “aeogu4pxwlxc0b”
},
“editorMode”: “code”,
“format”: “table”,
“hide”: false,
“rawQuery”: true,
“rawSql”: “SELECT max(f3) AS f3_max FROM muon_schema.muon_data_0 “,
“refId”: “C”,
“sql”: {
“columns”: [
{
“parameters”: [],
“type”: “function”
}
],
“groupBy”: [
{
“property”: {
“type”: “string”
},
“type”: “groupBy”
}
],
“limit”: 50
}
},
{
“datasource”: {
“type”: “grafana-postgresql-datasource”,
“uid”: “aeogu4pxwlxc0b”
},
“editorMode”: “code”,
“format”: “table”,
“hide”: false,
“rawQuery”: true,
“rawSql”: “SELECT max(f4) AS f4_max FROM muon_schema.muon_data_0 “,
“refId”: “D”,
“sql”: {
“columns”: [
{
“parameters”: [],
“type”: “function”
}
],
“groupBy”: [
{
“property”: {
“type”: “string”
},
“type”: “groupBy”
}
],
“limit”: 50
}
},
{
“datasource”: {
“type”: “grafana-postgresql-datasource”,
“uid”: “aeogu4pxwlxc0b”
},
“editorMode”: “code”,
“format”: “table”,
“hide”: false,
“rawQuery”: true,
“rawSql”: “SELECT max(f5) AS f5_max FROM muon_schema.muon_data_0 “,
“refId”: “E”,
“sql”: {
“columns”: [
{
“parameters”: [],
“type”: “function”
}
],
“groupBy”: [
{
“property”: {
“type”: “string”
},
“type”: “groupBy”
}
],
“limit”: 50
}
},
{
“datasource”: {
“type”: “grafana-postgresql-datasource”,
“uid”: “aeogu4pxwlxc0b”
},
“editorMode”: “code”,
“format”: “table”,
“hide”: false,
“rawQuery”: true,
“rawSql”: “SELECT max(f0) AS f0_max FROM muon_schema.muon_data_0 “,
“refId”: “F”,
“sql”: {
“columns”: [
{
“parameters”: [],
“type”: “function”
}
],
“groupBy”: [
{
“property”: {
“type”: “string”
},
“type”: “groupBy”
}
],
“limit”: 50
}
}
],
“title”: “Maximum frequencies detected on USB0 channel”,
“type”: “stat”
},
{
“datasource”: {
“type”: “grafana-postgresql-datasource”,
“uid”: “aeogu4pxwlxc0b”
},
“fieldConfig”: {
“defaults”: {
“color”: {
“mode”: “thresholds”
},
“mappings”: [],
“thresholds”: {
“mode”: “absolute”,
“steps”: [
{
“color”: “green”
},
{
“color”: “red”,
“value”: 80
}
]
},
“unit”: “rothz”
},
“overrides”: []
},
“gridPos”: {
“h”: 3,
“w”: 24,
“x”: 0,
“y”: 40
},
“id”: 98,
“options”: {
“colorMode”: “value”,
“graphMode”: “area”,
“justifyMode”: “auto”,
“orientation”: “auto”,
“percentChangeColorMode”: “standard”,
“reduceOptions”: {
“calcs”: [
“lastNotNull”
],
“fields”: “”,
“values”: false
},
“showPercentChange”: false,
“textMode”: “auto”,
“wideLayout”: true
},
“pluginVersion”: “12.0.2”,
“targets”: [
{
“datasource”: {
“type”: “grafana-postgresql-datasource”,
“uid”: “aeogu4pxwlxc0b”
},
“editorMode”: “code”,
“format”: “table”,
“rawQuery”: true,
“rawSql”: “SELECT avg(f1) AS f1_avg FROM muon_schema.muon_data_0 “,
“refId”: “A”,
“sql”: {
“columns”: [
{
“parameters”: [],
“type”: “function”
}
],
“groupBy”: [
{
“property”: {
“type”: “string”
},
“type”: “groupBy”
}
],
“limit”: 50
}
},
{
“datasource”: {
“type”: “grafana-postgresql-datasource”,
“uid”: “aeogu4pxwlxc0b”
},
“editorMode”: “code”,
“format”: “table”,
“hide”: false,
“rawQuery”: true,
“rawSql”: “SELECT avg(f2) AS f2_avg FROM muon_schema.muon_data_0 “,
“refId”: “B”,
“sql”: {
“columns”: [
{
“parameters”: [],
“type”: “function”
}
],
“groupBy”: [
{
“property”: {
“type”: “string”
},
“type”: “groupBy”
}
],
“limit”: 50
}
},
{
“datasource”: {
“type”: “grafana-postgresql-datasource”,
“uid”: “aeogu4pxwlxc0b”
},
“editorMode”: “code”,
“format”: “table”,
“hide”: false,
“rawQuery”: true,
“rawSql”: “SELECT avg(f3) AS f3_avg FROM muon_schema.muon_data_0 “,
“refId”: “C”,
“sql”: {
“columns”: [
{
“parameters”: [],
“type”: “function”
}
],
“groupBy”: [
{
“property”: {
“type”: “string”
},
“type”: “groupBy”
}
],
“limit”: 50
}
},
{
“datasource”: {
“type”: “grafana-postgresql-datasource”,
“uid”: “aeogu4pxwlxc0b”
},
“editorMode”: “code”,
“format”: “table”,
“hide”: false,
“rawQuery”: true,
“rawSql”: “SELECT avg(f4) AS f4_avg FROM muon_schema.muon_data_0 “,
“refId”: “D”,
“sql”: {
“columns”: [
{
“parameters”: [],
“type”: “function”
}
],
“groupBy”: [
{
“property”: {
“type”: “string”
},
“type”: “groupBy”
}
],
“limit”: 50
}
},
{
“datasource”: {
“type”: “grafana-postgresql-datasource”,
“uid”: “aeogu4pxwlxc0b”
},
“editorMode”: “code”,
“format”: “table”,
“hide”: false,
“rawQuery”: true,
“rawSql”: “SELECT avg(f5) AS f5_avg FROM muon_schema.muon_data_0 “,
“refId”: “E”,
“sql”: {
“columns”: [
{
“parameters”: [],
“type”: “function”
}
],
“groupBy”: [
{
“property”: {
“type”: “string”
},
“type”: “groupBy”
}
],
“limit”: 50
}
},
{
“datasource”: {
“type”: “grafana-postgresql-datasource”,
“uid”: “aeogu4pxwlxc0b”
},
“editorMode”: “code”,
“format”: “table”,
“hide”: false,
“rawQuery”: true,
“rawSql”: “SELECT avg(f0) AS f0_avg FROM muon_schema.muon_data_0 “,
“refId”: “F”,
“sql”: {
“columns”: [
{
“parameters”: [],
“type”: “function”
}
],
“groupBy”: [
{
“property”: {
“type”: “string”
},
“type”: “groupBy”
}
],
“limit”: 50
}
}
],
“title”: “Average frequencies detected on USB0 channel”,
“type”: “stat”
},
{
“datasource”: {
“type”: “grafana-postgresql-datasource”,
“uid”: “aeogu4pxwlxc0b”
},
“fieldConfig”: {
“defaults”: {
“color”: {
“mode”: “thresholds”
},
“mappings”: [],
“thresholds”: {
“mode”: “absolute”,
“steps”: [
{
“color”: “green”
},
{
“color”: “red”,
“value”: 80
}
]
},
“unit”: “rothz”
},
“overrides”: []
},
“gridPos”: {
“h”: 3,
“w”: 24,
“x”: 0,
“y”: 43
},
“id”: 99,
“options”: {
“colorMode”: “value”,
“graphMode”: “area”,
“justifyMode”: “auto”,
“orientation”: “auto”,
“percentChangeColorMode”: “standard”,
“reduceOptions”: {
“calcs”: [
“lastNotNull”
],
“fields”: “”,
“values”: false
},
“showPercentChange”: false,
“textMode”: “auto”,
“wideLayout”: true
},
“pluginVersion”: “12.0.2”,
“targets”: [
{
“datasource”: {
“type”: “grafana-postgresql-datasource”,
“uid”: “aeogu4pxwlxc0b”
},
“editorMode”: “code”,
“format”: “table”,
“rawQuery”: true,
“rawSql”: “SELECT min(f1) AS f1_min FROM muon_schema.muon_data_0 “,
“refId”: “A”,
“sql”: {
“columns”: [
{
“parameters”: [],
“type”: “function”
}
],
“groupBy”: [
{
“property”: {
“type”: “string”
},
“type”: “groupBy”
}
],
“limit”: 50
}
},
{
“datasource”: {
“type”: “grafana-postgresql-datasource”,
“uid”: “aeogu4pxwlxc0b”
},
“editorMode”: “code”,
“format”: “table”,
“hide”: false,
“rawQuery”: true,
“rawSql”: “SELECT min(f2) AS f2_min FROM muon_schema.muon_data_0 “,
“refId”: “B”,
“sql”: {
“columns”: [
{
“parameters”: [],
“type”: “function”
}
],
“groupBy”: [
{
“property”: {
“type”: “string”
},
“type”: “groupBy”
}
],
“limit”: 50
}
},
{
“datasource”: {
“type”: “grafana-postgresql-datasource”,
“uid”: “aeogu4pxwlxc0b”
},
“editorMode”: “code”,
“format”: “table”,
“hide”: false,
“rawQuery”: true,
“rawSql”: “SELECT min(f3) AS f3_min FROM muon_schema.muon_data_0 “,
“refId”: “C”,
“sql”: {
“columns”: [
{
“parameters”: [],
“type”: “function”
}
],
“groupBy”: [
{
“property”: {
“type”: “string”
},
“type”: “groupBy”
}
],
“limit”: 50
}
},
{
“datasource”: {
“type”: “grafana-postgresql-datasource”,
“uid”: “aeogu4pxwlxc0b”
},
“editorMode”: “code”,
“format”: “table”,
“hide”: false,
“rawQuery”: true,
“rawSql”: “SELECT min(f4) AS f4_min FROM muon_schema.muon_data_0 “,
“refId”: “D”,
“sql”: {
“columns”: [
{
“parameters”: [],
“type”: “function”
}
],
“groupBy”: [
{
“property”: {
“type”: “string”
},
“type”: “groupBy”
}
],
“limit”: 50
}
},
{
“datasource”: {
“type”: “grafana-postgresql-datasource”,
“uid”: “aeogu4pxwlxc0b”
},
“editorMode”: “code”,
“format”: “table”,
“hide”: false,
“rawQuery”: true,
“rawSql”: “SELECT min(f5) AS f5_min FROM muon_schema.muon_data_0 “,
“refId”: “E”,
“sql”: {
“columns”: [
{
“parameters”: [],
“type”: “function”
}
],
“groupBy”: [
{
“property”: {
“type”: “string”
},
“type”: “groupBy”
}
],
“limit”: 50
}
},
{
“datasource”: {
“type”: “grafana-postgresql-datasource”,
“uid”: “aeogu4pxwlxc0b”
},
“editorMode”: “code”,
“format”: “table”,
“hide”: false,
“rawQuery”: true,
“rawSql”: “SELECT min(f0) AS f0_min FROM muon_schema.muon_data_0 “,
“refId”: “F”,
“sql”: {
“columns”: [
{
“parameters”: [],
“type”: “function”
}
],
“groupBy”: [
{
“property”: {
“type”: “string”
},
“type”: “groupBy”
}
],
“limit”: 50
}
}
],
“title”: “Minimum frequencies detected on USB0 channel”,
“type”: “stat”
},
{
“datasource”: {
“type”: “grafana-postgresql-datasource”,
“uid”: “aeogu4pxwlxc0b”
},
“description”: “Use Canal and Frecuencia and Frecuencia máxima (above)”,
“fieldConfig”: {
“defaults”: {
“color”: {
“mode”: “palette-classic”
},
“custom”: {
“axisBorderShow”: false,
“axisCenteredZero”: false,
“axisColorMode”: “text”,
“axisLabel”: “”,
“axisPlacement”: “auto”,
“barAlignment”: 0,
“barWidthFactor”: 0.6,
“drawStyle”: “points”,
“fillOpacity”: 0,
“gradientMode”: “none”,
“hideFrom”: {
“legend”: false,
“tooltip”: false,
“viz”: false
},
“insertNulls”: false,
“lineInterpolation”: “linear”,
“lineWidth”: 1,
“pointSize”: 5,
“scaleDistribution”: {
“type”: “linear”
},
“showPoints”: “auto”,
“spanNulls”: false,
“stacking”: {
“group”: “A”,
“mode”: “none”
},
“thresholdsStyle”: {
“mode”: “off”
}
},
“fieldMinMax”: false,
“mappings”: [],
“thresholds”: {
“mode”: “absolute”,
“steps”: [
{
“color”: “green”
},
{
“color”: “red”,
“value”: 80
}
]
},
“unit”: “rothz”
},
“overrides”: [
{
“matcher”: {
“id”: “byName”,
“options”: “f5”
},
“properties”: [
{
“id”: “color”,
“value”: {
“fixedColor”: “purple”,
“mode”: “fixed”
}
}
]
}
]
},
“gridPos”: {
“h”: 10,
“w”: 24,
“x”: 0,
“y”: 46
},
“id”: 102,
“options”: {
“legend”: {
“calcs”: [],
“displayMode”: “list”,
“placement”: “bottom”,
“showLegend”: true
},
“timezone”: [
“utc”
],
“tooltip”: {
“hideZeros”: false,
“mode”: “single”,
“sort”: “none”
}
},
“pluginVersion”: “12.0.2”,
“targets”: [
{
“datasource”: {
“type”: “grafana-postgresql-datasource”,
“uid”: “aeogu4pxwlxc0b”
},
“editorMode”: “code”,
“format”: “time_series”,
“group”: [],
“hide”: false,
“metricColumn”: “none”,
“rawQuery”: true,
“rawSql”: “SELECT comp_time AS time, $Frecuencia FROM $Canal WHERE $Frecuencia > $fr_max AND comp_time > $__timeFrom() AND comp_time < $__timeTo()”,
“refId”: “A”,
“select”: [
[
{
“params”: [
“sipm”
],
“type”: “column”
}
]
],
“sql”: {
“columns”: [
{
“parameters”: [],
“type”: “function”
}
],
“groupBy”: [
{
“property”: {
“type”: “string”
},
“type”: “groupBy”
}
],
“limit”: 50
},
“table”: “registros”,
“timeColumn”: “fecha”,
“timeColumnType”: “timestamp”,
“where”: [
{
“name”: “$__timeFilter”,
“params”: [],
“type”: “macro”
}
]
}
],
“title”: “Graph 6: Peak frequency finder on channel X”,
“type”: “timeseries”
},
{
“datasource”: {
“type”: “grafana-postgresql-datasource”,
“uid”: “aeogu4pxwlxc0b”
},
“fieldConfig”: {
“defaults”: {
“color”: {
“mode”: “palette-classic”
},
“custom”: {
“fillOpacity”: 17,
“gradientMode”: “opacity”,
“hideFrom”: {
“legend”: false,
“tooltip”: false,
“viz”: false
},
“lineWidth”: 1,
“stacking”: {
“group”: “A”,
“mode”: “none”
}
},
“mappings”: [],
“thresholds”: {
“mode”: “absolute”,
“steps”: [
{
“color”: “green”
},
{
“color”: “red”,
“value”: 80
}
]
}
},
“overrides”: []
},
“gridPos”: {
“h”: 9,
“w”: 24,
“x”: 0,
“y”: 56
},
“id”: 103,
“options”: {
“bucketSize”: 1,
“combine”: false,
“legend”: {
“calcs”: [],
“displayMode”: “list”,
“placement”: “bottom”,
“showLegend”: true
},
“tooltip”: {
“hideZeros”: false,
“mode”: “single”,
“sort”: “none”
}
},
“pluginVersion”: “12.0.2”,
“targets”: [
{
“datasource”: {
“type”: “grafana-postgresql-datasource”,
“uid”: “aeogu4pxwlxc0b”
},
“editorMode”: “code”,
“format”: “table”,
“hide”: false,
“rawQuery”: true,
“rawSql”: “SELECT sipm AS sipm_0 FROM muon_schema.muon_data_0 WHERE sipm <1000”,
“refId”: “E”,
“sql”: {
“columns”: [
{
“parameters”: [],
“type”: “function”
}
],
“groupBy”: [
{
“property”: {
“type”: “string”
},
“type”: “groupBy”
}
],
“limit”: 50
}
},
{
“datasource”: {
“type”: “grafana-postgresql-datasource”,
“uid”: “aeogu4pxwlxc0b”
},
“editorMode”: “code”,
“format”: “table”,
“hide”: false,
“rawQuery”: true,
“rawSql”: “SELECT sipm AS sipm_1 FROM muon_schema.muon_data_1 WHERE sipm <1000”,
“refId”: “A”,
“sql”: {
“columns”: [
{
“parameters”: [],
“type”: “function”
}
],
“groupBy”: [
{
“property”: {
“type”: “string”
},
“type”: “groupBy”
}
],
“limit”: 50
}
}
],
“title”: “SIPM histogram (mV)”,
“type”: “histogram”
},
{
“datasource”: {
“type”: “grafana-postgresql-datasource”,
“uid”: “aeogu4pxwlxc0b”
},
“description”: “We estimate 80.1 mV (mode) equiv. 1 cm”,
“fieldConfig”: {
“defaults”: {
“color”: {
“mode”: “palette-classic”
},
“custom”: {
“fillOpacity”: 17,
“gradientMode”: “opacity”,
“hideFrom”: {
“legend”: false,
“tooltip”: false,
“viz”: false
},
“lineWidth”: 1,
“stacking”: {
“group”: “A”,
“mode”: “none”
}
},
“mappings”: [],
“thresholds”: {
“mode”: “absolute”,
“steps”: [
{
“color”: “green”
},
{
“color”: “red”,
“value”: 80
}
]
}
},
“overrides”: []
},
“gridPos”: {
“h”: 9,
“w”: 24,
“x”: 0,
“y”: 65
},
“id”: 114,
“options”: {
“bucketSize”: 0.01,
“combine”: false,
“legend”: {
“calcs”: [],
“displayMode”: “list”,
“placement”: “bottom”,
“showLegend”: true
},
“tooltip”: {
“hideZeros”: false,
“mode”: “single”,
“sort”: “none”
}
},
“pluginVersion”: “12.0.2”,
“targets”: [
{
“datasource”: {
“type”: “grafana-postgresql-datasource”,
“uid”: “aeogu4pxwlxc0b”
},
“editorMode”: “code”,
“format”: “table”,
“hide”: false,
“rawQuery”: true,
“rawSql”: “SELECT sipm/80.1 AS d_0 FROM muon_schema.muon_data_0 WHERE sipm <1000”,
“refId”: “E”,
“sql”: {
“columns”: [
{
“parameters”: [],
“type”: “function”
}
],
“groupBy”: [
{
“property”: {
“type”: “string”
},
“type”: “groupBy”
}
],
“limit”: 50
}
},
{
“datasource”: {
“type”: “grafana-postgresql-datasource”,
“uid”: “aeogu4pxwlxc0b”
},
“editorMode”: “code”,
“format”: “table”,
“hide”: false,
“rawQuery”: true,
“rawSql”: “SELECT sipm/80.1 AS d_1 FROM muon_schema.muon_data_1 WHERE sipm <1000”,
“refId”: “A”,
“sql”: {
“columns”: [
{
“parameters”: [],
“type”: “function”
}
],
“groupBy”: [
{
“property”: {
“type”: “string”
},
“type”: “groupBy”
}
],
“limit”: 50
}
}
],
“title”: “SIPM Distance Scintillator (cm)”,
“type”: “histogram”
}
],
“preload”: false,
“refresh”: “”,
“schemaVersion”: 41,
“tags”: [],
“templating”: {
“list”: [
{
“current”: {
“text”: “”,
“value”: “”
},
“datasource”: {
“type”: “grafana-postgresql-datasource”,
“uid”: “aeogu4pxwlxc0b”
},
“definition”: “SELECT DISTINCT energy FROM externos.noaa_protones_16 Order By energy”,
“includeAll”: false,
“label”: “Proton energy: “,
“name”: “energy”,
“options”: [],
“query”: “SELECT DISTINCT energy FROM externos.noaa_protones_16 Order By energy”,
“refresh”: 1,
“regex”: “”,
“type”: “query”
},
{
“current”: {
“text”: “”,
“value”: “”
},
“datasource”: {
“type”: “grafana-postgresql-datasource”,
“uid”: “aeogu4pxwlxc0b”
},
“definition”: “SELECT DISTINCT energy FROM externos.noaa_xray_16 Order By energy”,
“includeAll”: false,
“label”: “X-Ray Wavelength: “,
“name”: “wavelength”,
“options”: [],
“query”: “SELECT DISTINCT energy FROM externos.noaa_xray_16 Order By energy”,
“refresh”: 1,
“regex”: “”,
“type”: “query”
},
{
“current”: {
“text”: “muon_schema.muon_data_0”,
“value”: “muon_schema.muon_data_0”
},
“description”: “”,
“includeAll”: false,
“label”: “Canal”,
“name”: “Canal”,
“options”: [
{
“selected”: true,
“text”: “muon_schema.muon_data_0”,
“value”: “muon_schema.muon_data_0”
},
{
“selected”: false,
“text”: “muon_schema.muon_data_1”,
“value”: “muon_schema.muon_data_1”
}
],
“query”: “muon_schema.muon_data_0,muon_schema.muon_data_1”,
“type”: “custom”
},
{
“current”: {
“text”: “f1”,
“value”: “f1”
},
“label”: “Frecuencia”,
“name”: “Frecuencia”,
“options”: [
{
“selected”: false,
“text”: “f0”,
“value”: “f0”
},
{
“selected”: true,
“text”: “f1”,
“value”: “f1”
},
{
“selected”: false,
“text”: “f2”,
“value”: “f2”
},
{
“selected”: false,
“text”: “f3”,
“value”: “f3”
},
{
“selected”: false,
“text”: “f4”,
“value”: “f4”
},
{
“selected”: false,
“text”: “f5”,
“value”: “f5”
}
],
“query”: “f0,f1,f2,f3,f4,f5”,
“type”: “custom”
},
{
“current”: {
“text”: “0.2”,
“value”: “0.2”
},
“label”: “Frecuencia máxima”,
“name”: “fr_max”,
“options”: [
{
“selected”: false,
“text”: “0”,
“value”: “0”
},
{
“selected”: true,
“text”: “0.2”,
“value”: “0.2”
},
{
“selected”: false,
“text”: “0.25”,
“value”: “0.25”
},
{
“selected”: false,
“text”: “0.3”,
“value”: “0.3”
},
{
“selected”: false,
“text”: “0.4”,
“value”: “0.4”
},
{
“selected”: false,
“text”: “0.5”,
“value”: “0.5”
},
{
“selected”: false,
“text”: “0.6”,
“value”: “0.6”
},
{
“selected”: false,
“text”: “0.7”,
“value”: “0.7”
},
{
“selected”: false,
“text”: “0.8”,
“value”: “0.8”
},
{
“selected”: false,
“text”: “0.9”,
“value”: “0.9”
},
{
“selected”: false,
“text”: “1”,
“value”: “1”
},
{
“selected”: false,
“text”: “1.2”,
“value”: “1.2”
},
{
“selected”: false,
“text”: “1.5”,
“value”: “1.5”
},
{
“selected”: false,
“text”: “2”,
“value”: “2”
},
{
“selected”: false,
“text”: “3”,
“value”: “3”
},
{
“selected”: false,
“text”: “4”,
“value”: “4”
},
{
“selected”: false,
“text”: “5”,
“value”: “5”
},
{
“selected”: false,
“text”: “10”,
“value”: “10”
},
{
“selected”: false,
“text”: “20”,
“value”: “20”
},
{
“selected”: false,
“text”: “30”,
“value”: “30”
},
{
“selected”: false,
“text”: “40”,
“value”: “40”
},
{
“selected”: false,
“text”: “50”,
“value”: “50”
},
{
“selected”: false,
“text”: “100”,
“value”: “100”
},
{
“selected”: false,
“text”: “150”,
“value”: “150”
},
{
“selected”: false,
“text”: “180”,
“value”: “180”
},
{
“selected”: false,
“text”: “200”,
“value”: “200”
}
],
“query”: “0,0.2,0.25,0.3,0.4,0.5,0.6,0.7,0.8,0.9,1,1.2,1.5,2,3,4,5,10,20,30,40,50,100,150,180,200”,
“type”: “custom”
}
]
},
“time”: {
“from”: “now-6h”,
“to”: “now”
},
“timepicker”: {},
“timezone”: “browser”,
“title”: “LRO Cosmic Watch Muon Detectors V2 (currently used https://cosmicwatch.astronomy.me.uk 29/6/2025) Backup Copy 290625@2230”,
“uid”: “0647e3ae-d9dd-4c87-bd07-aa06aae1caab”,
“version”: 1
}