6,009 questions
0
votes
0
answers
17
views
Grafana cAdvisor Metrics
I have a kubernetes app running on minikube in Docker. I've installed Grafana, and can see certain logs in the UI, as well as confirmation that Alloy and cAdvisor are being scraped. However, I don't ...
- 3
0
votes
0
answers
14
views
Error Logs Missing with InfluxDB Backend Listener When Running via Maven
I am encountering an issue with error logging when using an InfluxDB backend listener with JMeter. The problem is I'm observing two behaviors when running it via CMD and the JMeter Maven plugin.
Local ...
0
votes
0
answers
15
views
Why am I still seeing Grafana Live API calls despite setting max_connections to zero?
In my grafana helm values.yaml I have specified the following
grafana.ini:
live:
max_connections: 0
This is based on the documentation that says "0 disables Grafana Live".
I have ...
- 395
0
votes
0
answers
27
views
Grafana no database access possible after fedora upgrade "connect: permission denied" [closed]
After an upgrade from Fedora 38 to 40 the Grafana installation won't connect to its datasoruces anymore.
In the datasources section, I get:
[sqleng.connectionError] failed to connect to server - ...
- 87
-1
votes
0
answers
15
views
Grafana alert no notification
When a Grafana alert fires and creates a notification, it works as expected. However, if the alert resolves and then fires again shortly after (within about 15 minutes), no new notification is created....
- 1,946
0
votes
0
answers
14
views
how to capture a partial consumer group failure in Prometheus using PromQL?
I want to explore the possibilities of capturing any sort of partial consumer group failures due to any reason using PromQL in Prometheus. So that I can use that metrics to monitor and later can add a ...
- 1
0
votes
0
answers
22
views
Grafana Dashboard queries don't work in browser but work through curl/postman [closed]
Setup
I initially had TIG-stack (Telegraf, InfluxDB and Grafana) deployed in a Linux server where it worked as expected. I've recently deployed it on OKD (OpenShift upstream). I have several ...
- 1
0
votes
0
answers
44
views
+100
Calculate QoS(Quality of Service) in % in Grafana using PromQl
I have a nodejs application with counter and histogram as well setup like this:
this.express.use((req, res, next) => {
const start = Date.now();
res.on('finish', () => {
...
- 234
0
votes
0
answers
13
views
Grafana multistage query with HTTP GET requests
I am trying to perform a multistage query in Grafana. The queries are HTTP GET requests. In my first request, I get an output in JSON format, I want each element of this output to form a new GET ...
- 955
0
votes
0
answers
15
views
Sets variables in Grafana?
Is there a way to define a toggle variable that holds sets of variables?
eg a region switch that would have:
'Europe': {ip: 'europe_ip', port: 'europe_port', service_name: 'europe_service_name'}
'...
- 196
0
votes
0
answers
41
views
if-else condition in Promql using Grafana Variables
I have a custom variable "Project_Name" in Grafana Dashboard. I want to execute below condition unsing Promql query in Stackdriver Metrics datasource(GCP)
if ($Project_Name == 'ALL') then :
...
- 107
0
votes
0
answers
29
views
MySql query graphing in Grafana
I would like the following query to plot in Grafana by day of the year each year in a data series which is the KWh output of our solar panels.
SELECT
DATE_FORMAT(DateStamp, '%m-%d') AS MonthDay,
...
-1
votes
0
answers
27
views
dashboard that shows uptime percentage from oci-metrics-datasource oci_healthchecks?
I've been asked to create a dashboard to show uptime \ pass rate as a percentage from a high level external monitoring ping to our services rest api.
When importing the data into Grafana, using the ...
- 463
0
votes
1
answer
26
views
Grafana and Azure Elasticsearch service data source: open port 9200
I am setting up Elasticsearch data source in Grafana. I am following the instructions
The Elasticsearch is running in Azure as Service (Elastic Observability (Elasticsearch) - An Azure Native ISV ...
- 9
0
votes
0
answers
29
views
grafana table to show counter division aggregation values in selected time range
I'm new to prometheus and grafana and stuck with such query and dashboard.
In prometheus there are 2 counters with shared labels. for example:
upload_file_size_total{filetype="jpg", version=&...
- 4,305
1
vote
0
answers
34
views
Does Grafana support the PromQL modifier @?
I'm trying to visualize a Prometheus query in Grafana, but I'm facing an issue. The query:
mymetric{mylabel="value"} @ end()
works perfectly in Prometheus and returns a valid graph. However, ...
- 335
1
vote
1
answer
42
views
How to query DynamoDB with multiple filters (platform, type, and rate_id) to return only monthly/weekly data
I'm trying to query a DynamoDB table to retrieve data for the current month or current week, depending on the filter applied (data_type = monthly or weekly). However, I'm encountering an issue where ...
- 31
0
votes
1
answer
29
views
Transform a table with start and end dates columns into a time series
I have the results of a query in Grafana that looks like this:
start_date
end_date
job_name
status
2024-11-26 15:00:42
2024-11-26 15:10:42
JOB_A
1
2024-11-26 11:32:12
2024-11-26 15:13:42
JOB_B
-1
...
- 453
0
votes
0
answers
13
views
How to Automatically Extract Tooltip Values from Grafana Graphs at Specific Timestamps?
I'm working on a Grafana frontend that visualizes time series data from CAN-traces recorded from cars. The data is stored in AWS Timestream for live analytics. Our team, consisting of developers and ...
- 1
0
votes
0
answers
12
views
How to implement opening a modal window with a table on double-clicking a canvas metricValue element?
I have a task to extend the functionality of the canvas. Specifically, I need to add the ability to open a modal window upon selecting a value for matricValue and double-clicking on an element, where ...
-1
votes
0
answers
35
views
Kubernetes: capture incoming and outgoing traffic by namespace
I am running multiple projects in a single managed k8s cluster. The cluster-internal network traffic is free, but I pay per GiB for the traffic to and from the cluster. The cost for that external ...
- 39
0
votes
1
answer
75
views
How to mount a GCP Cloud Storage volume in GCP Cloud Run service?
I'm trying to mount a volume type GCP Cloud Storage Bucket in GCP Cloud Run container that runs an official Docker grafana/grafana:10.3.12 image. The volume is configured with mounted path /etc/...
0
votes
0
answers
20
views
Grafana - limit access to template variables for specific users & teams
I'm learning Grafana and want to use it for monitoring multiple servers within our organisation. I've made a sample dashboard with template variable Host that allows for quick choice of the server I ...
- 1
0
votes
0
answers
32
views
Not able to get all containers in one column
I want create a table visualization in grafana to get CPU, Memory, Disk, Network details.
Container CPU Usage (%) Memory Usage (Bytes) Disk Reads (Bytes) Network In (Bytes)
cadvisor ...
0
votes
0
answers
29
views
Grafana label value to numeric value for graphs
sensorReading{instance="192.168.xxx.xxx", officeSensorNumber="1"} which returns
{__name__="sensorReading", instance="192.168.xxx.xxx", job="IPMI", ...
- 301
0
votes
0
answers
21
views
How to query rows with timestamps before today in grafana
How do I perform this kind of query in grafana?
select some_column from some_table where some_datetime < now();
I've made a dashboard variable that's populated from SELECT CURRENT_TIMESTAMP;
but i ...
- 18.2k
0
votes
0
answers
21
views
Custom grafana $timeFilter
I'm using this query to fetch data for current day power consumption in order to display in a bar chart.
SELECT mean("value")
FROM "Dataset"
WHERE "measurement" = 'Ea+' ...
- 1
0
votes
0
answers
20
views
Grafana - datasource as variable
I have one InfluxDB database, and a lot of buckets and a lot of datasources (where one datasource = access to one bucket). As You see, schema is simple: each datasource (named influxdb-clientXXX-r) ...
- 1,280
1
vote
0
answers
27
views
Query Text Field Not Displaying in Variable Query Editor for Grafana Plugin
Description:
I am developing a plugin for Grafana to fetch and display data from MongoDB. Everything works as expected, except for one issue when creating a variable in the Grafana dashboard. The &...
0
votes
0
answers
35
views
Calculating API Request Rate Over time by status code and path
I'm using the below expression to calculate the rate of requests by status_code and path:
sum(rate(http_request_duration_seconds_count[10m])) by (status_code, path) > 0
I'm getting abnormally ...
- 5,553
0
votes
0
answers
32
views
Prometheus metrics too sparse to calculate a rate, especially because they come from 40 different pods
I have a grpc API, with 40 pods and loadbalanced via envoy proxy.
I created a custom summary metric, let's call it server_price_predicted. Each server exposes it based on the requests it treated. When ...
- 67
0
votes
0
answers
14
views
Compare 2 metrics and give Distinct Count of INNER JOIN
I wanted to compare two metrics in Grafana.
missing_users_hosts{Site=~"$Site"}
active_users{Site=~"$Site"}
Now I wanted to find the Distinct Count of label name EmailID like ...
- 190
0
votes
0
answers
30
views
LogQL query filter where two fields are equal
I have a json formatted log entry and want to filter to all those, where the field coverCurrency is equal to the field premiumCurrency.
I tried: {namespace="calculation-engine"} | json | ...
- 1,845
0
votes
1
answer
51
views
WebIdentityErr: failed to retrieve credentials\ncaused by: SerializationError: failed to unmarshal error message\n\tstatus code: 405 , Loki Helm
I'm deploying Loki in an EKS cluster using an S3 bucket for storage. I've configured IAM Roles for Service Accounts (IRSA) to allow Loki to access the S3 bucket. However, I'm encountering the ...
- 423
0
votes
0
answers
23
views
Grafana alerts are not separated on Slack
I use prometheus, alertmanager, grafana and loki for monitoring.
I want to distinguish my grafana alerts to critical and warning severity.
When only one of the alerts is configured: trash-watchdog-...
0
votes
0
answers
33
views
Why are the values in my Grafana panel not sorting consistently with InfluxDB?
What Grafana version and what operating system are you using?
10.4
Using Flux Query Language
What are you trying to achieve?
Using the Stat panel (in a repeating row by variable ${vocDeviceName}, I ...
- 1
1
vote
1
answer
36
views
Using grafana operator, how can I create an Opensearch DataSource and set withCredentials = true in the Yaml?
I am using grafana operator to setup an Opensearch Datasource. According to the api documentation, the field cannot be set under the spec like this :
apiVersion: grafana.integreatly.org/v1beta1
kind: ...
- 3,914
1
vote
0
answers
42
views
How can I group values by label in Prometheus query?
This is my metric data
sync_unit_type {region="krg"} 1731441289.
Value is datetime represented as seconds (Unix time). There are different regions, also values are updated constantly every 5-...
- 313
0
votes
0
answers
99
views
Grafana pivot table
I have three SQL Server tables built like this:
SAMPLES (id, sample_number, sample_date, description)
PARAMETERS (id, parameter_name, measure_unit)
RESULTS (id, sample_id FK, parameter_id FK, value)
...
- 197
0
votes
0
answers
29
views
Using Metric Labels as Dynamic Limits in Grafana Expressions
I have an application where I want to export metrics with expected limits. The goal is to automate the creation of alerts and set triggered limits.
Ideally, I’d like to add an additional tag with the ...
-1
votes
0
answers
39
views
Filtering does not work in the endpoint /alertmanager/grafana/api/v2/alert
I've tried a variety of approaches to filtering data, but none have worked. All attempts to get an alert for a given field (alert_rule_uid) were unsuccessful.
Sample data:
"startsAt": "...
0
votes
1
answer
40
views
Grafana Prometheus Variable using multiple metrics
I am using Grafana with Data Source Prometheus.
I have 2 metrics which is working fine in table
webex_users{job="pushgateway"}
missed_webex_hosts{job="pushgateway"}
Both the ...
- 190
0
votes
0
answers
66
views
Grafana - Create variable with an array for each value
I would like to have an array for each variable value. The variable name is "Environment". For example:
Production : [applicationInsightsProductionConnectionString, ...
0
votes
0
answers
22
views
I want to combine two PromQL queries into one table - Grafana
I have two queries. One is counting the number of pods with specific label from K8s datasource and the other one is displaying a gauge from application datasource.
they both have namespace as a common ...
0
votes
1
answer
22
views
How to Accurately Calculate CPU Usage Percentage for Each Worker in a Clustered Node.js Application?
I'm running a clustered Node.js application and trying to monitor the CPU usage percentage for each individual worker process. I'm using the cluster module to fully utilize a multi-core server, with ...
- 3,099
0
votes
0
answers
30
views
Grafana - RabbitMQ - Stream protocol connection closed socket
I am currently facing an issue connecting to our rabbitmq server by using the rabbitmq datasource in grafana.
My connection details looks like the photo attached.
I have verified that the streams ...
- 1,132
0
votes
1
answer
55
views
Grafana/PromQL: midnight to midnight change in counter
Let's say I have a posts_total counter. It increases every day, and it has various labels, like posts_total{status='active'} and posts_total{status='deleted'}.
delta(posts_total{status=~"active|...
- 714
0
votes
1
answer
21
views
Is it possible to add field in a table visual that shows an indicator (such as red/yellow/green icon) as well as text?
Looking for some functionality akin to a Power BI screen, like this:
Is it possible to do this without a custom visual? Trying to do this on OSS Grafana.
Have so far tried value mappings, converting ...
- 191
0
votes
1
answer
33
views
Grafana Dashboard with Loki to display a single number
Hi I have a Grafana Dashboard that I want to use to display the failed logs sent to Loki.
The logs look something like this
enter image description here
I have edited the query to show the sum of the ...
- 1
0
votes
0
answers
50
views
Nginx regex k8s issues
I am attempting to deploy the grafana image renderer using 3 k8s manifests. 1 is a deploy, 2 is a service, and 3 is an ingress. The Nginx ingress regex rules say they are PCRE and I am attempting that....
