-
What Grafana version and what operating system are you using?
v8.4.4 (fcfb01fae) Self-Managed on Windows 10, using Chrome and Firefox -
What are you trying to achieve?
Create Annotation on the panel using Annotation query on Dashboard’s setting -
How are you trying to achieve it?
I created a new query in Dashboard setting, the result is as expected -
What happened?
The query continue the execution or loading, the UI circle continue to spin, the cancel suggestion over the UI does’t take effect. The issue continue with any setting (excluding hide) on the Annotations. There is an impact system performance on the Browser. The only solution found is to remove entirely the annotation on the dashboard, the performance return as normal.
-
What did you expect to happen?
After loading the annotations, the execution of the query is ended. -
Can you copy/paste the configuration(s) that you are having problems with?
Here the Dashboard JSON:
Test JSON
{
“annotations”: {
"list": [
{
"builtIn": 1,
"datasource": "-- Grafana --",
"enable": true,
"hide": true,
"iconColor": "rgba(0, 211, 255, 1)",
"name": "Annotations & Alerts",
"target": {
"limit": 100,
"matchAny": false,
"tags": [],
"type": "dashboard"
},
"type": "dashboard"
},
{
"enable": true,
"iconColor": "red",
"name": "New annotation",
"rawQuery": "SELECT\n extract(epoch from time) AS time,\n text as text,\n tag as tags\nFROM\n test_tag\nWHERE\n $__timeFilter(time);\n"
}
]
},
“editable”: true,
“fiscalYearStartMonth”: 0,
“graphTooltip”: 0,
“id”: 29,
“links”: ,
“liveNow”: false,
“panels”: [
{
"fieldConfig": {
"defaults": {
"color": {
"mode": "palette-classic"
},
"custom": {
"axisLabel": "",
"axisPlacement": "auto",
"barAlignment": 0,
"drawStyle": "line",
"fillOpacity": 0,
"gradientMode": "none",
"hideFrom": {
"legend": false,
"tooltip": false,
"viz": false
},
"lineInterpolation": "linear",
"lineWidth": 1,
"pointSize": 5,
"scaleDistribution": {
"type": "linear"
},
"showPoints": "auto",
"spanNulls": false,
"stacking": {
"group": "A",
"mode": "none"
},
"thresholdsStyle": {
"mode": "off"
}
},
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green",
"value": null
},
{
"color": "red",
"value": 80
}
]
}
},
"overrides": []
},
"gridPos": {
"h": 8,
"w": 13,
"x": 0,
"y": 0
},
"id": 2,
"options": {
"legend": {
"calcs": [],
"displayMode": "list",
"placement": "bottom"
},
"tooltip": {
"mode": "single",
"sort": "none"
}
},
"targets": [
{
"datasource": {
"type": "postgres",
"uid": "3QIAm9rMk"
},
"format": "time_series",
"group": [],
"metricColumn": "none",
"rawQuery": false,
"rawSql": "SELECT\n \"time\" AS \"time\",\n value\nFROM test_data\nWHERE\n $__timeFilter(\"time\")\nORDER BY 1",
"refId": "A",
"select": [
[
{
"params": [
"value"
],
"type": "column"
}
]
],
"table": "test_data",
"timeColumn": "\"time\"",
"timeColumnType": "date",
"where": [
{
"name": "$__timeFilter",
"params": [],
"type": "macro"
}
]
}
],
"title": "Panel Title",
"type": "timeseries"
}
],
“refresh”: “”,
“schemaVersion”: 35,
“style”: “dark”,
“tags”: ,
“templating”: {
"list": []
},
“time”: {
"from": "now-30d",
"to": "now-10d"
},
“timepicker”: {},
“timezone”: “”,
“title”: “New dashboard”,
“uid”: “WD2uji9nz”,
“version”: 2,
“weekStart”: “”
}
Thank you very much for you support 
