Hello
I am using Grafana 5.0.3 with InfluxDB 1.5.1 as datasource. ( on Centos 7.4)
InfluxDB stores AWR records ( kind of statements KPI) from one oracle DB.
I would like to have the TOP 3 of sql statements over intervals
To do that, I use the following request that works smoothly on the influx CLI :
select top(“ELAPSED_TIME_DELTA”,3 ) as “ELAPSED_TIME_DELTA”, “sql_id”, “EXECUTIONS_DELTA” FROM “AWR”.“aRetentionPolicy”.“SqlStats” WHERE time > now() - 1d GROUP BY time(30m)
name: SqlStats
time ELAPSED_TIME_DELTA sql_id EXECUTIONS_DELTA
1522141227161000000 973820 2uhj0b6azkys1 1800
1522141227161000000 296888 6u6h4nxajjx9g 1801
1522141227161000000 290624 2fh3rvu66aaqa 1
1522143031117000000 935222 2uhj0b6azkys1 1800
1522143031117000000 293121 4phvdvx32a3mf 30
1522143031117000000 281609 6u6h4nxajjx9g 1801
1522144834895000000 1448161 5am6wjwhgc77w 1
1522144834895000000 1235699 4p3gg08fz2n8z 1
1522144834895000000 1017868 4dtt3t6h2puz8 1
1522146638650000000 36696499 dvbv42b3hfyru 13
1522146638650000000 6213411 14khktjbkbymw 2
1522146638650000000 3327226 fhf8upax5cxsz 6
1522148442297000000 789231 2uhj0b6azkys1 1801
1522148442297000000 338127 6u6h4nxajjx9g 1800
1522148442297000000 292668 ca799ssnmwpg2 1800
How can I display this query on a panel with grafana ?
This query, inside Grafana, produces a single serie, without the “sql_id” tag.
Thanks in adance.